DBA Data[Home] [Help]

APPS.ZPB_AW_WRITE_BACK dependencies on ZPB_REQUESTS

Line 114: req_nm ZPB_REQUESTS.req_name%type;

110: P_START_TIME IN DATE,
111: P_OUTVAL OUT NOCOPY Number )
112: IS
113: req_id NUMBER;
114: req_nm ZPB_REQUESTS.req_name%type;
115: resp_name FND_RESPONSIBILITY_VL.RESPONSIBILITY_NAME%type;
116: zpb_user FND_USER.USER_NAME%type;
117: stmt_ln NUMBER;
118: cmd_str VARCHAR2(32767);

Line 145: from ZPB_REQUESTS

141: where user_id = P_USER_ID;
142:
143: select req_name
144: into req_nm
145: from ZPB_REQUESTS
146: where req_task_type = P_TASK_TYPE;
147:
148: select zpb_writeback_seq.nextval into tsk_seq from dual;
149: