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;
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;
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;
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
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
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