DBA Data[Home] [Help]

APPS.IGS_EN_SPAT_LGCY_PUB dependencies on FND_GLOBAL

Line 587: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;

583: FETCH c_igs_en_spa_terms_s INTO l_spa_terms_term_record_id;
584: CLOSE c_igs_en_spa_terms_s;
585:
586: -- derive the who column values
587: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
588: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
589: l_program_application_id := FND_GLOBAL.PROG_APPL_ID;
590: IF (l_request_id = -1) THEN
591: l_request_id := NULL;

Line 588: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;

584: CLOSE c_igs_en_spa_terms_s;
585:
586: -- derive the who column values
587: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
588: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
589: l_program_application_id := FND_GLOBAL.PROG_APPL_ID;
590: IF (l_request_id = -1) THEN
591: l_request_id := NULL;
592: l_program_id := NULL;

Line 589: l_program_application_id := FND_GLOBAL.PROG_APPL_ID;

585:
586: -- derive the who column values
587: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
588: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
589: l_program_application_id := FND_GLOBAL.PROG_APPL_ID;
590: IF (l_request_id = -1) THEN
591: l_request_id := NULL;
592: l_program_id := NULL;
593: l_program_application_id:= NULL;

Line 661: NVL(FND_GLOBAL.USER_ID, -1), -- created_by

657: p_spat_rec.attendance_type,
658: p_spat_rec.fee_cat,
659: l_coo_id,
660: l_class_standing_id,
661: NVL(FND_GLOBAL.USER_ID, -1), -- created_by
662: SYSDATE, -- creation_date
663: NVL(FND_GLOBAL.USER_ID,-1), -- last_updated_by
664: SYSDATE, -- last_update_date
665: NVL(FND_GLOBAL.LOGIN_ID, -1), -- last_update_login

Line 663: NVL(FND_GLOBAL.USER_ID,-1), -- last_updated_by

659: l_coo_id,
660: l_class_standing_id,
661: NVL(FND_GLOBAL.USER_ID, -1), -- created_by
662: SYSDATE, -- creation_date
663: NVL(FND_GLOBAL.USER_ID,-1), -- last_updated_by
664: SYSDATE, -- last_update_date
665: NVL(FND_GLOBAL.LOGIN_ID, -1), -- last_update_login
666: l_request_id, -- request_id
667: l_program_application_id, -- program_application_id

Line 665: NVL(FND_GLOBAL.LOGIN_ID, -1), -- last_update_login

661: NVL(FND_GLOBAL.USER_ID, -1), -- created_by
662: SYSDATE, -- creation_date
663: NVL(FND_GLOBAL.USER_ID,-1), -- last_updated_by
664: SYSDATE, -- last_update_date
665: NVL(FND_GLOBAL.LOGIN_ID, -1), -- last_update_login
666: l_request_id, -- request_id
667: l_program_application_id, -- program_application_id
668: l_program_id, -- program_id
669: l_program_update_date, -- program_update_date