APPS.IGS_PE_PRIV_LEVEL_PKG dependencies on IGS_SC_GEN_001

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

544: x_last_update_date=>X_LAST_UPDATE_DATE,
545: x_last_updated_by=>X_LAST_UPDATED_BY,
546: x_last_update_login=>X_LAST_UPDATE_LOGIN);
547: IF (x_mode = 'S') THEN
548: igs_sc_gen_001.set_ctx('R');
549: END IF;
550: insert into IGS_PE_PRIV_LEVEL (
551: PRIVACY_LEVEL_ID
552: ,PERSON_ID

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

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

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

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

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

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

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

747: x_last_update_date=>X_LAST_UPDATE_DATE,
748: x_last_updated_by=>X_LAST_UPDATED_BY,
749: x_last_update_login=>X_LAST_UPDATE_LOGIN);
750: IF (x_mode = 'S') THEN
751: igs_sc_gen_001.set_ctx('R');
752: END IF;
753: update IGS_PE_PRIV_LEVEL set
754: PERSON_ID = NEW_REFERENCES.PERSON_ID,
755: DATA_GROUP = NEW_REFERENCES.DATA_GROUP,

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

765: where ROWID = X_ROWID;
766: if (sql%notfound) then
767: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
768: igs_ge_msg_stack.add;
769: igs_sc_gen_001.unset_ctx('R');
770: app_exception.raise_exception;
771: end if;
772: IF (x_mode = 'S') THEN
773: igs_sc_gen_001.unset_ctx('R');

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

769: igs_sc_gen_001.unset_ctx('R');
770: app_exception.raise_exception;
771: end if;
772: IF (x_mode = 'S') THEN
773: igs_sc_gen_001.unset_ctx('R');
774: END IF;
775:
776:
777: After_DML (

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

783: IF (SQLCODE = (-28115)) THEN
784: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
785: fnd_message.set_token ('ERR_CD', SQLCODE);
786: igs_ge_msg_stack.add;
787: igs_sc_gen_001.unset_ctx('R');
788: app_exception.raise_exception;
789: ELSE
790: igs_sc_gen_001.unset_ctx('R');
791: RAISE;

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

786: igs_ge_msg_stack.add;
787: igs_sc_gen_001.unset_ctx('R');
788: app_exception.raise_exception;
789: ELSE
790: igs_sc_gen_001.unset_ctx('R');
791: RAISE;
792: END IF;
793:
794: end UPDATE_ROW;

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

881: p_action => 'DELETE',
882: x_rowid => X_ROWID
883: );
884: IF (x_mode = 'S') THEN
885: igs_sc_gen_001.set_ctx('R');
886: END IF;
887: delete from IGS_PE_PRIV_LEVEL
888: where ROWID = X_ROWID;
889: if (sql%notfound) then

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

888: where ROWID = X_ROWID;
889: if (sql%notfound) then
890: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
891: igs_ge_msg_stack.add;
892: igs_sc_gen_001.unset_ctx('R');
893: app_exception.raise_exception;
894: end if;
895: IF (x_mode = 'S') THEN
896: igs_sc_gen_001.unset_ctx('R');

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

892: igs_sc_gen_001.unset_ctx('R');
893: app_exception.raise_exception;
894: end if;
895: IF (x_mode = 'S') THEN
896: igs_sc_gen_001.unset_ctx('R');
897: END IF;
898:
899: After_DML (
900: p_action => 'DELETE',