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_US_PAYSLIP_SIMULATION_MAIN dependencies on PAY_PAYROLL_XML_EXTRACT_PKG

Line 46: pay_payroll_xml_extract_pkg. Added additional

42: details to make sure that the total length is
43: restricted to 60 Characters.
44: 07-Mar-2013 emunisek 120.10 16281614 Created procedure simulation_generate. This
45: was delivered earlier through package
46: pay_payroll_xml_extract_pkg. Added additional
47: procedures build_sql,print_blob and flex_seg_enabled
48: which are needed for simulation_generate
49: 14-Mar-2013 emunisek 120.11 16482011 Made changes so that Employee Name and Employer
50: Address details get displayed in the same way as

Line 3888: is created based on the procedure pay_payroll_xml_extract_pkg.

3884:
3885: /* Procedure : simulation_generate
3886: Purpose : This procedure interprets archived information, converts it to
3887: XML and prints it to a BLOB. This is a private procedure. This
3888: is created based on the procedure pay_payroll_xml_extract_pkg.
3889: generate_internal which is used by Regular Payslip
3890: Important :
3891: */
3892:

Line 3946: pay_payroll_xml_extract_pkg.g_xml_table.delete();

3942: END IF;
3943:
3944: hr_utility.trace ('P_CUSTOM_ACTION_INFO_CAT ='||P_CUSTOM_ACTION_INFO_CAT);
3945:
3946: pay_payroll_xml_extract_pkg.g_xml_table.delete();
3947: l_flex_col_num := 30;
3948: l_kff_seg_start := 5;
3949: l_kff_seg_end := 14;
3950: l_cntr_sql := 1;

Line 3990: 'pay_payroll_xml_extract_pkg.load_xml(''CS'', NULL, ''?xml version="1.0" encoding="'||

3986:
3987: IF p_generate_header_flag = 'Y' THEN
3988: build_sql(sqlstr,
3989: l_cntr_sql,
3990: 'pay_payroll_xml_extract_pkg.load_xml(''CS'', NULL, ''?xml version="1.0" encoding="'||
3991: hr_mx_utility.get_IANA_charset||'"?'', NULL);');
3992: END IF;
3993:
3994: IF p_root_tag IS NOT NULL THEN

Line 3997: 'pay_payroll_xml_extract_pkg.load_xml(''CS'', NULL, '''||

