DBA Data[Home] [Help]

APPS.MSC_WS_DRP dependencies on REQTBLTYP

Line 286: PROCEDURE RELEASE_DRP ( req_id OUT NOCOPY REQTBLTYP,

282:
283: -- =============================================================
284: -- Desc: Please see package spec for description
285: -- =============================================================
286: PROCEDURE RELEASE_DRP ( req_id OUT NOCOPY REQTBLTYP,
287: status OUT NOCOPY VARCHAR2,
288: userId IN NUMBER,
289: responsibilityId IN NUMBER,
290: planId IN NUMBER,

Line 302: l_req_id MSC_RELEASE_PK.REQTBLTYP;

298: l_val_instanceid NUMBER;
299: l_rel_time_window VARCHAR2(1);
300: RETCODE NUMBER;
301: ERRMSG VARCHAR2(200);
302: l_req_id MSC_RELEASE_PK.REQTBLTYP;
303:
304: i number;
305: j number :=1;
306:

Line 308: req_id := REQTBLTYP();

304: i number;
305: j number :=1;
306:
307: BEGIN
308: req_id := REQTBLTYP();
309: error_tracking_num :=2010;
310: msc_ws_common.validate_user_resp(l_val_result, userid, responsibilityid);
311:
312: IF(l_val_result <> 'OK') THEN

Line 381: PROCEDURE RELEASE_DRP_PUBLIC ( req_id OUT NOCOPY REQTBLTYP,

377:
378:
379: END RELEASE_DRP;
380:
381: PROCEDURE RELEASE_DRP_PUBLIC ( req_id OUT NOCOPY REQTBLTYP,
382: status OUT NOCOPY VARCHAR2,
383: UserName IN VARCHAR2,
384: RespName IN VARCHAR2,
385: RespApplName IN VARCHAR2,

Line 397: req_id := REQTBLTYP();

393: l_String VARCHAR2(30);
394: error_tracking_num number;
395: l_SecutirtGroupId NUMBER;
396: BEGIN
397: req_id := REQTBLTYP();
398: error_tracking_num :=2010;
399: MSC_WS_COMMON.GET_PERMISSION_IDS(l_String, userid, respid, l_SecutirtGroupId, UserName, RespName, RespApplName, SecurityGroupName, Language);
400: IF (l_String <> 'OK') THEN
401: Status := l_String;