[Home] [Help]
488: -- This procedure gets the parameters given by user and restricts
489: -- the assignments to be archived.
490: -- it then calls hr_nonrun.insact to create an assignment action id
491: -- it then archives Payroll Run assignment action id details
492: -- in pay_Action_information with context 'AU_ARCHIVE_ASG_DETAILS'
493: -- for each assignment.
494: -- There are 10 different cursors for choosing the assignment ids.
495: -- Depending on the parameters passed,the appropriate cursor is used.
496: --------------------------------------------------------------------+
1150: -- Create the archive assignment actions
1151: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
1152:
1153:
1154: insert into pay_action_information(
1155: action_information_id,
1156: action_context_id,
1157: action_context_type,
1158: effective_date,
1164: action_information3,
1165: assignment_id
1166: )
1167: values(
1168: pay_action_information_s.nextval,
1169: l_next_assignment_action_id,
1170: 'AAP',
1171: null,
1172: null,
1207:
1208: -- Create the archive assignment actions
1209: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
1210:
1211: insert into pay_action_information(
1212: action_information_id,
1213: action_context_id,
1214: action_context_type,
1215: effective_date,
1221: action_information3,
1222: assignment_id
1223: )
1224: values(
1225: pay_action_information_s.nextval,
1226: l_next_assignment_action_id,
1227: 'AAP',
1228: null,
1229: null,
1271:
1272: -- Create the archive assignment actions
1273: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
1274:
1275: insert into pay_action_information(
1276: action_information_id,
1277: action_context_id,
1278: action_context_type,
1279: effective_date,
1285: action_information3,
1286: assignment_id
1287: )
1288: values(
1289: pay_action_information_s.nextval,
1290: l_next_assignment_action_id,
1291: 'AAP',
1292: null,
1293: null,
1331:
1332: -- Create the archive assignment actions
1333: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
1334:
1335: insert into pay_action_information(
1336: action_information_id,
1337: action_context_id,
1338: action_context_type,
1339: effective_date,
1345: action_information3,
1346: assignment_id
1347: )
1348: values(
1349: pay_action_information_s.nextval,
1350: l_next_assignment_action_id,
1351: 'AAP',
1352: null,
1353: null,
1393:
1394: -- Create the archive assignment actions
1395: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
1396:
1397: insert into pay_action_information(
1398: action_information_id,
1399: action_context_id,
1400: action_context_type,
1401: effective_date,
1407: action_information3,
1408: assignment_id
1409: )
1410: values(
1411: pay_action_information_s.nextval,
1412: l_next_assignment_action_id,
1413: 'AAP',
1414: null,
1415: null,
1451:
1452: -- Create the archive assignment actions
1453: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
1454:
1455: insert into pay_action_information(
1456: action_information_id,
1457: action_context_id,
1458: action_context_type,
1459: effective_date,
1465: action_information3,
1466: assignment_id
1467: )
1468: values(
1469: pay_action_information_s.nextval,
1470: l_next_assignment_action_id,
1471: 'AAP',
1472: null,
1473: null,
1513:
1514: -- Create the archive assignment actions
1515: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
1516:
1517: insert into pay_action_information(
1518: action_information_id,
1519: action_context_id,
1520: action_context_type,
1521: effective_date,
1527: action_information3,
1528: assignment_id
1529: )
1530: values(
1531: pay_action_information_s.nextval,
1532: l_next_assignment_action_id,
1533: 'AAP',
1534: null,
1535: null,
1570:
1571: -- Create the archive assignment actions
1572: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
1573:
1574: insert into pay_action_information(
1575: action_information_id,
1576: action_context_id,
1577: action_context_type,
1578: effective_date,
1584: action_information3,
1585: assignment_id
1586: )
1587: values(
1588: pay_action_information_s.nextval,
1589: l_next_assignment_action_id,
1590: 'AAP',
1591: null,
1592: null,
1632:
1633: -- Create the archive assignment actions
1634: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
1635:
1636: insert into pay_action_information(
1637: action_information_id,
1638: action_context_id,
1639: action_context_type,
1640: effective_date,
1646: action_information3,
1647: assignment_id
1648: )
1649: values(
1650: pay_action_information_s.nextval,
1651: l_next_assignment_action_id,
1652: 'AAP',
1653: null,
1654: null,
1688:
1689: -- Create the archive assignment actions
1690: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
1691:
1692: insert into pay_action_information(
1693: action_information_id,
1694: action_context_id,
1695: action_context_type,
1696: effective_date,
1702: action_information3,
1703: assignment_id
1704: )
1705: values(
1706: pay_action_information_s.nextval,
1707: l_next_assignment_action_id,
1708: 'AAP',
1709: null,
1710: null,
1798:
1799: cursor csr_get_data (c_arc_ass_act_id number)
1800: is
1801: select pai.action_information1, pai.tax_unit_id, pai.assignment_id,pai.action_information3
1802: from pay_action_information pai
1803: where action_information_category = 'AU_ARCHIVE_ASG_DETAILS'
1804: and pai.action_context_id = c_arc_ass_act_id;
1805:
1806: /*Bug 4040688 - Two cursors introduced to get the maximum assignment action id for the assignment*/
1953: P_YTD_NET_PAYMENT => l_YTD_NET_PAYMENT ,
1954: P_YTD_EMPLOYER_CHARGES => l_YTD_EMPLOYER_CHARGES);
1955: END IF ;
1956:
1957: insert into pay_action_information (
1958: action_information_id,
1959: action_context_id,
1960: action_context_type,
1961: effective_date,
1973: action_information8,
1974: action_information9,
1975: action_information10)
1976: values (
1977: pay_action_information_s.nextval,
1978: p_assignment_action_id,
1979: 'AAP',
1980: p_effective_date,
1981: null,
2000: OPEN c_get_payroll_name(l_assignment_id,g_end_date,g_start_date);
2001: FETCH c_get_payroll_name INTO l_payroll_id,l_payroll_name;
2002: CLOSE c_get_payroll_name;
2003:
2004: insert into pay_action_information(
2005: action_information_id,
2006: action_context_id,
2007: action_context_type,
2008: effective_date,
2015: action_information9,
2016: action_information10,
2017: assignment_id)
2018: values(
2019: pay_action_information_s.nextval,
2020: g_arc_payroll_action_id,
2021: 'PA',
2022: p_effective_date,
2023: null,
2048: P_NET_PAYMENT => l_NET_PAYMENT ,
2049: P_EMPLOYER_CHARGES => l_EMPLOYER_CHARGES);
2050:
2051: --
2052: -- Insert the balance data into pay_action_information table
2053: -- This Direct Insert statement is for Performance Reasons.
2054: --
2055: /*Bug 4040688 - Modified contexts which will store only the run balance values.*/
2056: insert into pay_action_information (
2052: -- Insert the balance data into pay_action_information table
2053: -- This Direct Insert statement is for Performance Reasons.
2054: --
2055: /*Bug 4040688 - Modified contexts which will store only the run balance values.*/
2056: insert into pay_action_information (
2057: action_information_id,
2058: action_context_id,
2059: action_context_type,
2060: effective_date,
2072: action_information8,
2073: action_information9,
2074: action_information10)
2075: values (
2076: pay_action_information_s.nextval,
2077: p_assignment_action_id,
2078: 'AAP',
2079: p_effective_date,
2080: null,