3993:
3994: IF p_root_tag IS NOT NULL THEN
3995: build_sql(sqlstr,
3996: l_cntr_sql,
3997: 'pay_payroll_xml_extract_pkg.load_xml(''CS'', NULL, '''||
3998: p_root_tag||''', NULL);');
3999: END IF;
4000:
4001: /* Fetch legislation_code. */

Line 4003: FETCH pay_us_payslip_simulation_main.get_leg_code INTO pay_payroll_xml_extract_pkg.g_leg_code;

3999: END IF;
4000:
4001: /* Fetch legislation_code. */
4002: OPEN pay_us_payslip_simulation_main.get_leg_code(p_action_context_id);
4003: FETCH pay_us_payslip_simulation_main.get_leg_code INTO pay_payroll_xml_extract_pkg.g_leg_code;
4004: CLOSE pay_us_payslip_simulation_main.get_leg_code;
4005:
4006: /* Checking for International Payroll Legislation,
4007: The flag g_install_leg_check returns 'N' for International Payroll localization and 'Y' for supported legislations.

Line 4010: g_install_leg_check := pay_ip_utility.get_ip_installation(pay_payroll_xml_extract_pkg.g_leg_code);

4006: /* Checking for International Payroll Legislation,
4007: The flag g_install_leg_check returns 'N' for International Payroll localization and 'Y' for supported legislations.
4008: */
4009:
4010: g_install_leg_check := pay_ip_utility.get_ip_installation(pay_payroll_xml_extract_pkg.g_leg_code);
4011:
4012: FOR csr_get_archived_regions_rec IN pay_us_payslip_simulation_main.csr_get_archived_regions(p_action_context_id,
4013: p_action_information_id)
4014: LOOP

Line 4017: ('ADDRESS DETAILS', pay_payroll_xml_extract_pkg.g_leg_code ||

4013: p_action_information_id)
4014: LOOP
4015:
4016: IF csr_get_archived_regions_rec.action_information_category IN
4017: ('ADDRESS DETAILS', pay_payroll_xml_extract_pkg.g_leg_code ||
4018: ' EMPLOYER DETAILS') THEN
4019: build_sql(sqlstr,
4020: l_cntr_sql,
4021: 'FOR csr_get_sim_arch_info_rec IN pay_us_payslip_simulation_main.csr_get_sim_archived_info (:l_action_context_id,'''||

Line 4033: 'pay_payroll_xml_extract_pkg.load_xml(''CS'', NULL, ''' ||

4029: ||''', NULL, :l_action_information_id) LOOP ');
4030: END IF;
4031: build_sql(sqlstr,
4032: l_cntr_sql,
4033: 'pay_payroll_xml_extract_pkg.load_xml(''CS'', NULL, ''' ||
4034: csr_get_archived_regions_rec.action_information_category ||
4035: ''', NULL);');
4036:
4037: IF csr_get_archived_regions_rec.action_information_category = 'EMPLOYEE DETAILS'

Line 4038: AND pay_payroll_xml_extract_pkg.g_leg_code = 'US' THEN

4034: csr_get_archived_regions_rec.action_information_category ||
4035: ''', NULL);');
4036:
4037: IF csr_get_archived_regions_rec.action_information_category = 'EMPLOYEE DETAILS'
4038: AND pay_payroll_xml_extract_pkg.g_leg_code = 'US' THEN
4039:
4040: build_sql(sqlstr, l_cntr_sql, 'lt_pay_date := csr_get_sim_arch_info_rec.effective_date;');
4041:
4042: build_sql(sqlstr,l_cntr_sql,

Line 4066: build_sql(sqlstr,l_cntr_sql,'pay_payroll_xml_extract_pkg.load_xml(''D'', ''RATE_DISP_FLG'', lt_rate_flg);');

4062: 'AND organization_id=csr_get_sim_arch_info_rec.action_information2),''K'') INTO lt_rate_flg FROM DUAL;');
4063: build_sql(sqlstr,l_cntr_sql,'IF lt_rate_flg = ''K'' THEN ');
4064: build_sql(sqlstr,l_cntr_sql,' lt_rate_flg := ''N'';');
4065: build_sql(sqlstr,l_cntr_sql,'END IF;'||'END IF;'||'END IF;');
4066: build_sql(sqlstr,l_cntr_sql,'pay_payroll_xml_extract_pkg.load_xml(''D'', ''RATE_DISP_FLG'', lt_rate_flg);');
4067:
4068: END IF;
4069:
4070: IF csr_get_archived_regions_rec.action_information_category = 'AC EARNINGS'

Line 4071: AND pay_payroll_xml_extract_pkg.g_leg_code = 'US' THEN

4067:
4068: END IF;
4069:
4070: IF csr_get_archived_regions_rec.action_information_category = 'AC EARNINGS'
4071: AND pay_payroll_xml_extract_pkg.g_leg_code = 'US' THEN
4072:
4073: build_sql(sqlstr, l_cntr_sql, 'lt_state_cd := substr(csr_get_sim_arch_info_rec.action_information21,1,2);');
4074: build_sql(sqlstr, l_cntr_sql, 'lt_element_type := csr_get_sim_arch_info_rec.action_information20;');
4075: build_sql(sqlstr, l_cntr_sql,

Line 4079: ' pay_payroll_xml_extract_pkg.load_xml(''D'', ''DATE_DISP_FLG'', lt_ret_val);');

4075: build_sql(sqlstr, l_cntr_sql,
4076: 'SELECT NVL(hruserdt.get_table_value('||lt_per_bgId_value||',''ONLINE_PAYSLIP_DATE_CONTROL_TBL'',lt_state_cd'||
4077: ',lt_element_type,lt_pay_date),''N'') INTO lt_ret_val FROM DUAL ;');
4078: build_sql(sqlstr,l_cntr_sql,
4079: ' pay_payroll_xml_extract_pkg.load_xml(''D'', ''DATE_DISP_FLG'', lt_ret_val);');
4080:
4081: END IF;
4082:
4083: IF csr_get_archived_regions_rec.action_information_category =

Line 4112: 'pay_payroll_xml_extract_pkg.load_xml(''D'', ''Segment'

