13: X_Created_By NUMBER,
14: X_Last_Update_Login NUMBER) IS
15:
16:
17: p_req_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
18: p_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
19: p_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
20: p_curdate DATE := SYSDATE;
21: p_user_id NUMBER := FND_GLOBAL.USER_ID;
14: X_Last_Update_Login NUMBER) IS
15:
16:
17: p_req_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
18: p_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
19: p_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
20: p_curdate DATE := SYSDATE;
21: p_user_id NUMBER := FND_GLOBAL.USER_ID;
22: p_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
15:
16:
17: p_req_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
18: p_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
19: p_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
20: p_curdate DATE := SYSDATE;
21: p_user_id NUMBER := FND_GLOBAL.USER_ID;
22: p_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
23: max_seq NUMBER;
17: p_req_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
18: p_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
19: p_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
20: p_curdate DATE := SYSDATE;
21: p_user_id NUMBER := FND_GLOBAL.USER_ID;
22: p_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
23: max_seq NUMBER;
24:
25:
18: p_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
19: p_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
20: p_curdate DATE := SYSDATE;
21: p_user_id NUMBER := FND_GLOBAL.USER_ID;
22: p_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
23: max_seq NUMBER;
24:
25:
26: CURSOR wip_op_inst IS
349: X_Quantity NUMBER,
350: X_Last_Updated_By NUMBER,
351: X_Last_Update_Login NUMBER,
352: X_Success_Flag OUT NOCOPY NUMBER) IS
353: p_req_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
354: p_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
355: p_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
356: x_first_op NUMBER;
357: x_qty_comp NUMBER;
350: X_Last_Updated_By NUMBER,
351: X_Last_Update_Login NUMBER,
352: X_Success_Flag OUT NOCOPY NUMBER) IS
353: p_req_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
354: p_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
355: p_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
356: x_first_op NUMBER;
357: x_qty_comp NUMBER;
358: x_start DATE;
351: X_Last_Update_Login NUMBER,
352: X_Success_Flag OUT NOCOPY NUMBER) IS
353: p_req_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
354: p_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
355: p_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
356: x_first_op NUMBER;
357: x_qty_comp NUMBER;
358: x_start DATE;
359: x_comp DATE;