APPS.IEX_PROMISES_PUB dependencies on DBMS_SQL

Line 22: P_PROMISE_TBL IN DBMS_SQL.NUMBER_TABLE,

18: P_VALIDATION_LEVEL IN NUMBER, -- DEFAULT FND_API.G_VALID_LEVEL_FULL,
19: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
20: X_MSG_COUNT OUT NOCOPY NUMBER,
21: X_MSG_DATA OUT NOCOPY VARCHAR2,
22: P_PROMISE_TBL IN DBMS_SQL.NUMBER_TABLE,
23: P_STATUS IN VARCHAR2,
24: P_DAYS IN NUMBER DEFAULT NULL)
25: IS
26: l_api_name CONSTANT VARCHAR2(30) := 'SHOW_IN_UWQ';

Line 40: l_broken_promises DBMS_SQL.NUMBER_TABLE;

36:
37: Type refCur is Ref Cursor;
38: l_cursor refCur;
39: l_SQL VARCHAR2(10000);
40: l_broken_promises DBMS_SQL.NUMBER_TABLE;
41: i number;
42: j number;
43: l_uwq_active_date date;
44: l_uwq_complete_date date;

Line 2308: P_MASS_IDS_TBL IN DBMS_SQL.NUMBER_TABLE,

2304: END;
2305:
2306:
2307: PROCEDURE VALIDATE_MASS_INPUT(
2308: P_MASS_IDS_TBL IN DBMS_SQL.NUMBER_TABLE,
2309: P_PROMISE_REC IN IEX_PROMISES_PUB.PRO_MASS_REC_TYPE)
2310: IS
2311: Type refCur is Ref Cursor;
2312:

Line 2456: P_MASS_IDS_TBL IN DBMS_SQL.NUMBER_TABLE,

2452: P_VALIDATION_LEVEL IN NUMBER, -- DEFAULT FND_API.G_VALID_LEVEL_FULL,
2453: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2454: X_MSG_COUNT OUT NOCOPY NUMBER,
2455: X_MSG_DATA OUT NOCOPY VARCHAR2,
2456: P_MASS_IDS_TBL IN DBMS_SQL.NUMBER_TABLE,
2457: P_MASS_PROMISE_REC IN IEX_PROMISES_PUB.PRO_MASS_REC_TYPE,
2458: X_MASS_PRORESP_TBL OUT NOCOPY IEX_PROMISES_PUB.PRO_MASS_RESP_TBL)
2459: IS
2460: l_api_name CONSTANT VARCHAR2(30) := 'MASS_PROMISE';

Line 2491: l_MASS_IDS_TBL DBMS_SQL.NUMBER_TABLE;

2487: l_note_type varchar2(30);
2488: l_source_object_id NUMBER;
2489: l_source_object_code varchar2(20);
2490: l_cust_site_use_id number;
2491: l_MASS_IDS_TBL DBMS_SQL.NUMBER_TABLE;
2492: l_org_id number; --Added for bug 7237026 17-Nov-2008 barathsr
2493:
2494: -- generate new promise detail
2495: CURSOR prd_genid_crs IS