APPS.PV_OPP_MATCH_PUB dependencies on PV_TIE_BREAKING_TBL

Line 38: create or replace type apps.PV_TIE_BREAKING_TBL as table of system.PV_TIE_BREAKING_TYPE;

34:
35: grant all on pv_tie_breaking_type to apps;
36:
37: connect apps...
38: create or replace type apps.PV_TIE_BREAKING_TBL as table of system.PV_TIE_BREAKING_TYPE;
39: */
40:
41:
42:

Line 2051: l_tie_breaking_tab PV_TIE_BREAKING_TBL := PV_TIE_BREAKING_TBL();

2047: IS
2048:
2049: l_api_version NUMBER := 1.0;
2050: l_api_name VARCHAR2(30) := 'Tie_Breaker';
2051: l_tie_breaking_tab PV_TIE_BREAKING_TBL := PV_TIE_BREAKING_TBL();
2052: l_sql_string VARCHAR2(10000);
2053: l_index NUMBER;
2054: l_last_index NUMBER;
2055: l_comma VARCHAR2(1) := ',';

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

2338: SELECT *
2339: INTO l_dup_count
2340: FROM (
2341: SELECT COUNT(*)
2342: FROM THE (SELECT CAST(l_tie_breaking_tab AS PV_TIE_BREAKING_TBL)
2343: FROM dual) a
2344: WHERE ROWNUM < 2
2345: GROUP BY concat_value_str
2346: HAVING COUNT(*) > 1) b;

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

2390: l_index := 1;
2391:
2392: FOR x IN (
2393: SELECT *
2394: FROM THE (SELECT CAST(l_tie_breaking_tab AS PV_TIE_BREAKING_TBL)
2395: FROM dual) a
2396: ORDER BY concat_value_str DESC)
2397: LOOP
2398: x_partner_tbl(l_index) := x.party_id;

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

2409: -- attributes come up with NULL values).
2410: -- ------------------------------------------------------------
2411: FOR x IN (
2412: SELECT *
2413: FROM THE (SELECT CAST(l_tie_breaking_tab AS PV_TIE_BREAKING_TBL)
2414: FROM dual) a
2415: ORDER BY concat_value_str DESC, idx ASC)
2416: LOOP
2417: x_partner_tbl(l_index) := x.party_id;