917: IF (x_mode = 'I') THEN
918: x_last_updated_by := 1;
919: x_last_update_login := 0;
920: ELSIF (x_mode = 'R') THEN
921: x_last_updated_by := fnd_global.user_id;
922: IF (x_last_updated_by IS NULL) THEN
923: x_last_updated_by := -1;
924: END IF;
925: x_last_update_login := fnd_global.login_id;
921: x_last_updated_by := fnd_global.user_id;
922: IF (x_last_updated_by IS NULL) THEN
923: x_last_updated_by := -1;
924: END IF;
925: x_last_update_login := fnd_global.login_id;
926: IF (x_last_update_login IS NULL) THEN
927: x_last_update_login := -1;
928: END IF;
929: x_request_id := fnd_global.conc_request_id;
925: x_last_update_login := fnd_global.login_id;
926: IF (x_last_update_login IS NULL) THEN
927: x_last_update_login := -1;
928: END IF;
929: x_request_id := fnd_global.conc_request_id;
930: x_program_id := fnd_global.conc_program_id;
931: x_program_application_id := fnd_global.prog_appl_id;
932:
933: IF (x_request_id = -1) THEN
926: IF (x_last_update_login IS NULL) THEN
927: x_last_update_login := -1;
928: END IF;
929: x_request_id := fnd_global.conc_request_id;
930: x_program_id := fnd_global.conc_program_id;
931: x_program_application_id := fnd_global.prog_appl_id;
932:
933: IF (x_request_id = -1) THEN
934: x_request_id := NULL;
927: x_last_update_login := -1;
928: END IF;
929: x_request_id := fnd_global.conc_request_id;
930: x_program_id := fnd_global.conc_program_id;
931: x_program_application_id := fnd_global.prog_appl_id;
932:
933: IF (x_request_id = -1) THEN
934: x_request_id := NULL;
935: x_program_id := NULL;
1950: IF (X_MODE = 'I') THEN
1951: x_last_updated_by := 1;
1952: x_last_update_login := 0;
1953: ELSIF (x_mode = 'R') THEN
1954: x_last_updated_by := fnd_global.user_id;
1955: IF x_last_updated_by IS NULL THEN
1956: x_last_updated_by := -1;
1957: END IF;
1958: x_last_update_login := fnd_global.login_id;
1954: x_last_updated_by := fnd_global.user_id;
1955: IF x_last_updated_by IS NULL THEN
1956: x_last_updated_by := -1;
1957: END IF;
1958: x_last_update_login := fnd_global.login_id;
1959: IF (x_last_update_login IS NULL) THEN
1960: x_last_update_login := -1;
1961: END IF;
1962: ELSE
2101: x_esign_src_typ_cd => x_esign_src_typ_cd
2102: );
2103:
2104: IF (x_mode = 'R') THEN
2105: x_request_id := fnd_global.conc_request_id;
2106: x_program_id := fnd_global.conc_program_id;
2107: x_program_application_id := fnd_global.prog_appl_id;
2108: IF (x_request_id = -1) THEN
2109: x_request_id := old_references.request_id;
2102: );
2103:
2104: IF (x_mode = 'R') THEN
2105: x_request_id := fnd_global.conc_request_id;
2106: x_program_id := fnd_global.conc_program_id;
2107: x_program_application_id := fnd_global.prog_appl_id;
2108: IF (x_request_id = -1) THEN
2109: x_request_id := old_references.request_id;
2110: x_program_id := old_references.program_id;
2103:
2104: IF (x_mode = 'R') THEN
2105: x_request_id := fnd_global.conc_request_id;
2106: x_program_id := fnd_global.conc_program_id;
2107: x_program_application_id := fnd_global.prog_appl_id;
2108: IF (x_request_id = -1) THEN
2109: x_request_id := old_references.request_id;
2110: x_program_id := old_references.program_id;
2111: x_program_application_id := old_references.program_application_id;