[Home] [Help]
374: -- This procedure gets the parameters given by user and restricts
375: -- the assignments to be archived.
376: -- it then calls hr_nonrun.insact to create an assignment action id
377: -- it then archives Payroll Run assignment action id details
378: -- in pay_Action_information with context 'AU_ARCHIVE_ASG_DETAILS'
379: -- for each assignment.
380: -- There are 10 different cursors for choosing the assignment ids.
381: -- Depending on the parameters passed,the appropriate cursor is used.
382: --------------------------------------------------------------------+
1515: -- Create the archive assignment actions
1516: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
1517:
1518:
1519: insert into pay_action_information(
1520: action_information_id,
1521: action_context_id,
1522: action_context_type,
1523: effective_date,
1529: action_information3,
1530: assignment_id
1531: )
1532: values(
1533: pay_action_information_s.nextval,
1534: l_next_assignment_action_id,
1535: 'AAP',
1536: null,
1537: null,
1574:
1575: -- Create the archive assignment actions
1576: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
1577:
1578: insert into pay_action_information(
1579: action_information_id,
1580: action_context_id,
1581: action_context_type,
1582: effective_date,
1588: action_information3,
1589: assignment_id
1590: )
1591: values(
1592: pay_action_information_s.nextval,
1593: l_next_assignment_action_id,
1594: 'AAP',
1595: null,
1596: null,
1637:
1638: -- Create the archive assignment actions
1639: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
1640:
1641: insert into pay_action_information(
1642: action_information_id,
1643: action_context_id,
1644: action_context_type,
1645: effective_date,
1651: action_information3,
1652: assignment_id
1653: )
1654: values(
1655: pay_action_information_s.nextval,
1656: l_next_assignment_action_id,
1657: 'AAP',
1658: null,
1659: null,
1696:
1697: -- Create the archive assignment actions
1698: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
1699:
1700: insert into pay_action_information(
1701: action_information_id,
1702: action_context_id,
1703: action_context_type,
1704: effective_date,
1710: action_information3,
1711: assignment_id
1712: )
1713: values(
1714: pay_action_information_s.nextval,
1715: l_next_assignment_action_id,
1716: 'AAP',
1717: null,
1718: null,
1760:
1761: -- Create the archive assignment actions
1762: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
1763:
1764: insert into pay_action_information(
1765: action_information_id,
1766: action_context_id,
1767: action_context_type,
1768: effective_date,
1774: action_information3,
1775: assignment_id
1776: )
1777: values(
1778: pay_action_information_s.nextval,
1779: l_next_assignment_action_id,
1780: 'AAP',
1781: null,
1782: null,
1820:
1821: -- Create the archive assignment actions
1822: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
1823:
1824: insert into pay_action_information(
1825: action_information_id,
1826: action_context_id,
1827: action_context_type,
1828: effective_date,
1834: action_information3,
1835: assignment_id
1836: )
1837: values(
1838: pay_action_information_s.nextval,
1839: l_next_assignment_action_id,
1840: 'AAP',
1841: null,
1842: null,
1884:
1885: -- Create the archive assignment actions
1886: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
1887:
1888: insert into pay_action_information(
1889: action_information_id,
1890: action_context_id,
1891: action_context_type,
1892: effective_date,
1898: action_information3,
1899: assignment_id
1900: )
1901: values(
1902: pay_action_information_s.nextval,
1903: l_next_assignment_action_id,
1904: 'AAP',
1905: null,
1906: null,
1943:
1944: -- Create the archive assignment actions
1945: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
1946:
1947: insert into pay_action_information(
1948: action_information_id,
1949: action_context_id,
1950: action_context_type,
1951: effective_date,
1957: action_information3,
1958: assignment_id
1959: )
1960: values(
1961: pay_action_information_s.nextval,
1962: l_next_assignment_action_id,
1963: 'AAP',
1964: null,
1965: null,
2007:
2008: -- Create the archive assignment actions
2009: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
2010:
2011: insert into pay_action_information(
2012: action_information_id,
2013: action_context_id,
2014: action_context_type,
2015: effective_date,
2021: action_information3,
2022: assignment_id
2023: )
2024: values(
2025: pay_action_information_s.nextval,
2026: l_next_assignment_action_id,
2027: 'AAP',
2028: null,
2029: null,
2065:
2066: -- Create the archive assignment actions
2067: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
2068:
2069: insert into pay_action_information(
2070: action_information_id,
2071: action_context_id,
2072: action_context_type,
2073: effective_date,
2079: action_information3,
2080: assignment_id
2081: )
2082: values(
2083: pay_action_information_s.nextval,
2084: l_next_assignment_action_id,
2085: 'AAP',
2086: null,
2087: null,
2139: -- Create the archive assignment actions
2140: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
2141:
2142:
2143: insert into pay_action_information(
2144: action_information_id,
2145: action_context_id,
2146: action_context_type,
2147: effective_date,
2153: action_information3,
2154: assignment_id
2155: )
2156: values(
2157: pay_action_information_s.nextval,
2158: l_next_assignment_action_id,
2159: 'AAP',
2160: null,
2161: null,
2196:
2197: -- Create the archive assignment actions
2198: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
2199:
2200: insert into pay_action_information(
2201: action_information_id,
2202: action_context_id,
2203: action_context_type,
2204: effective_date,
2210: action_information3,
2211: assignment_id
2212: )
2213: values(
2214: pay_action_information_s.nextval,
2215: l_next_assignment_action_id,
2216: 'AAP',
2217: null,
2218: null,
2257:
2258: -- Create the archive assignment actions
2259: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
2260:
2261: insert into pay_action_information(
2262: action_information_id,
2263: action_context_id,
2264: action_context_type,
2265: effective_date,
2271: action_information3,
2272: assignment_id
2273: )
2274: values(
2275: pay_action_information_s.nextval,
2276: l_next_assignment_action_id,
2277: 'AAP',
2278: null,
2279: null,
2314:
2315: -- Create the archive assignment actions
2316: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
2317:
2318: insert into pay_action_information(
2319: action_information_id,
2320: action_context_id,
2321: action_context_type,
2322: effective_date,
2328: action_information3,
2329: assignment_id
2330: )
2331: values(
2332: pay_action_information_s.nextval,
2333: l_next_assignment_action_id,
2334: 'AAP',
2335: null,
2336: null,
2376:
2377: -- Create the archive assignment actions
2378: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
2379:
2380: insert into pay_action_information(
2381: action_information_id,
2382: action_context_id,
2383: action_context_type,
2384: effective_date,
2390: action_information3,
2391: assignment_id
2392: )
2393: values(
2394: pay_action_information_s.nextval,
2395: l_next_assignment_action_id,
2396: 'AAP',
2397: null,
2398: null,
2434:
2435: -- Create the archive assignment actions
2436: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
2437:
2438: insert into pay_action_information(
2439: action_information_id,
2440: action_context_id,
2441: action_context_type,
2442: effective_date,
2448: action_information3,
2449: assignment_id
2450: )
2451: values(
2452: pay_action_information_s.nextval,
2453: l_next_assignment_action_id,
2454: 'AAP',
2455: null,
2456: null,
2496:
2497: -- Create the archive assignment actions
2498: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
2499:
2500: insert into pay_action_information(
2501: action_information_id,
2502: action_context_id,
2503: action_context_type,
2504: effective_date,
2510: action_information3,
2511: assignment_id
2512: )
2513: values(
2514: pay_action_information_s.nextval,
2515: l_next_assignment_action_id,
2516: 'AAP',
2517: null,
2518: null,
2553:
2554: -- Create the archive assignment actions
2555: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
2556:
2557: insert into pay_action_information(
2558: action_information_id,
2559: action_context_id,
2560: action_context_type,
2561: effective_date,
2567: action_information3,
2568: assignment_id
2569: )
2570: values(
2571: pay_action_information_s.nextval,
2572: l_next_assignment_action_id,
2573: 'AAP',
2574: null,
2575: null,
2615:
2616: -- Create the archive assignment actions
2617: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
2618:
2619: insert into pay_action_information(
2620: action_information_id,
2621: action_context_id,
2622: action_context_type,
2623: effective_date,
2629: action_information3,
2630: assignment_id
2631: )
2632: values(
2633: pay_action_information_s.nextval,
2634: l_next_assignment_action_id,
2635: 'AAP',
2636: null,
2637: null,
2671:
2672: -- Create the archive assignment actions
2673: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
2674:
2675: insert into pay_action_information(
2676: action_information_id,
2677: action_context_id,
2678: action_context_type,
2679: effective_date,
2685: action_information3,
2686: assignment_id
2687: )
2688: values(
2689: pay_action_information_s.nextval,
2690: l_next_assignment_action_id,
2691: 'AAP',
2692: null,
2693: null,
2725: -- Type : Procedure
2726: -- Access: Public
2727: -- This procedure archives details for assignment.
2728: -- Employee details
2729: -- Checks pay_Action_information context ='AU_ARCHIVE_ASG_DETAILS'
2730: -- If employee details not previously archived,proc archives
2731: -- employee details in pay_Action_information with context
2732: -- 'AU_EMPLOYEE_RECON_DETAILS'.
2733: -- Element details.
2727: -- This procedure archives details for assignment.
2728: -- Employee details
2729: -- Checks pay_Action_information context ='AU_ARCHIVE_ASG_DETAILS'
2730: -- If employee details not previously archived,proc archives
2731: -- employee details in pay_Action_information with context
2732: -- 'AU_EMPLOYEE_RECON_DETAILS'.
2733: -- Element details.
2734: -- For each assignment run,proc archives element processed in
2735: -- pay_Action_information with context 'AU_ELEMENT_RECON_DETAILS'
2731: -- employee details in pay_Action_information with context
2732: -- 'AU_EMPLOYEE_RECON_DETAILS'.
2733: -- Element details.
2734: -- For each assignment run,proc archives element processed in
2735: -- pay_Action_information with context 'AU_ELEMENT_RECON_DETAILS'
2736: -- Balance Details.
2737: -- For each assignment run,proc archives balance details in
2738: -- pay_Action_information with context 'AU_BALANCE_RECON_DETAILS'
2739: -- Uses package pay_au_reconciliation_pkg to fetch balances.
2734: -- For each assignment run,proc archives element processed in
2735: -- pay_Action_information with context 'AU_ELEMENT_RECON_DETAILS'
2736: -- Balance Details.
2737: -- For each assignment run,proc archives balance details in
2738: -- pay_Action_information with context 'AU_BALANCE_RECON_DETAILS'
2739: -- Uses package pay_au_reconciliation_pkg to fetch balances.
2740:
2741: --------------------------------------------------------------------+
2742:
2918:
2919: cursor csr_get_data (c_arc_ass_act_id number)
2920: is
2921: select pai.action_information1, pai.tax_unit_id, pai.assignment_id,pai.action_information3
2922: from pay_action_information pai
2923: where action_information_category = 'AU_ARCHIVE_ASG_DETAILS'
2924: and pai.action_context_id = c_arc_ass_act_id;
2925:
2926: /*Bug 4040688 - Two new cursors added to get the maximum assignment action id*/
3112: P_YTD_NET_PAYMENT => l_YTD_NET_PAYMENT ,
3113: P_YTD_EMPLOYER_CHARGES => l_YTD_EMPLOYER_CHARGES);
3114: END IF ;
3115:
3116: insert into pay_action_information (
3117: action_information_id,
3118: action_context_id,
3119: action_context_type,
3120: effective_date,
3132: action_information8,
3133: action_information9,
3134: action_information10)
3135: values (
3136: pay_action_information_s.nextval,
3137: p_assignment_action_id,
3138: 'AAP',
3139: p_effective_date,
3140: null,
3160: hr_utility.set_location('l_max_asg_action_id......= '|| l_max_asg_action_id,20);
3161: end if;
3162:
3163: -- Archive employee details
3164: /* Bug 3953702 - Archived the Grade Name details into pay_action_information */
3165:
3166: /*Bug 4688872*/
3167: OPEN c_get_payroll_name(l_assignment_id,g_start_date,g_end_date);
3168: FETCH c_get_payroll_name INTO l_payroll_id, l_payroll_name;
3168: FETCH c_get_payroll_name INTO l_payroll_id, l_payroll_name;
3169: CLOSE c_get_payroll_name;
3170:
3171:
3172: insert into pay_action_information(
3173: action_information_id,
3174: action_context_id,
3175: action_context_type,
3176: effective_date,
3189: action_information10,
3190: action_information11,
3191: assignment_id)
3192: values(
3193: pay_action_information_s.nextval,
3194: g_arc_payroll_action_id,
3195: 'PA',
3196: p_effective_date,
3197: null,
3233: END IF;
3234: end if;
3235:
3236: --
3237: -- Insert the element data into pay_action_information table
3238: -- This Direct Insert statement is for Performance Reasons.
3239: --
3240:
3241: insert into pay_action_information (
3237: -- Insert the element data into pay_action_information table
3238: -- This Direct Insert statement is for Performance Reasons.
3239: --
3240:
3241: insert into pay_action_information (
3242: action_information_id,
3243: action_context_id,
3244: action_context_type,
3245: effective_date,
3253: action_information5,
3254: action_information6,
3255: assignment_id)
3256: values (
3257: pay_action_information_s.nextval,
3258: p_assignment_action_id,
3259: 'AAP',
3260: p_effective_date,
3261: null,
3299: P_EMPLOYER_CHARGES => l_EMPLOYER_CHARGES);
3300:
3301:
3302: --
3303: -- Insert the balance data into pay_action_information table
3304: -- This Direct Insert statement is for Performance Reasons.
3305: --
3306: /*Bug 4040688 - Modified insert statement to store run balance details.*/
3307: insert into pay_action_information (
3303: -- Insert the balance data into pay_action_information table
3304: -- This Direct Insert statement is for Performance Reasons.
3305: --
3306: /*Bug 4040688 - Modified insert statement to store run balance details.*/
3307: insert into pay_action_information (
3308: action_information_id,
3309: action_context_id,
3310: action_context_type,
3311: effective_date,
3323: action_information8,
3324: action_information9,
3325: action_information10)
3326: values (
3327: pay_action_information_s.nextval,
3328: p_assignment_action_id,
3329: 'AAP',
3330: p_effective_date,
3331: null,