eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CN_AUDIT_XMLGEN dependencies on PER_CN_SHARED_INFO

Line 591: per_cn_shared_info.get_lookup_meaning(paf.employee_category,'EMPLOYEE_CATG') asg_cat ,

587: CURSOR csr_group3_data(p_assignment_id IN NUMBER,
588: p_assignment_action_id IN NUMBER)
589: IS
590: SELECT TO_CHAR(get_employee_number(paf.person_id,ppa.effective_date)) eno,
591: per_cn_shared_info.get_lookup_meaning(paf.employee_category,'EMPLOYEE_CATG') asg_cat ,
592: get_employee_name(paf.person_id,ppa.effective_date) emp_name,
593: to_char(paf.organization_id) asg_org_id,
594: (select distinct p.payroll_name from pay_payrolls_f p where p.payroll_id = paf.payroll_id) pname,
595: to_CHAR(ppa.effective_date,'YYYY') yr,

Line 644: l_head_trans1 := per_cn_shared_info.get_lookup_meaning('HEADER_1','CN_SOE_LABELS');

640: hr_utility.trace ('Entering '||l_proc_name);
641: END IF ;
642:
643: IF g_opt_soe_or_min IS NULL OR g_opt_soe_or_min ='ENT' THEN
644: l_head_trans1 := per_cn_shared_info.get_lookup_meaning('HEADER_1','CN_SOE_LABELS');
645: l_head_trans2 := per_cn_shared_info.get_lookup_meaning('HEADER_2','CN_SOE_LABELS');
646: l_soe_header := l_head_trans1||' xsi:schemaLocation="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/SOE/XMLSchema '||
647: l_head_trans1||'.xsd" xmlns:'||l_head_trans2||
648: '="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/SOE/XMLSchema" xmlns="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/SOE/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"';

Line 645: l_head_trans2 := per_cn_shared_info.get_lookup_meaning('HEADER_2','CN_SOE_LABELS');

641: END IF ;
642:
643: IF g_opt_soe_or_min IS NULL OR g_opt_soe_or_min ='ENT' THEN
644: l_head_trans1 := per_cn_shared_info.get_lookup_meaning('HEADER_1','CN_SOE_LABELS');
645: l_head_trans2 := per_cn_shared_info.get_lookup_meaning('HEADER_2','CN_SOE_LABELS');
646: l_soe_header := l_head_trans1||' xsi:schemaLocation="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/SOE/XMLSchema '||
647: l_head_trans1||'.xsd" xmlns:'||l_head_trans2||
648: '="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/SOE/XMLSchema" xmlns="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/SOE/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"';
649: load_xml_internal('SG',l_soe_header,null);

Line 651: l_head_trans1 := per_cn_shared_info.get_lookup_meaning('HEADER_1','CN_MINISTRY_LABELS');

647: l_head_trans1||'.xsd" xmlns:'||l_head_trans2||
648: '="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/SOE/XMLSchema" xmlns="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/SOE/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"';
649: load_xml_internal('SG',l_soe_header,null);
650: ELSE
651: l_head_trans1 := per_cn_shared_info.get_lookup_meaning('HEADER_1','CN_MINISTRY_LABELS');
652: l_head_trans2 := per_cn_shared_info.get_lookup_meaning('HEADER_2','CN_MINISTRY_LABELS');
653: l_min_header := l_head_trans1||' xsi:schemaLocation="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/PSGA/XMLSchema '||
654: l_head_trans1||'.xsd" xmlns:'||l_head_trans2||
655: '="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/PSGA/XMLSchema" xmlns="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/PSGA/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"';

Line 652: l_head_trans2 := per_cn_shared_info.get_lookup_meaning('HEADER_2','CN_MINISTRY_LABELS');

648: '="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/SOE/XMLSchema" xmlns="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/SOE/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"';
649: load_xml_internal('SG',l_soe_header,null);
650: ELSE
651: l_head_trans1 := per_cn_shared_info.get_lookup_meaning('HEADER_1','CN_MINISTRY_LABELS');
652: l_head_trans2 := per_cn_shared_info.get_lookup_meaning('HEADER_2','CN_MINISTRY_LABELS');
653: l_min_header := l_head_trans1||' xsi:schemaLocation="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/PSGA/XMLSchema '||
654: l_head_trans1||'.xsd" xmlns:'||l_head_trans2||
655: '="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/PSGA/XMLSchema" xmlns="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/PSGA/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"';
656: load_xml_internal('SG',l_min_header,null);

Line 723: load_xml_internal('CG', g_pay_ele(4).p_meaning , per_cn_shared_info.get_lookup_meaning('NODATA','CN_AUDIT_DATA'));

719: ,p_action_information_id => l_action_info_id
720: ,p_object_version_number => l_ovn
721: );
722:
723: load_xml_internal('CG', g_pay_ele(4).p_meaning , per_cn_shared_info.get_lookup_meaning('NODATA','CN_AUDIT_DATA'));
724: ELSE
725: IF j.exp_cat_code = 'X' THEN
726: load_xml_internal('CG', g_pay_ele(4).p_meaning , NULL);
727: ELSE

Line 771: load_xml_internal('CG', g_ind_asg(2).p_meaning , nvl(group3rec.asg_cat,per_cn_shared_info.get_lookup_meaning('NODATA','CN_AUDIT_DATA')));

767: load_xml_internal('SG', g_ind_asg(0).p_meaning , null);
768: load_xml_internal('CG', g_ind_asg(1).p_meaning , group3rec.eno);
769:
770: IF g_opt_soe_or_min IS NULL OR g_opt_soe_or_min ='ENT' THEN
771: load_xml_internal('CG', g_ind_asg(2).p_meaning , nvl(group3rec.asg_cat,per_cn_shared_info.get_lookup_meaning('NODATA','CN_AUDIT_DATA')));
772: ELSE
773: load_xml_internal('CG', g_ind_asg(2).p_meaning , group3rec.emp_name);
774: END IF;
775:

Line 810: l_head_trans1 := per_cn_shared_info.get_lookup_meaning('HEADER_1','CN_SOE_LABELS');

806: hr_utility.trace ('Entering '||l_proc_name);
807: end if ;
808: --
809: IF g_opt_soe_or_min IS NULL OR g_opt_soe_or_min ='ENT' THEN
810: l_head_trans1 := per_cn_shared_info.get_lookup_meaning('HEADER_1','CN_SOE_LABELS');
811: load_xml_internal('EG',l_head_trans1,null);
812: ELSE
813: l_head_trans1 := per_cn_shared_info.get_lookup_meaning('HEADER_1','CN_MINISTRY_LABELS');
814: load_xml_internal('EG',l_head_trans1,null);

Line 813: l_head_trans1 := per_cn_shared_info.get_lookup_meaning('HEADER_1','CN_MINISTRY_LABELS');

809: IF g_opt_soe_or_min IS NULL OR g_opt_soe_or_min ='ENT' THEN
810: l_head_trans1 := per_cn_shared_info.get_lookup_meaning('HEADER_1','CN_SOE_LABELS');
811: load_xml_internal('EG',l_head_trans1,null);
812: ELSE
813: l_head_trans1 := per_cn_shared_info.get_lookup_meaning('HEADER_1','CN_MINISTRY_LABELS');
814: load_xml_internal('EG',l_head_trans1,null);
815: END IF;
816: if g_debug then
817: hr_utility.trace ('Leaving '||l_proc_name);

Line 1225: g_pay_prd(0).p_meaning := per_cn_shared_info.get_lookup_meaning('PERIOD',l_lookup_type);

1221: END IF;
1222:
1223:
1224: IF l_lookup_type IS NOT NULL THEN
1225: g_pay_prd(0).p_meaning := per_cn_shared_info.get_lookup_meaning('PERIOD',l_lookup_type);
1226: g_pay_prd(1).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_13',l_lookup_type);
1227: g_pay_prd(2).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_14',l_lookup_type);
1228: g_pay_prd(3).p_meaning := per_cn_shared_info.get_lookup_meaning('PERIOD_13',l_lookup_type);
1229: g_pay_prd(4).p_meaning := per_cn_shared_info.get_lookup_meaning('PERIOD_14',l_lookup_type);

Line 1226: g_pay_prd(1).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_13',l_lookup_type);

1222:
1223:
1224: IF l_lookup_type IS NOT NULL THEN
1225: g_pay_prd(0).p_meaning := per_cn_shared_info.get_lookup_meaning('PERIOD',l_lookup_type);
1226: g_pay_prd(1).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_13',l_lookup_type);
1227: g_pay_prd(2).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_14',l_lookup_type);
1228: g_pay_prd(3).p_meaning := per_cn_shared_info.get_lookup_meaning('PERIOD_13',l_lookup_type);
1229: g_pay_prd(4).p_meaning := per_cn_shared_info.get_lookup_meaning('PERIOD_14',l_lookup_type);
1230:

Line 1227: g_pay_prd(2).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_14',l_lookup_type);

1223:
1224: IF l_lookup_type IS NOT NULL THEN
1225: g_pay_prd(0).p_meaning := per_cn_shared_info.get_lookup_meaning('PERIOD',l_lookup_type);
1226: g_pay_prd(1).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_13',l_lookup_type);
1227: g_pay_prd(2).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_14',l_lookup_type);
1228: g_pay_prd(3).p_meaning := per_cn_shared_info.get_lookup_meaning('PERIOD_13',l_lookup_type);
1229: g_pay_prd(4).p_meaning := per_cn_shared_info.get_lookup_meaning('PERIOD_14',l_lookup_type);
1230:
1231: g_pay_ele(0).p_meaning := per_cn_shared_info.get_lookup_meaning('ELEMENT',l_lookup_type);

Line 1228: g_pay_prd(3).p_meaning := per_cn_shared_info.get_lookup_meaning('PERIOD_13',l_lookup_type);

1224: IF l_lookup_type IS NOT NULL THEN
1225: g_pay_prd(0).p_meaning := per_cn_shared_info.get_lookup_meaning('PERIOD',l_lookup_type);
1226: g_pay_prd(1).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_13',l_lookup_type);
1227: g_pay_prd(2).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_14',l_lookup_type);
1228: g_pay_prd(3).p_meaning := per_cn_shared_info.get_lookup_meaning('PERIOD_13',l_lookup_type);
1229: g_pay_prd(4).p_meaning := per_cn_shared_info.get_lookup_meaning('PERIOD_14',l_lookup_type);
1230:
1231: g_pay_ele(0).p_meaning := per_cn_shared_info.get_lookup_meaning('ELEMENT',l_lookup_type);
1232: g_pay_ele(1).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_12',l_lookup_type);

Line 1229: g_pay_prd(4).p_meaning := per_cn_shared_info.get_lookup_meaning('PERIOD_14',l_lookup_type);

1225: g_pay_prd(0).p_meaning := per_cn_shared_info.get_lookup_meaning('PERIOD',l_lookup_type);
1226: g_pay_prd(1).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_13',l_lookup_type);
1227: g_pay_prd(2).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_14',l_lookup_type);
1228: g_pay_prd(3).p_meaning := per_cn_shared_info.get_lookup_meaning('PERIOD_13',l_lookup_type);
1229: g_pay_prd(4).p_meaning := per_cn_shared_info.get_lookup_meaning('PERIOD_14',l_lookup_type);
1230:
1231: g_pay_ele(0).p_meaning := per_cn_shared_info.get_lookup_meaning('ELEMENT',l_lookup_type);
1232: g_pay_ele(1).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_12',l_lookup_type);
1233: g_pay_ele(2).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_15',l_lookup_type);

Line 1231: g_pay_ele(0).p_meaning := per_cn_shared_info.get_lookup_meaning('ELEMENT',l_lookup_type);

