eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_RUN_BALANCE_BUILD dependencies on PAY_BALANCE_VALIDATION

Line 29: ( DEFINED_BALANCE_ID pay_balance_validation.defined_balance_id%type,

25: Type typ_def_bal is table of pay_defined_balances.defined_balance_id%type index by binary_integer;
26: g_tab_def_bal typ_def_bal;
27:
28: type t_balance_validation_rec is record
29: ( DEFINED_BALANCE_ID pay_balance_validation.defined_balance_id%type,
30: BALANCE_LOAD_DATE pay_balance_validation.balance_load_date%type,
31: RUN_BALANCE_STATUS pay_balance_validation.run_balance_status%type,
32: DEL_BAL_BEFORE DATE,
33: PURGE_ONLY varchar2(1) );

Line 30: BALANCE_LOAD_DATE pay_balance_validation.balance_load_date%type,

26: g_tab_def_bal typ_def_bal;
27:
28: type t_balance_validation_rec is record
29: ( DEFINED_BALANCE_ID pay_balance_validation.defined_balance_id%type,
30: BALANCE_LOAD_DATE pay_balance_validation.balance_load_date%type,
31: RUN_BALANCE_STATUS pay_balance_validation.run_balance_status%type,
32: DEL_BAL_BEFORE DATE,
33: PURGE_ONLY varchar2(1) );
34: type t_balance_validation_tab is table of t_balance_validation_rec index by binary_integer;

Line 31: RUN_BALANCE_STATUS pay_balance_validation.run_balance_status%type,

27:
28: type t_balance_validation_rec is record
29: ( DEFINED_BALANCE_ID pay_balance_validation.defined_balance_id%type,
30: BALANCE_LOAD_DATE pay_balance_validation.balance_load_date%type,
31: RUN_BALANCE_STATUS pay_balance_validation.run_balance_status%type,
32: DEL_BAL_BEFORE DATE,
33: PURGE_ONLY varchar2(1) );
34: type t_balance_validation_tab is table of t_balance_validation_rec index by binary_integer;
35: g_old_balance_validation_tab t_balance_validation_tab;

Line 51: l_bal_valid_id pay_balance_validation.balance_validation_id%type;

47: p_business_group_id in number,
48: p_status in varchar2,
49: p_from_status in varchar2)
50: is
51: l_bal_valid_id pay_balance_validation.balance_validation_id%type;
52: l_update boolean;
53: begin
54: --
55: /* Can only set a valid status if the old status was processing */

Line 70: from pay_balance_validation

66: begin
67: --
68: select balance_validation_id
69: into l_bal_valid_id
70: from pay_balance_validation
71: where defined_balance_id = p_defined_balace_id
72: and business_group_id = p_business_group_id;
73: --
74: update pay_balance_validation

Line 74: update pay_balance_validation

70: from pay_balance_validation
71: where defined_balance_id = p_defined_balace_id
72: and business_group_id = p_business_group_id;
73: --
74: update pay_balance_validation
75: set run_balance_status = p_status,
76: balance_load_date = g_start_date
77: where balance_validation_id = l_bal_valid_id;
78: --

Line 82: insert into pay_balance_validation

78: --
79: exception
80: when no_data_found then
81: --
82: insert into pay_balance_validation
83: (balance_validation_id,
84: defined_balance_id,
85: business_group_id,
86: run_balance_status,

Line 88: values ( pay_balance_validation_s.nextval,

84: defined_balance_id,
85: business_group_id,
86: run_balance_status,
87: balance_load_date)
88: values ( pay_balance_validation_s.nextval,
89: p_defined_balace_id,
90: p_business_group_id,
91: p_status,
92: g_start_date);

Line 145: l_run_bal_stat pay_balance_validation.run_balance_status%type;

141: 'BOTH')
142: = 'BOTH')
143: );
144: --
145: l_run_bal_stat pay_balance_validation.run_balance_status%type;
146: l_bus_grp pay_payroll_actions.business_group_id%type;
147: l_request_id fnd_concurrent_requests.request_id%type;
148: l_old_balance_load_date pay_balance_validation.balance_load_date%type;
149: --

