DBA Data[Home] [Help]

APPS.MSC_WS_SRP dependencies on REQTBLTYP

Line 333: PROCEDURE RELEASE_SRP ( req_id OUT NOCOPY REQTBLTYP,

329:
330: -- =============================================================
331: -- Desc: Please see package spec for description
332: -- =============================================================
333: PROCEDURE RELEASE_SRP ( req_id OUT NOCOPY REQTBLTYP,
334: status OUT NOCOPY VARCHAR2,
335: userId IN NUMBER,
336: responsibilityId IN NUMBER,
337: planId IN NUMBER,

Line 349: l_req_id MSC_RELEASE_PK.REQTBLTYP;

345: l_val_instanceid NUMBER;
346: l_rel_time_window VARCHAR2(1);
347: RETCODE NUMBER;
348: ERRMSG VARCHAR2(200);
349: l_req_id MSC_RELEASE_PK.REQTBLTYP;
350:
351: i number;
352: j number :=1;
353:

Line 355: req_id := REQTBLTYP();

351: i number;
352: j number :=1;
353:
354: BEGIN
355: req_id := REQTBLTYP();
356: error_tracking_num :=2010;
357: msc_ws_common.validate_user_resp(l_val_result, userid, responsibilityid);
358:
359: IF(l_val_result <> 'OK') THEN

Line 430: PROCEDURE RELEASE_SRP_PUBLIC ( req_id OUT NOCOPY REQTBLTYP,

426: return;
427:
428: END RELEASE_SRP;
429:
430: PROCEDURE RELEASE_SRP_PUBLIC ( req_id OUT NOCOPY REQTBLTYP,
431: status OUT NOCOPY VARCHAR2,
432: UserName IN VARCHAR2,
433: RespName IN VARCHAR2,
434: RespApplName IN VARCHAR2,

Line 446: req_id := REQTBLTYP();

442: l_String VARCHAR2(30);
443: error_tracking_num number;
444: l_SecutirtGroupId NUMBER;
445: BEGIN
446: req_id := REQTBLTYP();
447: error_tracking_num :=2010;
448: MSC_WS_COMMON.GET_PERMISSION_IDS(l_String, userid, respid, l_SecutirtGroupId, UserName, RespName, RespApplName, SecurityGroupName, Language);
449: IF (l_String <> 'OK') THEN
450: Status := l_String;