1227: g_pay_prd(2).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_14',l_lookup_type);
1228: g_pay_prd(3).p_meaning := per_cn_shared_info.get_lookup_meaning('PERIOD_13',l_lookup_type);
1229: g_pay_prd(4).p_meaning := per_cn_shared_info.get_lookup_meaning('PERIOD_14',l_lookup_type);
1230:
1231: g_pay_ele(0).p_meaning := per_cn_shared_info.get_lookup_meaning('ELEMENT',l_lookup_type);
1232: g_pay_ele(1).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_12',l_lookup_type);
1233: g_pay_ele(2).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_15',l_lookup_type);
1234: g_pay_ele(3).p_meaning := per_cn_shared_info.get_lookup_meaning('ELEMENT_13',l_lookup_type);
1235: g_pay_ele(4).p_meaning := per_cn_shared_info.get_lookup_meaning('ELEMENT_14','CN_MINISTRY_LABELS');

Line 1232: g_pay_ele(1).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_12',l_lookup_type);

1228: g_pay_prd(3).p_meaning := per_cn_shared_info.get_lookup_meaning('PERIOD_13',l_lookup_type);
1229: g_pay_prd(4).p_meaning := per_cn_shared_info.get_lookup_meaning('PERIOD_14',l_lookup_type);
1230:
1231: g_pay_ele(0).p_meaning := per_cn_shared_info.get_lookup_meaning('ELEMENT',l_lookup_type);
1232: g_pay_ele(1).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_12',l_lookup_type);
1233: g_pay_ele(2).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_15',l_lookup_type);
1234: g_pay_ele(3).p_meaning := per_cn_shared_info.get_lookup_meaning('ELEMENT_13',l_lookup_type);
1235: g_pay_ele(4).p_meaning := per_cn_shared_info.get_lookup_meaning('ELEMENT_14','CN_MINISTRY_LABELS');
1236:

Line 1233: g_pay_ele(2).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_15',l_lookup_type);

1229: g_pay_prd(4).p_meaning := per_cn_shared_info.get_lookup_meaning('PERIOD_14',l_lookup_type);
1230:
1231: g_pay_ele(0).p_meaning := per_cn_shared_info.get_lookup_meaning('ELEMENT',l_lookup_type);
1232: g_pay_ele(1).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_12',l_lookup_type);
1233: g_pay_ele(2).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_15',l_lookup_type);
1234: g_pay_ele(3).p_meaning := per_cn_shared_info.get_lookup_meaning('ELEMENT_13',l_lookup_type);
1235: g_pay_ele(4).p_meaning := per_cn_shared_info.get_lookup_meaning('ELEMENT_14','CN_MINISTRY_LABELS');
1236:
1237: g_ind_asg(0).p_meaning := per_cn_shared_info.get_lookup_meaning('RECORD',l_lookup_type);

Line 1234: g_pay_ele(3).p_meaning := per_cn_shared_info.get_lookup_meaning('ELEMENT_13',l_lookup_type);

1230:
1231: g_pay_ele(0).p_meaning := per_cn_shared_info.get_lookup_meaning('ELEMENT',l_lookup_type);
1232: g_pay_ele(1).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_12',l_lookup_type);
1233: g_pay_ele(2).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_15',l_lookup_type);
1234: g_pay_ele(3).p_meaning := per_cn_shared_info.get_lookup_meaning('ELEMENT_13',l_lookup_type);
1235: g_pay_ele(4).p_meaning := per_cn_shared_info.get_lookup_meaning('ELEMENT_14','CN_MINISTRY_LABELS');
1236:
1237: g_ind_asg(0).p_meaning := per_cn_shared_info.get_lookup_meaning('RECORD',l_lookup_type);
1238: g_ind_asg(1).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_11',l_lookup_type);

Line 1235: g_pay_ele(4).p_meaning := per_cn_shared_info.get_lookup_meaning('ELEMENT_14','CN_MINISTRY_LABELS');

