APPS.PAY_AU_PAYMENT_SUMMARY dependencies on TAB_AU_EOY_BAL_TYPE

Line 3360: --create or replace type tab_au_eoy_bal_type is table of rec_au_eoy_bal_type ;

3356: p_fw_union_tab tab_allownace_balance;
3357:
3358:
3359: --create or replace type rec_au_eoy_bal_type is object (balance_name varchar2(80), balance_value number);
3360: --create or replace type tab_au_eoy_bal_type is table of rec_au_eoy_bal_type ;
3361: t_alw_bal_sort tab_au_eoy_bal_type := tab_au_eoy_bal_type();
3362: cnt number;
3363: idx number;
3364: t_union_bal_sort tab_au_eoy_bal_type := tab_au_eoy_bal_type();

Line 3361: t_alw_bal_sort tab_au_eoy_bal_type := tab_au_eoy_bal_type();

3357:
3358:
3359: --create or replace type rec_au_eoy_bal_type is object (balance_name varchar2(80), balance_value number);
3360: --create or replace type tab_au_eoy_bal_type is table of rec_au_eoy_bal_type ;
3361: t_alw_bal_sort tab_au_eoy_bal_type := tab_au_eoy_bal_type();
3362: cnt number;
3363: idx number;
3364: t_union_bal_sort tab_au_eoy_bal_type := tab_au_eoy_bal_type();
3365: counter number;

Line 3364: t_union_bal_sort tab_au_eoy_bal_type := tab_au_eoy_bal_type();

3360: --create or replace type tab_au_eoy_bal_type is table of rec_au_eoy_bal_type ;
3361: t_alw_bal_sort tab_au_eoy_bal_type := tab_au_eoy_bal_type();
3362: cnt number;
3363: idx number;
3364: t_union_bal_sort tab_au_eoy_bal_type := tab_au_eoy_bal_type();
3365: counter number;
3366: ix number;
3367: l_reporting_name pay_element_types_f.reporting_name%type;
3368: l_2006_union_setup_found boolean := false;

Line 3844: AS tab_au_eoy_bal_type)

3840:
3841: SELECT CAST (MULTISET (SELECT rec_au_eoy_bal_type(balance_name, balance_value)
3842: FROM TABLE(t_union_bal_sort)
3843: ORDER BY balance_value desc)
3844: AS tab_au_eoy_bal_type)
3845: INTO t_union_bal_sort
3846: FROM dual;
3847:
3848: if g_debug then

Line 4012: AS tab_au_eoy_bal_type)

4008:
4009: SELECT CAST (MULTISET (SELECT rec_au_eoy_bal_type(balance_name, balance_value)
4010: FROM TABLE(t_alw_bal_sort)
4011: ORDER BY balance_value desc)
4012: AS tab_au_eoy_bal_type)
4013: INTO t_alw_bal_sort
4014: FROM dual;
4015:
4016:

Line 4227: t_alw_bal_sort tab_au_eoy_bal_type := tab_au_eoy_bal_type(); /*bug9147430*/

4223: counter number := 1;
4224: i number;
4225: t_allowance_2006 tab_allownace_balance;
4226: idx number; /*bug9147430*/
4227: t_alw_bal_sort tab_au_eoy_bal_type := tab_au_eoy_bal_type(); /*bug9147430*/
4228: --
4229: begin
4230: if g_debug then
4231: hr_utility.set_location(l_procedure, 1);

Line 4329: AS tab_au_eoy_bal_type)

4325: SELECT CAST (MULTISET (SELECT rec_au_eoy_bal_type(balance_name, balance_value)
4326: FROM TABLE(t_alw_bal_sort)
4327: WHERE balance_value > 0
4328: ORDER BY balance_value desc)
4329: AS tab_au_eoy_bal_type)
4330: INTO t_alw_bal_sort
4331: FROM dual;
4332:
4333: hr_utility.trace('After FW Allowance Sorting');

Line 4687: t_union_bal_sort tab_au_eoy_bal_type := tab_au_eoy_bal_type(); /*bug9147430*/

4683: l_4_name pay_balance_types.balance_name%type;
4684: l_total_value number := 0;
4685: l_balance_type pay_balance_types.balance_type_id%type;
4686: idx number; /*bug9147430*/
4687: t_union_bal_sort tab_au_eoy_bal_type := tab_au_eoy_bal_type(); /*bug9147430*/
4688:
4689: begin
4690: g_debug := hr_utility.debug_enabled;
4691: --

Line 4756: AS tab_au_eoy_bal_type)

4752: SELECT CAST (MULTISET (SELECT rec_au_eoy_bal_type(balance_name, balance_value)
4753: FROM TABLE(t_union_bal_sort)
4754: WHERE balance_value > 0
4755: ORDER BY balance_value desc)
4756: AS tab_au_eoy_bal_type)
4757: INTO t_union_bal_sort
4758: FROM dual;
4759:
4760: hr_utility.trace('After FW Union Sorting');