[Home] [Help]
4: --
5: /* Setup Glabals */
6: --
7: g_timeout date;
8: g_def_bal_id pay_defined_balances.defined_balance_id%type;
9: g_bal_lvl pay_balance_dimensions.dimension_level%type;
10: g_proc_mode varchar2(30);
11: g_load_type varchar2(30);
12: g_save_run_bals pay_legislation_rules.rule_mode%type;
21: g_purge_only boolean default FALSE;
22: g_program_name fnd_concurrent_programs.concurrent_program_name%type;
23: g_generate_pact pay_payroll_actions.payroll_action_id%type;
24:
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,
114: 'BOTH') balance_level,
115: pbd.dimension_level
116: from pay_payroll_actions ppa,
117: per_business_groups pbg,
118: pay_defined_balances pdb,
119: pay_balance_dimensions pbd
120: where ppa.payroll_action_id = p_pact_id
121: and ppa.business_group_id = pbg.business_group_id
122: and ((pdb.business_group_id = pbg.business_group_id
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,
164: pay_defined_balances db
165: where db.defined_balance_id = bv.defined_balance_id
166: and bd.balance_dimension_id = db.balance_dimension_id
167: and bd.dimension_type = 'R'
168: and bd.DIMENSION_LEVEL in ('ASG','GRP'));
206: if (g_load_type <> 'DELTA') then
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;
250: --
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;
362: -- Override the balance level for a single balance load
363: --
364: select nvl(pbd.dimension_level, 'ASG')
365: into g_bal_lvl
366: from pay_defined_balances pdb,
367: pay_balance_dimensions pbd
368: where pdb.defined_balance_id = g_def_bal_id
369: and pdb.balance_dimension_id = pbd.balance_dimension_id;
370: --
390: p_chunk_number in number
391: )
392: is
393: --
394: type t_def_bal_id is table of pay_defined_balances.defined_balance_id%type
395: index by binary_integer;
396: --
397: l_delete_bals boolean;
398: l_def_bal_list pay_balance_pkg.t_balance_value_tab;
857: p_bal_load_date in date
858: )
859: is
860: --
861: type t_def_bal_id is table of pay_defined_balances.defined_balance_id%type
862: index by binary_integer;
863: --
864: l_delete_bals boolean;
865: l_def_bal_list pay_balance_pkg.t_balance_value_tab;
1383: select
1384: pdb.defined_balance_id
1385: from
1386: pay_balance_types pbt,
1387: pay_defined_balances pdb,
1388: pay_balance_dimensions pbd
1389: where pbd.dimension_level = 'GRP'
1390: and pdb.save_run_balance = 'Y'
1391: and pbd.dimension_type = 'R'
1421: select
1422: pdb.defined_balance_id
1423: from
1424: pay_balance_types pbt,
1425: pay_defined_balances pdb,
1426: pay_balance_dimensions pbd
1427: where pbd.dimension_level = 'ASG'
1428: and pdb.save_run_balance = 'Y'
1429: and pbd.dimension_type = 'R'