APPS.IGS_AD_TERM_UNITDTLS_PKG dependencies on IGS_SC_GEN_001

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

635: x_last_updated_by=>X_LAST_UPDATED_BY,
636: x_last_update_login=>X_LAST_UPDATE_LOGIN);
637:
638: IF (x_mode = 'S') THEN
639: igs_sc_gen_001.set_ctx('R');
640: END IF;
641: insert into IGS_AD_TERM_UNITDTLS (
642: UNIT_DETAILS_ID
643: ,TERM_DETAILS_ID

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

679: ,X_PROGRAM_APPLICATION_ID
680: ,X_PROGRAM_UPDATE_DATE
681: )RETURNING UNIT_DETAILS_ID INTO X_UNIT_DETAILS_ID ;
682: IF (x_mode = 'S') THEN
683: igs_sc_gen_001.unset_ctx('R');
684: END IF;
685:
686: open c;
687: fetch c into X_ROWID;

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

698: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
699: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
700: fnd_message.set_token ('ERR_CD', SQLCODE);
701: igs_ge_msg_stack.add;
702: igs_sc_gen_001.unset_ctx('R');
703: app_exception.raise_exception;
704: ELSE
705: igs_sc_gen_001.unset_ctx('R');
706: RAISE;

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

701: igs_ge_msg_stack.add;
702: igs_sc_gen_001.unset_ctx('R');
703: app_exception.raise_exception;
704: ELSE
705: igs_sc_gen_001.unset_ctx('R');
706: RAISE;
707: END IF;
708:
709: end INSERT_ROW;

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

867: end if;
868: end if;
869:
870: IF (x_mode = 'S') THEN
871: igs_sc_gen_001.set_ctx('R');
872: END IF;
873: UPDATE IGS_AD_TERM_UNITDTLS SET
874: TERM_DETAILS_ID = NEW_REFERENCES.TERM_DETAILS_ID,
875: UNIT = NEW_REFERENCES.UNIT,

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

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

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

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

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

907: IF (SQLCODE = (-28115)) THEN
908: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
909: fnd_message.set_token ('ERR_CD', SQLCODE);
910: igs_ge_msg_stack.add;
911: igs_sc_gen_001.unset_ctx('R');
912: app_exception.raise_exception;
913: ELSE
914: igs_sc_gen_001.unset_ctx('R');
915: RAISE;

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

910: igs_ge_msg_stack.add;
911: igs_sc_gen_001.unset_ctx('R');
912: app_exception.raise_exception;
913: ELSE
914: igs_sc_gen_001.unset_ctx('R');
915: RAISE;
916: END IF;
917:
918: end UPDATE_ROW;

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

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

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

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

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

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