APPS.IEX_SCORE_NEW_PVT dependencies on IEX_UTILITIES

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

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

Line 1368: l_conditions IEX_UTILITIES.Condition_Tbl;

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

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

1480:
1481: -- Added by Surya
1482: if l_conditions.COUNT >= 1 then
1483:
1484: vPLSQL2 := IEX_UTILITIES.buildWhereClause(l_conditions);
1485:
1486: If NVL(p_truncate,'Y') = 'N' then -- fix a bug 5765878 to truncate table to perform better by Ehuh 2.19.2007
1487: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Delete Filter Applied => '|| vPLSQL2);
1488: end if;

Line 1661: l_conditions IEX_UTILITIES.Condition_Tbl;

1657: j NUMBER ;
1658: l_object_code VARCHAR2(50);
1659: Type refCur is Ref Cursor;
1660: sql_cur refCur;
1661: l_conditions IEX_UTILITIES.Condition_Tbl;
1662:
1663: --clchang updated for sql bind var 05/07/2003
1664: vstr1 varchar2(100) ;
1665: vstr2 varchar2(100) ;

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

1712: l_conditions(i).Col_Name := 'SCORE_ID';
1713: l_conditions(i).Condition := '=';
1714: l_conditions(i).Value := P_SCORE_ID;
1715: end if;
1716: vPLSQL := IEX_UTILITIES.buildWhereClause(l_conditions);
1717:
1718: -- IF PG_DEBUG < 10 THEN
1719: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1720: IEX_DEBUG_PUB.logMessage(vPLSQL);