DBA Data[Home] [Help]

APPS.IEX_DELINQUENCY_PUB dependencies on DBMS_SQL

Line 2265: P_DELINQUENCY_ID_TBL IN DBMS_SQL.NUMBER_TABLE,

2261: P_VALIDATION_LEVEL IN NUMBER,
2262: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2263: X_MSG_COUNT OUT NOCOPY NUMBER,
2264: X_MSG_DATA OUT NOCOPY VARCHAR2,
2265: P_DELINQUENCY_ID_TBL IN DBMS_SQL.NUMBER_TABLE,
2266: P_UWQ_STATUS IN VARCHAR2,
2267: P_NO_DAYS IN NUMBER)
2268: IS
2269: l_api_name CONSTANT VARCHAR2(30) := 'SHOW_IN_UWQ';

Line 2284: l_broken_promises DBMS_SQL.NUMBER_TABLE;

2280:
2281: Type refCur is Ref Cursor;
2282: l_cursor refCur;
2283: l_SQL VARCHAR2(10000);
2284: l_broken_promises DBMS_SQL.NUMBER_TABLE;
2285: i number;
2286: j number;
2287: l_uwq_active_date date;
2288: l_uwq_complete_date date;