DBA Data[Home] [Help]

APPS.IEX_SCORE_NEW_PVT dependencies on IEX_FILTER_PUB

Line 368: t_object_ids IN IEX_FILTER_PUB.UNIVERSE_IDS,

364: || 11/02/04 acaraujo x_scores_tbl returns the bridge to the next concurrent prog.
365: || and scores are store as per the G_BATCH_SIZE to the history table
366: */
367: procedure getScores(p_score_comp_tbl IN IEX_SCORE_NEW_PVT.SCORE_ENG_COMP_TBL,
368: t_object_ids IN IEX_FILTER_PUB.UNIVERSE_IDS,
369: x_scores_tbl OUT NOCOPY IEX_SCORE_NEW_PVT.SCORES_TBL)
370: IS
371:
372: l_api_name varchar2(10) ;

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

755: l_msg_count NUMBER;
756: l_msg_data VARCHAR2(32767);
757:
758: --vPLSQL varchar2(5000);
759: l_universe IEX_FILTER_PUB.UNIVERSE_IDS; -- for TestUniverse / testGetScores
760: l_components_tbl IEX_SCORE_NEW_PVT.SCORE_ENG_COMP_TBL;-- for testGetComponents / testGetScores
761: l_scores_tbl IEX_SCORE_NEW_PVT.SCORES_TBL; -- fore testGetScores
762: b_valid BOOLEAN;
763: l_object_type VARCHAR2(25);

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

863:
864: -- bug#5586925 score in loop to increase scaleablility
865: l_last_batch := false;
866: while not l_last_batch loop
867: l_universe := iex_filter_pub.buildUniverse(p_object_id => p_score_id,
868: p_object_type => 'IEXSCORE',
869: p_last_object_scored => l_last_obj_scored,
870: x_end_of_universe => l_last_batch);
871:

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

1093: P_SCORE_ID IN NUMBER) RETURN NUMBER
1094:
1095: IS
1096: --vPLSQL varchar2(5000);
1097: l_universe IEX_FILTER_PUB.UNIVERSE_IDS; -- for TestUniverse / testGetScores
1098: l_components_tbl IEX_SCORE_NEW_PVT.SCORE_ENG_COMP_TBL; -- for testGetComponents / testGetScores
1099:
1100: l_scores_tbl IEX_SCORE_NEW_PVT.SCORES_TBL; -- fore testGetScores
1101: l_score_id number ;

Line 1370: l_score_history_ids IEX_FILTER_PUB.UNIVERSE_IDS;

1366: Type refCur is Ref Cursor;
1367: sql_cur refCur;
1368: l_conditions IEX_UTILITIES.Condition_Tbl;
1369: l_msg_data VARCHAR2(1000);
1370: l_score_history_ids IEX_FILTER_PUB.UNIVERSE_IDS;
1371:
1372: -- clchang updated for sql bind var 05/07/2003
1373: vStr1 VARCHAR2(100) ;
1374: vStr2 VARCHAR2(100) ;