APPS.PAY_AU_PAYMENT_SUMMARY dependencies on REC_AU_EOY_BAL_TYPE

Line 3359: --create or replace type rec_au_eoy_bal_type is object (balance_name varchar2(80), balance_value number);

3355: p_fw_allowance_tab tab_allownace_balance;
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;

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 3836: t_union_bal_sort(t_union_bal_sort.last) := rec_au_eoy_bal_type(p_fw_union_tab(ix).balance_name

3832: ix := p_fw_union_tab.first;
3833: loop
3834: exit when ix is null;
3835: t_union_bal_sort.extend;
3836: t_union_bal_sort(t_union_bal_sort.last) := rec_au_eoy_bal_type(p_fw_union_tab(ix).balance_name
3837: , p_fw_union_tab(ix).balance_value);
3838: ix := p_fw_union_tab.next(ix);
3839: end loop;
3840:

Line 3841: SELECT CAST (MULTISET (SELECT rec_au_eoy_bal_type(balance_name, balance_value)

3837: , p_fw_union_tab(ix).balance_value);
3838: ix := p_fw_union_tab.next(ix);
3839: end loop;
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

Line 4004: t_alw_bal_sort(t_alw_bal_sort.last) := rec_au_eoy_bal_type(p_fw_allowance_tab(idx).balance_name

4000: idx := p_fw_allowance_tab.first;
4001: loop
4002: exit when idx is null;
4003: t_alw_bal_sort.extend;
4004: t_alw_bal_sort(t_alw_bal_sort.last) := rec_au_eoy_bal_type(p_fw_allowance_tab(idx).balance_name
4005: , p_fw_allowance_tab(idx).balance_value);
4006: idx := p_fw_allowance_tab.next(idx);
4007: end loop;
4008:

Line 4009: SELECT CAST (MULTISET (SELECT rec_au_eoy_bal_type(balance_name, balance_value)

4005: , p_fw_allowance_tab(idx).balance_value);
4006: idx := p_fw_allowance_tab.next(idx);
4007: end loop;
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

Line 4320: t_alw_bal_sort(t_alw_bal_sort.last) := rec_au_eoy_bal_type(t_allowance_balance(idx).balance_name

4316: idx := t_allowance_balance.first;
4317: loop
4318: exit when idx is null;
4319: t_alw_bal_sort.extend;
4320: t_alw_bal_sort(t_alw_bal_sort.last) := rec_au_eoy_bal_type(t_allowance_balance(idx).balance_name
4321: , t_allowance_balance(idx).balance_value);
4322: idx := t_allowance_balance.next(idx);
4323: end loop;
4324:

Line 4325: SELECT CAST (MULTISET (SELECT rec_au_eoy_bal_type(balance_name, balance_value)

4321: , t_allowance_balance(idx).balance_value);
4322: idx := t_allowance_balance.next(idx);
4323: end loop;
4324:
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)

Line 4747: t_union_bal_sort(t_union_bal_sort.last) := rec_au_eoy_bal_type(t_union_table(idx).balance_name

4743: idx := t_union_table.first;
4744: loop
4745: exit when idx is null;
4746: t_union_bal_sort.extend;
4747: t_union_bal_sort(t_union_bal_sort.last) := rec_au_eoy_bal_type(t_union_table(idx).balance_name
4748: , t_union_table(idx).balance_value);
4749: idx := t_union_table.next(idx);
4750: end loop;
4751:

Line 4752: SELECT CAST (MULTISET (SELECT rec_au_eoy_bal_type(balance_name, balance_value)

4748: , t_union_table(idx).balance_value);
4749: idx := t_union_table.next(idx);
4750: end loop;
4751:
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)