DBA Data[Home] [Help]

APPS.PAY_MX_SUA_MAG dependencies on PAY_MAGTAPE_GENERIC

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

890: AND paa.assignment_action_id = cp_asg_act_id;
891:
892: CURSOR csr_asg_actions (cp_person_id number) IS
893: SELECT fnd_number.canonical_to_number(
894: pay_magtape_generic.get_parameter_value ('TRANSFER_ACT_ID')),
895: fnd_date.canonical_to_date(g_mag_end_date)
896: FROM DUAL
897: UNION
898: SELECT paa.assignment_action_id,

Line 1023: ln_assignment_action_id := pay_magtape_generic.get_parameter_value

1019: hr_utility_trace ('Entering '||l_proc_name);
1020: lv_per_do_not_report := 'N';
1021: ln_prev_payroll_action_id := -1;
1022:
1023: ln_assignment_action_id := pay_magtape_generic.get_parameter_value
1024: ('TRANSFER_ACT_ID');
1025: hr_utility_trace ('Processing asg action '|| ln_assignment_action_id);
1026:
1027: ld_end_date := fnd_date.canonical_to_date (g_mag_end_date)+1;

Line 1121: ln_assignment_action_id := pay_magtape_generic.get_parameter_value

1117: CLOSE get_emp_details;
1118: END LOOP;
1119: CLOSE csr_asg_actions;
1120:
1121: ln_assignment_action_id := pay_magtape_generic.get_parameter_value
1122: ('TRANSFER_ACT_ID');
1123: hr_utility_trace ('Fetching transactions for magtape asg action '||
1124: ln_assignment_action_id);
1125:

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

1303: l_proc_name := g_proc_name || 'GEN_XML_HEADER';
1304: hr_utility_trace ('Entering '||l_proc_name);
1305:
1306: hr_utility_trace ('Root XML tag = '||
1307: pay_magtape_generic.get_parameter_value('ROOT_XML_TAG'));
1308:
1309: lv_buf := pay_magtape_generic.get_parameter_value('ROOT_XML_TAG');
1310:
1311: write_to_magtape_lob (lv_buf);

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

1305:
1306: hr_utility_trace ('Root XML tag = '||
1307: pay_magtape_generic.get_parameter_value('ROOT_XML_TAG'));
1308:
1309: lv_buf := pay_magtape_generic.get_parameter_value('ROOT_XML_TAG');
1310:
1311: write_to_magtape_lob (lv_buf);
1312:
1313: hr_utility_trace ('BLOB contents after appending header information');

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

1334: WHERE paa_arch.assignment_action_id = lck.locked_action_id
1335: AND lck.locking_action_id = paa_mag.assignment_action_id
1336: AND paa_mag.chunk_number >= cp_chunk
1337: AND paa_mag.payroll_action_id =
1338: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
1339:
1340: CURSOR get_action_info_id (cp_action_context_id number) IS
1341: SELECT pai.action_information_id
1342: FROM pay_action_information pai

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

1369:
1370: -- Bug 4541979
1371: IF lt_act_info_id.count() = 0 THEN
1372: hr_utility_trace('GRE Information not found for magtape payroll action '
1373: || pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'));
1374: ELSE
1375: pay_payroll_xml_extract_pkg.generate(lt_act_info_id,
1376: NULL,
1377: g_document_type,

Line 1382: get_pact_info (pay_magtape_generic.get_parameter_value

1378: l_xml);
1379:
1380: -- Reload global variables if they are unset between multiple threads.
1381: IF g_mag_gre_id IS NULL THEN
1382: get_pact_info (pay_magtape_generic.get_parameter_value
1383: ('PAYROLL_ACTION_ID'),
1384: g_mag_gre_id,
1385: g_mag_start_date,
1386: g_mag_end_date,

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

1402: write_to_magtape_lob (l_xml);
1403: END IF;
1404:
1405: lv_buf := ' 1406: SUBSTR(pay_magtape_generic.get_parameter_value('ROOT_XML_TAG'),
1407: 2);
1408:
1409: write_to_magtape_lob (lv_buf);
1410: