[Home] [Help]
19: if g_debug then
20: hr_utility.set_location(l_proc,0);
21: end if;
22: --
23: select pay_action_information_s.nextval
24: into l_action_information_id
25: from dual;
26: --
27: if g_debug then
53: --
54: p_action_information_id := pay_jp_itwb_dml_pkg.next_action_information_id;
55: p_object_version_number := 1;
56: --
57: insert into pay_action_information(
58: action_information_id,
59: object_version_number,
60: action_context_id,
61: action_context_type,
128: action_information27,
129: action_information28,
130: action_information29,
131: action_information30
132: from pay_action_information
133: where action_context_id = p_action_context_id_o
134: and action_context_type = p_action_context_type
135: and action_information_category = p_action_information_category;
136: --
169: --
170: p_action_information_id := pay_jp_itwb_dml_pkg.next_action_information_id;
171: p_object_version_number := 1;
172: --
173: insert into pay_action_information(
174: action_information_id,
175: object_version_number,
176: action_context_id,
177: action_context_type,
244: action_information27,
245: action_information28,
246: action_information29,
247: action_information30
248: from pay_action_information
249: where action_context_id = p_action_context_id_o
250: and action_context_type = p_action_context_type
251: and action_information_category = p_action_information_category
252: and action_information1 = p_type;
288: --
289: p_action_information_id := pay_jp_itwb_dml_pkg.next_action_information_id;
290: p_object_version_number := 1;
291: --
292: insert into pay_action_information(
293: action_information_id,
294: object_version_number,
295: action_context_id,
296: action_context_type,
363: action_information27,
364: action_information28,
365: action_information29,
366: action_information30
367: from pay_action_information
368: where action_context_id = p_action_context_id_o
369: and action_context_type = p_action_context_type
370: and action_information_category = p_action_information_category
371: and action_information1 = fnd_number.number_to_canonical(p_item_pay_id)
404: is
405: select fnd_number.canonical_to_number(action_information1) item_pay_id,
406: action_information3 item_pay_type,
407: fnd_number.canonical_to_number(action_information4) item_id
408: from pay_action_information
409: where action_context_id = p_action_context_id_o
410: and action_information_category = p_action_information_category
411: and action_context_type = 'AAP'
412: order by
471: end if;
472: --
473: p_object_version_number := 1;
474: --
475: insert into pay_action_information(
476: action_information_id,
477: object_version_number,
478: action_context_id,
479: action_context_type,
530: end if;
531: --
532: p_object_version_number := 1;
533: --
534: insert into pay_action_information(
535: action_information_id,
536: object_version_number,
537: action_context_id,
538: action_context_type,
601: end if;
602: --
603: p_object_version_number := 1;
604: --
605: insert into pay_action_information(
606: action_information_id,
607: object_version_number,
608: action_context_id,
609: action_context_type,
705: -- because update might be done against proc action before p_arch_assignment_action_id_o
706: -- so that basically not update proc_assignment_action_id in update archive option except for same month
707: --
708: -- update pay_jp_itwb_assact_v
709: update pay_action_information
710: set object_version_number = p_object_version_number,
711: action_information1 = p_status,
712: action_information9 = fnd_number.number_to_canonical(p_arch_assignment_action_id_o)
713: where action_information_id = p_action_information_id
719: p_object_version_number := p_object_version_number + 1;
720: --
721: if to_char(p_effective_date,'MM') = to_char(p_proc_assact_date_o,'MM') then
722: --
723: update pay_action_information
724: set object_version_number = p_object_version_number,
725: action_information2 = decode(action_information2,
726: fnd_number.number_to_canonical(p_proc_assignment_action_id),
727: action_information2,
831: --
832: p_object_version_number := p_object_version_number + 1;
833: --
834: -- update pay_jp_itwb_assact_v
835: update pay_action_information
836: set object_version_number = p_object_version_number,
837: action_information1 = p_status,
838: action_information2 = fnd_number.number_to_canonical(p_proc_assignment_action_id),
839: action_information9 = fnd_number.number_to_canonical(p_arch_assignment_action_id_o)
879: end if;
880: --
881: p_object_version_number := 1;
882: --
883: insert into pay_action_information(
884: action_information_id,
885: object_version_number,
886: action_context_id,
887: action_context_type,
979: if to_char(p_effective_date,'MM') = to_char(p_proc_assact_date_o,'MM') then
980: --
981: p_object_version_number := p_object_version_number + 1;
982: --
983: update pay_action_information
984: set object_version_number = p_object_version_number,
985: action_information1 = decode(nvl(action_information1,'X'),
986: nvl(fnd_number.number_to_canonical(p_person_id),'X'),
987: action_information1,
1076: end if;
1077: --
1078: p_object_version_number := 1;
1079: --
1080: insert into pay_action_information(
1081: action_information_id,
1082: object_version_number,
1083: action_context_id,
1084: action_context_type,
1182: if to_char(p_effective_date,'MM') = to_char(p_proc_assact_date_o,'MM') then
1183: --
1184: p_object_version_number := p_object_version_number + 1;
1185: --
1186: update pay_action_information
1187: set object_version_number = p_object_version_number,
1188: action_information1 = decode(nvl(action_information1,'X'),
1189: nvl(fnd_number.number_to_canonical(p_address_id),'X'),
1190: action_information1,
1286: end if;
1287: --
1288: p_object_version_number := 1;
1289: --
1290: insert into pay_action_information(
1291: action_information_id,
1292: object_version_number,
1293: action_context_id,
1294: action_context_type,
1377: if to_char(p_effective_date,'MM') = to_char(p_proc_assact_date_o,'MM') then
1378: --
1379: p_object_version_number := p_object_version_number + 1;
1380: --
1381: update pay_action_information
1382: set object_version_number = p_object_version_number,
1383: action_information1 = decode(nvl(action_information1,'X'),
1384: nvl(fnd_date.date_to_canonical(p_hire_date),'X'),
1385: action_information1,
1459: end if;
1460: --
1461: p_object_version_number := 1;
1462: --
1463: insert into pay_action_information(
1464: action_information_id,
1465: object_version_number,
1466: action_context_id,
1467: action_context_type,
1574: if to_char(p_effective_date,'MM') = to_char(p_proc_assact_date_o,'MM') then
1575: --
1576: p_object_version_number := p_object_version_number + 1;
1577: --
1578: update pay_action_information
1579: set object_version_number = p_object_version_number,
1580: action_information1 = decode(nvl(action_information1,'X'),
1581: nvl(fnd_number.number_to_canonical(p_itax_org_id),'X'),
1582: action_information1,
1704: end if;
1705: --
1706: p_object_version_number := 1;
1707: --
1708: insert into pay_action_information(
1709: action_information_id,
1710: object_version_number,
1711: action_context_id,
1712: action_context_type,
1817: --
1818: p_object_version_number := p_object_version_number + 1;
1819: --
1820: -- update only 1 column for 1 update month, else set previous data
1821: update pay_action_information
1822: set object_version_number = p_object_version_number,
1823: action_information2 = decode(nvl(to_char(p_effective_date,'MM'),'X'),
1824: '01',p_col_mth1,
1825: decode(nvl(p_col_mth1,'X'),
2018: --
2019: p_object_version_number := p_object_version_number + 1;
2020: --
2021: --update multiple column for new multiple month, else set previous data
2022: update pay_action_information
2023: set object_version_number = p_object_version_number,
2024: action_information2 = decode(nvl(p_col_mth1,'X'),
2025: 'X',action_information2,
2026: p_col_mth1),
2106: end if;
2107: --
2108: p_object_version_number := 1;
2109: --
2110: insert into pay_action_information(
2111: action_information_id,
2112: object_version_number,
2113: action_context_id,
2114: action_context_type,
2221: end if;
2222: --
2223: p_object_version_number := p_object_version_number + 1;
2224: --
2225: update pay_action_information
2226: set object_version_number = p_object_version_number,
2227: action_information2 = decode(nvl(to_char(p_effective_date,'MM'),'X'),
2228: '01',fnd_number.number_to_canonical(p_col_mth1),
2229: decode(nvl(fnd_number.number_to_canonical(p_col_mth1),'X'),
2429: end if;
2430: --
2431: p_object_version_number := p_object_version_number + 1;
2432: --
2433: update pay_action_information
2434: set object_version_number = p_object_version_number,
2435: action_information2 = decode(nvl(fnd_number.number_to_canonical(p_col_mth1),'X'),
2436: 'X',action_information2,
2437: fnd_number.number_to_canonical(p_col_mth1)),
2522: end if;
2523: --
2524: p_object_version_number := 1;
2525: --
2526: insert into pay_action_information(
2527: action_information_id,
2528: object_version_number,
2529: action_context_id,
2530: action_context_type,
2674: --
2675: p_object_version_number := p_object_version_number + 1;
2676: --
2677: -- update only 1 column for 1 update month, else set previous data
2678: update pay_action_information
2679: set object_version_number = p_object_version_number,
2680: action_information2 = decode(nvl(l_csr_act_efd.col_cnt1,-1),
2681: 0,p_col_cnt1,
2682: decode(nvl(p_col_cnt1,'X'),
2908: --
2909: p_object_version_number := p_object_version_number + 1;
2910: --
2911: --update multiple column for new multiple month, else set previous data
2912: update pay_action_information
2913: set object_version_number = p_object_version_number,
2914: action_information2 = decode(nvl(p_col_cnt1,'X'),
2915: 'X',action_information2,
2916: p_col_cnt1),
3008: end if;
3009: --
3010: p_object_version_number := 1;
3011: --
3012: insert into pay_action_information(
3013: action_information_id,
3014: object_version_number,
3015: action_context_id,
3016: action_context_type,
3230: end if;
3231: --
3232: p_object_version_number := p_object_version_number + 1;
3233: --
3234: update pay_action_information
3235: set object_version_number = p_object_version_number,
3236: action_information2 = decode(nvl(l_csr_act_efd.col_cnt1,-1),
3237: 0,p_col_cnt1,
3238: decode(nvl(p_col_cnt1,'X'),
3537: end if;
3538: --
3539: p_object_version_number := p_object_version_number + 1;
3540: --
3541: update pay_action_information
3542: set object_version_number = p_object_version_number,
3543: action_information2 = decode(nvl(p_col_cnt1,'X'),
3544: 'X',action_information2,
3545: p_col_cnt1),
3708: end if;
3709: --
3710: p_object_version_number := 1;
3711: --
3712: insert into pay_action_information(
3713: action_information_id,
3714: object_version_number,
3715: action_context_id,
3716: action_context_type,
3835: end if;
3836: --
3837: p_object_version_number := p_object_version_number + 1;
3838: --
3839: update pay_action_information
3840: set object_version_number = p_object_version_number,
3841: action_information2 = decode(nvl(action_information2,'X'),
3842: nvl(fnd_number.number_to_canonical(p_item_pay_ord),'X'),action_information2,
3843: fnd_number.number_to_canonical(p_item_pay_ord)),
4088: if p_action_information_id is not null then
4089: --
4090: p_object_version_number := p_object_version_number + 1;
4091: --
4092: update pay_action_information
4093: set object_version_number = p_object_version_number,
4094: action_information7 = decode(nvl(fnd_number.number_to_canonical(p_col_mth1),'X'),
4095: 'X',action_information7,
4096: fnd_number.number_to_canonical(p_col_mth1)),
4216: end if;
4217: --
4218: p_object_version_number := 1;
4219: --
4220: insert into pay_action_information(
4221: action_information_id,
4222: object_version_number,
4223: action_context_id,
4224: action_context_type,
4343: end if;
4344: --
4345: p_object_version_number := p_object_version_number + 1;
4346: --
4347: update pay_action_information
4348: set object_version_number = p_object_version_number,
4349: action_information2 = decode(nvl(action_information2,'X'),
4350: nvl(fnd_number.number_to_canonical(p_item_pay_ord),'X'),action_information2,
4351: fnd_number.number_to_canonical(p_item_pay_ord)),
4596: if p_action_information_id is not null then
4597: --
4598: p_object_version_number := p_object_version_number + 1;
4599: --
4600: update pay_action_information
4601: set object_version_number = p_object_version_number,
4602: action_information7 = decode(nvl(fnd_number.number_to_canonical(p_col_mth1),'X'),
4603: 'X',action_information7,
4604: fnd_number.number_to_canonical(p_col_mth1)),
4727: end if;
4728: --
4729: p_object_version_number := 1;
4730: --
4731: insert into pay_action_information(
4732: action_information_id,
4733: object_version_number,
4734: action_context_id,
4735: action_context_type,
4889: end if;
4890: --
4891: p_object_version_number := p_object_version_number + 1;
4892: --
4893: update pay_action_information
4894: set object_version_number = p_object_version_number,
4895: action_information2 = decode(nvl(action_information2,'X'),
4896: nvl(fnd_number.number_to_canonical(p_item_pay_ord),'X'),action_information2,
4897: fnd_number.number_to_canonical(p_item_pay_ord)),
5178: if p_action_information_id is not null then
5179: --
5180: p_object_version_number := p_object_version_number + 1;
5181: --
5182: update pay_action_information
5183: set object_version_number = p_object_version_number,
5184: action_information7 = decode(nvl(fnd_number.number_to_canonical(p_col_cnt1),'X'),
5185: 'X',action_information7,
5186: fnd_number.number_to_canonical(p_col_cnt1)),
5321: end if;
5322: --
5323: p_object_version_number := 1;
5324: --
5325: insert into pay_action_information(
5326: action_information_id,
5327: object_version_number,
5328: action_context_id,
5329: action_context_type,
5483: end if;
5484: --
5485: p_object_version_number := p_object_version_number + 1;
5486: --
5487: update pay_action_information
5488: set object_version_number = p_object_version_number,
5489: action_information2 = decode(nvl(action_information2,'X'),
5490: nvl(fnd_number.number_to_canonical(p_item_pay_ord),'X'),action_information2,
5491: fnd_number.number_to_canonical(p_item_pay_ord)),
5772: if p_action_information_id is not null then
5773: --
5774: p_object_version_number := p_object_version_number + 1;
5775: --
5776: update pay_action_information
5777: set object_version_number = p_object_version_number,
5778: action_information7 = decode(nvl(fnd_number.number_to_canonical(p_col_cnt1),'X'),
5779: 'X',action_information7,
5780: fnd_number.number_to_canonical(p_col_cnt1)),
5912: end if;
5913: --
5914: p_object_version_number := 1;
5915: --
5916: insert into pay_action_information(
5917: action_information_id,
5918: object_version_number,
5919: action_context_id,
5920: action_context_type,
6034: if p_action_information_id is not null then
6035: --
6036: p_object_version_number := p_object_version_number + 1;
6037: --
6038: update pay_action_information
6039: set object_version_number = p_object_version_number,
6040: action_information2 = decode(nvl(action_information2,'X'),
6041: nvl(fnd_number.number_to_canonical(p_item_pay_ord),'X'),action_information2,
6042: fnd_number.number_to_canonical(p_item_pay_ord)),
6247: if p_action_information_id is not null then
6248: --
6249: p_object_version_number := p_object_version_number + 1;
6250: --
6251: update pay_action_information
6252: set object_version_number = p_object_version_number,
6253: action_information7 = decode(nvl(fnd_number.number_to_canonical(p_col_mth1),'X'),
6254: 'X',action_information7,
6255: fnd_number.number_to_canonical(p_col_mth1)),
6365: end if;
6366: --
6367: p_object_version_number := 1;
6368: --
6369: insert into pay_action_information(
6370: action_information_id,
6371: object_version_number,
6372: action_context_id,
6373: action_context_type,
6575: end if;
6576: --
6577: p_object_version_number := 1;
6578: --
6579: insert into pay_action_information(
6580: action_information_id,
6581: object_version_number,
6582: action_context_id,
6583: action_context_type,
6702: end if;
6703: --
6704: p_object_version_number := p_object_version_number + 1;
6705: --
6706: update pay_action_information
6707: set object_version_number = p_object_version_number,
6708: action_information1 = decode(nvl(action_information1,'X'),
6709: nvl(p_dep_itax_type,'X'),
6710: action_information1,
6853: end if;
6854: --
6855: p_object_version_number := 1;
6856: --
6857: insert into pay_action_information(
6858: action_information_id,
6859: object_version_number,
6860: action_context_id,
6861: action_context_type,
6948: if to_char(p_effective_date,'MM') = to_char(p_proc_assact_date_o,'MM') then
6949: --
6950: p_object_version_number := p_object_version_number + 1;
6951: --
6952: update pay_action_information
6953: set object_version_number = p_object_version_number,
6954: action_information1 = decode(nvl(action_information1,'X'),
6955: nvl(fnd_number.number_to_canonical(p_act),'X'),
6956: action_information1,
7059: --
7060: p_object_version_number := p_object_version_number + 1;
7061: --
7062: --update multiple column for new multiple month, else set previous data
7063: update pay_action_information
7064: set object_version_number = p_object_version_number,
7065: action_information1 = decode(nvl(fnd_number.number_to_canonical(p_act),'X'),
7066: 'X',action_information1,
7067: fnd_number.number_to_canonical(p_act)),
7130: end if;
7131: --
7132: p_object_version_number := 1;
7133: --
7134: insert into pay_action_information(
7135: action_information_id,
7136: object_version_number,
7137: action_context_id,
7138: action_context_type,
7255: if to_char(p_effective_date,'MM') = to_char(p_proc_assact_date_o,'MM') then
7256: --
7257: p_object_version_number := p_object_version_number + 1;
7258: --
7259: update pay_action_information
7260: set object_version_number = p_object_version_number,
7261: action_information1 = decode(nvl(action_information1,'X'),
7262: nvl(fnd_number.number_to_canonical(p_sal_txbl_mon),'X'),
7263: action_information1,
7436: --
7437: p_object_version_number := p_object_version_number + 1;
7438: --
7439: --update multiple column for new multiple month, else set previous data
7440: update pay_action_information
7441: set object_version_number = p_object_version_number,
7442: action_information1 = decode(nvl(fnd_number.number_to_canonical(p_sal_txbl_mon),'X'),
7443: 'X',action_information1,
7444: fnd_number.number_to_canonical(p_sal_txbl_mon)),
7549: end if;
7550: --
7551: p_object_version_number := 1;
7552: --
7553: insert into pay_action_information(
7554: action_information_id,
7555: object_version_number,
7556: action_context_id,
7557: action_context_type,
7710: if to_char(p_effective_date,'MM') = to_char(p_proc_assact_date_o,'MM') then
7711: --
7712: p_object_version_number := p_object_version_number + 1;
7713: --
7714: update pay_action_information
7715: set object_version_number = p_object_version_number,
7716: action_information1 = decode(nvl(action_information1,'X'),
7717: nvl(fnd_number.number_to_canonical(p_sal_dct_si_prem),'X'),
7718: action_information1,
7975: --
7976: p_object_version_number := p_object_version_number + 1;
7977: --
7978: --update multiple column for new multiple month, else set previous data
7979: update pay_action_information
7980: set object_version_number = p_object_version_number,
7981: action_information1 = decode(nvl(fnd_number.number_to_canonical(p_sal_dct_si_prem),'X'),
7982: 'X',action_information1,
7983: fnd_number.number_to_canonical(p_sal_dct_si_prem)),
8103: end if;
8104: --
8105: p_object_version_number := 1;
8106: --
8107: insert into pay_action_information(
8108: action_information_id,
8109: object_version_number,
8110: action_context_id,
8111: action_context_type,
8201: if to_char(p_effective_date,'MM') = to_char(p_proc_assact_date_o,'MM') then
8202: --
8203: p_object_version_number := p_object_version_number + 1;
8204: --
8205: update pay_action_information
8206: set object_version_number = p_object_version_number,
8207: action_information1 = decode(nvl(action_information1,'X'),
8208: nvl(fnd_number.number_to_canonical(p_amt_aft_emp_inc_dct),'X'),
8209: action_information1,
8319: --
8320: p_object_version_number := p_object_version_number + 1;
8321: --
8322: --update multiple column for new multiple month, else set previous data
8323: update pay_action_information
8324: set object_version_number = p_object_version_number,
8325: action_information1 = decode(nvl(fnd_number.number_to_canonical(p_amt_aft_emp_inc_dct),'X'),
8326: 'X',action_information1,
8327: fnd_number.number_to_canonical(p_amt_aft_emp_inc_dct)),
8403: end if;
8404: --
8405: p_object_version_number := 1;
8406: --
8407: insert into pay_action_information(
8408: action_information_id,
8409: object_version_number,
8410: action_context_id,
8411: action_context_type,
8542: if p_action_information_id is not null then
8543: --
8544: p_object_version_number := p_object_version_number + 1;
8545: --
8546: update pay_action_information
8547: set object_version_number = p_object_version_number,
8548: action_information2 = decode(nvl(action_information2,'X'),
8549: nvl(p_information1,'X'),action_information2,
8550: p_information1),