411: IF (x_mode = 'I') THEN
412: x_last_updated_by := 1;
413: x_last_update_login := 0;
414: ELSIF (x_mode = 'R') THEN
415: x_last_updated_by := fnd_global.user_id;
416: IF (x_last_updated_by IS NULL) THEN
417: x_last_updated_by := -1;
418: END IF;
419: x_last_update_login := fnd_global.login_id;
415: x_last_updated_by := fnd_global.user_id;
416: IF (x_last_updated_by IS NULL) THEN
417: x_last_updated_by := -1;
418: END IF;
419: x_last_update_login := fnd_global.login_id;
420: IF (x_last_update_login IS NULL) THEN
421: x_last_update_login := -1;
422: END IF;
423: x_request_id := fnd_global.conc_request_id;
419: x_last_update_login := fnd_global.login_id;
420: IF (x_last_update_login IS NULL) THEN
421: x_last_update_login := -1;
422: END IF;
423: x_request_id := fnd_global.conc_request_id;
424: x_program_id := fnd_global.conc_program_id;
425: x_program_application_id := fnd_global.prog_appl_id;
426: IF (x_request_id = -1) THEN
427: x_request_id := NULL;
420: IF (x_last_update_login IS NULL) THEN
421: x_last_update_login := -1;
422: END IF;
423: x_request_id := fnd_global.conc_request_id;
424: x_program_id := fnd_global.conc_program_id;
425: x_program_application_id := fnd_global.prog_appl_id;
426: IF (x_request_id = -1) THEN
427: x_request_id := NULL;
428: x_program_id := NULL;
421: x_last_update_login := -1;
422: END IF;
423: x_request_id := fnd_global.conc_request_id;
424: x_program_id := fnd_global.conc_program_id;
425: x_program_application_id := fnd_global.prog_appl_id;
426: IF (x_request_id = -1) THEN
427: x_request_id := NULL;
428: x_program_id := NULL;
429: x_program_application_id := NULL;
839: IF (X_MODE = 'I') THEN
840: x_last_updated_by := 1;
841: x_last_update_login := 0;
842: ELSIF (x_mode = 'R') THEN
843: x_last_updated_by := fnd_global.user_id;
844: IF x_last_updated_by IS NULL THEN
845: x_last_updated_by := -1;
846: END IF;
847: x_last_update_login := fnd_global.login_id;
843: x_last_updated_by := fnd_global.user_id;
844: IF x_last_updated_by IS NULL THEN
845: x_last_updated_by := -1;
846: END IF;
847: x_last_update_login := fnd_global.login_id;
848: IF (x_last_update_login IS NULL) THEN
849: x_last_update_login := -1;
850: END IF;
851: ELSE
892: x_order_placed_by => x_order_placed_by
893:
894: );
895: IF (x_mode = 'R') THEN
896: x_request_id := fnd_global.conc_request_id;
897: x_program_id := fnd_global.conc_program_id;
898: x_program_application_id := fnd_global.prog_appl_id;
899: IF (x_request_id = -1) THEN
900: x_request_id := old_references.request_id;
893:
894: );
895: IF (x_mode = 'R') THEN
896: x_request_id := fnd_global.conc_request_id;
897: x_program_id := fnd_global.conc_program_id;
898: x_program_application_id := fnd_global.prog_appl_id;
899: IF (x_request_id = -1) THEN
900: x_request_id := old_references.request_id;
901: x_program_id := old_references.program_id;
894: );
895: IF (x_mode = 'R') THEN
896: x_request_id := fnd_global.conc_request_id;
897: x_program_id := fnd_global.conc_program_id;
898: x_program_application_id := fnd_global.prog_appl_id;
899: IF (x_request_id = -1) THEN
900: x_request_id := old_references.request_id;
901: x_program_id := old_references.program_id;
902: x_program_application_id := old_references.program_application_id;