1231: g_pay_ele(0).p_meaning := per_cn_shared_info.get_lookup_meaning('ELEMENT',l_lookup_type);
1232: g_pay_ele(1).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_12',l_lookup_type);
1233: g_pay_ele(2).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_15',l_lookup_type);
1234: g_pay_ele(3).p_meaning := per_cn_shared_info.get_lookup_meaning('ELEMENT_13',l_lookup_type);
1235: g_pay_ele(4).p_meaning := per_cn_shared_info.get_lookup_meaning('ELEMENT_14','CN_MINISTRY_LABELS');
1236:
1237: g_ind_asg(0).p_meaning := per_cn_shared_info.get_lookup_meaning('RECORD',l_lookup_type);
1238: g_ind_asg(1).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_11',l_lookup_type);
1239: g_ind_asg(2).p_meaning := per_cn_shared_info.get_lookup_meaning('RECORD_12',l_lookup_type);

Line 1237: g_ind_asg(0).p_meaning := per_cn_shared_info.get_lookup_meaning('RECORD',l_lookup_type);

1233: g_pay_ele(2).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_15',l_lookup_type);
1234: g_pay_ele(3).p_meaning := per_cn_shared_info.get_lookup_meaning('ELEMENT_13',l_lookup_type);
1235: g_pay_ele(4).p_meaning := per_cn_shared_info.get_lookup_meaning('ELEMENT_14','CN_MINISTRY_LABELS');
1236:
1237: g_ind_asg(0).p_meaning := per_cn_shared_info.get_lookup_meaning('RECORD',l_lookup_type);
1238: g_ind_asg(1).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_11',l_lookup_type);
1239: g_ind_asg(2).p_meaning := per_cn_shared_info.get_lookup_meaning('RECORD_12',l_lookup_type);
1240: g_ind_asg(3).p_meaning := per_cn_shared_info.get_lookup_meaning('RECORD_13',l_lookup_type);
1241: g_ind_asg(4).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_12',l_lookup_type);

Line 1238: g_ind_asg(1).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_11',l_lookup_type);

1234: g_pay_ele(3).p_meaning := per_cn_shared_info.get_lookup_meaning('ELEMENT_13',l_lookup_type);
1235: g_pay_ele(4).p_meaning := per_cn_shared_info.get_lookup_meaning('ELEMENT_14','CN_MINISTRY_LABELS');
1236:
1237: g_ind_asg(0).p_meaning := per_cn_shared_info.get_lookup_meaning('RECORD',l_lookup_type);
1238: g_ind_asg(1).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_11',l_lookup_type);
1239: g_ind_asg(2).p_meaning := per_cn_shared_info.get_lookup_meaning('RECORD_12',l_lookup_type);
1240: g_ind_asg(3).p_meaning := per_cn_shared_info.get_lookup_meaning('RECORD_13',l_lookup_type);
1241: g_ind_asg(4).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_12',l_lookup_type);
1242: g_ind_asg(5).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_13',l_lookup_type);

Line 1239: g_ind_asg(2).p_meaning := per_cn_shared_info.get_lookup_meaning('RECORD_12',l_lookup_type);

1235: g_pay_ele(4).p_meaning := per_cn_shared_info.get_lookup_meaning('ELEMENT_14','CN_MINISTRY_LABELS');
1236:
1237: g_ind_asg(0).p_meaning := per_cn_shared_info.get_lookup_meaning('RECORD',l_lookup_type);
1238: g_ind_asg(1).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_11',l_lookup_type);
1239: g_ind_asg(2).p_meaning := per_cn_shared_info.get_lookup_meaning('RECORD_12',l_lookup_type);
1240: g_ind_asg(3).p_meaning := per_cn_shared_info.get_lookup_meaning('RECORD_13',l_lookup_type);
1241: g_ind_asg(4).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_12',l_lookup_type);
1242: g_ind_asg(5).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_13',l_lookup_type);
1243: g_ind_asg(6).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_14',l_lookup_type);

