APPS.IGS_PS_FACLTY_DISP_PKG dependencies on IGS_SC_GEN_001

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

507: x_last_update_date=>X_LAST_UPDATE_DATE,
508: x_last_updated_by=>X_LAST_UPDATED_BY,
509: x_last_update_login=>X_LAST_UPDATE_LOGIN);
510: IF (x_mode = 'S') THEN
511: igs_sc_gen_001.set_ctx('R');
512: END IF;
513: insert into IGS_PS_FACLTY_DISP (
514: DISPLN_UNIT_ID
515: ,DISPLN_UNIT_TYPE

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

531: ,X_LAST_UPDATED_BY
532: ,X_LAST_UPDATE_LOGIN
533: );
534: IF (x_mode = 'S') THEN
535: igs_sc_gen_001.unset_ctx('R');
536: END IF;
537:
538: open c;
539: fetch c into X_ROWID;

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

550: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
551: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
552: fnd_message.set_token ('ERR_CD', SQLCODE);
553: igs_ge_msg_stack.add;
554: igs_sc_gen_001.unset_ctx('R');
555: app_exception.raise_exception;
556: ELSE
557: igs_sc_gen_001.unset_ctx('R');
558: RAISE;

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

553: igs_ge_msg_stack.add;
554: igs_sc_gen_001.unset_ctx('R');
555: app_exception.raise_exception;
556: ELSE
557: igs_sc_gen_001.unset_ctx('R');
558: RAISE;
559: END IF;
560:
561: end INSERT_ROW;

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

660: x_last_update_date=>X_LAST_UPDATE_DATE,
661: x_last_updated_by=>X_LAST_UPDATED_BY,
662: x_last_update_login=>X_LAST_UPDATE_LOGIN);
663: IF (x_mode = 'S') THEN
664: igs_sc_gen_001.set_ctx('R');
665: END IF;
666: update IGS_PS_FACLTY_DISP set
667: DISPLN_UNIT_TYPE = NEW_REFERENCES.DISPLN_UNIT_TYPE,
668: PERSON_ID = NEW_REFERENCES.PERSON_ID,

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

673: where ROWID = X_ROWID;
674: if (sql%notfound) then
675: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
676: igs_ge_msg_stack.add;
677: igs_sc_gen_001.unset_ctx('R');
678: app_exception.raise_exception;
679: end if;
680: IF (x_mode = 'S') THEN
681: igs_sc_gen_001.unset_ctx('R');

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

677: igs_sc_gen_001.unset_ctx('R');
678: app_exception.raise_exception;
679: end if;
680: IF (x_mode = 'S') THEN
681: igs_sc_gen_001.unset_ctx('R');
682: END IF;
683:
684:
685: After_DML (

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

691: IF (SQLCODE = (-28115)) THEN
692: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
693: fnd_message.set_token ('ERR_CD', SQLCODE);
694: igs_ge_msg_stack.add;
695: igs_sc_gen_001.unset_ctx('R');
696: app_exception.raise_exception;
697: ELSE
698: igs_sc_gen_001.unset_ctx('R');
699: RAISE;

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

694: igs_ge_msg_stack.add;
695: igs_sc_gen_001.unset_ctx('R');
696: app_exception.raise_exception;
697: ELSE
698: igs_sc_gen_001.unset_ctx('R');
699: RAISE;
700: END IF;
701:
702: end UPDATE_ROW;

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

765: p_action => 'DELETE',
766: x_rowid => X_ROWID
767: );
768: IF (x_mode = 'S') THEN
769: igs_sc_gen_001.set_ctx('R');
770: END IF;
771: delete from IGS_PS_FACLTY_DISP
772: where ROWID = X_ROWID;
773: if (sql%notfound) then

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

772: where ROWID = X_ROWID;
773: if (sql%notfound) then
774: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
775: igs_ge_msg_stack.add;
776: igs_sc_gen_001.unset_ctx('R');
777: app_exception.raise_exception;
778: end if;
779: IF (x_mode = 'S') THEN
780: igs_sc_gen_001.unset_ctx('R');

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

776: igs_sc_gen_001.unset_ctx('R');
777: app_exception.raise_exception;
778: end if;
779: IF (x_mode = 'S') THEN
780: igs_sc_gen_001.unset_ctx('R');
781: END IF;
782:
783: After_DML (
784: p_action => 'DELETE',