APPS.IEX_DELINQUENCY_PUB dependencies on DBMS_SQL

Line 2188: P_DELINQUENCY_ID_TBL IN DBMS_SQL.NUMBER_TABLE,

2184: P_VALIDATION_LEVEL IN NUMBER,
2185: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2186: X_MSG_COUNT OUT NOCOPY NUMBER,
2187: X_MSG_DATA OUT NOCOPY VARCHAR2,
2188: P_DELINQUENCY_ID_TBL IN DBMS_SQL.NUMBER_TABLE,
2189: P_UWQ_STATUS IN VARCHAR2,
2190: P_NO_DAYS IN NUMBER)
2191: IS
2192: l_api_name CONSTANT VARCHAR2(30) := 'SHOW_IN_UWQ';

Line 2207: l_broken_promises DBMS_SQL.NUMBER_TABLE;

2203:
2204: Type refCur is Ref Cursor;
2205: l_cursor refCur;
2206: l_SQL VARCHAR2(10000);
2207: l_broken_promises DBMS_SQL.NUMBER_TABLE;
2208: i number;
2209: j number;
2210: l_uwq_active_date date;
2211: l_uwq_complete_date date;