HRMS
文章平均质量分 77
caixingyun
这个作者很懒,什么都没留下…
展开
-
EBS HRMS数据表
4.1. 人员基本息 表 (PER_ALL_PEOPLE_F)原创 2014-01-01 23:14:57 · 4759 阅读 · 0 评论 -
API创建员工
DECLARE lc_employee_number PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE := 'PRAJ_01'; ln_person_id PER_ALL_PEOPLE_F.PERSON_ID%TYPE; ln_原创 2013-12-29 13:21:29 · 1871 阅读 · 0 评论 -
API创建员工支付方式
DECLARE ln_method_id PAY_PERSONAL_PAYMENT_METHODS_F.PERSONAL_PAYMENT_METHOD_ID%TYPE; ln_ext_acc_id PAY_EXTERNAL_ACCOUNTS.EXTERNAL_ACCOUNT_ID%TYPE; ln_obj_ver_num PAY_PERSONAL_PAYMENT_M原创 2013-12-29 13:21:57 · 1675 阅读 · 0 评论 -
API创建员工地址
DECLARE ln_address_id PER_ADDRESSES.ADDRESS_ID%TYPE; ln_object_version_number PER_ADDRESSES.OBJECT_VERSION_NUMBER%TYPE; BEGIN -- Create Employee Address原创 2013-12-29 13:22:21 · 1606 阅读 · 0 评论 -
API创建员工联系人
DECLARE ln_contact_rel_id PER_CONTACT_RELATIONSHIPS.CONTACT_RELATIONSHIP_ID%TYPE; ln_ctr_object_ver_num PER_CONTACT_RELATIONSHIPS.OBJECT_VERSION_NUMBER%TYPE;原创 2013-12-29 13:22:42 · 1639 阅读 · 0 评论 -
API创建/更新员工联系电话
DECLARE ln_phone_id PER_PHONES.PHONE_ID%TYPE; ln_object_version_number PER_PHONES.OBJECT_VERSION_NUMBER%TYPE; BEGIN -- Create or Update Employee原创 2013-12-29 13:23:12 · 1588 阅读 · 0 评论 -
EBS 客户表结构
客户表/联系人/PARTY关联HZ_PARTIES客户账户表HZ_CUST_ACCOUNTSSELECT hp.party_number --客户注册标识, hp.party_name --组织名/客户, hp.known_as --别名, hp.organization_name_phonetic --名称拼音, acc.account_number原创 2014-01-03 17:59:24 · 4620 阅读 · 0 评论 -
API创建员工Element
DECLARE ln_element_link_id PAY_ELEMENT_LINKS_F.ELEMENT_LINK_ID%TYPE; ld_effective_start_date DATE; ld_effective_end_date DATE; ln_element_entry_原创 2013-12-29 13:22:59 · 2103 阅读 · 0 评论 -
API创建/更新员工薪水
DECLARE lb_inv_next_sal_date_warning BOOLEAN; lb_proposed_salary_warning BOOLEAN; lb_approved_warning BOOLEAN; lb_payroll_warning原创 2013-12-29 13:23:27 · 1708 阅读 · 0 评论 -
Understanding and Using HRMS Security in Oracle HRMS
Understanding and Using HRMS Security in Oracle HRMSProduct:Oracle Human Resources Minimum Version:11.5.9An Oracle White PaperAbstractUnderstanding and Using HRMS Security in Oracle HRMS原创 2014-10-23 15:27:51 · 2324 阅读 · 0 评论