APPS.IEX_SCORE_NEW_PVT dependencies on IEX_FILTER_PUB

Line 472: t_object_ids IN IEX_FILTER_PUB.UNIVERSE_IDS,

468: || 11/02/04 acaraujo x_scores_tbl returns the bridge to the next concurrent prog.
469: || and scores are store as per the G_BATCH_SIZE to the history table
470: */
471: procedure getScores(p_score_comp_tbl IN IEX_SCORE_NEW_PVT.SCORE_ENG_COMP_TBL,
472: t_object_ids IN IEX_FILTER_PUB.UNIVERSE_IDS,
473: x_scores_tbl OUT NOCOPY IEX_SCORE_NEW_PVT.SCORES_TBL)
474: IS
475:
476: l_api_name varchar2(10) ;

Line 1011: l_universe IEX_FILTER_PUB.UNIVERSE_IDS; -- for TestUniverse / testGetScores

1007: l_msg_count NUMBER;
1008: l_msg_data VARCHAR2(32767);
1009:
1010: --vPLSQL varchar2(5000);
1011: l_universe IEX_FILTER_PUB.UNIVERSE_IDS; -- for TestUniverse / testGetScores
1012: l_components_tbl IEX_SCORE_NEW_PVT.SCORE_ENG_COMP_TBL;-- for testGetComponents / testGetScores
1013: l_scores_tbl IEX_SCORE_NEW_PVT.SCORES_TBL; -- fore testGetScores
1014: b_valid BOOLEAN;
1015: -- l_object_type VARCHAR2(25);

Line 1271: l_universe := iex_filter_pub.buildUniverse(p_object_id => p_score_id,

1267: -- start for bug 9387044
1268: -- bug#5586925 score in loop to increase scaleablility
1269: /* l_last_batch := false;
1270: while not l_last_batch loop
1271: l_universe := iex_filter_pub.buildUniverse(p_object_id => p_score_id,
1272: p_query_obj_id => p_unv_obj_id, --Added for Bug 8933776 17-Dec-2009 barathsr
1273: p_limit_rows => p_limit_rows_val, --Added for Bug 8933776 17-Dec-2009 barathsr
1274: p_object_type => 'IEXSCORE',
1275: p_last_object_scored => l_last_obj_scored,

Line 1299: vsql := iex_filter_pub.buildsql(p_object_id => p_score_id, p_object_type => 'IEXSCORE',

1295:
1296: l_count := 0;
1297: l_universe_size:=0;
1298: univ_size:=0;
1299: vsql := iex_filter_pub.buildsql(p_object_id => p_score_id, p_object_type => 'IEXSCORE',
1300: p_query_obj_id => p_unv_obj_id, --Added for Bug 9670348 27-May-2009 barathsr
1301: p_limit_rows => p_limit_rows_val);--Added for Bug 9670348 27-May-2009 barathsr
1302:
1303: open universe_cur for vsql;

Line 1567: l_universe IEX_FILTER_PUB.UNIVERSE_IDS; -- for TestUniverse / testGetScores

1563: P_SCORE_ID IN NUMBER) RETURN NUMBER
1564:
1565: IS
1566: --vPLSQL varchar2(5000);
1567: l_universe IEX_FILTER_PUB.UNIVERSE_IDS; -- for TestUniverse / testGetScores
1568: l_components_tbl IEX_SCORE_NEW_PVT.SCORE_ENG_COMP_TBL; -- for testGetComponents / testGetScores
1569:
1570: l_scores_tbl IEX_SCORE_NEW_PVT.SCORES_TBL; -- fore testGetScores
1571: l_score_id number ;

Line 1983: l_score_history_ids IEX_FILTER_PUB.UNIVERSE_IDS;

1979: Type refCur is Ref Cursor;
1980: sql_cur refCur;
1981: l_conditions IEX_UTILITIES.Condition_Tbl;
1982: l_msg_data VARCHAR2(1000);
1983: l_score_history_ids IEX_FILTER_PUB.UNIVERSE_IDS;
1984:
1985: -- clchang updated for sql bind var 05/07/2003
1986: vStr1 VARCHAR2(100) ;
1987: vStr2 VARCHAR2(100) ;