[Home] [Help]
89: g_feed_feed_tab FND_TABLE_OF_NUMBER;
90:
91: type t_feed_rec is record
92: (input_value_id pay_balance_feeds_f.input_value_id%type,
93: element_type_id pay_input_values_f.element_type_id%type,
94: effective_start_date pay_balance_feeds_f.effective_start_date%type,
95: effective_end_date pay_balance_feeds_f.effective_end_date%type,
96: scale pay_balance_feeds_f.scale%type
97: );
358: g_con_source_number2 pay_latest_balances.source_number2%type;
359:
360: type t_inp_value is record
361: (
362: rv_input_name pay_input_values_f.name%type,
363: rv_input_value pay_run_result_values.result_value%type
364: );
365:
366: Type typ_inp_value is table of t_inp_value index by binary_integer;
6363:
6364: l_ivchk varchar2(2);
6365: l_rrv_found number := -1;
6366: l_ora_db_vers number;
6367: l_element_type_id pay_input_values_f.element_type_id%type;
6368: --
6369: BEGIN
6370: g_debug := hr_utility.debug_enabled;
6371: if g_debug then
6386:
6387: if l_rrv_found = 1 then --{ result exists for this input
6388:
6389: select distinct element_type_id into l_element_type_id
6390: from pay_input_values_f
6391: where input_value_id = p_input_value_id;
6392:
6393: -- bug 14007061 balance initialized from sot but not generated
6394: update pay_balance_validation bv set run_balance_status = 'I'
6592: p_ele_id in number,
6593: p_effdate in date) is
6594: select piv.name,prrv.result_value
6595: from pay_run_result_values prrv,
6596: pay_input_values_f piv
6597: where prrv.run_result_id = p_rr_id
6598: and piv.input_value_id = prrv.input_value_id
6599: and piv.element_type_id = p_ele_id
6600: and p_effdate between piv.effective_start_date
6601: and piv.effective_end_date;
6602: --
6603: cnt_value pay_run_result_values.result_value%type;
6604: l_rr_rec t_run_result_rec;
6605: l_inp_val_name pay_input_values_f.name%type;
6606: l_found boolean;
6607:
6608:
6609: --
7111: l_eff_date date;
7112: l_asg_def_bal_id number;
7113: l_found boolean;
7114: l_asgbal_cnt number;
7115: l_inp_val_name pay_input_values_f.name%type;
7116: --
7117: BEGIN
7118: g_debug := hr_utility.debug_enabled;
7119: if g_debug then
7844: select
7845: /*+ ORDERED USE_NL(pbf, pdb, pbd, prrv) */
7846: distinct pdb.defined_balance_id
7847: from
7848: pay_input_values_f piv
7849: ,pay_balance_feeds_f pbf
7850: ,pay_defined_balances pdb
7851: ,pay_balance_dimensions pbd
7852: ,pay_run_result_values prrv
8116: l_org_needed_chr varchar2(10);
8117: l_context_lst t_context_tab;
8118: l_cnt number;
8119: l_output_list t_detailed_bal_out_tab;
8120: l_inp_val_name pay_input_values_f.name%type;
8121: l_found boolean;
8122: --
8123: begin
8124: --
8618: pbd.balance_dimension_id
8619: from
8620: pay_assignment_actions paa,
8621: pay_run_results prr,
8622: pay_input_values_f piv,
8623: pay_balance_feeds_f pbf,
8624: pay_balance_types pbt,
8625: pay_defined_balances pdb,
8626: pay_balance_dimensions pbd,
8854: l_org_needed_chr pay_legislation_rules.rule_mode%type;
8855: l_context_lst t_context_tab;
8856: l_cnt number;
8857: l_output_list t_detailed_bal_out_tab;
8858: l_inp_val_name pay_input_values_f.name%type;
8859: l_found boolean;
8860: l_next_free number;
8861: l_bg_id per_business_groups.business_group_id%type;
8862: l_leg_code per_business_groups.legislation_code%type;
9652: pdb.balance_type_id,
9653: pdb.balance_dimension_id
9654: from
9655: pay_run_results prr,
9656: pay_input_values_f piv,
9657: pay_balance_feeds_f pbf,
9658: pay_defined_balances pdb,
9659: pay_balance_attributes pba,
9660: pay_balance_dimensions pbd,
9761: l_org_needed_chr pay_legislation_rules.rule_mode%type;
9762: l_context_lst t_context_tab;
9763: l_cnt number;
9764: l_output_list t_detailed_bal_out_tab;
9765: l_inp_val_name pay_input_values_f.name%type;
9766: l_found boolean;
9767: l_next_free number;
9768: l_bg_id per_business_groups.business_group_id%type;
9769: l_leg_code per_business_groups.legislation_code%type;
10350: l_st2_needed_chr varchar2(10);
10351: l_context_lst t_context_tab;
10352: l_cnt number;
10353: l_output_list t_detailed_bal_out_tab;
10354: l_inp_val_name pay_input_values_f.name%type;
10355: l_found boolean;
10356: --
10357: begin
10358: --
11047: l_sn_needed pay_legislation_rules.rule_mode%type;
11048: l_sn2_needed pay_legislation_rules.rule_mode%type;
11049: l_org_needed pay_legislation_rules.rule_mode%type;
11050: l_st2_needed pay_legislation_rules.rule_mode%type;
11051: l_inp_val_name pay_input_values_f.name%type;
11052: l_asg_id number;
11053: l_pactid number;
11054: l_eff_date date;
11055: l_act_type pay_payroll_actions.action_type%type;
11408: cursor csr_feed(p_balance_type_id number , p_business_group_id number, p_from_date date ) is
11409:
11410: select distinct f.input_value_id , i.element_type_id, f.effective_start_date, f.effective_end_date,
11411: f.scale
11412: from pay_balance_feeds_f f, pay_input_values_f i
11413: where f.balance_type_id = p_balance_type_id
11414: and (f.business_group_id is null or f.business_group_id = p_business_group_id)
11415: and f.effective_end_date >= p_from_date
11416: and i.input_value_id = f.input_value_id
11481: close csr_feed;
11482:
11483: select distinct f.input_value_id , i.element_type_id, f.balance_feed_id
11484: bulk collect into g_feed_input_tab, g_feed_element_tab, g_feed_feed_tab
11485: from pay_balance_feeds_f f, pay_input_values_f i
11486: where f.balance_type_id = g_balance_type_id
11487: and (f.business_group_id is null or f.business_group_id = p_business_group_id)
11488: and f.effective_end_date >= p_from_date
11489: and i.input_value_id = f.input_value_id
11705: cursor csr_feed(p_balance_type_id number , p_business_group_id number, p_from_date date ) is
11706:
11707: select distinct f.input_value_id , i.element_type_id, f.effective_start_date, f.effective_end_date,
11708: f.scale
11709: from pay_balance_feeds_f f, pay_input_values_f i
11710: where f.balance_type_id = p_balance_type_id
11711: and (f.business_group_id is null or f.business_group_id = p_business_group_id)
11712: and f.effective_end_date >= p_from_date
11713: and i.input_value_id = f.input_value_id
11782: close csr_feed;
11783:
11784: select distinct f.input_value_id , i.element_type_id, f.balance_feed_id
11785: bulk collect into g_feed_input_tab, g_feed_element_tab, g_feed_feed_tab
11786: from pay_balance_feeds_f f, pay_input_values_f i
11787: where f.balance_type_id = g_balance_type_id
11788: and (f.business_group_id is null or f.business_group_id = p_business_group_id)
11789: and f.effective_end_date >= p_from_date
11790: and i.input_value_id = f.input_value_id