Line 148: l_old_balance_load_date pay_balance_validation.balance_load_date%type;

144: --
145: l_run_bal_stat pay_balance_validation.run_balance_status%type;
146: l_bus_grp pay_payroll_actions.business_group_id%type;
147: l_request_id fnd_concurrent_requests.request_id%type;
148: l_old_balance_load_date pay_balance_validation.balance_load_date%type;
149: --
150: begin
151: g_purge_only := FALSE;
152: --

Line 159: update pay_balance_validation bv

155: from pay_payroll_actions
156: where payroll_action_id = p_pactid;
157:
158: -- bug 14301014 mark non run balances as invalid
159: update pay_balance_validation bv
160: set RUN_BALANCE_STATUS = 'I'
161: where RUN_BALANCE_STATUS <> 'I'
162: and bv.business_group_id = l_bus_grp
163: and not exists ( select 'run balance candidate' from pay_balance_dimensions bd,

Line 187: from pay_balance_validation

183: run_balance_status,
184: case when run_balance_status = 'V' and balance_load_date <= g_start_date then g_start_date else hr_api.g_eot end del_bal_before,
185: case when run_balance_status = 'V' and balance_load_date <= g_start_date then 'Y' else 'N' end purge_only
186: bulk collect into g_old_balance_validation_tab
187: from pay_balance_validation
188: where business_group_id = l_bus_grp;
189: if g_debug then
190: hr_utility.trace('set_run_bal_status store g_old_balance_validation_tab. '|| g_old_balance_validation_tab.count);
191: end if;

Line 211: pay_balance_validation pbv

207: --
208: select nvl(pbv.run_balance_status, 'I'), nvl(pbv.balance_load_date,hr_api.g_eot)
209: into l_run_bal_stat, l_old_balance_load_date
210: from pay_defined_balances pdb,
211: pay_balance_validation pbv
212: where pdb.defined_balance_id = dbrec.defined_balance_id
213: and pbv.defined_balance_id (+) = pdb.defined_balance_id
214: and pbv.business_group_id (+) = dbrec.business_group_id;
215: --

Line 235: update pay_balance_validation

231: --
232: else
233: --
234: if (p_status = 'V') then
235: update pay_balance_validation
236: set balance_load_date = g_start_date
237: where dbrec.defined_balance_id = defined_balance_id
238: and dbrec.business_group_id = business_group_id;
239: end if;

Line 255: pay_balance_validation pbv

251: select nvl(pbv.run_balance_status, 'I'), nvl(pbv.balance_load_date,hr_api.g_eot)
252:
253: into l_run_bal_stat, l_old_balance_load_date
254: from pay_defined_balances pdb,
255: pay_balance_validation pbv
256: where pdb.defined_balance_id = g_def_bal_id
257: and pbv.defined_balance_id (+) = pdb.defined_balance_id
258: and pbv.business_group_id (+) = l_bus_grp;
259:

Line 282: update pay_balance_validation

278: else
279: --
280: if (p_status = 'V') then
281: --
282: update pay_balance_validation
283: set balance_load_date = g_start_date
284: where defined_balance_id = g_def_bal_id
285: and business_group_id = l_bus_grp;
286: --

Line 635: l_run_bal_status pay_balance_validation.run_balance_status%type;

631: and ppa.effective_date between nvl(prt.effective_start_date, ppa.effective_date)
632: and nvl(prt.effective_end_date, ppa.effective_date)
633: order by 2;
634: --
635: l_run_bal_status pay_balance_validation.run_balance_status%type;
636: l_bal_load_date pay_balance_validation.balance_load_date%type;
637:
638: /*Bug 9315998*/
639: Type typ_getaa is table of getaa%rowtype index by binary_integer;

Line 636: l_bal_load_date pay_balance_validation.balance_load_date%type;

632: and nvl(prt.effective_end_date, ppa.effective_date)
633: order by 2;
634: --
635: l_run_bal_status pay_balance_validation.run_balance_status%type;
636: l_bal_load_date pay_balance_validation.balance_load_date%type;
637:
638: /*Bug 9315998*/
639: Type typ_getaa is table of getaa%rowtype index by binary_integer;
640: lt_tab_getaa typ_getaa;

Line 656: -- pay_balance_validation to identify rows to be deleted

652: --
653: if (g_proc_mode = 'INVALID') then
654: --
655: -- altered delete statement to use pay_balance_attributes rather than
656: -- pay_balance_validation to identify rows to be deleted
657: --
658: /*Bug 9315998 Begin */
659: If g_att_cached = FALSE then
660: select pba.defined_balance_id

Line 721: from pay_balance_validation pbv

717: delete /*+ INDEX(prb PAY_RUN_BALANCES_N1) */
718: from pay_run_balances prb
719: where prb.assignment_id = p_asg_id
720: and exists (select ''
721: from pay_balance_validation pbv
722: where pbv.defined_balance_id = prb.defined_balance_id
723: and pbv.business_group_id = p_bus_grp
724: and prb.effective_date < greatest(nvl(pbv.balance_load_date,
725: to_date('0001/01/01 00:00:00',

Line 750: from pay_balance_validation

746: select balance_load_date,
747: run_balance_status
748: into l_bal_load_date,
749: l_run_bal_status
750: from pay_balance_validation
751: where defined_balance_id = g_def_bal_id
752: and business_group_id = p_bus_grp;
753: --
754: exception

Line 929: from pay_balance_validation pbv

925: --
926: delete from pay_run_balances prb
927: where prb.payroll_action_id = p_pactid
928: and exists (select ''
929: from pay_balance_validation pbv
930: where pbv.defined_balance_id =
931: prb.defined_balance_id
932: and pbv.run_balance_status = 'P'
933: and pbv.business_group_id = p_bus_grp);

Line 1042: from pay_balance_validation pbv

1038: --
1039: delete from pay_run_balances prb
1040: where prb.payroll_action_id = p_pactid
1041: and exists (select ''
1042: from pay_balance_validation pbv
1043: where pbv.defined_balance_id = prb.defined_balance_id
1044: and pbv.run_balance_status = 'P'
1045: and pbv.business_group_id = p_bus_grp);
1046: hr_utility.trace('calculate_full_grp_balances2. Delete by pact . p_pactid:'||p_pactid|| ' cnt:'||sql%rowcount);

Line 1085: l_run_bal_status pay_balance_validation.run_balance_status%type;

1081: procedure process_group_lvl_balances( p_pactid in number)
1082: is
1083: l_grp_eff_date date;
1084: l_bus_grp pay_payroll_actions.business_group_id%type;
1085: l_run_bal_status pay_balance_validation.run_balance_status%type;
1086: l_bal_load_date pay_balance_validation.balance_load_date%type;
1087: l_leg_code per_business_groups.legislation_code%type;
1088: l_del_cnt number;
1089: begin

Line 1086: l_bal_load_date pay_balance_validation.balance_load_date%type;

1082: is
1083: l_grp_eff_date date;
1084: l_bus_grp pay_payroll_actions.business_group_id%type;
1085: l_run_bal_status pay_balance_validation.run_balance_status%type;
1086: l_bal_load_date pay_balance_validation.balance_load_date%type;
1087: l_leg_code per_business_groups.legislation_code%type;
1088: l_del_cnt number;
1089: begin
1090: --

Line 1123: and exists (select /+ INDEX(pbv PAY_BALANCE_VALIDATION_UK1) / ''

1119: --
1120: delete /*+ INDEX(prb PAY_RUN_BALANCES_N4) */
1121: from pay_run_balances prb
1122: where prb.payroll_action_id = p_pactid
1123: and exists (select /*+ INDEX(pbv PAY_BALANCE_VALIDATION_UK1) */ ''
1124: from pay_balance_validation pbv
1125: where pbv.defined_balance_id = prb.defined_balance_id
1126: and pbv.run_balance_status = 'P'
1127: and pbv.business_group_id = l_bus_grp);

Line 1124: from pay_balance_validation pbv

1120: delete /*+ INDEX(prb PAY_RUN_BALANCES_N4) */
1121: from pay_run_balances prb
1122: where prb.payroll_action_id = p_pactid
1123: and exists (select /*+ INDEX(pbv PAY_BALANCE_VALIDATION_UK1) */ ''
1124: from pay_balance_validation pbv
1125: where pbv.defined_balance_id = prb.defined_balance_id
1126: and pbv.run_balance_status = 'P'
1127: and pbv.business_group_id = l_bus_grp);
1128: if g_debug then

Line 1172: from pay_balance_validation pbv

1168: delete /*+ INDEX(prb PAY_RUN_BALANCES_N4) */
1169: from pay_run_balances prb
1170: where prb.payroll_action_id = p_pactid
1171: and exists (select ''
1172: from pay_balance_validation pbv
1173: where pbv.defined_balance_id = prb.defined_balance_id
1174: and pbv.business_group_id = l_bus_grp
1175: and prb.effective_date < greatest(nvl(pbv.balance_load_date,
1176: to_date('0001/01/01 00:00:00',

Line 1203: from pay_balance_validation

1199: select balance_load_date,
1200: run_balance_status
1201: into l_bal_load_date,
1202: l_run_bal_status
1203: from pay_balance_validation
1204: where defined_balance_id = g_def_bal_id
1205: and business_group_id = l_bus_grp;
1206: --
1207: exception

Line 1406: from pay_balance_validation pbv

1402: )
1403: and ( p_bal_list <> 'INVALID'
1404: or ( p_bal_list = 'INVALID'
1405: and exists (select ''
1406: from pay_balance_validation pbv
1407: where pbv.defined_balance_id = pdb.defined_balance_id
1408: and pbv.business_group_id = p_bus_grp_id
1409: and pbv.run_balance_status = 'P')
1410: )

Line 1435: from pay_balance_validation pbv

1431: and pdb.balance_type_id = pbt.balance_type_id
1432: and ( p_bal_list <> 'INVALID'
1433: or ( p_bal_list = 'INVALID'
1434: and exists (select ''
1435: from pay_balance_validation pbv
1436: where pbv.defined_balance_id = pdb.defined_balance_id
1437: and pbv.business_group_id = p_bus_grp_id
1438: and pbv.run_balance_status = 'P')
1439: )

Line 1828: l_run_bal_stat pay_balance_validation.run_balance_status%type;

1824: procedure action_archinit(p_payroll_action_id in number) is
1825: --
1826: l_timeout_sec number;
1827: current_time date;
1828: l_run_bal_stat pay_balance_validation.run_balance_status%type;
1829: l_bus_grp pay_payroll_actions.business_group_id%type;
1830: l_request_id fnd_concurrent_requests.request_id%type;
1831: l_old_balance_load_date pay_balance_validation.balance_load_date%type;
1832: l_parm_purge_only varchar2(1);

Line 1831: l_old_balance_load_date pay_balance_validation.balance_load_date%type;

1827: current_time date;
1828: l_run_bal_stat pay_balance_validation.run_balance_status%type;
1829: l_bus_grp pay_payroll_actions.business_group_id%type;
1830: l_request_id fnd_concurrent_requests.request_id%type;
1831: l_old_balance_load_date pay_balance_validation.balance_load_date%type;
1832: l_parm_purge_only varchar2(1);
1833: --
1834: begin
1835: --

Line 1903: from pay_balance_validation bv

1899: pay_balance_attributes ba
1900: where bad.attribute_name = g_att_name
1901: and bad.ATTRIBUTE_ID = ba.ATTRIBUTE_ID
1902: and ba.defined_balance_id = bv.defined_balance_id) balance_status
1903: from pay_balance_validation bv
1904: where bv.business_group_id = l_bus_grp) bv2;
1905: if g_debug then --{
1906: hr_utility.trace('set_run_bal_status store g_old_balance_validation_tab. '|| g_old_balance_validation_tab.count);
1907: end if; --}