4108: AND cntr_flex_col BETWEEN l_kff_seg_start
4109: AND l_kff_seg_end THEN
4110: build_sql(sqlstr,
4111: l_cntr_sql,
4112: 'pay_payroll_xml_extract_pkg.load_xml(''D'', ''Segment'
4113: || (cntr_flex_col - l_kff_seg_start + 1) ||
4114: ''', LTRIM(RTRIM(csr_get_sim_arch_info_rec.action_information'
4115: || cntr_flex_col ||')));');
4116: ELSE

Line 4120: AND pay_payroll_xml_extract_pkg.g_leg_code = 'US' THEN

4116: ELSE
4117:
4118: IF csr_get_archived_regions_rec.action_information_category =
4119: 'EMPLOYEE THIRD PARTY PAYMENTS'
4120: AND pay_payroll_xml_extract_pkg.g_leg_code = 'US' THEN
4121:
4122: build_sql(sqlstr,l_cntr_sql,
4123: 'csr_get_sim_arch_info_rec.action_information4 :=
4124: pay_us_employee_payslip_web.get_check_number(csr_get_sim_arch_info_rec.action_information17

Line 4134: 'pay_payroll_xml_extract_pkg.load_xml(''D'', '''

4130:
4131: END IF;
4132:
4133: build_sql(sqlstr,l_cntr_sql,
4134: 'pay_payroll_xml_extract_pkg.load_xml(''D'', '''
4135: || csr_get_archived_regions_rec.action_information_category ||
4136: ''', ''ACTION_INFORMATION'|| cntr_flex_col ||
4137: ''', LTRIM(RTRIM(csr_get_sim_arch_info_rec.action_information'
4138: || cntr_flex_col ||')));');

Line 4153: 'FOR csr_payroll_details_rec IN pay_payroll_xml_extract_pkg.csr_payroll_details(csr_get_sim_arch_info_rec.action_information16) LOOP ');

4149: IF csr_get_archived_regions_rec.action_information_category =
4150: 'EMPLOYEE DETAILS' THEN
4151: build_sql(sqlstr,
4152: l_cntr_sql,
4153: 'FOR csr_payroll_details_rec IN pay_payroll_xml_extract_pkg.csr_payroll_details(csr_get_sim_arch_info_rec.action_information16) LOOP ');
4154: build_sql(sqlstr,
4155: l_cntr_sql,
4156: 'pay_payroll_xml_extract_pkg.load_xml(''D'', NULL, ''PAYROLL_NAME'', csr_payroll_details_rec.payroll_name);');
4157: build_sql(sqlstr,

Line 4156: 'pay_payroll_xml_extract_pkg.load_xml(''D'', NULL, ''PAYROLL_NAME'', csr_payroll_details_rec.payroll_name);');

4152: l_cntr_sql,
4153: 'FOR csr_payroll_details_rec IN pay_payroll_xml_extract_pkg.csr_payroll_details(csr_get_sim_arch_info_rec.action_information16) LOOP ');
4154: build_sql(sqlstr,
4155: l_cntr_sql,
4156: 'pay_payroll_xml_extract_pkg.load_xml(''D'', NULL, ''PAYROLL_NAME'', csr_payroll_details_rec.payroll_name);');
4157: build_sql(sqlstr,
4158: l_cntr_sql,
4159: 'pay_payroll_xml_extract_pkg.load_xml(''D'', NULL, ''PERIOD_TYPE'', csr_payroll_details_rec.period_type);');
4160: build_sql(sqlstr,

Line 4159: 'pay_payroll_xml_extract_pkg.load_xml(''D'', NULL, ''PERIOD_TYPE'', csr_payroll_details_rec.period_type);');

4155: l_cntr_sql,
4156: 'pay_payroll_xml_extract_pkg.load_xml(''D'', NULL, ''PAYROLL_NAME'', csr_payroll_details_rec.payroll_name);');
4157: build_sql(sqlstr,
4158: l_cntr_sql,
4159: 'pay_payroll_xml_extract_pkg.load_xml(''D'', NULL, ''PERIOD_TYPE'', csr_payroll_details_rec.period_type);');
4160: build_sql(sqlstr,
4161: l_cntr_sql,
4162: 'pay_payroll_xml_extract_pkg.load_xml(''D'', NULL, ''START_DATE'', csr_payroll_details_rec.start_date);');
4163: build_sql(sqlstr,

Line 4162: 'pay_payroll_xml_extract_pkg.load_xml(''D'', NULL, ''START_DATE'', csr_payroll_details_rec.start_date);');

