APPS.PV_MATCH_V3_PUB dependencies on PV_TIE_BREAKING_TBL

Line 2473: l_tie_breaking_tab PV_TIE_BREAKING_TBL := PV_TIE_BREAKING_TBL();

2469: IS
2470:
2471: l_api_version NUMBER := 1.0;
2472: l_api_name VARCHAR2(30) := 'Tie_Breaker';
2473: l_tie_breaking_tab PV_TIE_BREAKING_TBL := PV_TIE_BREAKING_TBL();
2474: l_sql_string VARCHAR2(10000);
2475: l_index NUMBER;
2476: l_last_index NUMBER;
2477: l_comma VARCHAR2(1) := ',';

Line 2776: FROM THE (SELECT CAST(l_tie_breaking_tab AS PV_TIE_BREAKING_TBL)

2772: SELECT *
2773: INTO l_dup_count
2774: FROM (
2775: SELECT COUNT(*)
2776: FROM THE (SELECT CAST(l_tie_breaking_tab AS PV_TIE_BREAKING_TBL)
2777: FROM dual) a
2778: WHERE ROWNUM < 2
2779: GROUP BY concat_value_str
2780: HAVING COUNT(*) > 1) b;

Line 2828: FROM THE (SELECT CAST(l_tie_breaking_tab AS PV_TIE_BREAKING_TBL)

2824: l_index := 1;
2825:
2826: FOR x IN (
2827: SELECT *
2828: FROM THE (SELECT CAST(l_tie_breaking_tab AS PV_TIE_BREAKING_TBL)
2829: FROM dual) a
2830: ORDER BY concat_value_str DESC)
2831: LOOP
2832: x_partner_tbl(l_index) := x.party_id;

Line 2847: FROM THE (SELECT CAST(l_tie_breaking_tab AS PV_TIE_BREAKING_TBL)

2843: -- attributes come up with NULL values).
2844: -- ------------------------------------------------------------
2845: FOR x IN (
2846: SELECT *
2847: FROM THE (SELECT CAST(l_tie_breaking_tab AS PV_TIE_BREAKING_TBL)
2848: FROM dual) a
2849: ORDER BY concat_value_str DESC, idx ASC)
2850: LOOP
2851: x_partner_tbl(l_index) := x.party_id;