DBA Data[Home] [Help]

APPS.PAY_MX_SUA_MAG dependencies on PAY_MAGTAPE_GENERIC

Line 779: pay_magtape_generic.get_parameter_value ('TRANSFER_ACT_ID')),

775: AND paa.assignment_action_id = cp_asg_act_id;
776:
777: CURSOR csr_asg_actions (cp_person_id number) IS
778: SELECT fnd_number.canonical_to_number(
779: pay_magtape_generic.get_parameter_value ('TRANSFER_ACT_ID')),
780: fnd_date.canonical_to_date(g_mag_end_date)
781: FROM DUAL
782: UNION
783: SELECT paa.assignment_action_id,

Line 905: ln_assignment_action_id := pay_magtape_generic.get_parameter_value

901: hr_utility_trace ('Entering '||l_proc_name);
902: lv_per_do_not_report := 'N';
903: ln_prev_payroll_action_id := -1;
904:
905: ln_assignment_action_id := pay_magtape_generic.get_parameter_value
906: ('TRANSFER_ACT_ID');
907: hr_utility_trace ('Processing asg action '|| ln_assignment_action_id);
908: OPEN c_get_bus_grp_id;
909: FETCH c_get_bus_grp_id INTO ln_business_group;

Line 998: ln_assignment_action_id := pay_magtape_generic.get_parameter_value

994: CLOSE get_emp_details;
995: END LOOP;
996: CLOSE csr_asg_actions;
997:
998: ln_assignment_action_id := pay_magtape_generic.get_parameter_value
999: ('TRANSFER_ACT_ID');
1000: hr_utility_trace ('Fetching transactions for magtape asg action '||
1001: ln_assignment_action_id);
1002:

Line 1179: pay_magtape_generic.get_parameter_value('ROOT_XML_TAG'));

1175: l_proc_name := g_proc_name || 'GEN_XML_HEADER';
1176: hr_utility_trace ('Entering '||l_proc_name);
1177:
1178: hr_utility_trace ('Root XML tag = '||
1179: pay_magtape_generic.get_parameter_value('ROOT_XML_TAG'));
1180:
1181: lv_buf := pay_magtape_generic.get_parameter_value('ROOT_XML_TAG');
1182:
1183: write_to_magtape_lob (lv_buf);

Line 1181: lv_buf := pay_magtape_generic.get_parameter_value('ROOT_XML_TAG');

1177:
1178: hr_utility_trace ('Root XML tag = '||
1179: pay_magtape_generic.get_parameter_value('ROOT_XML_TAG'));
1180:
1181: lv_buf := pay_magtape_generic.get_parameter_value('ROOT_XML_TAG');
1182:
1183: write_to_magtape_lob (lv_buf);
1184:
1185: hr_utility_trace ('BLOB contents after appending header information');

Line 1210: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');

1206: WHERE paa_arch.assignment_action_id = lck.locked_action_id
1207: AND lck.locking_action_id = paa_mag.assignment_action_id
1208: AND paa_mag.chunk_number >= cp_chunk
1209: AND paa_mag.payroll_action_id =
1210: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
1211:
1212: CURSOR get_action_info_id (cp_action_context_id number) IS
1213: SELECT pai.action_information_id
1214: FROM pay_action_information pai

Line 1245: || pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'));

1241:
1242: -- Bug 4541979
1243: IF lt_act_info_id.count() = 0 THEN
1244: hr_utility_trace('GRE Information not found for magtape payroll action '
1245: || pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'));
1246: ELSE
1247: pay_payroll_xml_extract_pkg.generate(lt_act_info_id,
1248: NULL,
1249: g_document_type,

Line 1254: get_pact_info (pay_magtape_generic.get_parameter_value

1250: l_xml);
1251:
1252: -- Reload global variables if they are unset between multiple threads.
1253: IF g_mag_gre_id IS NULL THEN
1254: get_pact_info (pay_magtape_generic.get_parameter_value
1255: ('PAYROLL_ACTION_ID'),
1256: g_mag_gre_id,
1257: g_mag_start_date,
1258: g_mag_end_date,

Line 1278: SUBSTR(pay_magtape_generic.get_parameter_value('ROOT_XML_TAG'),

1274: write_to_magtape_lob (l_xml);
1275: END IF;
1276:
1277: lv_buf := ' 1278: SUBSTR(pay_magtape_generic.get_parameter_value('ROOT_XML_TAG'),
1279: 2);
1280:
1281: write_to_magtape_lob (lv_buf);
1282: