457: IF (x_mode = 'I') THEN
458: x_last_updated_by := 1;
459: x_last_update_login := 0;
460: ELSIF (x_mode = 'R') THEN
461: x_last_updated_by := fnd_global.user_id;
462: IF (x_last_updated_by IS NULL) THEN
463: x_last_updated_by := -1;
464: END IF;
465: x_last_update_login := fnd_global.login_id;
461: x_last_updated_by := fnd_global.user_id;
462: IF (x_last_updated_by IS NULL) THEN
463: x_last_updated_by := -1;
464: END IF;
465: x_last_update_login := fnd_global.login_id;
466: IF (x_last_update_login IS NULL) THEN
467: x_last_update_login := -1;
468: END IF;
469: x_request_id := fnd_global.conc_request_id;
465: x_last_update_login := fnd_global.login_id;
466: IF (x_last_update_login IS NULL) THEN
467: x_last_update_login := -1;
468: END IF;
469: x_request_id := fnd_global.conc_request_id;
470: x_program_id := fnd_global.conc_program_id;
471: x_program_application_id := fnd_global.prog_appl_id;
472:
473: IF (x_request_id = -1) THEN
466: IF (x_last_update_login IS NULL) THEN
467: x_last_update_login := -1;
468: END IF;
469: x_request_id := fnd_global.conc_request_id;
470: x_program_id := fnd_global.conc_program_id;
471: x_program_application_id := fnd_global.prog_appl_id;
472:
473: IF (x_request_id = -1) THEN
474: x_request_id := NULL;
467: x_last_update_login := -1;
468: END IF;
469: x_request_id := fnd_global.conc_request_id;
470: x_program_id := fnd_global.conc_program_id;
471: x_program_application_id := fnd_global.prog_appl_id;
472:
473: IF (x_request_id = -1) THEN
474: x_request_id := NULL;
475: x_program_id := NULL;
660: IF (X_MODE = 'I') THEN
661: x_last_updated_by := 1;
662: x_last_update_login := 0;
663: ELSIF (x_mode = 'R') THEN
664: x_last_updated_by := fnd_global.user_id;
665: IF x_last_updated_by IS NULL THEN
666: x_last_updated_by := -1;
667: END IF;
668: x_last_update_login := fnd_global.login_id;
664: x_last_updated_by := fnd_global.user_id;
665: IF x_last_updated_by IS NULL THEN
666: x_last_updated_by := -1;
667: END IF;
668: x_last_update_login := fnd_global.login_id;
669: IF (x_last_update_login IS NULL) THEN
670: x_last_update_login := -1;
671: END IF;
672: ELSE
694: x_bill_desc => x_bill_desc
695: );
696:
697: IF (x_mode = 'R') THEN
698: x_request_id := fnd_global.conc_request_id;
699: x_program_id := fnd_global.conc_program_id;
700: x_program_application_id := fnd_global.prog_appl_id;
701: IF (x_request_id = -1) THEN
702: x_request_id := old_references.request_id;
695: );
696:
697: IF (x_mode = 'R') THEN
698: x_request_id := fnd_global.conc_request_id;
699: x_program_id := fnd_global.conc_program_id;
700: x_program_application_id := fnd_global.prog_appl_id;
701: IF (x_request_id = -1) THEN
702: x_request_id := old_references.request_id;
703: x_program_id := old_references.program_id;
696:
697: IF (x_mode = 'R') THEN
698: x_request_id := fnd_global.conc_request_id;
699: x_program_id := fnd_global.conc_program_id;
700: x_program_application_id := fnd_global.prog_appl_id;
701: IF (x_request_id = -1) THEN
702: x_request_id := old_references.request_id;
703: x_program_id := old_references.program_id;
704: x_program_application_id := old_references.program_application_id;