APPS.IEX_STRY_API_PUB dependencies on DBMS_SQL

Line 885: P_WORK_ITEM_ID_TBL IN DBMS_SQL.NUMBER_TABLE,

881: P_VALIDATION_LEVEL IN NUMBER,
882: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
883: X_MSG_COUNT OUT NOCOPY NUMBER,
884: X_MSG_DATA OUT NOCOPY VARCHAR2,
885: P_WORK_ITEM_ID_TBL IN DBMS_SQL.NUMBER_TABLE,
886: P_UWQ_STATUS IN VARCHAR2,
887: P_NO_DAYS IN NUMBER)
888: IS
889: l_api_name CONSTANT VARCHAR2(30) := 'SHOW_IN_UWQ';

Line 904: l_broken_promises DBMS_SQL.NUMBER_TABLE;

900:
901: Type refCur is Ref Cursor;
902: l_cursor refCur;
903: l_SQL VARCHAR2(10000);
904: l_broken_promises DBMS_SQL.NUMBER_TABLE;
905: i number;
906: j number;
907: l_uwq_active_date date;
908: l_uwq_complete_date date;