APPS.IGS_AD_APPL_PGMAPPRV_PKG dependencies on IGS_SC_GEN_001

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

594: x_last_update_date=>X_LAST_UPDATE_DATE,
595: x_last_updated_by=>X_LAST_UPDATED_BY,
596: x_last_update_login=>X_LAST_UPDATE_LOGIN);
597: IF (x_mode = 'S') THEN
598: igs_sc_gen_001.set_ctx('R');
599: END IF;
600:
601: insert into IGS_AD_APPL_PGMAPPRV (
602: APPL_PGMAPPRV_ID

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

641: ,X_PROGRAM_APPLICATION_ID
642: ,X_PROGRAM_UPDATE_DATE
643: )RETURNING APPL_PGMAPPRV_ID INTO X_APPL_PGMAPPRV_ID;
644: IF (x_mode = 'S') THEN
645: igs_sc_gen_001.unset_ctx('R');
646: END IF;
647:
648: open c;
649: fetch c into X_ROWID;

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

660: NULL;
661: EXCEPTION
662: WHEN OTHERS THEN
663: IF (x_mode = 'S') THEN
664: igs_sc_gen_001.unset_ctx('R');
665: END IF;
666: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
667: -- Code to handle Security Policy error raised
668: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.

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

851: end if;
852: end if;
853:
854: IF (x_mode = 'S') THEN
855: igs_sc_gen_001.set_ctx('R');
856: END IF;
857: update IGS_AD_APPL_PGMAPPRV set
858: PERSON_ID = NEW_REFERENCES.PERSON_ID,
859: ADMISSION_APPL_NUMBER = NEW_REFERENCES.ADMISSION_APPL_NUMBER,

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

875: where ROWID = X_ROWID;
876: if (sql%notfound) then
877: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
878: igs_ge_msg_stack.add;
879: igs_sc_gen_001.unset_ctx('R');
880: app_exception.raise_exception;
881: end if;
882: IF (x_mode = 'S') THEN
883: igs_sc_gen_001.unset_ctx('R');

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

879: igs_sc_gen_001.unset_ctx('R');
880: app_exception.raise_exception;
881: end if;
882: IF (x_mode = 'S') THEN
883: igs_sc_gen_001.unset_ctx('R');
884: END IF;
885:
886:
887: After_DML (

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

996: p_action => 'DELETE',
997: x_rowid => X_ROWID
998: );
999: IF (x_mode = 'S') THEN
1000: igs_sc_gen_001.set_ctx('R');
1001: END IF;
1002: delete from IGS_AD_APPL_PGMAPPRV
1003: where ROWID = X_ROWID;
1004: if (sql%notfound) then

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

1003: where ROWID = X_ROWID;
1004: if (sql%notfound) then
1005: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1006: igs_ge_msg_stack.add;
1007: igs_sc_gen_001.unset_ctx('R');
1008: app_exception.raise_exception;
1009: end if;
1010: IF (x_mode = 'S') THEN
1011: igs_sc_gen_001.unset_ctx('R');

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

1007: igs_sc_gen_001.unset_ctx('R');
1008: app_exception.raise_exception;
1009: end if;
1010: IF (x_mode = 'S') THEN
1011: igs_sc_gen_001.unset_ctx('R');
1012: END IF;
1013:
1014: After_DML (
1015: p_action => 'DELETE',