4158: l_cntr_sql,
4159: 'pay_payroll_xml_extract_pkg.load_xml(''D'', NULL, ''PERIOD_TYPE'', csr_payroll_details_rec.period_type);');
4160: build_sql(sqlstr,
4161: l_cntr_sql,
4162: 'pay_payroll_xml_extract_pkg.load_xml(''D'', NULL, ''START_DATE'', csr_payroll_details_rec.start_date);');
4163: build_sql(sqlstr,
4164: l_cntr_sql,
4165: 'pay_payroll_xml_extract_pkg.load_xml(''D'', NULL, ''END_DATE'', csr_payroll_details_rec.end_date);');
4166: build_sql(sqlstr,

Line 4165: 'pay_payroll_xml_extract_pkg.load_xml(''D'', NULL, ''END_DATE'', csr_payroll_details_rec.end_date);');

4161: l_cntr_sql,
4162: 'pay_payroll_xml_extract_pkg.load_xml(''D'', NULL, ''START_DATE'', csr_payroll_details_rec.start_date);');
4163: build_sql(sqlstr,
4164: l_cntr_sql,
4165: 'pay_payroll_xml_extract_pkg.load_xml(''D'', NULL, ''END_DATE'', csr_payroll_details_rec.end_date);');
4166: build_sql(sqlstr,
4167: l_cntr_sql,
4168: 'pay_payroll_xml_extract_pkg.load_xml(''D'', NULL, ''PAYMENT_DATE'', substr(fnd_date.date_to_canonical(csr_get_sim_arch_info_rec.effective_date),1,10));');
4169: build_sql(sqlstr,

Line 4168: 'pay_payroll_xml_extract_pkg.load_xml(''D'', NULL, ''PAYMENT_DATE'', substr(fnd_date.date_to_canonical(csr_get_sim_arch_info_rec.effective_date),1,10));');

4164: l_cntr_sql,
4165: 'pay_payroll_xml_extract_pkg.load_xml(''D'', NULL, ''END_DATE'', csr_payroll_details_rec.end_date);');
4166: build_sql(sqlstr,
4167: l_cntr_sql,
4168: 'pay_payroll_xml_extract_pkg.load_xml(''D'', NULL, ''PAYMENT_DATE'', substr(fnd_date.date_to_canonical(csr_get_sim_arch_info_rec.effective_date),1,10));');
4169: build_sql(sqlstr,
4170: l_cntr_sql,
4171: 'END LOOP;');
4172: build_sql(sqlstr,

Line 4200: pay_payroll_xml_extract_pkg.g_leg_code||

4196:
4197: build_sql(sqlstr,
4198: l_cntr_sql,
4199: 'EXECUTE IMMEDIATE (''BEGIN pay_'||
4200: pay_payroll_xml_extract_pkg.g_leg_code||
4201: '_simulation.add_custom_xml('||l_action_context_id||
4202: ', '''''|| csr_get_archived_regions_rec.action_information_category ||
4203: ''''', '''''|| p_document_type ||
4204: '''''); END;'');');

Line 4210: 'IF pay_payroll_xml_extract_pkg.g_custom_xml.count() > 0 THEN ');

4206: END IF;
4207:
4208: build_sql(sqlstr,
4209: l_cntr_sql,
4210: 'IF pay_payroll_xml_extract_pkg.g_custom_xml.count() > 0 THEN ');
4211: build_sql(sqlstr,
4212: l_cntr_sql,
4213: 'pay_payroll_xml_extract_pkg.load_xml('''');');
4216: build_sql(sqlstr,
4217: l_cntr_sql,

Line 4214: pay_payroll_xml_extract_pkg.g_leg_code||

4210: 'IF pay_payroll_xml_extract_pkg.g_custom_xml.count() > 0 THEN ');
4211: build_sql(sqlstr,
4212: l_cntr_sql,
4213: 'pay_payroll_xml_extract_pkg.load_xml('''');');
4216: build_sql(sqlstr,
4217: l_cntr_sql,
4218: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');

Line 4218: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');

4214: pay_payroll_xml_extract_pkg.g_leg_code||
4215: '_SIMULATION.ADD_CUSTOM_XML -->'');');
4216: build_sql(sqlstr,
4217: l_cntr_sql,
4218: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');
4219: build_sql(sqlstr,
4220: l_cntr_sql,
4221: 'pay_payroll_xml_extract_pkg.load_xml(pay_payroll_xml_extract_pkg.g_custom_xml(cntr));');
4222: build_sql(sqlstr,

Line 4221: 'pay_payroll_xml_extract_pkg.load_xml(pay_payroll_xml_extract_pkg.g_custom_xml(cntr));');

4217: l_cntr_sql,
4218: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');
4219: build_sql(sqlstr,
4220: l_cntr_sql,
4221: 'pay_payroll_xml_extract_pkg.load_xml(pay_payroll_xml_extract_pkg.g_custom_xml(cntr));');
4222: build_sql(sqlstr,
4223: l_cntr_sql,
4224: 'END LOOP;');
4225: build_sql(sqlstr,

Line 4227: 'pay_payroll_xml_extract_pkg.g_custom_xml.delete();');

4223: l_cntr_sql,
4224: 'END LOOP;');
4225: build_sql(sqlstr,
4226: l_cntr_sql,
4227: 'pay_payroll_xml_extract_pkg.g_custom_xml.delete();');
4228: build_sql(sqlstr,
4229: l_cntr_sql,
4230: 'END IF;');
4231: build_sql(sqlstr,

Line 4255: 'IF pay_payroll_xml_extract_pkg.g_custom_xml.count() > 0 THEN ');

