[Home] [Help]
850: -- This procedure gets the parameters given by user and restricts
851: -- the assignments to be archived.
852: -- it then calls hr_nonrun.insact to create an assignment action id
853: -- it then archives Payroll Run assignment action id details
854: -- in pay_Action_information with context 'AU_ARCHIVE_ASG_DETAILS'
855: -- for each assignment.
856: -- There are 10 different cursors for choosing the assignment ids.
857: -- Depending on the parameters passed,the appropriate cursor is used.
858: --------------------------------------------------------------------+
1025:
1026: -- Create the archive assignment actions
1027: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
1028:
1029: insert into pay_action_information(
1030: action_information_id,
1031: action_context_id,
1032: action_context_type,
1033: effective_date,
1039: action_information3,
1040: assignment_id
1041: )
1042: values(
1043: pay_action_information_s.nextval,
1044: l_next_assignment_action_id,
1045: 'AAP',
1046: null,
1047: null,
1166:
1167: cursor csr_get_data (c_arc_ass_act_id number)
1168: is
1169: select pai.action_information1, pai.action_information2, pai.tax_unit_id, pai.assignment_id,pai.action_information3
1170: from pay_action_information pai
1171: where action_information_category = 'AU_ARCHIVE_ASG_DETAILS'
1172: and pai.action_context_id = c_arc_ass_act_id;
1173:
1174:
1358:
1359:
1360:
1361: hr_utility.set_location('in BBR loop', 300);
1362: insert into pay_action_information(
1363: action_information_id,
1364: action_context_id,
1365: action_context_type,
1366: effective_date,
1377: action_information7,
1378: action_information8,
1379: action_information9)
1380: values(
1381: pay_action_information_s.nextval,
1382: g_arc_payroll_action_id,
1383: 'PA',
1384: p_effective_date,
1385: null,
1399:
1400:
1401:
1402: --
1403: -- Insert the balance data into pay_action_information table
1404: -- This Direct Insert statement is for Performance Reasons.
1405: --
1406: insert into pay_action_information (
1407: action_information_id,
1402: --
1403: -- Insert the balance data into pay_action_information table
1404: -- This Direct Insert statement is for Performance Reasons.
1405: --
1406: insert into pay_action_information (
1407: action_information_id,
1408: action_context_id,
1409: action_context_type,
1410: effective_date,
1427: action_information13,
1428: action_information14,
1429: action_information15) /* 4731692 */
1430: values (
1431: pay_action_information_s.nextval,
1432: p_assignment_action_id,
1433: 'AAP',
1434: p_effective_date,
1435: null,