Line 1240: g_ind_asg(3).p_meaning := per_cn_shared_info.get_lookup_meaning('RECORD_13',l_lookup_type);

1236:
1237: g_ind_asg(0).p_meaning := per_cn_shared_info.get_lookup_meaning('RECORD',l_lookup_type);
1238: g_ind_asg(1).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_11',l_lookup_type);
1239: g_ind_asg(2).p_meaning := per_cn_shared_info.get_lookup_meaning('RECORD_12',l_lookup_type);
1240: g_ind_asg(3).p_meaning := per_cn_shared_info.get_lookup_meaning('RECORD_13',l_lookup_type);
1241: g_ind_asg(4).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_12',l_lookup_type);
1242: g_ind_asg(5).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_13',l_lookup_type);
1243: g_ind_asg(6).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_14',l_lookup_type);
1244: g_ind_asg(7).p_meaning := per_cn_shared_info.get_lookup_meaning('RECORD_17',l_lookup_type);

Line 1241: g_ind_asg(4).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_12',l_lookup_type);

1237: g_ind_asg(0).p_meaning := per_cn_shared_info.get_lookup_meaning('RECORD',l_lookup_type);
1238: g_ind_asg(1).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_11',l_lookup_type);
1239: g_ind_asg(2).p_meaning := per_cn_shared_info.get_lookup_meaning('RECORD_12',l_lookup_type);
1240: g_ind_asg(3).p_meaning := per_cn_shared_info.get_lookup_meaning('RECORD_13',l_lookup_type);
1241: g_ind_asg(4).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_12',l_lookup_type);
1242: g_ind_asg(5).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_13',l_lookup_type);
1243: g_ind_asg(6).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_14',l_lookup_type);
1244: g_ind_asg(7).p_meaning := per_cn_shared_info.get_lookup_meaning('RECORD_17',l_lookup_type);
1245: g_ind_asg(8).p_meaning := per_cn_shared_info.get_lookup_meaning('RECORD_18',l_lookup_type);

Line 1242: g_ind_asg(5).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_13',l_lookup_type);

1238: g_ind_asg(1).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_11',l_lookup_type);
1239: g_ind_asg(2).p_meaning := per_cn_shared_info.get_lookup_meaning('RECORD_12',l_lookup_type);
1240: g_ind_asg(3).p_meaning := per_cn_shared_info.get_lookup_meaning('RECORD_13',l_lookup_type);
1241: g_ind_asg(4).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_12',l_lookup_type);
1242: g_ind_asg(5).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_13',l_lookup_type);
1243: g_ind_asg(6).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_14',l_lookup_type);
1244: g_ind_asg(7).p_meaning := per_cn_shared_info.get_lookup_meaning('RECORD_17',l_lookup_type);
1245: g_ind_asg(8).p_meaning := per_cn_shared_info.get_lookup_meaning('RECORD_18',l_lookup_type);
1246: g_ind_asg(9).p_meaning := per_cn_shared_info.get_lookup_meaning('RECORD_19',l_lookup_type);

Line 1243: g_ind_asg(6).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_14',l_lookup_type);

1239: g_ind_asg(2).p_meaning := per_cn_shared_info.get_lookup_meaning('RECORD_12',l_lookup_type);
1240: g_ind_asg(3).p_meaning := per_cn_shared_info.get_lookup_meaning('RECORD_13',l_lookup_type);
1241: g_ind_asg(4).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_12',l_lookup_type);
1242: g_ind_asg(5).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_13',l_lookup_type);
1243: g_ind_asg(6).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_14',l_lookup_type);
1244: g_ind_asg(7).p_meaning := per_cn_shared_info.get_lookup_meaning('RECORD_17',l_lookup_type);
1245: g_ind_asg(8).p_meaning := per_cn_shared_info.get_lookup_meaning('RECORD_18',l_lookup_type);
1246: g_ind_asg(9).p_meaning := per_cn_shared_info.get_lookup_meaning('RECORD_19',l_lookup_type);
1247:

Line 1244: g_ind_asg(7).p_meaning := per_cn_shared_info.get_lookup_meaning('RECORD_17',l_lookup_type);

1240: g_ind_asg(3).p_meaning := per_cn_shared_info.get_lookup_meaning('RECORD_13',l_lookup_type);
1241: g_ind_asg(4).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_12',l_lookup_type);
1242: g_ind_asg(5).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_13',l_lookup_type);
1243: g_ind_asg(6).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_14',l_lookup_type);
1244: g_ind_asg(7).p_meaning := per_cn_shared_info.get_lookup_meaning('RECORD_17',l_lookup_type);
1245: g_ind_asg(8).p_meaning := per_cn_shared_info.get_lookup_meaning('RECORD_18',l_lookup_type);
1246: g_ind_asg(9).p_meaning := per_cn_shared_info.get_lookup_meaning('RECORD_19',l_lookup_type);
1247:
1248:

Line 1245: g_ind_asg(8).p_meaning := per_cn_shared_info.get_lookup_meaning('RECORD_18',l_lookup_type);

1241: g_ind_asg(4).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_12',l_lookup_type);
1242: g_ind_asg(5).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_13',l_lookup_type);
1243: g_ind_asg(6).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_14',l_lookup_type);
1244: g_ind_asg(7).p_meaning := per_cn_shared_info.get_lookup_meaning('RECORD_17',l_lookup_type);
1245: g_ind_asg(8).p_meaning := per_cn_shared_info.get_lookup_meaning('RECORD_18',l_lookup_type);
1246: g_ind_asg(9).p_meaning := per_cn_shared_info.get_lookup_meaning('RECORD_19',l_lookup_type);
1247:
1248:
1249: g_ind_detail(0).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL',l_lookup_type);

Line 1246: g_ind_asg(9).p_meaning := per_cn_shared_info.get_lookup_meaning('RECORD_19',l_lookup_type);

1242: g_ind_asg(5).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_13',l_lookup_type);
1243: g_ind_asg(6).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_14',l_lookup_type);
1244: g_ind_asg(7).p_meaning := per_cn_shared_info.get_lookup_meaning('RECORD_17',l_lookup_type);
1245: g_ind_asg(8).p_meaning := per_cn_shared_info.get_lookup_meaning('RECORD_18',l_lookup_type);
1246: g_ind_asg(9).p_meaning := per_cn_shared_info.get_lookup_meaning('RECORD_19',l_lookup_type);
1247:
1248:
1249: g_ind_detail(0).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL',l_lookup_type);
1250: g_ind_detail(1).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_11',l_lookup_type);

Line 1249: g_ind_detail(0).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL',l_lookup_type);

1245: g_ind_asg(8).p_meaning := per_cn_shared_info.get_lookup_meaning('RECORD_18',l_lookup_type);
1246: g_ind_asg(9).p_meaning := per_cn_shared_info.get_lookup_meaning('RECORD_19',l_lookup_type);
1247:
1248:
1249: g_ind_detail(0).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL',l_lookup_type);
1250: g_ind_detail(1).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_11',l_lookup_type);
1251: g_ind_detail(2).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_12',l_lookup_type);
1252: g_ind_detail(3).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_13',l_lookup_type);
1253: g_ind_detail(4).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_14',l_lookup_type);

Line 1250: g_ind_detail(1).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_11',l_lookup_type);

1246: g_ind_asg(9).p_meaning := per_cn_shared_info.get_lookup_meaning('RECORD_19',l_lookup_type);
1247:
1248:
1249: g_ind_detail(0).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL',l_lookup_type);
1250: g_ind_detail(1).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_11',l_lookup_type);
1251: g_ind_detail(2).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_12',l_lookup_type);
1252: g_ind_detail(3).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_13',l_lookup_type);
1253: g_ind_detail(4).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_14',l_lookup_type);
1254: g_ind_detail(5).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_15',l_lookup_type);

Line 1251: g_ind_detail(2).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_12',l_lookup_type);

1247:
1248:
1249: g_ind_detail(0).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL',l_lookup_type);
1250: g_ind_detail(1).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_11',l_lookup_type);
1251: g_ind_detail(2).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_12',l_lookup_type);
1252: g_ind_detail(3).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_13',l_lookup_type);
1253: g_ind_detail(4).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_14',l_lookup_type);
1254: g_ind_detail(5).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_15',l_lookup_type);
1255: g_ind_detail(6).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_16',l_lookup_type);

Line 1252: g_ind_detail(3).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_13',l_lookup_type);

1248:
1249: g_ind_detail(0).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL',l_lookup_type);
1250: g_ind_detail(1).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_11',l_lookup_type);
1251: g_ind_detail(2).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_12',l_lookup_type);
1252: g_ind_detail(3).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_13',l_lookup_type);
1253: g_ind_detail(4).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_14',l_lookup_type);
1254: g_ind_detail(5).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_15',l_lookup_type);
1255: g_ind_detail(6).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_16',l_lookup_type);
1256:

Line 1253: g_ind_detail(4).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_14',l_lookup_type);

1249: g_ind_detail(0).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL',l_lookup_type);
1250: g_ind_detail(1).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_11',l_lookup_type);
1251: g_ind_detail(2).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_12',l_lookup_type);
1252: g_ind_detail(3).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_13',l_lookup_type);
1253: g_ind_detail(4).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_14',l_lookup_type);
1254: g_ind_detail(5).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_15',l_lookup_type);
1255: g_ind_detail(6).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_16',l_lookup_type);
1256:
1257:

Line 1254: g_ind_detail(5).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_15',l_lookup_type);

1250: g_ind_detail(1).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_11',l_lookup_type);
1251: g_ind_detail(2).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_12',l_lookup_type);
1252: g_ind_detail(3).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_13',l_lookup_type);
1253: g_ind_detail(4).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_14',l_lookup_type);
1254: g_ind_detail(5).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_15',l_lookup_type);
1255: g_ind_detail(6).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_16',l_lookup_type);
1256:
1257:
1258: END IF;

Line 1255: g_ind_detail(6).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_16',l_lookup_type);

1251: g_ind_detail(2).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_12',l_lookup_type);
1252: g_ind_detail(3).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_13',l_lookup_type);
1253: g_ind_detail(4).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_14',l_lookup_type);
1254: g_ind_detail(5).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_15',l_lookup_type);
1255: g_ind_detail(6).p_meaning := per_cn_shared_info.get_lookup_meaning('DETAIL_16',l_lookup_type);
1256:
1257:
1258: END IF;
1259:

Line 1455: l_file := per_cn_shared_info.get_lookup_meaning('SOE_NAME','CN_AUDIT_DATA');

1451: pay_payroll_actions
1452: WHERE payroll_action_id = p_pactid;
1453:
1454: IF g_opt_soe_or_min IS NULL OR g_opt_soe_or_min = 'ENT' THEN
1455: l_file := per_cn_shared_info.get_lookup_meaning('SOE_NAME','CN_AUDIT_DATA');
1456: ELSE
1457: l_file := per_cn_shared_info.get_lookup_meaning('PSM_NAME','CN_AUDIT_DATA');
1458: END IF;
1459:

Line 1457: l_file := per_cn_shared_info.get_lookup_meaning('PSM_NAME','CN_AUDIT_DATA');

1453:
1454: IF g_opt_soe_or_min IS NULL OR g_opt_soe_or_min = 'ENT' THEN
1455: l_file := per_cn_shared_info.get_lookup_meaning('SOE_NAME','CN_AUDIT_DATA');
1456: ELSE
1457: l_file := per_cn_shared_info.get_lookup_meaning('PSM_NAME','CN_AUDIT_DATA');
1458: END IF;
1459:
1460: l_file := l_file || g_year || lpad(to_char(g_start_period),2,'0') || lpad(to_char(g_end_period),2,'0');
1461: