DBA Data[Home] [Help]

APPS.IGS_PR_COHINST_RANK_PKG dependencies on FND_GLOBAL

Line 371: x_last_updated_by := fnd_global.user_id;

367: IF (x_mode = 'I') THEN
368: x_last_updated_by := 1;
369: x_last_update_login := 0;
370: ELSIF (x_mode = 'R') THEN
371: x_last_updated_by := fnd_global.user_id;
372: IF (x_last_updated_by IS NULL) THEN
373: x_last_updated_by := -1;
374: END IF;
375: x_last_update_login := fnd_global.login_id;

Line 375: x_last_update_login := fnd_global.login_id;

371: x_last_updated_by := fnd_global.user_id;
372: IF (x_last_updated_by IS NULL) THEN
373: x_last_updated_by := -1;
374: END IF;
375: x_last_update_login := fnd_global.login_id;
376: IF (x_last_update_login IS NULL) THEN
377: x_last_update_login := -1;
378: END IF;
379: x_request_id := fnd_global.conc_request_id;

Line 379: x_request_id := fnd_global.conc_request_id;

375: x_last_update_login := fnd_global.login_id;
376: IF (x_last_update_login IS NULL) THEN
377: x_last_update_login := -1;
378: END IF;
379: x_request_id := fnd_global.conc_request_id;
380: x_program_id := fnd_global.conc_program_id;
381: x_program_application_id := fnd_global.prog_appl_id;
382:
383: IF (x_request_id = -1) THEN

Line 380: x_program_id := fnd_global.conc_program_id;

376: IF (x_last_update_login IS NULL) THEN
377: x_last_update_login := -1;
378: END IF;
379: x_request_id := fnd_global.conc_request_id;
380: x_program_id := fnd_global.conc_program_id;
381: x_program_application_id := fnd_global.prog_appl_id;
382:
383: IF (x_request_id = -1) THEN
384: x_request_id := NULL;

Line 381: x_program_application_id := fnd_global.prog_appl_id;

377: x_last_update_login := -1;
378: END IF;
379: x_request_id := fnd_global.conc_request_id;
380: x_program_id := fnd_global.conc_program_id;
381: x_program_application_id := fnd_global.prog_appl_id;
382:
383: IF (x_request_id = -1) THEN
384: x_request_id := NULL;
385: x_program_id := NULL;

Line 560: x_last_updated_by := fnd_global.user_id;

556: IF (X_MODE = 'I') THEN
557: x_last_updated_by := 1;
558: x_last_update_login := 0;
559: ELSIF (x_mode = 'R') THEN
560: x_last_updated_by := fnd_global.user_id;
561: IF x_last_updated_by IS NULL THEN
562: x_last_updated_by := -1;
563: END IF;
564: x_last_update_login := fnd_global.login_id;

Line 564: x_last_update_login := fnd_global.login_id;

560: x_last_updated_by := fnd_global.user_id;
561: IF x_last_updated_by IS NULL THEN
562: x_last_updated_by := -1;
563: END IF;
564: x_last_update_login := fnd_global.login_id;
565: IF (x_last_update_login IS NULL) THEN
566: x_last_update_login := -1;
567: END IF;
568: ELSE

Line 594: x_request_id := fnd_global.conc_request_id;

590: x_last_update_login => x_last_update_login
591: );
592:
593: IF (x_mode = 'R') THEN
594: x_request_id := fnd_global.conc_request_id;
595: x_program_id := fnd_global.conc_program_id;
596: x_program_application_id := fnd_global.prog_appl_id;
597: IF (x_request_id = -1) THEN
598: x_request_id := old_references.request_id;

Line 595: x_program_id := fnd_global.conc_program_id;

591: );
592:
593: IF (x_mode = 'R') THEN
594: x_request_id := fnd_global.conc_request_id;
595: x_program_id := fnd_global.conc_program_id;
596: x_program_application_id := fnd_global.prog_appl_id;
597: IF (x_request_id = -1) THEN
598: x_request_id := old_references.request_id;
599: x_program_id := old_references.program_id;

Line 596: x_program_application_id := fnd_global.prog_appl_id;

592:
593: IF (x_mode = 'R') THEN
594: x_request_id := fnd_global.conc_request_id;
595: x_program_id := fnd_global.conc_program_id;
596: x_program_application_id := fnd_global.prog_appl_id;
597: IF (x_request_id = -1) THEN
598: x_request_id := old_references.request_id;
599: x_program_id := old_references.program_id;
600: x_program_application_id := old_references.program_application_id;

Line 640: WHERE user_id = FND_GLOBAL.USER_ID;

636:
637: CURSOR c_fnd IS
638: SELECT distinct person_party_id
639: FROm FND_USER
640: WHERE user_id = FND_GLOBAL.USER_ID;
641: l_person_party_id fnd_user.person_party_id%TYPE;
642:
643: CURSOR c_meaning IS
644: SELECT meaning

Line 673: P_OVRBY_PERSON_ID => FND_GLOBAL.USER_ID,

669: P_PERSON_NUMBER => rec_pers.person_number,
670: P_PERSON_NAME => rec_pers.full_name,
671: P_CURRENT_RANK => new_references.cohort_rank,
672: P_OVERRIDE_RANK => new_references.cohort_override_rank,
673: P_OVRBY_PERSON_ID => FND_GLOBAL.USER_ID,
674: P_OVRBY_PERSON_NUMBER => rec_admin.person_number,
675: P_OVRBY_PERSON_NAME => NVL(rec_admin.full_name,l_meaning.meaning)
676: );
677: END IF;