APPS.IEX_PROMISES_PUB dependencies on DBMS_SQL

Line 23: P_PROMISE_TBL IN DBMS_SQL.NUMBER_TABLE,

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

Line 41: l_broken_promises DBMS_SQL.NUMBER_TABLE;

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

Line 2207: P_MASS_IDS_TBL IN DBMS_SQL.NUMBER_TABLE,

2203: END;
2204:
2205:
2206: PROCEDURE VALIDATE_MASS_INPUT(
2207: P_MASS_IDS_TBL IN DBMS_SQL.NUMBER_TABLE,
2208: P_PROMISE_REC IN IEX_PROMISES_PUB.PRO_MASS_REC_TYPE)
2209: IS
2210: Type refCur is Ref Cursor;
2211:

Line 2355: P_MASS_IDS_TBL IN DBMS_SQL.NUMBER_TABLE,

2351: P_VALIDATION_LEVEL IN NUMBER, -- DEFAULT FND_API.G_VALID_LEVEL_FULL,
2352: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2353: X_MSG_COUNT OUT NOCOPY NUMBER,
2354: X_MSG_DATA OUT NOCOPY VARCHAR2,
2355: P_MASS_IDS_TBL IN DBMS_SQL.NUMBER_TABLE,
2356: P_MASS_PROMISE_REC IN IEX_PROMISES_PUB.PRO_MASS_REC_TYPE,
2357: X_MASS_PRORESP_TBL OUT NOCOPY IEX_PROMISES_PUB.PRO_MASS_RESP_TBL)
2358: IS
2359: l_api_name CONSTANT VARCHAR2(30) := 'MASS_PROMISE';

Line 2390: l_MASS_IDS_TBL DBMS_SQL.NUMBER_TABLE;

2386: l_note_type varchar2(30);
2387: l_source_object_id NUMBER;
2388: l_source_object_code varchar2(20);
2389: l_cust_site_use_id number;
2390: l_MASS_IDS_TBL DBMS_SQL.NUMBER_TABLE;
2391: l_org_id number; --Added for bug 7237026 17-Nov-2008 barathsr
2392:
2393: -- generate new promise detail
2394: CURSOR prd_genid_crs IS