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_INS_CA_TRNSFR dependencies on IGS_RE_SCHOLARSHIP

Line 513: --This module inserts research IGS_RE_SCHOLARSHIP details as a

509: p_message_name OUT NOCOPY VARCHAR2)
510: RETURN BOOLEAN AS
511:
512: BEGIN -- enrp_ins_sch_trnsfr
513: --This module inserts research IGS_RE_SCHOLARSHIP details as a
514: --result of course transfer.
515: DECLARE
516: cst_enrp_ins_ca_trnsfr CONSTANT VARCHAR2(18) := 'ENRP_INS_CA_TRNSFR';
517: v_sch_exists VARCHAR2(1);

Line 518: v_sch1_scholarship_type IGS_RE_SCHOLARSHIP.scholarship_type%TYPE;

514: --result of course transfer.
515: DECLARE
516: cst_enrp_ins_ca_trnsfr CONSTANT VARCHAR2(18) := 'ENRP_INS_CA_TRNSFR';
517: v_sch_exists VARCHAR2(1);
518: v_sch1_scholarship_type IGS_RE_SCHOLARSHIP.scholarship_type%TYPE;
519: v_sch1_start_dt IGS_RE_SCHOLARSHIP.start_dt%TYPE;
520: v_sch1_end_dt IGS_RE_SCHOLARSHIP.end_dt%TYPE;
521: v_sch1_dollar_value IGS_RE_SCHOLARSHIP.dollar_value%TYPE;
522: v_sch1_description IGS_RE_SCHOLARSHIP.description%TYPE;

Line 519: v_sch1_start_dt IGS_RE_SCHOLARSHIP.start_dt%TYPE;

515: DECLARE
516: cst_enrp_ins_ca_trnsfr CONSTANT VARCHAR2(18) := 'ENRP_INS_CA_TRNSFR';
517: v_sch_exists VARCHAR2(1);
518: v_sch1_scholarship_type IGS_RE_SCHOLARSHIP.scholarship_type%TYPE;
519: v_sch1_start_dt IGS_RE_SCHOLARSHIP.start_dt%TYPE;
520: v_sch1_end_dt IGS_RE_SCHOLARSHIP.end_dt%TYPE;
521: v_sch1_dollar_value IGS_RE_SCHOLARSHIP.dollar_value%TYPE;
522: v_sch1_description IGS_RE_SCHOLARSHIP.description%TYPE;
523: v_sch1_other_benefits IGS_RE_SCHOLARSHIP.other_benefits%TYPE;

Line 520: v_sch1_end_dt IGS_RE_SCHOLARSHIP.end_dt%TYPE;

516: cst_enrp_ins_ca_trnsfr CONSTANT VARCHAR2(18) := 'ENRP_INS_CA_TRNSFR';
517: v_sch_exists VARCHAR2(1);
518: v_sch1_scholarship_type IGS_RE_SCHOLARSHIP.scholarship_type%TYPE;
519: v_sch1_start_dt IGS_RE_SCHOLARSHIP.start_dt%TYPE;
520: v_sch1_end_dt IGS_RE_SCHOLARSHIP.end_dt%TYPE;
521: v_sch1_dollar_value IGS_RE_SCHOLARSHIP.dollar_value%TYPE;
522: v_sch1_description IGS_RE_SCHOLARSHIP.description%TYPE;
523: v_sch1_other_benefits IGS_RE_SCHOLARSHIP.other_benefits%TYPE;
524: v_sch1_conditions IGS_RE_SCHOLARSHIP.conditions%TYPE;

Line 521: v_sch1_dollar_value IGS_RE_SCHOLARSHIP.dollar_value%TYPE;

517: v_sch_exists VARCHAR2(1);
518: v_sch1_scholarship_type IGS_RE_SCHOLARSHIP.scholarship_type%TYPE;
519: v_sch1_start_dt IGS_RE_SCHOLARSHIP.start_dt%TYPE;
520: v_sch1_end_dt IGS_RE_SCHOLARSHIP.end_dt%TYPE;
521: v_sch1_dollar_value IGS_RE_SCHOLARSHIP.dollar_value%TYPE;
522: v_sch1_description IGS_RE_SCHOLARSHIP.description%TYPE;
523: v_sch1_other_benefits IGS_RE_SCHOLARSHIP.other_benefits%TYPE;
524: v_sch1_conditions IGS_RE_SCHOLARSHIP.conditions%TYPE;
525: CURSOR c_sch IS

Line 522: v_sch1_description IGS_RE_SCHOLARSHIP.description%TYPE;

518: v_sch1_scholarship_type IGS_RE_SCHOLARSHIP.scholarship_type%TYPE;
519: v_sch1_start_dt IGS_RE_SCHOLARSHIP.start_dt%TYPE;
520: v_sch1_end_dt IGS_RE_SCHOLARSHIP.end_dt%TYPE;
521: v_sch1_dollar_value IGS_RE_SCHOLARSHIP.dollar_value%TYPE;
522: v_sch1_description IGS_RE_SCHOLARSHIP.description%TYPE;
523: v_sch1_other_benefits IGS_RE_SCHOLARSHIP.other_benefits%TYPE;
524: v_sch1_conditions IGS_RE_SCHOLARSHIP.conditions%TYPE;
525: CURSOR c_sch IS
526: SELECT 'x'

Line 523: v_sch1_other_benefits IGS_RE_SCHOLARSHIP.other_benefits%TYPE;

