116:
117:
118: BEGIN
119:
120: x_user_id := FND_GLOBAL.USER_ID;
121: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
122: x_login_id := FND_GLOBAL.LOGIN_ID;
123: x_appl_id := FND_GLOBAL.PROG_APPL_ID;
124: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
117:
118: BEGIN
119:
120: x_user_id := FND_GLOBAL.USER_ID;
121: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
122: x_login_id := FND_GLOBAL.LOGIN_ID;
123: x_appl_id := FND_GLOBAL.PROG_APPL_ID;
124: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
125:
118: BEGIN
119:
120: x_user_id := FND_GLOBAL.USER_ID;
121: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
122: x_login_id := FND_GLOBAL.LOGIN_ID;
123: x_appl_id := FND_GLOBAL.PROG_APPL_ID;
124: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
125:
126: open cal;
119:
120: x_user_id := FND_GLOBAL.USER_ID;
121: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
122: x_login_id := FND_GLOBAL.LOGIN_ID;
123: x_appl_id := FND_GLOBAL.PROG_APPL_ID;
124: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
125:
126: open cal;
127: fetch cal into x_cal_code, x_excp_set_id;
120: x_user_id := FND_GLOBAL.USER_ID;
121: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
122: x_login_id := FND_GLOBAL.LOGIN_ID;
123: x_appl_id := FND_GLOBAL.PROG_APPL_ID;
124: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
125:
126: open cal;
127: fetch cal into x_cal_code, x_excp_set_id;
128: x_found := cal%NOTFOUND;
712:
713: BEGIN
714:
715: -- populate who columns --
716: x_user_id := fnd_global.user_id;
717: x_login_id := fnd_global.login_id;
718: x_request_id := fnd_global.conc_request_id;
719: x_appl_id := fnd_global.prog_appl_id;
720: x_program_id := fnd_global.conc_program_id;
713: BEGIN
714:
715: -- populate who columns --
716: x_user_id := fnd_global.user_id;
717: x_login_id := fnd_global.login_id;
718: x_request_id := fnd_global.conc_request_id;
719: x_appl_id := fnd_global.prog_appl_id;
720: x_program_id := fnd_global.conc_program_id;
721:
714:
715: -- populate who columns --
716: x_user_id := fnd_global.user_id;
717: x_login_id := fnd_global.login_id;
718: x_request_id := fnd_global.conc_request_id;
719: x_appl_id := fnd_global.prog_appl_id;
720: x_program_id := fnd_global.conc_program_id;
721:
722: -- get the assembly and line id of the closed schedule --
715: -- populate who columns --
716: x_user_id := fnd_global.user_id;
717: x_login_id := fnd_global.login_id;
718: x_request_id := fnd_global.conc_request_id;
719: x_appl_id := fnd_global.prog_appl_id;
720: x_program_id := fnd_global.conc_program_id;
721:
722: -- get the assembly and line id of the closed schedule --
723: open gen_info;
716: x_user_id := fnd_global.user_id;
717: x_login_id := fnd_global.login_id;
718: x_request_id := fnd_global.conc_request_id;
719: x_appl_id := fnd_global.prog_appl_id;
720: x_program_id := fnd_global.conc_program_id;
721:
722: -- get the assembly and line id of the closed schedule --
723: open gen_info;
724: fetch gen_info INTO x_wip_id, x_line_id, x_qty_completed;