eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_EN_SPAT_LGCY_PUB dependencies on IGS_EN_SPA_TERMS

Line 7: of table igs_en_spa_terms

3:
4: /*****************************************************************************
5: Who When What
6: sgurusam 20-Jun-05 Added PLAN_SHT_STATUS value as 'NONE' in insert the statement
7: of table igs_en_spa_terms
8: ******************************************************************************/
9:
10: g_pkg_name CONSTANT VARCHAR2(30) := 'IGS_EN_SPAT_LGCY_PUB';
11:

Line 127: p_desc_flex_name => 'IGS_EN_SPA_TERMS_FLEX') THEN

123: p_attribute17 => p_spat_rec.attribute17,
124: p_attribute18 => p_spat_rec.attribute18,
125: p_attribute19 => p_spat_rec.attribute19,
126: p_attribute20 => p_spat_rec.attribute20,
127: p_desc_flex_name => 'IGS_EN_SPA_TERMS_FLEX') THEN
128: l_ret_status := FALSE;
129: FND_MESSAGE.SET_NAME('IGS','IGS_AD_INVALID_DESC_FLEX');
130: FND_MSG_PUB.ADD;
131: END IF;

Line 247: l_get_uk_for_validation_return := igs_en_spa_terms_pkg.get_uk_for_validation(

243: l_get_pk_for_validation_return BOOLEAN;
244: l_get_uk_for_validation_return BOOLEAN;
245:
246: BEGIN
247: l_get_uk_for_validation_return := igs_en_spa_terms_pkg.get_uk_for_validation(
248: p_person_id,
249: p_spat_rec.program_cd,
250: p_term_cal_type,
251: p_term_sequence_number);

Line 295: CURSOR c_igs_en_spa_terms_career(

291: || Change History :
292: || Who When What
293: ------------------------------------------------------------------------------*/
294:
295: CURSOR c_igs_en_spa_terms_career(
296: pc_course_type igs_ps_ver.course_type%TYPE,
297: pc_person_id NUMBER,
298: pc_term_cal_type VARCHAR2,
299: pc_term_sequence_number NUMBER,

Line 300: pc_program_cd igs_en_spa_terms.program_cd%TYPE) IS

296: pc_course_type igs_ps_ver.course_type%TYPE,
297: pc_person_id NUMBER,
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

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 312: CURSOR c_igs_en_spa_terms_normal(

308: ps_ver.course_type = pc_course_type AND
309: spa_terms.program_cd = ps_ver.course_cd AND
310: spa_terms.program_version = ps_ver.version_number;
311:
312: CURSOR c_igs_en_spa_terms_normal(
313: pc_person_id NUMBER,
314: pc_term_cal_type VARCHAR2,
315: pc_term_sequence_number NUMBER,
316: pc_program_cd igs_en_spa_terms.program_cd%TYPE) IS

Line 316: pc_program_cd igs_en_spa_terms.program_cd%TYPE) IS

312: CURSOR c_igs_en_spa_terms_normal(
313: pc_person_id NUMBER,
314: pc_term_cal_type VARCHAR2,
315: pc_term_sequence_number NUMBER,
316: pc_program_cd igs_en_spa_terms.program_cd%TYPE) IS
317: SELECT 'X'
318: FROM igs_en_spa_terms
319: WHERE
320: person_id = pc_person_id AND

Line 318: FROM igs_en_spa_terms

314: pc_term_cal_type VARCHAR2,
315: pc_term_sequence_number NUMBER,
316: pc_program_cd igs_en_spa_terms.program_cd%TYPE) IS
317: SELECT 'X'
318: FROM igs_en_spa_terms
319: WHERE
320: person_id = pc_person_id AND
321: term_cal_type = pc_term_cal_type AND
322: term_sequence_number = pc_term_sequence_number AND

Line 336: l_igs_en_spa_terms_career c_igs_en_spa_terms_career%ROWTYPE;

332: course_cd = cp_program_cd AND
333: version_number = cp_program_version;
334:
335: l_return_value BOOLEAN := TRUE;
336: l_igs_en_spa_terms_career c_igs_en_spa_terms_career%ROWTYPE;
337: l_igs_en_spa_terms_normal c_igs_en_spa_terms_normal%ROWTYPE;
338: l_course_type_p_spat_rec igs_ps_ver.course_type%TYPE;
339: l_career_flag VARCHAR2(1);
340:

Line 337: l_igs_en_spa_terms_normal c_igs_en_spa_terms_normal%ROWTYPE;

333: version_number = cp_program_version;
334:
335: l_return_value BOOLEAN := TRUE;
336: l_igs_en_spa_terms_career c_igs_en_spa_terms_career%ROWTYPE;
337: l_igs_en_spa_terms_normal c_igs_en_spa_terms_normal%ROWTYPE;
338: l_course_type_p_spat_rec igs_ps_ver.course_type%TYPE;
339: l_career_flag VARCHAR2(1);
340:
341: BEGIN

Line 349: OPEN c_igs_en_spa_terms_career(

345:
346: l_career_flag := NVL(FND_PROFILE.VALUE('CAREER_MODEL_ENABLED'), 'N');
347:
348: IF l_career_flag = 'Y' THEN
349: OPEN c_igs_en_spa_terms_career(
350: l_course_type_p_spat_rec,
351: p_person_id,
352: p_term_cal_type,
353: p_term_sequence_number,

Line 355: FETCH c_igs_en_spa_terms_career INTO l_igs_en_spa_terms_career;

351: p_person_id,
352: p_term_cal_type,
353: p_term_sequence_number,
354: p_spat_rec.program_cd);
355: FETCH c_igs_en_spa_terms_career INTO l_igs_en_spa_terms_career;
356: IF c_igs_en_spa_terms_career%FOUND THEN
357: FND_MESSAGE.SET_NAME('IGS','IGS_EN_SPAT_EXISTS_CAREER');
358: FND_MSG_PUB.ADD;
359: l_return_value := FALSE;

Line 356: IF c_igs_en_spa_terms_career%FOUND THEN

352: p_term_cal_type,
353: p_term_sequence_number,
354: p_spat_rec.program_cd);
355: FETCH c_igs_en_spa_terms_career INTO l_igs_en_spa_terms_career;
356: IF c_igs_en_spa_terms_career%FOUND THEN
357: FND_MESSAGE.SET_NAME('IGS','IGS_EN_SPAT_EXISTS_CAREER');
358: FND_MSG_PUB.ADD;
359: l_return_value := FALSE;
360: END IF;

Line 361: CLOSE c_igs_en_spa_terms_career;

357: FND_MESSAGE.SET_NAME('IGS','IGS_EN_SPAT_EXISTS_CAREER');
358: FND_MSG_PUB.ADD;
359: l_return_value := FALSE;
360: END IF;
361: CLOSE c_igs_en_spa_terms_career;
362: END IF;
363:
364: -- if the new record is a key program
365: IF p_spat_rec.key_program_flag = 'Y' THEN

Line 367: OPEN c_igs_en_spa_terms_normal(

363:
364: -- if the new record is a key program
365: IF p_spat_rec.key_program_flag = 'Y' THEN
366: -- check if any other key program already exists for the term and person
367: OPEN c_igs_en_spa_terms_normal(
368: p_person_id,
369: p_term_cal_type,
370: p_term_sequence_number,
371: p_spat_rec.program_cd);

Line 372: FETCH c_igs_en_spa_terms_normal INTO l_igs_en_spa_terms_normal;

368: p_person_id,
369: p_term_cal_type,
370: p_term_sequence_number,
371: p_spat_rec.program_cd);
372: FETCH c_igs_en_spa_terms_normal INTO l_igs_en_spa_terms_normal;
373: IF c_igs_en_spa_terms_normal%FOUND THEN
374: FND_MESSAGE.SET_NAME('IGS','IGS_EN_MORE_KEY_IN_TERM');
375: FND_MSG_PUB.ADD;
376: l_return_value := FALSE;

Line 373: IF c_igs_en_spa_terms_normal%FOUND THEN

369: p_term_cal_type,
370: p_term_sequence_number,
371: p_spat_rec.program_cd);
372: FETCH c_igs_en_spa_terms_normal INTO l_igs_en_spa_terms_normal;
373: IF c_igs_en_spa_terms_normal%FOUND THEN
374: FND_MESSAGE.SET_NAME('IGS','IGS_EN_MORE_KEY_IN_TERM');
375: FND_MSG_PUB.ADD;
376: l_return_value := FALSE;
377: END IF;

Line 378: CLOSE c_igs_en_spa_terms_normal;

374: FND_MESSAGE.SET_NAME('IGS','IGS_EN_MORE_KEY_IN_TERM');
375: FND_MSG_PUB.ADD;
376: l_return_value := FALSE;
377: END IF;
378: CLOSE c_igs_en_spa_terms_normal;
379: END IF;
380: RETURN l_return_value;
381: END validate_pre_spat;
382:

Line 384: p_person_id IN igs_en_spa_terms.person_id%TYPE,

380: RETURN l_return_value;
381: END validate_pre_spat;
382:
383: PROCEDURE validate_post_spat(
384: p_person_id IN igs_en_spa_terms.person_id%TYPE,
385: p_term_cal_type IN igs_en_spa_terms.term_cal_type%TYPE,
386: p_term_sequence_number IN igs_en_spa_terms.term_sequence_number%TYPE,
387: p_class_standing_id IN igs_en_spa_terms.class_standing_id%TYPE,
388: p_coo_id IN igs_en_spa_terms.coo_id%TYPE,

Line 385: p_term_cal_type IN igs_en_spa_terms.term_cal_type%TYPE,

381: END validate_pre_spat;
382:
383: PROCEDURE validate_post_spat(
384: p_person_id IN igs_en_spa_terms.person_id%TYPE,
385: p_term_cal_type IN igs_en_spa_terms.term_cal_type%TYPE,
386: p_term_sequence_number IN igs_en_spa_terms.term_sequence_number%TYPE,
387: p_class_standing_id IN igs_en_spa_terms.class_standing_id%TYPE,
388: p_coo_id IN igs_en_spa_terms.coo_id%TYPE,
389: p_spat_rec IN spat_rec_type) AS

Line 386: p_term_sequence_number IN igs_en_spa_terms.term_sequence_number%TYPE,

382:
383: PROCEDURE validate_post_spat(
384: p_person_id IN igs_en_spa_terms.person_id%TYPE,
385: p_term_cal_type IN igs_en_spa_terms.term_cal_type%TYPE,
386: p_term_sequence_number IN igs_en_spa_terms.term_sequence_number%TYPE,
387: p_class_standing_id IN igs_en_spa_terms.class_standing_id%TYPE,
388: p_coo_id IN igs_en_spa_terms.coo_id%TYPE,
389: p_spat_rec IN spat_rec_type) AS
390: /*----------------------------------------------------------------------------

Line 387: p_class_standing_id IN igs_en_spa_terms.class_standing_id%TYPE,

383: PROCEDURE validate_post_spat(
384: p_person_id IN igs_en_spa_terms.person_id%TYPE,
385: p_term_cal_type IN igs_en_spa_terms.term_cal_type%TYPE,
386: p_term_sequence_number IN igs_en_spa_terms.term_sequence_number%TYPE,
387: p_class_standing_id IN igs_en_spa_terms.class_standing_id%TYPE,
388: p_coo_id IN igs_en_spa_terms.coo_id%TYPE,
389: p_spat_rec IN spat_rec_type) AS
390: /*----------------------------------------------------------------------------
391: || Created By : vkarthik

Line 388: p_coo_id IN igs_en_spa_terms.coo_id%TYPE,

384: p_person_id IN igs_en_spa_terms.person_id%TYPE,
385: p_term_cal_type IN igs_en_spa_terms.term_cal_type%TYPE,
386: p_term_sequence_number IN igs_en_spa_terms.term_sequence_number%TYPE,
387: p_class_standing_id IN igs_en_spa_terms.class_standing_id%TYPE,
388: p_coo_id IN igs_en_spa_terms.coo_id%TYPE,
389: p_spat_rec IN spat_rec_type) AS
390: /*----------------------------------------------------------------------------
391: || Created By : vkarthik
392: || Created On : 11-Dec-2003

Line 399: v_term_rec igs_en_spa_terms_api.EN_SPAT_REC_TYPE%TYPE;

395: || Change History :
396: || Who When What
397: ------------------------------------------------------------------------------*/
398:
399: v_term_rec igs_en_spa_terms_api.EN_SPAT_REC_TYPE%TYPE;
400: BEGIN
401: -- fill gaps
402: v_term_rec.person_id := p_person_id;
403: v_term_rec.program_cd := p_spat_rec.program_cd;

Line 417: igs_en_spa_terms_api.backward_gap_fill ( v_term_rec);

413: v_term_rec.fee_cat := p_spat_rec.fee_cat;
414: v_term_rec.class_standing_id := p_class_standing_id;
415:
416: IF p_term_cal_type IS NOT NULL AND p_term_sequence_number IS NOT NULL THEN
417: igs_en_spa_terms_api.backward_gap_fill ( v_term_rec);
418: igs_en_spa_terms_api.forward_gap_fill ( v_term_rec);
419: END IF;
420:
421: END validate_post_spat;

Line 418: igs_en_spa_terms_api.forward_gap_fill ( v_term_rec);

414: v_term_rec.class_standing_id := p_class_standing_id;
415:
416: IF p_term_cal_type IS NOT NULL AND p_term_sequence_number IS NOT NULL THEN
417: igs_en_spa_terms_api.backward_gap_fill ( v_term_rec);
418: igs_en_spa_terms_api.forward_gap_fill ( v_term_rec);
419: END IF;
420:
421: END validate_post_spat;
422:

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 450: l_spa_terms_term_record_id igs_en_spa_terms.term_record_id%TYPE;

446: l_api_version CONSTANT NUMBER := 1.0;
447: l_validation_failed BOOLEAN :=FALSE;
448: l_get_calendar_instance_return VARCHAR2(10);
449: l_validate_db_ret_status VARCHAR2(1);
450: l_spa_terms_term_record_id igs_en_spa_terms.term_record_id%TYPE;
451: l_request_id igs_en_spa_terms.request_id%TYPE;
452: l_program_application_id igs_en_spa_terms.program_application_id%TYPE;
453: l_program_id igs_en_spa_terms.program_id%TYPE;
454: l_program_update_date igs_en_spa_terms.program_update_date%TYPE;

Line 451: l_request_id igs_en_spa_terms.request_id%TYPE;

447: l_validation_failed BOOLEAN :=FALSE;
448: l_get_calendar_instance_return VARCHAR2(10);
449: l_validate_db_ret_status VARCHAR2(1);
450: l_spa_terms_term_record_id igs_en_spa_terms.term_record_id%TYPE;
451: l_request_id igs_en_spa_terms.request_id%TYPE;
452: l_program_application_id igs_en_spa_terms.program_application_id%TYPE;
453: l_program_id igs_en_spa_terms.program_id%TYPE;
454: l_program_update_date igs_en_spa_terms.program_update_date%TYPE;
455: l_person_id igs_en_spa_terms.person_id%TYPE;

Line 452: l_program_application_id igs_en_spa_terms.program_application_id%TYPE;

448: l_get_calendar_instance_return VARCHAR2(10);
449: l_validate_db_ret_status VARCHAR2(1);
450: l_spa_terms_term_record_id igs_en_spa_terms.term_record_id%TYPE;
451: l_request_id igs_en_spa_terms.request_id%TYPE;
452: l_program_application_id igs_en_spa_terms.program_application_id%TYPE;
453: l_program_id igs_en_spa_terms.program_id%TYPE;
454: l_program_update_date igs_en_spa_terms.program_update_date%TYPE;
455: l_person_id igs_en_spa_terms.person_id%TYPE;
456: l_term_cal_type igs_en_spa_terms.term_cal_type%TYPE;

Line 453: l_program_id igs_en_spa_terms.program_id%TYPE;

449: l_validate_db_ret_status VARCHAR2(1);
450: l_spa_terms_term_record_id igs_en_spa_terms.term_record_id%TYPE;
451: l_request_id igs_en_spa_terms.request_id%TYPE;
452: l_program_application_id igs_en_spa_terms.program_application_id%TYPE;
453: l_program_id igs_en_spa_terms.program_id%TYPE;
454: l_program_update_date igs_en_spa_terms.program_update_date%TYPE;
455: l_person_id igs_en_spa_terms.person_id%TYPE;
456: l_term_cal_type igs_en_spa_terms.term_cal_type%TYPE;
457: l_term_sequence_number igs_en_spa_terms.term_sequence_number%TYPE;

Line 454: l_program_update_date igs_en_spa_terms.program_update_date%TYPE;

450: l_spa_terms_term_record_id igs_en_spa_terms.term_record_id%TYPE;
451: l_request_id igs_en_spa_terms.request_id%TYPE;
452: l_program_application_id igs_en_spa_terms.program_application_id%TYPE;
453: l_program_id igs_en_spa_terms.program_id%TYPE;
454: l_program_update_date igs_en_spa_terms.program_update_date%TYPE;
455: l_person_id igs_en_spa_terms.person_id%TYPE;
456: l_term_cal_type igs_en_spa_terms.term_cal_type%TYPE;
457: l_term_sequence_number igs_en_spa_terms.term_sequence_number%TYPE;
458: l_ci_start_dt DATE;

Line 455: l_person_id igs_en_spa_terms.person_id%TYPE;

451: l_request_id igs_en_spa_terms.request_id%TYPE;
452: l_program_application_id igs_en_spa_terms.program_application_id%TYPE;
453: l_program_id igs_en_spa_terms.program_id%TYPE;
454: l_program_update_date igs_en_spa_terms.program_update_date%TYPE;
455: l_person_id igs_en_spa_terms.person_id%TYPE;
456: l_term_cal_type igs_en_spa_terms.term_cal_type%TYPE;
457: l_term_sequence_number igs_en_spa_terms.term_sequence_number%TYPE;
458: l_ci_start_dt DATE;
459: l_ci_end_dt DATE;

Line 456: l_term_cal_type igs_en_spa_terms.term_cal_type%TYPE;

452: l_program_application_id igs_en_spa_terms.program_application_id%TYPE;
453: l_program_id igs_en_spa_terms.program_id%TYPE;
454: l_program_update_date igs_en_spa_terms.program_update_date%TYPE;
455: l_person_id igs_en_spa_terms.person_id%TYPE;
456: l_term_cal_type igs_en_spa_terms.term_cal_type%TYPE;
457: l_term_sequence_number igs_en_spa_terms.term_sequence_number%TYPE;
458: l_ci_start_dt DATE;
459: l_ci_end_dt DATE;
460: l_class_standing_id igs_en_spa_terms.class_standing_id%TYPE;

Line 457: l_term_sequence_number igs_en_spa_terms.term_sequence_number%TYPE;

453: l_program_id igs_en_spa_terms.program_id%TYPE;
454: l_program_update_date igs_en_spa_terms.program_update_date%TYPE;
455: l_person_id igs_en_spa_terms.person_id%TYPE;
456: l_term_cal_type igs_en_spa_terms.term_cal_type%TYPE;
457: l_term_sequence_number igs_en_spa_terms.term_sequence_number%TYPE;
458: l_ci_start_dt DATE;
459: l_ci_end_dt DATE;
460: l_class_standing_id igs_en_spa_terms.class_standing_id%TYPE;
461: l_coo_id igs_en_spa_terms.coo_id%TYPE;

Line 460: l_class_standing_id igs_en_spa_terms.class_standing_id%TYPE;

456: l_term_cal_type igs_en_spa_terms.term_cal_type%TYPE;
457: l_term_sequence_number igs_en_spa_terms.term_sequence_number%TYPE;
458: l_ci_start_dt DATE;
459: l_ci_end_dt DATE;
460: l_class_standing_id igs_en_spa_terms.class_standing_id%TYPE;
461: l_coo_id igs_en_spa_terms.coo_id%TYPE;
462:
463: BEGIN
464: -- create a save point

Line 461: l_coo_id igs_en_spa_terms.coo_id%TYPE;

457: l_term_sequence_number igs_en_spa_terms.term_sequence_number%TYPE;
458: l_ci_start_dt DATE;
459: l_ci_end_dt DATE;
460: l_class_standing_id igs_en_spa_terms.class_standing_id%TYPE;
461: l_coo_id igs_en_spa_terms.coo_id%TYPE;
462:
463: BEGIN
464: -- create a save point
465: SAVEPOINT create_spa_t_svpt;

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;

Line 600: INSERT INTO igs_en_spa_terms (

596: l_program_update_date := SYSDATE;
597: END IF;
598:
599: -- insert legacy record into spa_terms
600: INSERT INTO igs_en_spa_terms (
601: term_record_id,
602: person_id,
603: program_cd,
604: program_version,