4251: ''''', '''''|| p_document_type ||
4252: '''''); END;'');');
4253: build_sql(sqlstr,
4254: l_cntr_sql,
4255: 'IF pay_payroll_xml_extract_pkg.g_custom_xml.count() > 0 THEN ');
4256: build_sql(sqlstr,
4257: l_cntr_sql,
4258: 'pay_payroll_xml_extract_pkg.load_xml('''');');

Line 4258: 'pay_payroll_xml_extract_pkg.load_xml('''');');
4260: build_sql(sqlstr,
4261: l_cntr_sql,
4262: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');

Line 4262: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');

4258: 'pay_payroll_xml_extract_pkg.load_xml('''');');
4260: build_sql(sqlstr,
4261: l_cntr_sql,
4262: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');
4263: build_sql(sqlstr,
4264: l_cntr_sql,
4265: 'pay_payroll_xml_extract_pkg.load_xml(pay_payroll_xml_extract_pkg.g_custom_xml(cntr));');
4266: build_sql(sqlstr,

Line 4265: 'pay_payroll_xml_extract_pkg.load_xml(pay_payroll_xml_extract_pkg.g_custom_xml(cntr));');

4261: l_cntr_sql,
4262: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');
4263: build_sql(sqlstr,
4264: l_cntr_sql,
4265: 'pay_payroll_xml_extract_pkg.load_xml(pay_payroll_xml_extract_pkg.g_custom_xml(cntr));');
4266: build_sql(sqlstr,
4267: l_cntr_sql,
4268: 'END LOOP;');
4269: build_sql(sqlstr,

Line 4271: 'pay_payroll_xml_extract_pkg.g_custom_xml.delete();');

4267: l_cntr_sql,
4268: 'END LOOP;');
4269: build_sql(sqlstr,
4270: l_cntr_sql,
4271: 'pay_payroll_xml_extract_pkg.g_custom_xml.delete();');
4272: build_sql(sqlstr,
4273: l_cntr_sql,
4274: 'END IF;');
4275: build_sql(sqlstr,

Line 4287: 'pay_payroll_xml_extract_pkg.load_xml(''CE'', NULL, ''' ||

4283: 'END;');
4284:
4285: build_sql(sqlstr,
4286: l_cntr_sql,
4287: 'pay_payroll_xml_extract_pkg.load_xml(''CE'', NULL, ''' ||
4288: csr_get_archived_regions_rec.action_information_category ||
4289: ''', NULL);');
4290: build_sql(sqlstr,
4291: l_cntr_sql,

Line 4314: pay_payroll_xml_extract_pkg.g_leg_code||

4310:
4311: build_sql(sqlstr,
4312: l_cntr_sql,
4313: 'EXECUTE IMMEDIATE (''BEGIN pay_'||
4314: pay_payroll_xml_extract_pkg.g_leg_code||
4315: '_simulation.add_custom_xml('||l_action_context_id||', NULL'||
4316: ', '''''|| p_document_type ||
4317: '''''); END;'');');
4318:

Line 4323: 'IF pay_payroll_xml_extract_pkg.g_custom_xml.count() > 0 THEN ');

4319: END IF;
4320:
4321: build_sql(sqlstr,
4322: l_cntr_sql,
4323: 'IF pay_payroll_xml_extract_pkg.g_custom_xml.count() > 0 THEN ');
4324: build_sql(sqlstr,
4325: l_cntr_sql,
4326: 'pay_payroll_xml_extract_pkg.load_xml('''');');
4329: build_sql(sqlstr,
4330: l_cntr_sql,

Line 4327: pay_payroll_xml_extract_pkg.g_leg_code||

4323: 'IF pay_payroll_xml_extract_pkg.g_custom_xml.count() > 0 THEN ');
4324: build_sql(sqlstr,
4325: l_cntr_sql,
4326: 'pay_payroll_xml_extract_pkg.load_xml('''');');
4329: build_sql(sqlstr,
4330: l_cntr_sql,
4331: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');

Line 4331: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');

4327: pay_payroll_xml_extract_pkg.g_leg_code||
4328: '_SIMULATION.ADD_CUSTOM_XML -->'');');
4329: build_sql(sqlstr,
4330: l_cntr_sql,
4331: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');
4332: build_sql(sqlstr,
4333: l_cntr_sql,
4334: 'pay_payroll_xml_extract_pkg.load_xml(pay_payroll_xml_extract_pkg.g_custom_xml(cntr));');
4335: build_sql(sqlstr,

Line 4334: 'pay_payroll_xml_extract_pkg.load_xml(pay_payroll_xml_extract_pkg.g_custom_xml(cntr));');

4330: l_cntr_sql,
4331: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');
4332: build_sql(sqlstr,
4333: l_cntr_sql,
4334: 'pay_payroll_xml_extract_pkg.load_xml(pay_payroll_xml_extract_pkg.g_custom_xml(cntr));');
4335: build_sql(sqlstr,
4336: l_cntr_sql,
4337: 'END LOOP;');
4338: build_sql(sqlstr,

Line 4340: 'pay_payroll_xml_extract_pkg.g_custom_xml.delete();');

4336: l_cntr_sql,
4337: 'END LOOP;');
4338: build_sql(sqlstr,
4339: l_cntr_sql,
4340: 'pay_payroll_xml_extract_pkg.g_custom_xml.delete();');
4341: build_sql(sqlstr,
4342: l_cntr_sql,
4343: 'END IF;');
4344: build_sql(sqlstr,

Line 4366: 'IF pay_payroll_xml_extract_pkg.g_custom_xml.count() > 0 THEN ');

4362: ', '''''|| p_document_type ||
4363: '''''); END;'');');
4364: build_sql(sqlstr,
4365: l_cntr_sql,
4366: 'IF pay_payroll_xml_extract_pkg.g_custom_xml.count() > 0 THEN ');
4367: build_sql(sqlstr,
4368: l_cntr_sql,
4369: 'pay_payroll_xml_extract_pkg.load_xml('''');');

