APPS.IGS_EN_SPAT_LGCY_PUB dependencies on IGS_EN_SPA_TERMS_S

Line 302: FROM igs_en_spa_terms spa_terms, igs_ps_ver ps_ver

298: pc_term_cal_type VARCHAR2,
299: pc_term_sequence_number NUMBER,
300: pc_program_cd igs_en_spa_terms.program_cd%TYPE) IS
301: SELECT 'X'
302: FROM igs_en_spa_terms spa_terms, igs_ps_ver ps_ver
303: WHERE
304: spa_terms.person_id = pc_person_id AND
305: spa_terms.term_cal_type = pc_term_cal_type AND
306: spa_terms.term_sequence_number = pc_term_sequence_number AND

Line 441: CURSOR c_igs_en_spa_terms_s IS

437: || Change History :
438: || Who When What
439: ------------------------------------------------------------------------------*/
440:
441: CURSOR c_igs_en_spa_terms_s IS
442: SELECT igs_en_spa_terms_s.NEXTVAL
443: FROM dual;
444:
445: l_api_name CONSTANT VARCHAR2(30) := 'create_spa_t';

Line 442: SELECT igs_en_spa_terms_s.NEXTVAL

438: || Who When What
439: ------------------------------------------------------------------------------*/
440:
441: CURSOR c_igs_en_spa_terms_s IS
442: SELECT igs_en_spa_terms_s.NEXTVAL
443: FROM dual;
444:
445: l_api_name CONSTANT VARCHAR2(30) := 'create_spa_t';
446: l_api_version CONSTANT NUMBER := 1.0;

Line 581: --get the nextval from sequence igs_en_spa_terms_s for term_record_id

577:
578: -- if no validation failed then insert the record into spa terms table
579: IF NOT l_validation_failed THEN
580:
581: --get the nextval from sequence igs_en_spa_terms_s for term_record_id
582: OPEN c_igs_en_spa_terms_s;
583: FETCH c_igs_en_spa_terms_s INTO l_spa_terms_term_record_id;
584: CLOSE c_igs_en_spa_terms_s;
585:

Line 582: OPEN c_igs_en_spa_terms_s;

578: -- if no validation failed then insert the record into spa terms table
579: IF NOT l_validation_failed THEN
580:
581: --get the nextval from sequence igs_en_spa_terms_s for term_record_id
582: OPEN c_igs_en_spa_terms_s;
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

Line 583: FETCH c_igs_en_spa_terms_s INTO l_spa_terms_term_record_id;

579: IF NOT l_validation_failed THEN
580:
581: --get the nextval from sequence igs_en_spa_terms_s for term_record_id
582: OPEN c_igs_en_spa_terms_s;
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;

Line 584: CLOSE c_igs_en_spa_terms_s;

580:
581: --get the nextval from sequence igs_en_spa_terms_s for term_record_id
582: OPEN c_igs_en_spa_terms_s;
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;