DBA Data[Home] [Help]

APPS.MSC_WS_ASCP dependencies on REQTBLTYP

Line 310: PROCEDURE RELEASE_ASCP ( req_id OUT NOCOPY REQTBLTYP,

306:
307: -- =============================================================
308: -- Desc: Please see package spec for description
309: -- =============================================================
310: PROCEDURE RELEASE_ASCP ( req_id OUT NOCOPY REQTBLTYP,
311: status OUT NOCOPY VARCHAR2,
312: userId IN NUMBER,
313: responsibilityId IN NUMBER,
314: planId IN NUMBER,

Line 326: l_req_id MSC_RELEASE_PK.REQTBLTYP;

322: l_val_instanceid NUMBER;
323: l_rel_time_window VARCHAR2(1);
324: RETCODE NUMBER;
325: ERRMSG VARCHAR2(200);
326: l_req_id MSC_RELEASE_PK.REQTBLTYP;
327:
328: i number;
329: j number :=1;
330:

Line 332: req_id := REQTBLTYP();

328: i number;
329: j number :=1;
330:
331: BEGIN
332: req_id := REQTBLTYP();
333: error_tracking_num :=2010;
334: msc_ws_common.validate_user_resp(l_val_result, userid, responsibilityid);
335:
336: IF(l_val_result <> 'OK') THEN

Line 410: PROCEDURE RELEASE_ASCP_PUBLIC ( req_id OUT NOCOPY REQTBLTYP,

406:
407:
408: END RELEASE_ASCP;
409:
410: PROCEDURE RELEASE_ASCP_PUBLIC ( req_id OUT NOCOPY REQTBLTYP,
411: status OUT NOCOPY VARCHAR2,
412: UserName IN VARCHAR2,
413: RespName IN VARCHAR2,
414: RespApplName IN VARCHAR2,

Line 430: req_id := REQTBLTYP();

426:
427:
428: BEGIN
429:
430: req_id := REQTBLTYP();
431: error_tracking_num :=2010;
432: MSC_WS_COMMON.GET_PERMISSION_IDS(l_String, userid, respid, l_SecutirtGroupId, UserName, RespName, RespApplName, SecurityGroupName, Language);
433: IF (l_String <> 'OK') THEN
434: Status := l_String;