Line 4369: 'pay_payroll_xml_extract_pkg.load_xml('''');');
4371: build_sql(sqlstr,
4372: l_cntr_sql,
4373: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');

Line 4373: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');

4369: 'pay_payroll_xml_extract_pkg.load_xml('''');');
4371: build_sql(sqlstr,
4372: l_cntr_sql,
4373: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');
4374: build_sql(sqlstr,
4375: l_cntr_sql,
4376: 'pay_payroll_xml_extract_pkg.load_xml(pay_payroll_xml_extract_pkg.g_custom_xml(cntr));');
4377: build_sql(sqlstr,

Line 4376: 'pay_payroll_xml_extract_pkg.load_xml(pay_payroll_xml_extract_pkg.g_custom_xml(cntr));');

4372: l_cntr_sql,
4373: 'FOR cntr IN pay_payroll_xml_extract_pkg.g_custom_xml.first()..pay_payroll_xml_extract_pkg.g_custom_xml.last() LOOP ');
4374: build_sql(sqlstr,
4375: l_cntr_sql,
4376: 'pay_payroll_xml_extract_pkg.load_xml(pay_payroll_xml_extract_pkg.g_custom_xml(cntr));');
4377: build_sql(sqlstr,
4378: l_cntr_sql,
4379: 'END LOOP;');
4380: build_sql(sqlstr,

Line 4382: 'pay_payroll_xml_extract_pkg.g_custom_xml.delete();');

