APPS.IEX_SCORE_NEW_PVT dependencies on IEX_UTILITIES

Line 76: iex_utilities.validate_any_id(p_col_id => p_object_id,

72: end;
73: end if;
74:
75: -- see if the ID passed is OK on the FROM_TABLE/SELECT_ID
76: iex_utilities.validate_any_id(p_col_id => p_object_id,
77: p_col_name => l_col_name,
78: p_table_name => l_table_name,
79: x_msg_count => l_msg_count,
80: x_msg_data => l_msg_data,

Line 1981: l_conditions IEX_UTILITIES.Condition_Tbl;

1977: j NUMBER ;
1978: l_object_code VARCHAR2(50);
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

Line 2112: vPLSQL2 := IEX_UTILITIES.buildWhereClause(l_conditions);

2108: -- end for bug 13335079
2109: -- Added by Surya
2110: if l_conditions.COUNT >= 1 then
2111:
2112: vPLSQL2 := IEX_UTILITIES.buildWhereClause(l_conditions);
2113:
2114: If NVL(p_truncate,'Y') = 'N' then -- fix a bug 5765878 to truncate table to perform better by Ehuh 2.19.2007
2115: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Delete Filter Applied => '|| vPLSQL2);
2116: end if;

Line 2336: l_conditions IEX_UTILITIES.Condition_Tbl;

2332: j NUMBER ;
2333: l_object_code VARCHAR2(50);
2334: Type refCur is Ref Cursor;
2335: sql_cur refCur;
2336: l_conditions IEX_UTILITIES.Condition_Tbl;
2337:
2338: --clchang updated for sql bind var 05/07/2003
2339: vstr1 varchar2(100) ;
2340: vstr2 varchar2(100) ;

Line 2391: vPLSQL := IEX_UTILITIES.buildWhereClause(l_conditions);

2387: l_conditions(i).Col_Name := 'SCORE_ID';
2388: l_conditions(i).Condition := '=';
2389: l_conditions(i).Value := P_SCORE_ID;
2390: end if;
2391: vPLSQL := IEX_UTILITIES.buildWhereClause(l_conditions);
2392:
2393: -- IF PG_DEBUG < 10 THEN
2394: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2395: IEX_DEBUG_PUB.logMessage(vPLSQL);