[Home] [Help]
5907: end if;
5908: --
5909: -- set g_effective_date (ie. process date) even if case of update
5910: -- so that effective_date will not be latest date in year
5911: pay_jp_itwb_dml_pkg.create_pact(
5912: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
5913: p_payroll_action_id => p_payroll_action_id,
5914: p_action_context_type => 'PA',
5915: p_effective_date => g_effective_date,
5908: --
5909: -- set g_effective_date (ie. process date) even if case of update
5910: -- so that effective_date will not be latest date in year
5911: pay_jp_itwb_dml_pkg.create_pact(
5912: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
5913: p_payroll_action_id => p_payroll_action_id,
5914: p_action_context_type => 'PA',
5915: p_effective_date => g_effective_date,
5916: p_action_information_category => 'JP_ITWB_PACT',
5927: end if;
5928: --
5929: if g_arch_option = 'ADD' then
5930: --
5931: pay_jp_itwb_dml_pkg.copy_pai(
5932: p_action_context_id => p_payroll_action_id,
5933: p_effective_date => g_effective_date,
5934: p_action_context_id_o => g_payroll_action_id_o,
5935: p_action_context_type => 'PA',
5959: close csr_org;
5960: --
5961: -- itax_org_address max size is 150 x 3 byte < 240 x 2
5962: l_object_version_number := null;
5963: pay_jp_itwb_dml_pkg.create_itax_org(
5964: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
5965: p_payroll_action_id => p_payroll_action_id,
5966: p_action_context_type => 'PA',
5967: p_effective_date => g_effective_date,
5960: --
5961: -- itax_org_address max size is 150 x 3 byte < 240 x 2
5962: l_object_version_number := null;
5963: pay_jp_itwb_dml_pkg.create_itax_org(
5964: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
5965: p_payroll_action_id => p_payroll_action_id,
5966: p_action_context_type => 'PA',
5967: p_effective_date => g_effective_date,
5968: p_action_information_category => 'JP_ITWB_ITAX_ORG',
12555: end if;
12556: --
12557: -- include copy, before updating
12558: -- update status for all case
12559: pay_jp_itwb_dml_pkg.add_assact(
12560: p_assignment_action_id => p_assignment_action_id,
12561: p_effective_date => g_effective_date,
12562: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
12563: p_proc_assignment_action_id => l_proc_assignment_action_id,
12569: and g_detail_debug = 'Y' then
12570: l_archive_step := 5;
12571: end if;
12572: --
12573: pay_jp_itwb_dml_pkg.copy_pai(
12574: p_action_context_id => p_assignment_action_id,
12575: p_effective_date => g_effective_date,
12576: p_action_context_id_o => l_arch_assignment_action_id_o,
12577: p_action_context_type => 'AAP',
12583: and g_detail_debug = 'Y' then
12584: l_archive_step := 6;
12585: end if;
12586: --
12587: pay_jp_itwb_dml_pkg.copy_pai(
12588: p_action_context_id => p_assignment_action_id,
12589: p_effective_date => g_effective_date,
12590: p_action_context_id_o => l_arch_assignment_action_id_o,
12591: p_action_context_type => 'AAP',
12597: and g_detail_debug = 'Y' then
12598: l_archive_step := 7;
12599: end if;
12600: --
12601: pay_jp_itwb_dml_pkg.copy_pai(
12602: p_action_context_id => p_assignment_action_id,
12603: p_effective_date => g_effective_date,
12604: p_action_context_id_o => l_arch_assignment_action_id_o,
12605: p_action_context_type => 'AAP',
12611: and g_detail_debug = 'Y' then
12612: l_archive_step := 8;
12613: end if;
12614: --
12615: pay_jp_itwb_dml_pkg.copy_pai(
12616: p_action_context_id => p_assignment_action_id,
12617: p_effective_date => g_effective_date,
12618: p_action_context_id_o => l_arch_assignment_action_id_o,
12619: p_action_context_type => 'AAP',
12627: end if;
12628: --
12629: -- include copy, before adding
12630: -- add = update in only case when data is not null
12631: pay_jp_itwb_dml_pkg.add_sal_act(
12632: p_assignment_action_id => p_assignment_action_id,
12633: p_effective_date => g_effective_date,
12634: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
12635: p_category => 'ACT',
12652: and g_detail_debug = 'Y' then
12653: l_archive_step := 10;
12654: end if;
12655: --
12656: pay_jp_itwb_dml_pkg.add_sal_act(
12657: p_assignment_action_id => p_assignment_action_id,
12658: p_effective_date => g_effective_date,
12659: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
12660: p_category => 'EFD',
12677: and g_detail_debug = 'Y' then
12678: l_archive_step := 11;
12679: end if;
12680: --
12681: pay_jp_itwb_dml_pkg.add_sal_act(
12682: p_assignment_action_id => p_assignment_action_id,
12683: p_effective_date => g_effective_date,
12684: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
12685: p_category => 'ERD',
12702: and g_detail_debug = 'Y' then
12703: l_archive_step := 12;
12704: end if;
12705: --
12706: pay_jp_itwb_dml_pkg.add_sal_act(
12707: p_assignment_action_id => p_assignment_action_id,
12708: p_effective_date => g_effective_date,
12709: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
12710: p_category => 'PAY',
12728: l_archive_step := 13;
12729: end if;
12730: --
12731: -- set col_tot later, set_data_pay_col_tot
12732: pay_jp_itwb_dml_pkg.add_sal_pay(
12733: p_assignment_action_id => p_assignment_action_id,
12734: p_effective_date => g_effective_date,
12735: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
12736: p_category => 'TXBL',
12754: and g_detail_debug = 'Y' then
12755: l_archive_step := 14;
12756: end if;
12757: --
12758: pay_jp_itwb_dml_pkg.add_sal_pay(
12759: p_assignment_action_id => p_assignment_action_id,
12760: p_effective_date => g_effective_date,
12761: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
12762: p_category => 'NTXBL',
12780: and g_detail_debug = 'Y' then
12781: l_archive_step := 15;
12782: end if;
12783: --
12784: pay_jp_itwb_dml_pkg.add_sal_pay(
12785: p_assignment_action_id => p_assignment_action_id,
12786: p_effective_date => g_effective_date,
12787: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
12788: p_category => 'PAY',
12806: and g_detail_debug = 'Y' then
12807: l_archive_step := 16;
12808: end if;
12809: --
12810: pay_jp_itwb_dml_pkg.add_sal_pay(
12811: p_assignment_action_id => p_assignment_action_id,
12812: p_effective_date => g_effective_date,
12813: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
12814: p_category => 'HI',
12832: and g_detail_debug = 'Y' then
12833: l_archive_step := 17;
12834: end if;
12835: --
12836: pay_jp_itwb_dml_pkg.add_sal_pay(
12837: p_assignment_action_id => p_assignment_action_id,
12838: p_effective_date => g_effective_date,
12839: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
12840: p_category => 'CI',
12858: and g_detail_debug = 'Y' then
12859: l_archive_step := 18;
12860: end if;
12861: --
12862: pay_jp_itwb_dml_pkg.add_sal_pay(
12863: p_assignment_action_id => p_assignment_action_id,
12864: p_effective_date => g_effective_date,
12865: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
12866: p_category => 'WP',
12884: and g_detail_debug = 'Y' then
12885: l_archive_step := 19;
12886: end if;
12887: --
12888: pay_jp_itwb_dml_pkg.add_sal_pay(
12889: p_assignment_action_id => p_assignment_action_id,
12890: p_effective_date => g_effective_date,
12891: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
12892: p_category => 'WPF',
12910: and g_detail_debug = 'Y' then
12911: l_archive_step := 20;
12912: end if;
12913: --
12914: pay_jp_itwb_dml_pkg.add_sal_pay(
12915: p_assignment_action_id => p_assignment_action_id,
12916: p_effective_date => g_effective_date,
12917: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
12918: p_category => 'EI',
12936: and g_detail_debug = 'Y' then
12937: l_archive_step := 21;
12938: end if;
12939: --
12940: pay_jp_itwb_dml_pkg.add_sal_pay(
12941: p_assignment_action_id => p_assignment_action_id,
12942: p_effective_date => g_effective_date,
12943: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
12944: p_category => 'SI',
12962: and g_detail_debug = 'Y' then
12963: l_archive_step := 22;
12964: end if;
12965: --
12966: pay_jp_itwb_dml_pkg.add_sal_pay(
12967: p_assignment_action_id => p_assignment_action_id,
12968: p_effective_date => g_effective_date,
12969: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
12970: p_category => 'DCT_EARN',
12988: and g_detail_debug = 'Y' then
12989: l_archive_step := 23;
12990: end if;
12991: --
12992: pay_jp_itwb_dml_pkg.add_sal_pay(
12993: p_assignment_action_id => p_assignment_action_id,
12994: p_effective_date => g_effective_date,
12995: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
12996: p_category => 'DPT',
13014: and g_detail_debug = 'Y' then
13015: l_archive_step := 24;
13016: end if;
13017: --
13018: pay_jp_itwb_dml_pkg.add_sal_pay(
13019: p_assignment_action_id => p_assignment_action_id,
13020: p_effective_date => g_effective_date,
13021: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
13022: p_category => 'ITX',
13040: and g_detail_debug = 'Y' then
13041: l_archive_step := 25;
13042: end if;
13043: --
13044: pay_jp_itwb_dml_pkg.add_sal_pay(
13045: p_assignment_action_id => p_assignment_action_id,
13046: p_effective_date => g_effective_date,
13047: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
13048: p_category => 'YEA_ITX',
13066: and g_detail_debug = 'Y' then
13067: l_archive_step := 26;
13068: end if;
13069: --
13070: pay_jp_itwb_dml_pkg.add_sal_pay(
13071: p_assignment_action_id => p_assignment_action_id,
13072: p_effective_date => g_effective_date,
13073: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
13074: p_category => 'NET_ITX',
13092: and g_detail_debug = 'Y' then
13093: l_archive_step := 27;
13094: end if;
13095: --
13096: pay_jp_itwb_dml_pkg.add_sal_pay(
13097: p_assignment_action_id => p_assignment_action_id,
13098: p_effective_date => g_effective_date,
13099: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
13100: p_category => 'LTX',
13118: and g_detail_debug = 'Y' then
13119: l_archive_step := 28;
13120: end if;
13121: --
13122: pay_jp_itwb_dml_pkg.add_sal_pay(
13123: p_assignment_action_id => p_assignment_action_id,
13124: p_effective_date => g_effective_date,
13125: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
13126: p_category => 'LTX_LUMP',
13144: and g_detail_debug = 'Y' then
13145: l_archive_step := 29;
13146: end if;
13147: --
13148: pay_jp_itwb_dml_pkg.add_sal_pay(
13149: p_assignment_action_id => p_assignment_action_id,
13150: p_effective_date => g_effective_date,
13151: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
13152: p_category => 'DCT',
13170: and g_detail_debug = 'Y' then
13171: l_archive_step := 30;
13172: end if;
13173: --
13174: pay_jp_itwb_dml_pkg.add_sal_pay(
13175: p_assignment_action_id => p_assignment_action_id,
13176: p_effective_date => g_effective_date,
13177: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
13178: p_category => 'NET_PAY',
13196: and g_detail_debug = 'Y' then
13197: l_archive_step := 31;
13198: end if;
13199: --
13200: pay_jp_itwb_dml_pkg.add_bon_act(
13201: p_assignment_action_id => p_assignment_action_id,
13202: p_effective_date => g_effective_date,
13203: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
13204: p_category => 'ACT',
13224: and g_detail_debug = 'Y' then
13225: l_archive_step := 32;
13226: end if;
13227: --
13228: pay_jp_itwb_dml_pkg.add_bon_act(
13229: p_assignment_action_id => p_assignment_action_id,
13230: p_effective_date => g_effective_date,
13231: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
13232: p_category => 'TYPE',
13252: and g_detail_debug = 'Y' then
13253: l_archive_step := 33;
13254: end if;
13255: --
13256: pay_jp_itwb_dml_pkg.add_bon_act(
13257: p_assignment_action_id => p_assignment_action_id,
13258: p_effective_date => g_effective_date,
13259: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
13260: p_category => 'EFD',
13280: and g_detail_debug = 'Y' then
13281: l_archive_step := 34;
13282: end if;
13283: --
13284: pay_jp_itwb_dml_pkg.add_bon_act(
13285: p_assignment_action_id => p_assignment_action_id,
13286: p_effective_date => g_effective_date,
13287: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
13288: p_category => 'ERD',
13308: and g_detail_debug = 'Y' then
13309: l_archive_step := 35;
13310: end if;
13311: --
13312: pay_jp_itwb_dml_pkg.add_bon_act(
13313: p_assignment_action_id => p_assignment_action_id,
13314: p_effective_date => g_effective_date,
13315: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
13316: p_category => 'PAY',
13336: and g_detail_debug = 'Y' then
13337: l_archive_step := 36;
13338: end if;
13339: --
13340: pay_jp_itwb_dml_pkg.add_bon_pay(
13341: p_assignment_action_id => p_assignment_action_id,
13342: p_effective_date => g_effective_date,
13343: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
13344: p_category => 'TXBL',
13365: and g_detail_debug = 'Y' then
13366: l_archive_step := 37;
13367: end if;
13368: --
13369: pay_jp_itwb_dml_pkg.add_bon_pay(
13370: p_assignment_action_id => p_assignment_action_id,
13371: p_effective_date => g_effective_date,
13372: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
13373: p_category => 'NTXBL',
13394: and g_detail_debug = 'Y' then
13395: l_archive_step := 38;
13396: end if;
13397: --
13398: pay_jp_itwb_dml_pkg.add_bon_pay(
13399: p_assignment_action_id => p_assignment_action_id,
13400: p_effective_date => g_effective_date,
13401: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
13402: p_category => 'PAY',
13423: and g_detail_debug = 'Y' then
13424: l_archive_step := 39;
13425: end if;
13426: --
13427: pay_jp_itwb_dml_pkg.add_bon_pay(
13428: p_assignment_action_id => p_assignment_action_id,
13429: p_effective_date => g_effective_date,
13430: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
13431: p_category => 'HI',
13452: and g_detail_debug = 'Y' then
13453: l_archive_step := 40;
13454: end if;
13455: --
13456: pay_jp_itwb_dml_pkg.add_bon_pay(
13457: p_assignment_action_id => p_assignment_action_id,
13458: p_effective_date => g_effective_date,
13459: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
13460: p_category => 'CI',
13481: and g_detail_debug = 'Y' then
13482: l_archive_step := 41;
13483: end if;
13484: --
13485: pay_jp_itwb_dml_pkg.add_bon_pay(
13486: p_assignment_action_id => p_assignment_action_id,
13487: p_effective_date => g_effective_date,
13488: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
13489: p_category => 'WP',
13510: and g_detail_debug = 'Y' then
13511: l_archive_step := 42;
13512: end if;
13513: --
13514: pay_jp_itwb_dml_pkg.add_bon_pay(
13515: p_assignment_action_id => p_assignment_action_id,
13516: p_effective_date => g_effective_date,
13517: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
13518: p_category => 'WPF',
13539: and g_detail_debug = 'Y' then
13540: l_archive_step := 43;
13541: end if;
13542: --
13543: pay_jp_itwb_dml_pkg.add_bon_pay(
13544: p_assignment_action_id => p_assignment_action_id,
13545: p_effective_date => g_effective_date,
13546: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
13547: p_category => 'EI',
13568: and g_detail_debug = 'Y' then
13569: l_archive_step := 44;
13570: end if;
13571: --
13572: pay_jp_itwb_dml_pkg.add_bon_pay(
13573: p_assignment_action_id => p_assignment_action_id,
13574: p_effective_date => g_effective_date,
13575: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
13576: p_category => 'SI',
13597: and g_detail_debug = 'Y' then
13598: l_archive_step := 45;
13599: end if;
13600: --
13601: pay_jp_itwb_dml_pkg.add_bon_pay(
13602: p_assignment_action_id => p_assignment_action_id,
13603: p_effective_date => g_effective_date,
13604: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
13605: p_category => 'DCT_EARN',
13626: and g_detail_debug = 'Y' then
13627: l_archive_step := 46;
13628: end if;
13629: --
13630: pay_jp_itwb_dml_pkg.add_bon_pay(
13631: p_assignment_action_id => p_assignment_action_id,
13632: p_effective_date => g_effective_date,
13633: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
13634: p_category => 'DPT',
13655: and g_detail_debug = 'Y' then
13656: l_archive_step := 47;
13657: end if;
13658: --
13659: pay_jp_itwb_dml_pkg.add_bon_pay(
13660: p_assignment_action_id => p_assignment_action_id,
13661: p_effective_date => g_effective_date,
13662: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
13663: p_category => 'ITX',
13684: and g_detail_debug = 'Y' then
13685: l_archive_step := 48;
13686: end if;
13687: --
13688: pay_jp_itwb_dml_pkg.add_bon_pay(
13689: p_assignment_action_id => p_assignment_action_id,
13690: p_effective_date => g_effective_date,
13691: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
13692: p_category => 'ITX_RATE',
13713: and g_detail_debug = 'Y' then
13714: l_archive_step := 49;
13715: end if;
13716: --
13717: pay_jp_itwb_dml_pkg.add_bon_pay(
13718: p_assignment_action_id => p_assignment_action_id,
13719: p_effective_date => g_effective_date,
13720: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
13721: p_category => 'YEA_ITX',
13742: and g_detail_debug = 'Y' then
13743: l_archive_step := 50;
13744: end if;
13745: --
13746: pay_jp_itwb_dml_pkg.add_bon_pay(
13747: p_assignment_action_id => p_assignment_action_id,
13748: p_effective_date => g_effective_date,
13749: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
13750: p_category => 'NET_ITX',
13771: and g_detail_debug = 'Y' then
13772: l_archive_step := 51;
13773: end if;
13774: --
13775: pay_jp_itwb_dml_pkg.add_bon_pay(
13776: p_assignment_action_id => p_assignment_action_id,
13777: p_effective_date => g_effective_date,
13778: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
13779: p_category => 'LTX_LUMP',
13800: and g_detail_debug = 'Y' then
13801: l_archive_step := 52;
13802: end if;
13803: --
13804: pay_jp_itwb_dml_pkg.add_bon_pay(
13805: p_assignment_action_id => p_assignment_action_id,
13806: p_effective_date => g_effective_date,
13807: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
13808: p_category => 'DCT',
13829: and g_detail_debug = 'Y' then
13830: l_archive_step := 53;
13831: end if;
13832: --
13833: pay_jp_itwb_dml_pkg.add_bon_pay(
13834: p_assignment_action_id => p_assignment_action_id,
13835: p_effective_date => g_effective_date,
13836: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
13837: p_category => 'NET_PAY',
13866: and g_detail_debug = 'Y' then
13867: l_archive_step := 55;
13868: end if;
13869: --
13870: pay_jp_itwb_dml_pkg.copy_pai_all_item(
13871: p_action_context_id => p_assignment_action_id,
13872: p_effective_date => g_effective_date,
13873: p_action_information_category => 'JP_ITWB_SAL_EARN',
13874: p_action_context_id_o => l_arch_assignment_action_id_o);
13877: and g_detail_debug = 'Y' then
13878: l_archive_step := 56;
13879: end if;
13880: --
13881: pay_jp_itwb_dml_pkg.copy_pai_all_item(
13882: p_action_context_id => p_assignment_action_id,
13883: p_effective_date => g_effective_date,
13884: p_action_information_category => 'JP_ITWB_SAL_DCT',
13885: p_action_context_id_o => l_arch_assignment_action_id_o);
13888: and g_detail_debug = 'Y' then
13889: l_archive_step := 57;
13890: end if;
13891: --
13892: pay_jp_itwb_dml_pkg.copy_pai_all_item(
13893: p_action_context_id => p_assignment_action_id,
13894: p_effective_date => g_effective_date,
13895: p_action_information_category => 'JP_ITWB_BON_EARN',
13896: p_action_context_id_o => l_arch_assignment_action_id_o);
13899: and g_detail_debug = 'Y' then
13900: l_archive_step := 58;
13901: end if;
13902: --
13903: pay_jp_itwb_dml_pkg.copy_pai_all_item(
13904: p_action_context_id => p_assignment_action_id,
13905: p_effective_date => g_effective_date,
13906: p_action_information_category => 'JP_ITWB_BON_DCT',
13907: p_action_context_id_o => l_arch_assignment_action_id_o);
13910: and g_detail_debug = 'Y' then
13911: l_archive_step := 59;
13912: end if;
13913: --
13914: pay_jp_itwb_dml_pkg.copy_pai_all_item(
13915: p_action_context_id => p_assignment_action_id,
13916: p_effective_date => g_effective_date,
13917: p_action_information_category => 'JP_ITWB_WRK',
13918: p_action_context_id_o => l_arch_assignment_action_id_o);
14136: --
14137: if not l_skip then
14138: --
14139: -- set col_tot later, set_data_item_col_tot
14140: pay_jp_itwb_dml_pkg.add_sal_earn(
14141: p_assignment_action_id => p_assignment_action_id,
14142: p_assignment_id => p_assignment_id,
14143: p_effective_date => g_effective_date,
14144: p_item_pay_id => l_data_sal_ass_pay_tbl(i).payroll_id,
14203: end if;
14204: --
14205: if not l_skip then
14206: --
14207: pay_jp_itwb_dml_pkg.add_sal_dct(
14208: p_assignment_action_id => p_assignment_action_id,
14209: p_assignment_id => p_assignment_id,
14210: p_effective_date => g_effective_date,
14211: p_item_pay_id => l_data_sal_ass_pay_tbl(i).payroll_id,
14270: end if;
14271: --
14272: if not l_skip then
14273: --
14274: pay_jp_itwb_dml_pkg.add_wrk(
14275: p_assignment_action_id => p_assignment_action_id,
14276: p_assignment_id => p_assignment_id,
14277: p_effective_date => g_effective_date,
14278: p_item_pay_id => l_data_sal_ass_pay_tbl(i).payroll_id,
14368: end if;
14369: --
14370: if not l_skip then
14371: --
14372: pay_jp_itwb_dml_pkg.add_bon_earn(
14373: p_assignment_action_id => p_assignment_action_id,
14374: p_assignment_id => p_assignment_id,
14375: p_effective_date => g_effective_date,
14376: p_item_pay_id => l_data_bon_ass_pay_tbl(m).payroll_id,
14441: end if;
14442: --
14443: if not l_skip then
14444: --
14445: pay_jp_itwb_dml_pkg.add_bon_dct(
14446: p_assignment_action_id => p_assignment_action_id,
14447: p_assignment_id => p_assignment_id,
14448: p_effective_date => g_effective_date,
14449: p_item_pay_id => l_data_bon_ass_pay_tbl(m).payroll_id,
14499: and g_detail_debug = 'Y' then
14500: l_archive_step := 75;
14501: end if;
14502: --
14503: pay_jp_itwb_dml_pkg.copy_pjob(
14504: p_assignment_action_id => p_assignment_action_id,
14505: p_effective_date => g_effective_date,
14506: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o);
14507: --
14509: and g_detail_debug = 'Y' then
14510: l_archive_step := 76;
14511: end if;
14512: --
14513: pay_jp_itwb_dml_pkg.copy_pai(
14514: p_action_context_id => p_assignment_action_id,
14515: p_effective_date => g_effective_date,
14516: p_action_context_id_o => l_arch_assignment_action_id_o,
14517: p_action_context_type => 'AAP',
14524: l_archive_step := 77;
14525: end if;
14526: --
14527: -- add = update in only case when data is not null
14528: pay_jp_itwb_dml_pkg.add_yea_act(
14529: p_assignment_action_id => p_assignment_action_id,
14530: p_effective_date => g_effective_date,
14531: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
14532: p_act => g_data_yea_tbl(nvl(g_body_tbl(p_assignment_action_id).yea_act,0)).yea_act_id,
14543: l_archive_step := 78;
14544: end if;
14545: --
14546: -- add = update in only case when data is not null
14547: pay_jp_itwb_dml_pkg.add_yea_pay(
14548: p_assignment_action_id => p_assignment_action_id,
14549: p_effective_date => g_effective_date,
14550: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
14551: p_sal_txbl_mon => g_data_yea_tbl(nvl(g_body_tbl(p_assignment_action_id).yea_act,0)).yea_pay_sal_txbl_mon,
14572: l_archive_step := 79;
14573: end if;
14574: --
14575: -- add = update in only case when data is not null
14576: pay_jp_itwb_dml_pkg.add_yea_dct(
14577: p_assignment_action_id => p_assignment_action_id,
14578: p_effective_date => g_effective_date,
14579: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
14580: p_sal_dct_si_prem => g_data_yea_tbl(nvl(g_body_tbl(p_assignment_action_id).yea_act,0)).yea_dct_sal_dct_si_prem_calc,
14613: l_archive_step := 80;
14614: end if;
14615: --
14616: -- add = update in only case when data is not null
14617: pay_jp_itwb_dml_pkg.add_yea_tax(
14618: p_assignment_action_id => p_assignment_action_id,
14619: p_effective_date => g_effective_date,
14620: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
14621: p_amt_aft_emp_inc_dct => g_data_yea_tbl(nvl(g_body_tbl(p_assignment_action_id).yea_act,0)).yea_tax_amt_aft_emp_inc_dct,
14632: and g_detail_debug = 'Y' then
14633: l_archive_step := 81;
14634: end if;
14635: --
14636: pay_jp_itwb_dml_pkg.copy_pai_type(
14637: p_action_context_id => p_assignment_action_id,
14638: p_effective_date => g_effective_date,
14639: p_action_context_id_o => l_arch_assignment_action_id_o,
14640: p_action_context_type => 'AAP',
14647: and g_detail_debug = 'Y' then
14648: l_archive_step := 82;
14649: end if;
14650: --
14651: pay_jp_itwb_dml_pkg.copy_pai_type(
14652: p_action_context_id => p_assignment_action_id,
14653: p_effective_date => g_effective_date,
14654: p_action_context_id_o => l_arch_assignment_action_id_o,
14655: p_action_context_type => 'AAP',
14662: and g_detail_debug = 'Y' then
14663: l_archive_step := 83;
14664: end if;
14665: --
14666: pay_jp_itwb_dml_pkg.copy_pai_type(
14667: p_action_context_id => p_assignment_action_id,
14668: p_effective_date => g_effective_date,
14669: p_action_context_id_o => l_arch_assignment_action_id_o,
14670: p_action_context_type => 'AAP',
14694: -- include copy, before updating
14695: -- update can be available for case when month is same
14696: -- but status should be update in any case
14697: -- update all data (inc null data) if difference
14698: pay_jp_itwb_dml_pkg.update_assact(
14699: p_assignment_action_id => p_assignment_action_id,
14700: p_effective_date => g_effective_date,
14701: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
14702: p_proc_assignment_action_id => l_proc_assignment_action_id,
14718: --
14719: -- include copy, before updating
14720: -- update can be available for case when month is same
14721: -- update all data (inc null data) if difference
14722: pay_jp_itwb_dml_pkg.update_emp(
14723: p_assignment_action_id => p_assignment_action_id,
14724: p_effective_date => g_effective_date,
14725: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
14726: p_proc_assignment_action_id => l_proc_assignment_action_id,
14740: and g_detail_debug = 'Y' then
14741: l_archive_step := 87;
14742: end if;
14743: --
14744: pay_jp_itwb_dml_pkg.update_emp_add(
14745: p_assignment_action_id => p_assignment_action_id,
14746: p_effective_date => g_effective_date,
14747: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
14748: p_proc_assignment_action_id => l_proc_assignment_action_id,
14764: and g_detail_debug = 'Y' then
14765: l_archive_step := 88;
14766: end if;
14767: --
14768: pay_jp_itwb_dml_pkg.update_emp_ass(
14769: p_assignment_action_id => p_assignment_action_id,
14770: p_effective_date => g_effective_date,
14771: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
14772: p_proc_assignment_action_id => l_proc_assignment_action_id,
14783: and g_detail_debug = 'Y' then
14784: l_archive_step := 89;
14785: end if;
14786: --
14787: pay_jp_itwb_dml_pkg.update_emp_si(
14788: p_assignment_action_id => p_assignment_action_id,
14789: p_effective_date => g_effective_date,
14790: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
14791: p_proc_assignment_action_id => l_proc_assignment_action_id,
14812: end if;
14813: --
14814: -- include copy, before updating
14815: -- update for all case
14816: pay_jp_itwb_dml_pkg.update_sal_act(
14817: p_assignment_action_id => p_assignment_action_id,
14818: p_effective_date => g_effective_date,
14819: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
14820: p_category => 'ACT',
14837: and g_detail_debug = 'Y' then
14838: l_archive_step := 91;
14839: end if;
14840: --
14841: pay_jp_itwb_dml_pkg.update_sal_act(
14842: p_assignment_action_id => p_assignment_action_id,
14843: p_effective_date => g_effective_date,
14844: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
14845: p_category => 'EFD',
14862: and g_detail_debug = 'Y' then
14863: l_archive_step := 92;
14864: end if;
14865: --
14866: pay_jp_itwb_dml_pkg.update_sal_act(
14867: p_assignment_action_id => p_assignment_action_id,
14868: p_effective_date => g_effective_date,
14869: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
14870: p_category => 'ERD',
14887: and g_detail_debug = 'Y' then
14888: l_archive_step := 93;
14889: end if;
14890: --
14891: pay_jp_itwb_dml_pkg.update_sal_act(
14892: p_assignment_action_id => p_assignment_action_id,
14893: p_effective_date => g_effective_date,
14894: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
14895: p_category => 'PAY',
14913: l_archive_step := 94;
14914: end if;
14915: --
14916: -- set col_tot later, set_data_pay_col_tot
14917: pay_jp_itwb_dml_pkg.update_sal_pay(
14918: p_assignment_action_id => p_assignment_action_id,
14919: p_effective_date => g_effective_date,
14920: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
14921: p_category => 'TXBL',
14939: and g_detail_debug = 'Y' then
14940: l_archive_step := 95;
14941: end if;
14942: --
14943: pay_jp_itwb_dml_pkg.update_sal_pay(
14944: p_assignment_action_id => p_assignment_action_id,
14945: p_effective_date => g_effective_date,
14946: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
14947: p_category => 'NTXBL',
14965: and g_detail_debug = 'Y' then
14966: l_archive_step := 96;
14967: end if;
14968: --
14969: pay_jp_itwb_dml_pkg.update_sal_pay(
14970: p_assignment_action_id => p_assignment_action_id,
14971: p_effective_date => g_effective_date,
14972: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
14973: p_category => 'PAY',
14991: and g_detail_debug = 'Y' then
14992: l_archive_step := 97;
14993: end if;
14994: --
14995: pay_jp_itwb_dml_pkg.update_sal_pay(
14996: p_assignment_action_id => p_assignment_action_id,
14997: p_effective_date => g_effective_date,
14998: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
14999: p_category => 'HI',
15017: and g_detail_debug = 'Y' then
15018: l_archive_step := 98;
15019: end if;
15020: --
15021: pay_jp_itwb_dml_pkg.update_sal_pay(
15022: p_assignment_action_id => p_assignment_action_id,
15023: p_effective_date => g_effective_date,
15024: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
15025: p_category => 'CI',
15043: and g_detail_debug = 'Y' then
15044: l_archive_step := 99;
15045: end if;
15046: --
15047: pay_jp_itwb_dml_pkg.update_sal_pay(
15048: p_assignment_action_id => p_assignment_action_id,
15049: p_effective_date => g_effective_date,
15050: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
15051: p_category => 'WP',
15069: and g_detail_debug = 'Y' then
15070: l_archive_step := 100;
15071: end if;
15072: --
15073: pay_jp_itwb_dml_pkg.update_sal_pay(
15074: p_assignment_action_id => p_assignment_action_id,
15075: p_effective_date => g_effective_date,
15076: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
15077: p_category => 'WPF',
15095: and g_detail_debug = 'Y' then
15096: l_archive_step := 101;
15097: end if;
15098: --
15099: pay_jp_itwb_dml_pkg.update_sal_pay(
15100: p_assignment_action_id => p_assignment_action_id,
15101: p_effective_date => g_effective_date,
15102: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
15103: p_category => 'EI',
15121: and g_detail_debug = 'Y' then
15122: l_archive_step := 102;
15123: end if;
15124: --
15125: pay_jp_itwb_dml_pkg.update_sal_pay(
15126: p_assignment_action_id => p_assignment_action_id,
15127: p_effective_date => g_effective_date,
15128: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
15129: p_category => 'SI',
15147: and g_detail_debug = 'Y' then
15148: l_archive_step := 103;
15149: end if;
15150: --
15151: pay_jp_itwb_dml_pkg.update_sal_pay(
15152: p_assignment_action_id => p_assignment_action_id,
15153: p_effective_date => g_effective_date,
15154: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
15155: p_category => 'DCT_EARN',
15173: and g_detail_debug = 'Y' then
15174: l_archive_step := 104;
15175: end if;
15176: --
15177: pay_jp_itwb_dml_pkg.update_sal_pay(
15178: p_assignment_action_id => p_assignment_action_id,
15179: p_effective_date => g_effective_date,
15180: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
15181: p_category => 'DPT',
15199: and g_detail_debug = 'Y' then
15200: l_archive_step := 105;
15201: end if;
15202: --
15203: pay_jp_itwb_dml_pkg.update_sal_pay(
15204: p_assignment_action_id => p_assignment_action_id,
15205: p_effective_date => g_effective_date,
15206: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
15207: p_category => 'ITX',
15225: and g_detail_debug = 'Y' then
15226: l_archive_step := 106;
15227: end if;
15228: --
15229: pay_jp_itwb_dml_pkg.update_sal_pay(
15230: p_assignment_action_id => p_assignment_action_id,
15231: p_effective_date => g_effective_date,
15232: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
15233: p_category => 'YEA_ITX',
15251: and g_detail_debug = 'Y' then
15252: l_archive_step := 107;
15253: end if;
15254: --
15255: pay_jp_itwb_dml_pkg.update_sal_pay(
15256: p_assignment_action_id => p_assignment_action_id,
15257: p_effective_date => g_effective_date,
15258: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
15259: p_category => 'NET_ITX',
15277: and g_detail_debug = 'Y' then
15278: l_archive_step := 108;
15279: end if;
15280: --
15281: pay_jp_itwb_dml_pkg.update_sal_pay(
15282: p_assignment_action_id => p_assignment_action_id,
15283: p_effective_date => g_effective_date,
15284: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
15285: p_category => 'LTX',
15303: and g_detail_debug = 'Y' then
15304: l_archive_step := 109;
15305: end if;
15306: --
15307: pay_jp_itwb_dml_pkg.update_sal_pay(
15308: p_assignment_action_id => p_assignment_action_id,
15309: p_effective_date => g_effective_date,
15310: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
15311: p_category => 'LTX_LUMP',
15329: and g_detail_debug = 'Y' then
15330: l_archive_step := 110;
15331: end if;
15332: --
15333: pay_jp_itwb_dml_pkg.update_sal_pay(
15334: p_assignment_action_id => p_assignment_action_id,
15335: p_effective_date => g_effective_date,
15336: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
15337: p_category => 'DCT',
15355: and g_detail_debug = 'Y' then
15356: l_archive_step := 111;
15357: end if;
15358: --
15359: pay_jp_itwb_dml_pkg.update_sal_pay(
15360: p_assignment_action_id => p_assignment_action_id,
15361: p_effective_date => g_effective_date,
15362: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
15363: p_category => 'NET_PAY',
15381: and g_detail_debug = 'Y' then
15382: l_archive_step := 112;
15383: end if;
15384: --
15385: pay_jp_itwb_dml_pkg.update_bon_act(
15386: p_assignment_action_id => p_assignment_action_id,
15387: p_effective_date => g_effective_date,
15388: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
15389: p_category => 'ACT',
15409: and g_detail_debug = 'Y' then
15410: l_archive_step := 113;
15411: end if;
15412: --
15413: pay_jp_itwb_dml_pkg.update_bon_act(
15414: p_assignment_action_id => p_assignment_action_id,
15415: p_effective_date => g_effective_date,
15416: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
15417: p_category => 'TYPE',
15437: and g_detail_debug = 'Y' then
15438: l_archive_step := 114;
15439: end if;
15440: --
15441: pay_jp_itwb_dml_pkg.update_bon_act(
15442: p_assignment_action_id => p_assignment_action_id,
15443: p_effective_date => g_effective_date,
15444: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
15445: p_category => 'EFD',
15465: and g_detail_debug = 'Y' then
15466: l_archive_step := 115;
15467: end if;
15468: --
15469: pay_jp_itwb_dml_pkg.update_bon_act(
15470: p_assignment_action_id => p_assignment_action_id,
15471: p_effective_date => g_effective_date,
15472: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
15473: p_category => 'ERD',
15493: and g_detail_debug = 'Y' then
15494: l_archive_step := 116;
15495: end if;
15496: --
15497: pay_jp_itwb_dml_pkg.update_bon_act(
15498: p_assignment_action_id => p_assignment_action_id,
15499: p_effective_date => g_effective_date,
15500: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
15501: p_category => 'PAY',
15521: and g_detail_debug = 'Y' then
15522: l_archive_step := 117;
15523: end if;
15524: --
15525: pay_jp_itwb_dml_pkg.update_bon_pay(
15526: p_assignment_action_id => p_assignment_action_id,
15527: p_effective_date => g_effective_date,
15528: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
15529: p_category => 'TXBL',
15550: and g_detail_debug = 'Y' then
15551: l_archive_step := 118;
15552: end if;
15553: --
15554: pay_jp_itwb_dml_pkg.update_bon_pay(
15555: p_assignment_action_id => p_assignment_action_id,
15556: p_effective_date => g_effective_date,
15557: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
15558: p_category => 'NTXBL',
15579: and g_detail_debug = 'Y' then
15580: l_archive_step := 119;
15581: end if;
15582: --
15583: pay_jp_itwb_dml_pkg.update_bon_pay(
15584: p_assignment_action_id => p_assignment_action_id,
15585: p_effective_date => g_effective_date,
15586: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
15587: p_category => 'PAY',
15608: and g_detail_debug = 'Y' then
15609: l_archive_step := 120;
15610: end if;
15611: --
15612: pay_jp_itwb_dml_pkg.update_bon_pay(
15613: p_assignment_action_id => p_assignment_action_id,
15614: p_effective_date => g_effective_date,
15615: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
15616: p_category => 'HI',
15637: and g_detail_debug = 'Y' then
15638: l_archive_step := 121;
15639: end if;
15640: --
15641: pay_jp_itwb_dml_pkg.update_bon_pay(
15642: p_assignment_action_id => p_assignment_action_id,
15643: p_effective_date => g_effective_date,
15644: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
15645: p_category => 'CI',
15666: and g_detail_debug = 'Y' then
15667: l_archive_step := 122;
15668: end if;
15669: --
15670: pay_jp_itwb_dml_pkg.update_bon_pay(
15671: p_assignment_action_id => p_assignment_action_id,
15672: p_effective_date => g_effective_date,
15673: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
15674: p_category => 'WP',
15695: and g_detail_debug = 'Y' then
15696: l_archive_step := 123;
15697: end if;
15698: --
15699: pay_jp_itwb_dml_pkg.update_bon_pay(
15700: p_assignment_action_id => p_assignment_action_id,
15701: p_effective_date => g_effective_date,
15702: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
15703: p_category => 'WPF',
15724: and g_detail_debug = 'Y' then
15725: l_archive_step := 124;
15726: end if;
15727: --
15728: pay_jp_itwb_dml_pkg.update_bon_pay(
15729: p_assignment_action_id => p_assignment_action_id,
15730: p_effective_date => g_effective_date,
15731: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
15732: p_category => 'EI',
15753: and g_detail_debug = 'Y' then
15754: l_archive_step := 125;
15755: end if;
15756: --
15757: pay_jp_itwb_dml_pkg.update_bon_pay(
15758: p_assignment_action_id => p_assignment_action_id,
15759: p_effective_date => g_effective_date,
15760: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
15761: p_category => 'SI',
15782: and g_detail_debug = 'Y' then
15783: l_archive_step := 126;
15784: end if;
15785: --
15786: pay_jp_itwb_dml_pkg.update_bon_pay(
15787: p_assignment_action_id => p_assignment_action_id,
15788: p_effective_date => g_effective_date,
15789: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
15790: p_category => 'DCT_EARN',
15811: and g_detail_debug = 'Y' then
15812: l_archive_step := 127;
15813: end if;
15814: --
15815: pay_jp_itwb_dml_pkg.update_bon_pay(
15816: p_assignment_action_id => p_assignment_action_id,
15817: p_effective_date => g_effective_date,
15818: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
15819: p_category => 'DPT',
15840: and g_detail_debug = 'Y' then
15841: l_archive_step := 128;
15842: end if;
15843: --
15844: pay_jp_itwb_dml_pkg.update_bon_pay(
15845: p_assignment_action_id => p_assignment_action_id,
15846: p_effective_date => g_effective_date,
15847: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
15848: p_category => 'ITX',
15869: and g_detail_debug = 'Y' then
15870: l_archive_step := 129;
15871: end if;
15872: --
15873: pay_jp_itwb_dml_pkg.update_bon_pay(
15874: p_assignment_action_id => p_assignment_action_id,
15875: p_effective_date => g_effective_date,
15876: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
15877: p_category => 'ITX_RATE',
15898: and g_detail_debug = 'Y' then
15899: l_archive_step := 130;
15900: end if;
15901: --
15902: pay_jp_itwb_dml_pkg.update_bon_pay(
15903: p_assignment_action_id => p_assignment_action_id,
15904: p_effective_date => g_effective_date,
15905: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
15906: p_category => 'YEA_ITX',
15927: and g_detail_debug = 'Y' then
15928: l_archive_step := 131;
15929: end if;
15930: --
15931: pay_jp_itwb_dml_pkg.update_bon_pay(
15932: p_assignment_action_id => p_assignment_action_id,
15933: p_effective_date => g_effective_date,
15934: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
15935: p_category => 'NET_ITX',
15956: and g_detail_debug = 'Y' then
15957: l_archive_step := 132;
15958: end if;
15959: --
15960: pay_jp_itwb_dml_pkg.update_bon_pay(
15961: p_assignment_action_id => p_assignment_action_id,
15962: p_effective_date => g_effective_date,
15963: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
15964: p_category => 'LTX_LUMP',
15985: and g_detail_debug = 'Y' then
15986: l_archive_step := 133;
15987: end if;
15988: --
15989: pay_jp_itwb_dml_pkg.update_bon_pay(
15990: p_assignment_action_id => p_assignment_action_id,
15991: p_effective_date => g_effective_date,
15992: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
15993: p_category => 'DCT',
16014: and g_detail_debug = 'Y' then
16015: l_archive_step := 134;
16016: end if;
16017: --
16018: pay_jp_itwb_dml_pkg.update_bon_pay(
16019: p_assignment_action_id => p_assignment_action_id,
16020: p_effective_date => g_effective_date,
16021: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
16022: p_category => 'NET_PAY',
16051: and g_detail_debug = 'Y' then
16052: l_archive_step := 136;
16053: end if;
16054: --
16055: pay_jp_itwb_dml_pkg.copy_pai_all_item(
16056: p_action_context_id => p_assignment_action_id,
16057: p_effective_date => g_effective_date,
16058: p_action_information_category => 'JP_ITWB_SAL_EARN',
16059: p_action_context_id_o => l_arch_assignment_action_id_o);
16062: and g_detail_debug = 'Y' then
16063: l_archive_step := 137;
16064: end if;
16065: --
16066: pay_jp_itwb_dml_pkg.copy_pai_all_item(
16067: p_action_context_id => p_assignment_action_id,
16068: p_effective_date => g_effective_date,
16069: p_action_information_category => 'JP_ITWB_SAL_DCT',
16070: p_action_context_id_o => l_arch_assignment_action_id_o);
16073: and g_detail_debug = 'Y' then
16074: l_archive_step := 138;
16075: end if;
16076: --
16077: pay_jp_itwb_dml_pkg.copy_pai_all_item(
16078: p_action_context_id => p_assignment_action_id,
16079: p_effective_date => g_effective_date,
16080: p_action_information_category => 'JP_ITWB_BON_EARN',
16081: p_action_context_id_o => l_arch_assignment_action_id_o);
16084: and g_detail_debug = 'Y' then
16085: l_archive_step := 139;
16086: end if;
16087: --
16088: pay_jp_itwb_dml_pkg.copy_pai_all_item(
16089: p_action_context_id => p_assignment_action_id,
16090: p_effective_date => g_effective_date,
16091: p_action_information_category => 'JP_ITWB_BON_DCT',
16092: p_action_context_id_o => l_arch_assignment_action_id_o);
16095: and g_detail_debug = 'Y' then
16096: l_archive_step := 140;
16097: end if;
16098: --
16099: pay_jp_itwb_dml_pkg.copy_pai_all_item(
16100: p_action_context_id => p_assignment_action_id,
16101: p_effective_date => g_effective_date,
16102: p_action_information_category => 'JP_ITWB_WRK',
16103: p_action_context_id_o => l_arch_assignment_action_id_o);
16319: --
16320: if not l_skip then
16321: --
16322: -- set col_tot later, set_data_item_col_tot
16323: pay_jp_itwb_dml_pkg.update_sal_earn(
16324: p_assignment_action_id => p_assignment_action_id,
16325: p_assignment_id => p_assignment_id,
16326: p_effective_date => g_effective_date,
16327: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
16387: end if;
16388: --
16389: if not l_skip then
16390: --
16391: pay_jp_itwb_dml_pkg.update_sal_dct(
16392: p_assignment_action_id => p_assignment_action_id,
16393: p_assignment_id => p_assignment_id,
16394: p_effective_date => g_effective_date,
16395: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
16455: end if;
16456: --
16457: if not l_skip then
16458: --
16459: pay_jp_itwb_dml_pkg.update_wrk(
16460: p_assignment_action_id => p_assignment_action_id,
16461: p_assignment_id => p_assignment_id,
16462: p_effective_date => g_effective_date,
16463: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
16559: end if;
16560: --
16561: if not l_skip then
16562: --
16563: pay_jp_itwb_dml_pkg.update_bon_earn(
16564: p_assignment_action_id => p_assignment_action_id,
16565: p_assignment_id => p_assignment_id,
16566: p_effective_date => g_effective_date,
16567: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
16633: end if;
16634: --
16635: if not l_skip then
16636: --
16637: pay_jp_itwb_dml_pkg.update_bon_dct(
16638: p_assignment_action_id => p_assignment_action_id,
16639: p_assignment_id => p_assignment_id,
16640: p_effective_date => g_effective_date,
16641: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
16777: --
16778: if l_pjob_rec_ind is not null then
16779: --
16780: -- update can be available for case when month is same
16781: pay_jp_itwb_dml_pkg.update_pjob(
16782: p_assignment_action_id => p_assignment_action_id,
16783: p_assignment_id => p_assignment_id,
16784: p_effective_date => g_effective_date,
16785: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
16803: --
16804: else
16805: --
16806: -- copy action once for multiple loop when month is different, no l_action_information_id by update_pjob
16807: pay_jp_itwb_dml_pkg.copy_pjob(
16808: p_assignment_action_id => p_assignment_action_id,
16809: p_effective_date => g_effective_date,
16810: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o);
16811: --
16821: if g_body_tbl(p_assignment_action_id).yea_act is not null
16822: or to_char(g_body_tbl(p_assignment_action_id).assact_proc_ass_action_date_o,'MM') = to_char(g_effective_date,'MM')
16823: or nvl(g_upd_force,'N') = 'Y' then
16824: --
16825: pay_jp_itwb_dml_pkg.update_dep(
16826: p_assignment_action_id => p_assignment_action_id,
16827: p_effective_date => g_effective_date,
16828: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
16829: p_proc_assignment_action_id => l_proc_assignment_action_id,
16849: p_object_version_number => l_object_version_number);
16850: --
16851: else
16852: --
16853: pay_jp_itwb_dml_pkg.copy_pai(
16854: p_assignment_action_id,
16855: g_effective_date,
16856: l_arch_assignment_action_id_o,
16857: 'AAP',
16866: l_archive_step := 161;
16867: end if;
16868: --
16869: -- update can be available for case when month is same
16870: pay_jp_itwb_dml_pkg.update_yea_act(
16871: p_assignment_action_id => p_assignment_action_id,
16872: p_effective_date => g_effective_date,
16873: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
16874: p_proc_assignment_action_id => l_proc_assignment_action_id,
16886: and g_detail_debug = 'Y' then
16887: l_archive_step := 162;
16888: end if;
16889: --
16890: pay_jp_itwb_dml_pkg.update_yea_pay(
16891: p_assignment_action_id => p_assignment_action_id,
16892: p_effective_date => g_effective_date,
16893: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
16894: p_proc_assignment_action_id => l_proc_assignment_action_id,
16916: and g_detail_debug = 'Y' then
16917: l_archive_step := 163;
16918: end if;
16919: --
16920: pay_jp_itwb_dml_pkg.update_yea_dct(
16921: p_assignment_action_id => p_assignment_action_id,
16922: p_effective_date => g_effective_date,
16923: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
16924: p_proc_assignment_action_id => l_proc_assignment_action_id,
16958: and g_detail_debug = 'Y' then
16959: l_archive_step := 164;
16960: end if;
16961: --
16962: pay_jp_itwb_dml_pkg.update_yea_tax(
16963: p_assignment_action_id => p_assignment_action_id,
16964: p_effective_date => g_effective_date,
16965: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
16966: p_proc_assignment_action_id => l_proc_assignment_action_id,
16983: if g_org_cust_proc is not null
16984: and (to_char(g_body_tbl(p_assignment_action_id).assact_proc_ass_action_date_o,'MM') = to_char(g_effective_date,'MM')
16985: or nvl(g_upd_force,'N') = 'Y') then
16986: --
16987: pay_jp_itwb_dml_pkg.update_emp_cust(
16988: p_assignment_action_id => p_assignment_action_id,
16989: p_assignment_id => p_assignment_id,
16990: p_effective_date => g_effective_date,
16991: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
17022: and g_detail_debug = 'Y' then
17023: l_archive_step := 166;
17024: end if;
17025: --
17026: pay_jp_itwb_dml_pkg.update_emp_cust(
17027: p_assignment_action_id => p_assignment_action_id,
17028: p_assignment_id => p_assignment_id,
17029: p_effective_date => g_effective_date,
17030: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
17061: and g_detail_debug = 'Y' then
17062: l_archive_step := 167;
17063: end if;
17064: --
17065: pay_jp_itwb_dml_pkg.update_emp_cust(
17066: p_assignment_action_id => p_assignment_action_id,
17067: p_assignment_id => p_assignment_id,
17068: p_effective_date => g_effective_date,
17069: p_arch_assignment_action_id_o => l_arch_assignment_action_id_o,
17097: p_object_version_number => l_object_version_number);
17098: --
17099: else
17100: --
17101: pay_jp_itwb_dml_pkg.copy_pai_type(
17102: p_assignment_action_id,
17103: g_effective_date,
17104: l_arch_assignment_action_id_o,
17105: 'AAP',
17107: 'T',
17108: l_action_information_id,
17109: l_object_version_number);
17110: --
17111: pay_jp_itwb_dml_pkg.copy_pai_type(
17112: p_assignment_action_id,
17113: g_effective_date,
17114: l_arch_assignment_action_id_o,
17115: 'AAP',
17117: 'D',
17118: l_action_information_id,
17119: l_object_version_number);
17120: --
17121: pay_jp_itwb_dml_pkg.copy_pai_type(
17122: p_assignment_action_id,
17123: g_effective_date,
17124: l_arch_assignment_action_id_o,
17125: 'AAP',
17146: hr_utility.set_location(l_proc,60);
17147: hr_utility.trace('RENEW mode or no latest assact in ADD mode');
17148: end if;
17149: --
17150: pay_jp_itwb_dml_pkg.create_assact(
17151: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17152: p_assignment_action_id => p_assignment_action_id,
17153: p_action_context_type => 'AAP',
17154: p_assignment_id => p_assignment_id,
17147: hr_utility.trace('RENEW mode or no latest assact in ADD mode');
17148: end if;
17149: --
17150: pay_jp_itwb_dml_pkg.create_assact(
17151: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17152: p_assignment_action_id => p_assignment_action_id,
17153: p_action_context_type => 'AAP',
17154: p_assignment_id => p_assignment_id,
17155: p_effective_date => g_effective_date,
17169: and g_detail_debug = 'Y' then
17170: l_archive_step := 170;
17171: end if;
17172: --
17173: pay_jp_itwb_dml_pkg.create_emp(
17174: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17175: p_assignment_action_id => p_assignment_action_id,
17176: p_action_context_type => 'AAP',
17177: p_assignment_id => p_assignment_id,
17170: l_archive_step := 170;
17171: end if;
17172: --
17173: pay_jp_itwb_dml_pkg.create_emp(
17174: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17175: p_assignment_action_id => p_assignment_action_id,
17176: p_action_context_type => 'AAP',
17177: p_assignment_id => p_assignment_id,
17178: p_effective_date => g_effective_date,
17191: and g_detail_debug = 'Y' then
17192: l_archive_step := 171;
17193: end if;
17194: --
17195: pay_jp_itwb_dml_pkg.create_emp_add(
17196: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17197: p_assignment_action_id => p_assignment_action_id,
17198: p_action_context_type => 'AAP',
17199: p_assignment_id => p_assignment_id,
17192: l_archive_step := 171;
17193: end if;
17194: --
17195: pay_jp_itwb_dml_pkg.create_emp_add(
17196: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17197: p_assignment_action_id => p_assignment_action_id,
17198: p_action_context_type => 'AAP',
17199: p_assignment_id => p_assignment_id,
17200: p_effective_date => g_effective_date,
17215: and g_detail_debug = 'Y' then
17216: l_archive_step := 172;
17217: end if;
17218: --
17219: pay_jp_itwb_dml_pkg.create_emp_ass(
17220: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17221: p_assignment_action_id => p_assignment_action_id,
17222: p_action_context_type => 'AAP',
17223: p_assignment_id => p_assignment_id,
17216: l_archive_step := 172;
17217: end if;
17218: --
17219: pay_jp_itwb_dml_pkg.create_emp_ass(
17220: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17221: p_assignment_action_id => p_assignment_action_id,
17222: p_action_context_type => 'AAP',
17223: p_assignment_id => p_assignment_id,
17224: p_effective_date => g_effective_date,
17234: and g_detail_debug = 'Y' then
17235: l_archive_step := 173;
17236: end if;
17237: --
17238: pay_jp_itwb_dml_pkg.create_emp_si(
17239: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17240: p_assignment_action_id => p_assignment_action_id,
17241: p_action_context_type => 'AAP',
17242: p_assignment_id => p_assignment_id,
17235: l_archive_step := 173;
17236: end if;
17237: --
17238: pay_jp_itwb_dml_pkg.create_emp_si(
17239: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17240: p_assignment_action_id => p_assignment_action_id,
17241: p_action_context_type => 'AAP',
17242: p_assignment_id => p_assignment_id,
17243: p_effective_date => g_effective_date,
17261: and g_detail_debug = 'Y' then
17262: l_archive_step := 174;
17263: end if;
17264: --
17265: pay_jp_itwb_dml_pkg.create_sal_act(
17266: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17267: p_assignment_action_id => p_assignment_action_id,
17268: p_action_context_type => 'AAP',
17269: p_assignment_id => p_assignment_id,
17262: l_archive_step := 174;
17263: end if;
17264: --
17265: pay_jp_itwb_dml_pkg.create_sal_act(
17266: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17267: p_assignment_action_id => p_assignment_action_id,
17268: p_action_context_type => 'AAP',
17269: p_assignment_id => p_assignment_id,
17270: p_effective_date => g_effective_date,
17288: and g_detail_debug = 'Y' then
17289: l_archive_step := 175;
17290: end if;
17291: --
17292: pay_jp_itwb_dml_pkg.create_sal_act(
17293: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17294: p_assignment_action_id => p_assignment_action_id,
17295: p_action_context_type => 'AAP',
17296: p_assignment_id => p_assignment_id,
17289: l_archive_step := 175;
17290: end if;
17291: --
17292: pay_jp_itwb_dml_pkg.create_sal_act(
17293: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17294: p_assignment_action_id => p_assignment_action_id,
17295: p_action_context_type => 'AAP',
17296: p_assignment_id => p_assignment_id,
17297: p_effective_date => g_effective_date,
17315: and g_detail_debug = 'Y' then
17316: l_archive_step := 176;
17317: end if;
17318: --
17319: pay_jp_itwb_dml_pkg.create_sal_act(
17320: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17321: p_assignment_action_id => p_assignment_action_id,
17322: p_action_context_type => 'AAP',
17323: p_assignment_id => p_assignment_id,
17316: l_archive_step := 176;
17317: end if;
17318: --
17319: pay_jp_itwb_dml_pkg.create_sal_act(
17320: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17321: p_assignment_action_id => p_assignment_action_id,
17322: p_action_context_type => 'AAP',
17323: p_assignment_id => p_assignment_id,
17324: p_effective_date => g_effective_date,
17342: and g_detail_debug = 'Y' then
17343: l_archive_step := 177;
17344: end if;
17345: --
17346: pay_jp_itwb_dml_pkg.create_sal_act(
17347: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17348: p_assignment_action_id => p_assignment_action_id,
17349: p_action_context_type => 'AAP',
17350: p_assignment_id => p_assignment_id,
17343: l_archive_step := 177;
17344: end if;
17345: --
17346: pay_jp_itwb_dml_pkg.create_sal_act(
17347: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17348: p_assignment_action_id => p_assignment_action_id,
17349: p_action_context_type => 'AAP',
17350: p_assignment_id => p_assignment_id,
17351: p_effective_date => g_effective_date,
17370: l_archive_step := 178;
17371: end if;
17372: --
17373: -- set col_tot later, set_data_pay_col_tot
17374: pay_jp_itwb_dml_pkg.create_sal_pay(
17375: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17376: p_assignment_action_id => p_assignment_action_id,
17377: p_action_context_type => 'AAP',
17378: p_assignment_id => p_assignment_id,
17371: end if;
17372: --
17373: -- set col_tot later, set_data_pay_col_tot
17374: pay_jp_itwb_dml_pkg.create_sal_pay(
17375: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17376: p_assignment_action_id => p_assignment_action_id,
17377: p_action_context_type => 'AAP',
17378: p_assignment_id => p_assignment_id,
17379: p_effective_date => g_effective_date,
17398: and g_detail_debug = 'Y' then
17399: l_archive_step := 179;
17400: end if;
17401: --
17402: pay_jp_itwb_dml_pkg.create_sal_pay(
17403: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17404: p_assignment_action_id => p_assignment_action_id,
17405: p_action_context_type => 'AAP',
17406: p_assignment_id => p_assignment_id,
17399: l_archive_step := 179;
17400: end if;
17401: --
17402: pay_jp_itwb_dml_pkg.create_sal_pay(
17403: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17404: p_assignment_action_id => p_assignment_action_id,
17405: p_action_context_type => 'AAP',
17406: p_assignment_id => p_assignment_id,
17407: p_effective_date => g_effective_date,
17426: and g_detail_debug = 'Y' then
17427: l_archive_step := 180;
17428: end if;
17429: --
17430: pay_jp_itwb_dml_pkg.create_sal_pay(
17431: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17432: p_assignment_action_id => p_assignment_action_id,
17433: p_action_context_type => 'AAP',
17434: p_assignment_id => p_assignment_id,
17427: l_archive_step := 180;
17428: end if;
17429: --
17430: pay_jp_itwb_dml_pkg.create_sal_pay(
17431: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17432: p_assignment_action_id => p_assignment_action_id,
17433: p_action_context_type => 'AAP',
17434: p_assignment_id => p_assignment_id,
17435: p_effective_date => g_effective_date,
17454: and g_detail_debug = 'Y' then
17455: l_archive_step := 181;
17456: end if;
17457: --
17458: pay_jp_itwb_dml_pkg.create_sal_pay(
17459: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17460: p_assignment_action_id => p_assignment_action_id,
17461: p_action_context_type => 'AAP',
17462: p_assignment_id => p_assignment_id,
17455: l_archive_step := 181;
17456: end if;
17457: --
17458: pay_jp_itwb_dml_pkg.create_sal_pay(
17459: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17460: p_assignment_action_id => p_assignment_action_id,
17461: p_action_context_type => 'AAP',
17462: p_assignment_id => p_assignment_id,
17463: p_effective_date => g_effective_date,
17482: and g_detail_debug = 'Y' then
17483: l_archive_step := 182;
17484: end if;
17485: --
17486: pay_jp_itwb_dml_pkg.create_sal_pay(
17487: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17488: p_assignment_action_id => p_assignment_action_id,
17489: p_action_context_type => 'AAP',
17490: p_assignment_id => p_assignment_id,
17483: l_archive_step := 182;
17484: end if;
17485: --
17486: pay_jp_itwb_dml_pkg.create_sal_pay(
17487: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17488: p_assignment_action_id => p_assignment_action_id,
17489: p_action_context_type => 'AAP',
17490: p_assignment_id => p_assignment_id,
17491: p_effective_date => g_effective_date,
17510: and g_detail_debug = 'Y' then
17511: l_archive_step := 183;
17512: end if;
17513: --
17514: pay_jp_itwb_dml_pkg.create_sal_pay(
17515: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17516: p_assignment_action_id => p_assignment_action_id,
17517: p_action_context_type => 'AAP',
17518: p_assignment_id => p_assignment_id,
17511: l_archive_step := 183;
17512: end if;
17513: --
17514: pay_jp_itwb_dml_pkg.create_sal_pay(
17515: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17516: p_assignment_action_id => p_assignment_action_id,
17517: p_action_context_type => 'AAP',
17518: p_assignment_id => p_assignment_id,
17519: p_effective_date => g_effective_date,
17538: and g_detail_debug = 'Y' then
17539: l_archive_step := 184;
17540: end if;
17541: --
17542: pay_jp_itwb_dml_pkg.create_sal_pay(
17543: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17544: p_assignment_action_id => p_assignment_action_id,
17545: p_action_context_type => 'AAP',
17546: p_assignment_id => p_assignment_id,
17539: l_archive_step := 184;
17540: end if;
17541: --
17542: pay_jp_itwb_dml_pkg.create_sal_pay(
17543: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17544: p_assignment_action_id => p_assignment_action_id,
17545: p_action_context_type => 'AAP',
17546: p_assignment_id => p_assignment_id,
17547: p_effective_date => g_effective_date,
17566: and g_detail_debug = 'Y' then
17567: l_archive_step := 185;
17568: end if;
17569: --
17570: pay_jp_itwb_dml_pkg.create_sal_pay(
17571: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17572: p_assignment_action_id => p_assignment_action_id,
17573: p_action_context_type => 'AAP',
17574: p_assignment_id => p_assignment_id,
17567: l_archive_step := 185;
17568: end if;
17569: --
17570: pay_jp_itwb_dml_pkg.create_sal_pay(
17571: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17572: p_assignment_action_id => p_assignment_action_id,
17573: p_action_context_type => 'AAP',
17574: p_assignment_id => p_assignment_id,
17575: p_effective_date => g_effective_date,
17594: and g_detail_debug = 'Y' then
17595: l_archive_step := 186;
17596: end if;
17597: --
17598: pay_jp_itwb_dml_pkg.create_sal_pay(
17599: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17600: p_assignment_action_id => p_assignment_action_id,
17601: p_action_context_type => 'AAP',
17602: p_assignment_id => p_assignment_id,
17595: l_archive_step := 186;
17596: end if;
17597: --
17598: pay_jp_itwb_dml_pkg.create_sal_pay(
17599: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17600: p_assignment_action_id => p_assignment_action_id,
17601: p_action_context_type => 'AAP',
17602: p_assignment_id => p_assignment_id,
17603: p_effective_date => g_effective_date,
17622: and g_detail_debug = 'Y' then
17623: l_archive_step := 187;
17624: end if;
17625: --
17626: pay_jp_itwb_dml_pkg.create_sal_pay(
17627: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17628: p_assignment_action_id => p_assignment_action_id,
17629: p_action_context_type => 'AAP',
17630: p_assignment_id => p_assignment_id,
17623: l_archive_step := 187;
17624: end if;
17625: --
17626: pay_jp_itwb_dml_pkg.create_sal_pay(
17627: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17628: p_assignment_action_id => p_assignment_action_id,
17629: p_action_context_type => 'AAP',
17630: p_assignment_id => p_assignment_id,
17631: p_effective_date => g_effective_date,
17650: and g_detail_debug = 'Y' then
17651: l_archive_step := 188;
17652: end if;
17653: --
17654: pay_jp_itwb_dml_pkg.create_sal_pay(
17655: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17656: p_assignment_action_id => p_assignment_action_id,
17657: p_action_context_type => 'AAP',
17658: p_assignment_id => p_assignment_id,
17651: l_archive_step := 188;
17652: end if;
17653: --
17654: pay_jp_itwb_dml_pkg.create_sal_pay(
17655: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17656: p_assignment_action_id => p_assignment_action_id,
17657: p_action_context_type => 'AAP',
17658: p_assignment_id => p_assignment_id,
17659: p_effective_date => g_effective_date,
17678: and g_detail_debug = 'Y' then
17679: l_archive_step := 189;
17680: end if;
17681: --
17682: pay_jp_itwb_dml_pkg.create_sal_pay(
17683: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17684: p_assignment_action_id => p_assignment_action_id,
17685: p_action_context_type => 'AAP',
17686: p_assignment_id => p_assignment_id,
17679: l_archive_step := 189;
17680: end if;
17681: --
17682: pay_jp_itwb_dml_pkg.create_sal_pay(
17683: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17684: p_assignment_action_id => p_assignment_action_id,
17685: p_action_context_type => 'AAP',
17686: p_assignment_id => p_assignment_id,
17687: p_effective_date => g_effective_date,
17706: and g_detail_debug = 'Y' then
17707: l_archive_step := 190;
17708: end if;
17709: --
17710: pay_jp_itwb_dml_pkg.create_sal_pay(
17711: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17712: p_assignment_action_id => p_assignment_action_id,
17713: p_action_context_type => 'AAP',
17714: p_assignment_id => p_assignment_id,
17707: l_archive_step := 190;
17708: end if;
17709: --
17710: pay_jp_itwb_dml_pkg.create_sal_pay(
17711: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17712: p_assignment_action_id => p_assignment_action_id,
17713: p_action_context_type => 'AAP',
17714: p_assignment_id => p_assignment_id,
17715: p_effective_date => g_effective_date,
17734: and g_detail_debug = 'Y' then
17735: l_archive_step := 191;
17736: end if;
17737: --
17738: pay_jp_itwb_dml_pkg.create_sal_pay(
17739: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17740: p_assignment_action_id => p_assignment_action_id,
17741: p_action_context_type => 'AAP',
17742: p_assignment_id => p_assignment_id,
17735: l_archive_step := 191;
17736: end if;
17737: --
17738: pay_jp_itwb_dml_pkg.create_sal_pay(
17739: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17740: p_assignment_action_id => p_assignment_action_id,
17741: p_action_context_type => 'AAP',
17742: p_assignment_id => p_assignment_id,
17743: p_effective_date => g_effective_date,
17762: and g_detail_debug = 'Y' then
17763: l_archive_step := 192;
17764: end if;
17765: --
17766: pay_jp_itwb_dml_pkg.create_sal_pay(
17767: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17768: p_assignment_action_id => p_assignment_action_id,
17769: p_action_context_type => 'AAP',
17770: p_assignment_id => p_assignment_id,
17763: l_archive_step := 192;
17764: end if;
17765: --
17766: pay_jp_itwb_dml_pkg.create_sal_pay(
17767: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17768: p_assignment_action_id => p_assignment_action_id,
17769: p_action_context_type => 'AAP',
17770: p_assignment_id => p_assignment_id,
17771: p_effective_date => g_effective_date,
17790: and g_detail_debug = 'Y' then
17791: l_archive_step := 193;
17792: end if;
17793: --
17794: pay_jp_itwb_dml_pkg.create_sal_pay(
17795: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17796: p_assignment_action_id => p_assignment_action_id,
17797: p_action_context_type => 'AAP',
17798: p_assignment_id => p_assignment_id,
17791: l_archive_step := 193;
17792: end if;
17793: --
17794: pay_jp_itwb_dml_pkg.create_sal_pay(
17795: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17796: p_assignment_action_id => p_assignment_action_id,
17797: p_action_context_type => 'AAP',
17798: p_assignment_id => p_assignment_id,
17799: p_effective_date => g_effective_date,
17818: and g_detail_debug = 'Y' then
17819: l_archive_step := 194;
17820: end if;
17821: --
17822: pay_jp_itwb_dml_pkg.create_sal_pay(
17823: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17824: p_assignment_action_id => p_assignment_action_id,
17825: p_action_context_type => 'AAP',
17826: p_assignment_id => p_assignment_id,
17819: l_archive_step := 194;
17820: end if;
17821: --
17822: pay_jp_itwb_dml_pkg.create_sal_pay(
17823: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17824: p_assignment_action_id => p_assignment_action_id,
17825: p_action_context_type => 'AAP',
17826: p_assignment_id => p_assignment_id,
17827: p_effective_date => g_effective_date,
17846: and g_detail_debug = 'Y' then
17847: l_archive_step := 195;
17848: end if;
17849: --
17850: pay_jp_itwb_dml_pkg.create_sal_pay(
17851: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17852: p_assignment_action_id => p_assignment_action_id,
17853: p_action_context_type => 'AAP',
17854: p_assignment_id => p_assignment_id,
17847: l_archive_step := 195;
17848: end if;
17849: --
17850: pay_jp_itwb_dml_pkg.create_sal_pay(
17851: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17852: p_assignment_action_id => p_assignment_action_id,
17853: p_action_context_type => 'AAP',
17854: p_assignment_id => p_assignment_id,
17855: p_effective_date => g_effective_date,
17874: and g_detail_debug = 'Y' then
17875: l_archive_step := 196;
17876: end if;
17877: --
17878: pay_jp_itwb_dml_pkg.create_bon_act(
17879: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17880: p_assignment_action_id => p_assignment_action_id,
17881: p_action_context_type => 'AAP',
17882: p_assignment_id => p_assignment_id,
17875: l_archive_step := 196;
17876: end if;
17877: --
17878: pay_jp_itwb_dml_pkg.create_bon_act(
17879: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17880: p_assignment_action_id => p_assignment_action_id,
17881: p_action_context_type => 'AAP',
17882: p_assignment_id => p_assignment_id,
17883: p_effective_date => g_effective_date,
17904: and g_detail_debug = 'Y' then
17905: l_archive_step := 197;
17906: end if;
17907: --
17908: pay_jp_itwb_dml_pkg.create_bon_act(
17909: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17910: p_assignment_action_id => p_assignment_action_id,
17911: p_action_context_type => 'AAP',
17912: p_assignment_id => p_assignment_id,
17905: l_archive_step := 197;
17906: end if;
17907: --
17908: pay_jp_itwb_dml_pkg.create_bon_act(
17909: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17910: p_assignment_action_id => p_assignment_action_id,
17911: p_action_context_type => 'AAP',
17912: p_assignment_id => p_assignment_id,
17913: p_effective_date => g_effective_date,
17934: and g_detail_debug = 'Y' then
17935: l_archive_step := 198;
17936: end if;
17937: --
17938: pay_jp_itwb_dml_pkg.create_bon_act(
17939: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17940: p_assignment_action_id => p_assignment_action_id,
17941: p_action_context_type => 'AAP',
17942: p_assignment_id => p_assignment_id,
17935: l_archive_step := 198;
17936: end if;
17937: --
17938: pay_jp_itwb_dml_pkg.create_bon_act(
17939: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17940: p_assignment_action_id => p_assignment_action_id,
17941: p_action_context_type => 'AAP',
17942: p_assignment_id => p_assignment_id,
17943: p_effective_date => g_effective_date,
17964: and g_detail_debug = 'Y' then
17965: l_archive_step := 199;
17966: end if;
17967: --
17968: pay_jp_itwb_dml_pkg.create_bon_act(
17969: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17970: p_assignment_action_id => p_assignment_action_id,
17971: p_action_context_type => 'AAP',
17972: p_assignment_id => p_assignment_id,
17965: l_archive_step := 199;
17966: end if;
17967: --
17968: pay_jp_itwb_dml_pkg.create_bon_act(
17969: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
17970: p_assignment_action_id => p_assignment_action_id,
17971: p_action_context_type => 'AAP',
17972: p_assignment_id => p_assignment_id,
17973: p_effective_date => g_effective_date,
17994: and g_detail_debug = 'Y' then
17995: l_archive_step := 200;
17996: end if;
17997: --
17998: pay_jp_itwb_dml_pkg.create_bon_act(
17999: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
18000: p_assignment_action_id => p_assignment_action_id,
18001: p_action_context_type => 'AAP',
18002: p_assignment_id => p_assignment_id,
17995: l_archive_step := 200;
17996: end if;
17997: --
17998: pay_jp_itwb_dml_pkg.create_bon_act(
17999: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
18000: p_assignment_action_id => p_assignment_action_id,
18001: p_action_context_type => 'AAP',
18002: p_assignment_id => p_assignment_id,
18003: p_effective_date => g_effective_date,
18024: and g_detail_debug = 'Y' then
18025: l_archive_step := 201;
18026: end if;
18027: --
18028: pay_jp_itwb_dml_pkg.create_bon_pay(
18029: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
18030: p_assignment_action_id => p_assignment_action_id,
18031: p_action_context_type => 'AAP',
18032: p_assignment_id => p_assignment_id,
18025: l_archive_step := 201;
18026: end if;
18027: --
18028: pay_jp_itwb_dml_pkg.create_bon_pay(
18029: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
18030: p_assignment_action_id => p_assignment_action_id,
18031: p_action_context_type => 'AAP',
18032: p_assignment_id => p_assignment_id,
18033: p_effective_date => g_effective_date,
18055: and g_detail_debug = 'Y' then
18056: l_archive_step := 202;
18057: end if;
18058: --
18059: pay_jp_itwb_dml_pkg.create_bon_pay(
18060: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
18061: p_assignment_action_id => p_assignment_action_id,
18062: p_action_context_type => 'AAP',
18063: p_assignment_id => p_assignment_id,
18056: l_archive_step := 202;
18057: end if;
18058: --
18059: pay_jp_itwb_dml_pkg.create_bon_pay(
18060: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
18061: p_assignment_action_id => p_assignment_action_id,
18062: p_action_context_type => 'AAP',
18063: p_assignment_id => p_assignment_id,
18064: p_effective_date => g_effective_date,
18086: and g_detail_debug = 'Y' then
18087: l_archive_step := 203;
18088: end if;
18089: --
18090: pay_jp_itwb_dml_pkg.create_bon_pay(
18091: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
18092: p_assignment_action_id => p_assignment_action_id,
18093: p_action_context_type => 'AAP',
18094: p_assignment_id => p_assignment_id,
18087: l_archive_step := 203;
18088: end if;
18089: --
18090: pay_jp_itwb_dml_pkg.create_bon_pay(
18091: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
18092: p_assignment_action_id => p_assignment_action_id,
18093: p_action_context_type => 'AAP',
18094: p_assignment_id => p_assignment_id,
18095: p_effective_date => g_effective_date,
18117: and g_detail_debug = 'Y' then
18118: l_archive_step := 204;
18119: end if;
18120: --
18121: pay_jp_itwb_dml_pkg.create_bon_pay(
18122: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
18123: p_assignment_action_id => p_assignment_action_id,
18124: p_action_context_type => 'AAP',
18125: p_assignment_id => p_assignment_id,
18118: l_archive_step := 204;
18119: end if;
18120: --
18121: pay_jp_itwb_dml_pkg.create_bon_pay(
18122: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
18123: p_assignment_action_id => p_assignment_action_id,
18124: p_action_context_type => 'AAP',
18125: p_assignment_id => p_assignment_id,
18126: p_effective_date => g_effective_date,
18148: and g_detail_debug = 'Y' then
18149: l_archive_step := 205;
18150: end if;
18151: --
18152: pay_jp_itwb_dml_pkg.create_bon_pay(
18153: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
18154: p_assignment_action_id => p_assignment_action_id,
18155: p_action_context_type => 'AAP',
18156: p_assignment_id => p_assignment_id,
18149: l_archive_step := 205;
18150: end if;
18151: --
18152: pay_jp_itwb_dml_pkg.create_bon_pay(
18153: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
18154: p_assignment_action_id => p_assignment_action_id,
18155: p_action_context_type => 'AAP',
18156: p_assignment_id => p_assignment_id,
18157: p_effective_date => g_effective_date,
18179: and g_detail_debug = 'Y' then
18180: l_archive_step := 206;
18181: end if;
18182: --
18183: pay_jp_itwb_dml_pkg.create_bon_pay(
18184: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
18185: p_assignment_action_id => p_assignment_action_id,
18186: p_action_context_type => 'AAP',
18187: p_assignment_id => p_assignment_id,
18180: l_archive_step := 206;
18181: end if;
18182: --
18183: pay_jp_itwb_dml_pkg.create_bon_pay(
18184: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
18185: p_assignment_action_id => p_assignment_action_id,
18186: p_action_context_type => 'AAP',
18187: p_assignment_id => p_assignment_id,
18188: p_effective_date => g_effective_date,
18210: and g_detail_debug = 'Y' then
18211: l_archive_step := 207;
18212: end if;
18213: --
18214: pay_jp_itwb_dml_pkg.create_bon_pay(
18215: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
18216: p_assignment_action_id => p_assignment_action_id,
18217: p_action_context_type => 'AAP',
18218: p_assignment_id => p_assignment_id,
18211: l_archive_step := 207;
18212: end if;
18213: --
18214: pay_jp_itwb_dml_pkg.create_bon_pay(
18215: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
18216: p_assignment_action_id => p_assignment_action_id,
18217: p_action_context_type => 'AAP',
18218: p_assignment_id => p_assignment_id,
18219: p_effective_date => g_effective_date,
18241: and g_detail_debug = 'Y' then
18242: l_archive_step := 208;
18243: end if;
18244: --
18245: pay_jp_itwb_dml_pkg.create_bon_pay(
18246: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
18247: p_assignment_action_id => p_assignment_action_id,
18248: p_action_context_type => 'AAP',
18249: p_assignment_id => p_assignment_id,
18242: l_archive_step := 208;
18243: end if;
18244: --
18245: pay_jp_itwb_dml_pkg.create_bon_pay(
18246: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
18247: p_assignment_action_id => p_assignment_action_id,
18248: p_action_context_type => 'AAP',
18249: p_assignment_id => p_assignment_id,
18250: p_effective_date => g_effective_date,
18272: and g_detail_debug = 'Y' then
18273: l_archive_step := 209;
18274: end if;
18275: --
18276: pay_jp_itwb_dml_pkg.create_bon_pay(
18277: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
18278: p_assignment_action_id => p_assignment_action_id,
18279: p_action_context_type => 'AAP',
18280: p_assignment_id => p_assignment_id,
18273: l_archive_step := 209;
18274: end if;
18275: --
18276: pay_jp_itwb_dml_pkg.create_bon_pay(
18277: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
18278: p_assignment_action_id => p_assignment_action_id,
18279: p_action_context_type => 'AAP',
18280: p_assignment_id => p_assignment_id,
18281: p_effective_date => g_effective_date,
18303: and g_detail_debug = 'Y' then
18304: l_archive_step := 210;
18305: end if;
18306: --
18307: pay_jp_itwb_dml_pkg.create_bon_pay(
18308: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
18309: p_assignment_action_id => p_assignment_action_id,
18310: p_action_context_type => 'AAP',
18311: p_assignment_id => p_assignment_id,
18304: l_archive_step := 210;
18305: end if;
18306: --
18307: pay_jp_itwb_dml_pkg.create_bon_pay(
18308: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
18309: p_assignment_action_id => p_assignment_action_id,
18310: p_action_context_type => 'AAP',
18311: p_assignment_id => p_assignment_id,
18312: p_effective_date => g_effective_date,
18334: and g_detail_debug = 'Y' then
18335: l_archive_step := 211;
18336: end if;
18337: --
18338: pay_jp_itwb_dml_pkg.create_bon_pay(
18339: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
18340: p_assignment_action_id => p_assignment_action_id,
18341: p_action_context_type => 'AAP',
18342: p_assignment_id => p_assignment_id,
18335: l_archive_step := 211;
18336: end if;
18337: --
18338: pay_jp_itwb_dml_pkg.create_bon_pay(
18339: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
18340: p_assignment_action_id => p_assignment_action_id,
18341: p_action_context_type => 'AAP',
18342: p_assignment_id => p_assignment_id,
18343: p_effective_date => g_effective_date,
18365: and g_detail_debug = 'Y' then
18366: l_archive_step := 212;
18367: end if;
18368: --
18369: pay_jp_itwb_dml_pkg.create_bon_pay(
18370: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
18371: p_assignment_action_id => p_assignment_action_id,
18372: p_action_context_type => 'AAP',
18373: p_assignment_id => p_assignment_id,
18366: l_archive_step := 212;
18367: end if;
18368: --
18369: pay_jp_itwb_dml_pkg.create_bon_pay(
18370: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
18371: p_assignment_action_id => p_assignment_action_id,
18372: p_action_context_type => 'AAP',
18373: p_assignment_id => p_assignment_id,
18374: p_effective_date => g_effective_date,
18396: and g_detail_debug = 'Y' then
18397: l_archive_step := 213;
18398: end if;
18399: --
18400: pay_jp_itwb_dml_pkg.create_bon_pay(
18401: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
18402: p_assignment_action_id => p_assignment_action_id,
18403: p_action_context_type => 'AAP',
18404: p_assignment_id => p_assignment_id,
18397: l_archive_step := 213;
18398: end if;
18399: --
18400: pay_jp_itwb_dml_pkg.create_bon_pay(
18401: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
18402: p_assignment_action_id => p_assignment_action_id,
18403: p_action_context_type => 'AAP',
18404: p_assignment_id => p_assignment_id,
18405: p_effective_date => g_effective_date,
18427: and g_detail_debug = 'Y' then
18428: l_archive_step := 214;
18429: end if;
18430: --
18431: pay_jp_itwb_dml_pkg.create_bon_pay(
18432: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
18433: p_assignment_action_id => p_assignment_action_id,
18434: p_action_context_type => 'AAP',
18435: p_assignment_id => p_assignment_id,
18428: l_archive_step := 214;
18429: end if;
18430: --
18431: pay_jp_itwb_dml_pkg.create_bon_pay(
18432: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
18433: p_assignment_action_id => p_assignment_action_id,
18434: p_action_context_type => 'AAP',
18435: p_assignment_id => p_assignment_id,
18436: p_effective_date => g_effective_date,
18458: and g_detail_debug = 'Y' then
18459: l_archive_step := 215;
18460: end if;
18461: --
18462: pay_jp_itwb_dml_pkg.create_bon_pay(
18463: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
18464: p_assignment_action_id => p_assignment_action_id,
18465: p_action_context_type => 'AAP',
18466: p_assignment_id => p_assignment_id,
18459: l_archive_step := 215;
18460: end if;
18461: --
18462: pay_jp_itwb_dml_pkg.create_bon_pay(
18463: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
18464: p_assignment_action_id => p_assignment_action_id,
18465: p_action_context_type => 'AAP',
18466: p_assignment_id => p_assignment_id,
18467: p_effective_date => g_effective_date,
18489: and g_detail_debug = 'Y' then
18490: l_archive_step := 216;
18491: end if;
18492: --
18493: pay_jp_itwb_dml_pkg.create_bon_pay(
18494: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
18495: p_assignment_action_id => p_assignment_action_id,
18496: p_action_context_type => 'AAP',
18497: p_assignment_id => p_assignment_id,
18490: l_archive_step := 216;
18491: end if;
18492: --
18493: pay_jp_itwb_dml_pkg.create_bon_pay(
18494: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
18495: p_assignment_action_id => p_assignment_action_id,
18496: p_action_context_type => 'AAP',
18497: p_assignment_id => p_assignment_id,
18498: p_effective_date => g_effective_date,
18520: and g_detail_debug = 'Y' then
18521: l_archive_step := 217;
18522: end if;
18523: --
18524: pay_jp_itwb_dml_pkg.create_bon_pay(
18525: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
18526: p_assignment_action_id => p_assignment_action_id,
18527: p_action_context_type => 'AAP',
18528: p_assignment_id => p_assignment_id,
18521: l_archive_step := 217;
18522: end if;
18523: --
18524: pay_jp_itwb_dml_pkg.create_bon_pay(
18525: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
18526: p_assignment_action_id => p_assignment_action_id,
18527: p_action_context_type => 'AAP',
18528: p_assignment_id => p_assignment_id,
18529: p_effective_date => g_effective_date,
18551: and g_detail_debug = 'Y' then
18552: l_archive_step := 218;
18553: end if;
18554: --
18555: pay_jp_itwb_dml_pkg.create_bon_pay(
18556: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
18557: p_assignment_action_id => p_assignment_action_id,
18558: p_action_context_type => 'AAP',
18559: p_assignment_id => p_assignment_id,
18552: l_archive_step := 218;
18553: end if;
18554: --
18555: pay_jp_itwb_dml_pkg.create_bon_pay(
18556: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
18557: p_assignment_action_id => p_assignment_action_id,
18558: p_action_context_type => 'AAP',
18559: p_assignment_id => p_assignment_id,
18560: p_effective_date => g_effective_date,
18798: --
18799: if not l_skip then
18800: --
18801: -- set col_tot later, set_data_item_col_tot
18802: pay_jp_itwb_dml_pkg.create_sal_earn(
18803: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
18804: p_assignment_action_id => p_assignment_action_id,
18805: p_action_context_type => 'AAP',
18806: p_assignment_id => p_assignment_id,
18799: if not l_skip then
18800: --
18801: -- set col_tot later, set_data_item_col_tot
18802: pay_jp_itwb_dml_pkg.create_sal_earn(
18803: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
18804: p_assignment_action_id => p_assignment_action_id,
18805: p_action_context_type => 'AAP',
18806: p_assignment_id => p_assignment_id,
18807: p_effective_date => g_effective_date,
18867: end if;
18868: --
18869: if not l_skip then
18870: --
18871: pay_jp_itwb_dml_pkg.create_sal_dct(
18872: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
18873: p_assignment_action_id => p_assignment_action_id,
18874: p_action_context_type => 'AAP',
18875: p_assignment_id => p_assignment_id,
18868: --
18869: if not l_skip then
18870: --
18871: pay_jp_itwb_dml_pkg.create_sal_dct(
18872: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
18873: p_assignment_action_id => p_assignment_action_id,
18874: p_action_context_type => 'AAP',
18875: p_assignment_id => p_assignment_id,
18876: p_effective_date => g_effective_date,
18936: end if;
18937: --
18938: if not l_skip then
18939: --
18940: pay_jp_itwb_dml_pkg.create_wrk(
18941: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
18942: p_assignment_action_id => p_assignment_action_id,
18943: p_action_context_type => 'AAP',
18944: p_assignment_id => p_assignment_id,
18937: --
18938: if not l_skip then
18939: --
18940: pay_jp_itwb_dml_pkg.create_wrk(
18941: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
18942: p_assignment_action_id => p_assignment_action_id,
18943: p_action_context_type => 'AAP',
18944: p_assignment_id => p_assignment_id,
18945: p_effective_date => g_effective_date,
19046: end if;
19047: --
19048: if not l_skip then
19049: --
19050: pay_jp_itwb_dml_pkg.create_bon_earn(
19051: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
19052: p_assignment_action_id => p_assignment_action_id,
19053: p_action_context_type => 'AAP',
19054: p_assignment_id => p_assignment_id,
19047: --
19048: if not l_skip then
19049: --
19050: pay_jp_itwb_dml_pkg.create_bon_earn(
19051: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
19052: p_assignment_action_id => p_assignment_action_id,
19053: p_action_context_type => 'AAP',
19054: p_assignment_id => p_assignment_id,
19055: p_effective_date => g_effective_date,
19121: end if;
19122: --
19123: if not l_skip then
19124: --
19125: pay_jp_itwb_dml_pkg.create_bon_dct(
19126: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
19127: p_assignment_action_id => p_assignment_action_id,
19128: p_action_context_type => 'AAP',
19129: p_assignment_id => p_assignment_id,
19122: --
19123: if not l_skip then
19124: --
19125: pay_jp_itwb_dml_pkg.create_bon_dct(
19126: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
19127: p_assignment_action_id => p_assignment_action_id,
19128: p_action_context_type => 'AAP',
19129: p_assignment_id => p_assignment_id,
19130: p_effective_date => g_effective_date,
19254: end if;
19255: --
19256: if l_pjob_rec_ind is not null then
19257: --
19258: pay_jp_itwb_dml_pkg.create_pjob(
19259: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
19260: p_assignment_action_id => p_assignment_action_id,
19261: p_action_context_type => 'AAP',
19262: p_assignment_id => p_assignment_id,
19255: --
19256: if l_pjob_rec_ind is not null then
19257: --
19258: pay_jp_itwb_dml_pkg.create_pjob(
19259: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
19260: p_assignment_action_id => p_assignment_action_id,
19261: p_action_context_type => 'AAP',
19262: p_assignment_id => p_assignment_id,
19263: p_effective_date => g_effective_date,
19283: and g_detail_debug = 'Y' then
19284: l_archive_step := 238;
19285: end if;
19286: --
19287: pay_jp_itwb_dml_pkg.create_dep(
19288: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
19289: p_assignment_action_id => p_assignment_action_id,
19290: p_action_context_type => 'AAP',
19291: p_assignment_id => p_assignment_id,
19284: l_archive_step := 238;
19285: end if;
19286: --
19287: pay_jp_itwb_dml_pkg.create_dep(
19288: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
19289: p_assignment_action_id => p_assignment_action_id,
19290: p_action_context_type => 'AAP',
19291: p_assignment_id => p_assignment_id,
19292: p_effective_date => g_effective_date,
19315: and g_detail_debug = 'Y' then
19316: l_archive_step := 239;
19317: end if;
19318: --
19319: pay_jp_itwb_dml_pkg.create_yea_act(
19320: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
19321: p_assignment_action_id => p_assignment_action_id,
19322: p_action_context_type => 'AAP',
19323: p_assignment_id => p_assignment_id,
19316: l_archive_step := 239;
19317: end if;
19318: --
19319: pay_jp_itwb_dml_pkg.create_yea_act(
19320: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
19321: p_assignment_action_id => p_assignment_action_id,
19322: p_action_context_type => 'AAP',
19323: p_assignment_id => p_assignment_id,
19324: p_effective_date => g_effective_date,
19335: and g_detail_debug = 'Y' then
19336: l_archive_step := 240;
19337: end if;
19338: --
19339: pay_jp_itwb_dml_pkg.create_yea_pay(
19340: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
19341: p_assignment_action_id => p_assignment_action_id,
19342: p_action_context_type => 'AAP',
19343: p_assignment_id => p_assignment_id,
19336: l_archive_step := 240;
19337: end if;
19338: --
19339: pay_jp_itwb_dml_pkg.create_yea_pay(
19340: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
19341: p_assignment_action_id => p_assignment_action_id,
19342: p_action_context_type => 'AAP',
19343: p_assignment_id => p_assignment_id,
19344: p_effective_date => g_effective_date,
19365: and g_detail_debug = 'Y' then
19366: l_archive_step := 241;
19367: end if;
19368: --
19369: pay_jp_itwb_dml_pkg.create_yea_dct(
19370: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
19371: p_assignment_action_id => p_assignment_action_id,
19372: p_action_context_type => 'AAP',
19373: p_assignment_id => p_assignment_id,
19366: l_archive_step := 241;
19367: end if;
19368: --
19369: pay_jp_itwb_dml_pkg.create_yea_dct(
19370: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
19371: p_assignment_action_id => p_assignment_action_id,
19372: p_action_context_type => 'AAP',
19373: p_assignment_id => p_assignment_id,
19374: p_effective_date => g_effective_date,
19407: and g_detail_debug = 'Y' then
19408: l_archive_step := 242;
19409: end if;
19410: --
19411: pay_jp_itwb_dml_pkg.create_yea_tax(
19412: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
19413: p_assignment_action_id => p_assignment_action_id,
19414: p_action_context_type => 'AAP',
19415: p_assignment_id => p_assignment_id,
19408: l_archive_step := 242;
19409: end if;
19410: --
19411: pay_jp_itwb_dml_pkg.create_yea_tax(
19412: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
19413: p_assignment_action_id => p_assignment_action_id,
19414: p_action_context_type => 'AAP',
19415: p_assignment_id => p_assignment_id,
19416: p_effective_date => g_effective_date,
19435: and g_detail_debug = 'Y' then
19436: l_archive_step := 244;
19437: end if;
19438: --
19439: pay_jp_itwb_dml_pkg.create_emp_cust(
19440: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
19441: p_assignment_action_id => p_assignment_action_id,
19442: p_action_context_type => 'AAP',
19443: p_assignment_id => p_assignment_id,
19436: l_archive_step := 244;
19437: end if;
19438: --
19439: pay_jp_itwb_dml_pkg.create_emp_cust(
19440: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
19441: p_assignment_action_id => p_assignment_action_id,
19442: p_action_context_type => 'AAP',
19443: p_assignment_id => p_assignment_id,
19444: p_effective_date => g_effective_date,
19475: and g_detail_debug = 'Y' then
19476: l_archive_step := 245;
19477: end if;
19478: --
19479: pay_jp_itwb_dml_pkg.create_emp_cust(
19480: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
19481: p_assignment_action_id => p_assignment_action_id,
19482: p_action_context_type => 'AAP',
19483: p_assignment_id => p_assignment_id,
19476: l_archive_step := 245;
19477: end if;
19478: --
19479: pay_jp_itwb_dml_pkg.create_emp_cust(
19480: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
19481: p_assignment_action_id => p_assignment_action_id,
19482: p_action_context_type => 'AAP',
19483: p_assignment_id => p_assignment_id,
19484: p_effective_date => g_effective_date,
19515: and g_detail_debug = 'Y' then
19516: l_archive_step := 246;
19517: end if;
19518: --
19519: pay_jp_itwb_dml_pkg.create_emp_cust(
19520: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
19521: p_assignment_action_id => p_assignment_action_id,
19522: p_action_context_type => 'AAP',
19523: p_assignment_id => p_assignment_id,
19516: l_archive_step := 246;
19517: end if;
19518: --
19519: pay_jp_itwb_dml_pkg.create_emp_cust(
19520: p_action_information_id => pay_jp_itwb_dml_pkg.next_action_information_id,
19521: p_assignment_action_id => p_assignment_action_id,
19522: p_action_context_type => 'AAP',
19523: p_assignment_id => p_assignment_id,
19524: p_effective_date => g_effective_date,