APPS.IGS_AS_SPL_CONS_APPL_PKG dependencies on IGS_SC_GEN_001

Line 535: igs_sc_gen_001.set_ctx('R');

531: x_uoo_id => X_UOO_ID,
532: x_notified_date => X_NOTIFIED_DATE
533: );
534: IF (x_mode = 'S') THEN
535: igs_sc_gen_001.set_ctx('R');
536: END IF;
537: insert into IGS_AS_SPL_CONS_APPL (
538: PERSON_ID,
539: COURSE_CD,

Line 583: igs_sc_gen_001.unset_ctx('R');

579: NEW_REFERENCES.UOO_ID,
580: X_NOTIFIED_DATE
581: );
582: IF (x_mode = 'S') THEN
583: igs_sc_gen_001.unset_ctx('R');
584: END IF;
585:
586: open c;
587: fetch c into X_ROWID;

Line 600: igs_sc_gen_001.unset_ctx('R');

596: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
597: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
598: fnd_message.set_token ('ERR_CD', SQLCODE);
599: igs_ge_msg_stack.add;
600: igs_sc_gen_001.unset_ctx('R');
601: app_exception.raise_exception;
602: ELSE
603: igs_sc_gen_001.unset_ctx('R');
604: RAISE;

Line 603: igs_sc_gen_001.unset_ctx('R');

599: igs_ge_msg_stack.add;
600: igs_sc_gen_001.unset_ctx('R');
601: app_exception.raise_exception;
602: ELSE
603: igs_sc_gen_001.unset_ctx('R');
604: RAISE;
605: END IF;
606:
607: end INSERT_ROW;

Line 741: igs_sc_gen_001.set_ctx('R');

737: x_uoo_id=>X_UOO_ID,
738: x_notified_date => X_NOTIFIED_DATE
739: );
740: IF (x_mode = 'S') THEN
741: igs_sc_gen_001.set_ctx('R');
742: END IF;
743: update IGS_AS_SPL_CONS_APPL set
744: SPCL_CONSIDERATION_CAT = NEW_REFERENCES.SPCL_CONSIDERATION_CAT,
745: SOUGHT_OUTCOME = NEW_REFERENCES.SOUGHT_OUTCOME,

Line 758: igs_sc_gen_001.unset_ctx('R');

754: where ROWID = X_ROWID;
755: if (sql%notfound) then
756: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
757: igs_ge_msg_stack.add;
758: igs_sc_gen_001.unset_ctx('R');
759: app_exception.raise_exception;
760: end if;
761: IF (x_mode = 'S') THEN
762: igs_sc_gen_001.unset_ctx('R');

Line 762: igs_sc_gen_001.unset_ctx('R');

758: igs_sc_gen_001.unset_ctx('R');
759: app_exception.raise_exception;
760: end if;
761: IF (x_mode = 'S') THEN
762: igs_sc_gen_001.unset_ctx('R');
763: END IF;
764:
765:
766: EXCEPTION

Line 772: igs_sc_gen_001.unset_ctx('R');

768: IF (SQLCODE = (-28115)) THEN
769: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
770: fnd_message.set_token ('ERR_CD', SQLCODE);
771: igs_ge_msg_stack.add;
772: igs_sc_gen_001.unset_ctx('R');
773: app_exception.raise_exception;
774: ELSE
775: igs_sc_gen_001.unset_ctx('R');
776: RAISE;

Line 775: igs_sc_gen_001.unset_ctx('R');

771: igs_ge_msg_stack.add;
772: igs_sc_gen_001.unset_ctx('R');
773: app_exception.raise_exception;
774: ELSE
775: igs_sc_gen_001.unset_ctx('R');
776: RAISE;
777: END IF;
778:
779: end UPDATE_ROW;

Line 863: igs_sc_gen_001.set_ctx('R');

859: p_action => 'DELETE',
860: x_rowid => X_ROWID
861: );
862: IF (x_mode = 'S') THEN
863: igs_sc_gen_001.set_ctx('R');
864: END IF;
865: delete from IGS_AS_SPL_CONS_APPL
866: where ROWID = X_ROWID;
867: if (sql%notfound) then

Line 870: igs_sc_gen_001.unset_ctx('R');

866: where ROWID = X_ROWID;
867: if (sql%notfound) then
868: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
869: igs_ge_msg_stack.add;
870: igs_sc_gen_001.unset_ctx('R');
871: app_exception.raise_exception;
872: end if;
873: IF (x_mode = 'S') THEN
874: igs_sc_gen_001.unset_ctx('R');

Line 874: igs_sc_gen_001.unset_ctx('R');

870: igs_sc_gen_001.unset_ctx('R');
871: app_exception.raise_exception;
872: end if;
873: IF (x_mode = 'S') THEN
874: igs_sc_gen_001.unset_ctx('R');
875: END IF;
876:
877:
878: end DELETE_ROW;