519: v_sch1_start_dt IGS_RE_SCHOLARSHIP.start_dt%TYPE;
520: v_sch1_end_dt IGS_RE_SCHOLARSHIP.end_dt%TYPE;
521: v_sch1_dollar_value IGS_RE_SCHOLARSHIP.dollar_value%TYPE;
522: v_sch1_description IGS_RE_SCHOLARSHIP.description%TYPE;
523: v_sch1_other_benefits IGS_RE_SCHOLARSHIP.other_benefits%TYPE;
524: v_sch1_conditions IGS_RE_SCHOLARSHIP.conditions%TYPE;
525: CURSOR c_sch IS
526: SELECT 'x'
527: FROM IGS_RE_SCHOLARSHIP sch

Line 524: v_sch1_conditions IGS_RE_SCHOLARSHIP.conditions%TYPE;

520: v_sch1_end_dt IGS_RE_SCHOLARSHIP.end_dt%TYPE;
521: v_sch1_dollar_value IGS_RE_SCHOLARSHIP.dollar_value%TYPE;
522: v_sch1_description IGS_RE_SCHOLARSHIP.description%TYPE;
523: v_sch1_other_benefits IGS_RE_SCHOLARSHIP.other_benefits%TYPE;
524: v_sch1_conditions IGS_RE_SCHOLARSHIP.conditions%TYPE;
525: CURSOR c_sch IS
526: SELECT 'x'
527: FROM IGS_RE_SCHOLARSHIP sch
528: WHERE sch.person_id = p_person_id AND

Line 527: FROM IGS_RE_SCHOLARSHIP sch

523: v_sch1_other_benefits IGS_RE_SCHOLARSHIP.other_benefits%TYPE;
524: v_sch1_conditions IGS_RE_SCHOLARSHIP.conditions%TYPE;
525: CURSOR c_sch IS
526: SELECT 'x'
527: FROM IGS_RE_SCHOLARSHIP sch
528: WHERE sch.person_id = p_person_id AND
529: sch.ca_sequence_number = p_ca_sequence_number;
530: CURSOR c_sch1 IS
531: SELECT sch.scholarship_type,

Line 538: FROM IGS_RE_SCHOLARSHIP sch

534: sch.dollar_value,
535: sch.description,
536: sch.other_benefits,
537: sch.conditions
538: FROM IGS_RE_SCHOLARSHIP sch
539: WHERE sch.person_id = p_person_id AND
540: sch.ca_sequence_number = p_transfer_ca_sequence_number
541: ORDER BY sch.start_dt;
542: BEGIN

Line 551: --Validate that IGS_RE_SCHOLARSHIP details have not already been transferred

547: cst_enrp_ins_ca_trnsfr) = TRUE THEN
548: --Not processing course transfer Candidature, finish processing
549: RETURN TRUE;
550: END IF;
551: --Validate that IGS_RE_SCHOLARSHIP details have not already been transferred
552: OPEN c_sch;
553: FETCH c_sch INTO v_sch_exists;
554: IF c_sch%FOUND THEN
555: CLOSE c_sch;

Line 556: --IGS_RE_SCHOLARSHIP details already exist, cannot transfer

552: OPEN c_sch;
553: FETCH c_sch INTO v_sch_exists;
554: IF c_sch%FOUND THEN
555: CLOSE c_sch;
556: --IGS_RE_SCHOLARSHIP details already exist, cannot transfer
557: p_message_name := 'IGS_RE_SCHOLARSHIP_EXISTS';
558: RETURN FALSE;
559: END IF;
560: CLOSE c_sch;

Line 557: p_message_name := 'IGS_RE_SCHOLARSHIP_EXISTS';

553: FETCH c_sch INTO v_sch_exists;
554: IF c_sch%FOUND THEN
555: CLOSE c_sch;
556: --IGS_RE_SCHOLARSHIP details already exist, cannot transfer
557: p_message_name := 'IGS_RE_SCHOLARSHIP_EXISTS';
558: RETURN FALSE;
559: END IF;
560: CLOSE c_sch;
561: SAVEPOINT sp_scholarship;

Line 562: BEGIN --Insert IGS_RE_SCHOLARSHIP details

558: RETURN FALSE;
559: END IF;
560: CLOSE c_sch;
561: SAVEPOINT sp_scholarship;
562: BEGIN --Insert IGS_RE_SCHOLARSHIP details
563: FOR v_sch1_rec IN c_sch1 LOOP
564:
565: DECLARE
566: l_rowid VARCHAR2(25);

Line 569: IGS_RE_SCHOLARSHIP_PKG.INSERT_ROW(

565: DECLARE
566: l_rowid VARCHAR2(25);
567: l_org_id NUMBER(15) := IGS_GE_GEN_003.GET_ORG_ID;
568: BEGIN
569: IGS_RE_SCHOLARSHIP_PKG.INSERT_ROW(
570: x_rowid => l_rowid,
571: X_org_id => l_org_id,
572: x_person_id => p_person_id,
573: x_ca_sequence_number => p_ca_sequence_number,

Line 584: END LOOP; --(IGS_RE_SCHOLARSHIP)

580: x_conditions => v_sch1_rec.conditions );
581:
582: END;
583:
584: END LOOP; --(IGS_RE_SCHOLARSHIP)
585: EXCEPTION
586: WHEN OTHERS THEN -- (exception)
587: ROLLBACK TO sp_scholarship;
588: p_message_name :='IGS_RE_CANT_INSERT_SCHOLARSHI';