29: AND COSTED IN (WIP_CONSTANTS.PENDING,WIP_CONSTANTS.ERROR);
30: BEGIN
31: l_stmt_num := 5;
32:
33: l_user_id := FND_GLOBAL.USER_ID;
34: l_login_id := FND_GLOBAL.LOGIN_ID;
35: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
36: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
37: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
30: BEGIN
31: l_stmt_num := 5;
32:
33: l_user_id := FND_GLOBAL.USER_ID;
34: l_login_id := FND_GLOBAL.LOGIN_ID;
35: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
36: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
37: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
38: l_debug := FND_PROFILE.VALUE('MRP_DEBUG');
31: l_stmt_num := 5;
32:
33: l_user_id := FND_GLOBAL.USER_ID;
34: l_login_id := FND_GLOBAL.LOGIN_ID;
35: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
36: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
37: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
38: l_debug := FND_PROFILE.VALUE('MRP_DEBUG');
39: l_err_code := '';
32:
33: l_user_id := FND_GLOBAL.USER_ID;
34: l_login_id := FND_GLOBAL.LOGIN_ID;
35: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
36: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
37: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
38: l_debug := FND_PROFILE.VALUE('MRP_DEBUG');
39: l_err_code := '';
40: l_err_msg := '';
33: l_user_id := FND_GLOBAL.USER_ID;
34: l_login_id := FND_GLOBAL.LOGIN_ID;
35: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
36: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
37: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
38: l_debug := FND_PROFILE.VALUE('MRP_DEBUG');
39: l_err_code := '';
40: l_err_msg := '';
41: l_err_num := 0;