4378: l_cntr_sql,
4379: 'END LOOP;');
4380: build_sql(sqlstr,
4381: l_cntr_sql,
4382: 'pay_payroll_xml_extract_pkg.g_custom_xml.delete();');
4383: build_sql(sqlstr,
4384: l_cntr_sql,
4385: 'END IF;');
4386: build_sql(sqlstr,

Line 4399: 'pay_payroll_xml_extract_pkg.load_xml(''CE'', NULL, '''||

4395:
4396: IF p_root_tag IS NOT NULL THEN
4397: build_sql(sqlstr,
4398: l_cntr_sql,
4399: 'pay_payroll_xml_extract_pkg.load_xml(''CE'', NULL, '''||
4400: p_root_tag||''', NULL);');
4401: END IF;
4402:
4403: build_sql(sqlstr,

Line 4430: IF pay_payroll_xml_extract_pkg.g_xml_table.count() <> 0 THEN

4426: p_action_information_id);
4427: ret := dbms_sql.execute(csr);
4428: dbms_sql.close_cursor(csr);
4429:
4430: IF pay_payroll_xml_extract_pkg.g_xml_table.count() <> 0 THEN
4431: dbms_lob.createTemporary(l_xml, true, dbms_lob.session);
4432: FOR cntr IN pay_payroll_xml_extract_pkg.g_xml_table.first()..pay_payroll_xml_extract_pkg.g_xml_table.last() LOOP
4433: lr_xml := utl_raw.cast_to_raw(pay_payroll_xml_extract_pkg.g_xml_table(cntr));
4434: ln_amt := utl_raw.length(lr_xml);

Line 4432: FOR cntr IN pay_payroll_xml_extract_pkg.g_xml_table.first()..pay_payroll_xml_extract_pkg.g_xml_table.last() LOOP

4428: dbms_sql.close_cursor(csr);
4429:
4430: IF pay_payroll_xml_extract_pkg.g_xml_table.count() <> 0 THEN
4431: dbms_lob.createTemporary(l_xml, true, dbms_lob.session);
4432: FOR cntr IN pay_payroll_xml_extract_pkg.g_xml_table.first()..pay_payroll_xml_extract_pkg.g_xml_table.last() LOOP
4433: lr_xml := utl_raw.cast_to_raw(pay_payroll_xml_extract_pkg.g_xml_table(cntr));
4434: ln_amt := utl_raw.length(lr_xml);
4435:
4436: dbms_lob.writeAppend(l_xml,

Line 4433: lr_xml := utl_raw.cast_to_raw(pay_payroll_xml_extract_pkg.g_xml_table(cntr));

4429:
4430: IF pay_payroll_xml_extract_pkg.g_xml_table.count() <> 0 THEN
4431: dbms_lob.createTemporary(l_xml, true, dbms_lob.session);
4432: FOR cntr IN pay_payroll_xml_extract_pkg.g_xml_table.first()..pay_payroll_xml_extract_pkg.g_xml_table.last() LOOP
4433: lr_xml := utl_raw.cast_to_raw(pay_payroll_xml_extract_pkg.g_xml_table(cntr));
4434: ln_amt := utl_raw.length(lr_xml);
4435:
4436: dbms_lob.writeAppend(l_xml,
4437: ln_amt,

Line 4440: hr_utility.trace (pay_payroll_xml_extract_pkg.g_xml_table(cntr));

4436: dbms_lob.writeAppend(l_xml,
4437: ln_amt,
4438: lr_xml);
4439:
4440: hr_utility.trace (pay_payroll_xml_extract_pkg.g_xml_table(cntr));
4441: END LOOP;
4442: p_xml := l_xml;
4443: dbms_lob.freeTemporary(l_xml);
4444: END IF;

Line 4449: pay_payroll_xml_extract_pkg.g_xml_table.delete();

4445:
4446: print_blob (p_xml);
4447:
4448: -- Unset globals before exit;
4449: pay_payroll_xml_extract_pkg.g_xml_table.delete();
4450: g_custom_context := NULL;
4451:
4452: hr_utility.trace ('Leaving '||gv_package||lv_procedure_name);
4453:

Line 4461: PAY_PAYROLL_XML_EXTRACT_PKG.GENERATE.

4457: /* Procedure : generate_xml
4458: Purpose : This procedure is used to generate the XML Data necessary
4459: to generate the Payroll Simulation Output. This procedure
4460: is similar to the current XML generation procedure
4461: PAY_PAYROLL_XML_EXTRACT_PKG.GENERATE.
4462: Important : This procedure will be executed by Core Payroll post the
4463: Database level rollback of changes made during Payroll
4464: Simulation run. Hence any information required for
4465: generating Output, that will not be available due to