APPS.IGS_AD_TEST_SEGMENTS_PKG dependencies on IGS_SC_GEN_001

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

718: x_segment_type => x_segment_type,
719: x_segment_group => x_segment_group);
720:
721: IF (x_mode = 'S') THEN
722: igs_sc_gen_001.set_ctx('R');
723: END IF;
724: INSERT INTO IGS_AD_TEST_SEGMENTS (
725: MIN_SCORE
726: ,MAX_SCORE

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

770: ,NEW_REFERENCES.SEGMENT_TYPE
771: ,NEW_REFERENCES.SEGMENT_GROUP
772: )RETURNING TEST_SEGMENT_ID INTO X_TEST_SEGMENT_ID;
773: IF (x_mode = 'S') THEN
774: igs_sc_gen_001.unset_ctx('R');
775: END IF;
776:
777:
778: OPEN c;

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

794: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
795: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
796: fnd_message.set_token ('ERR_CD', SQLCODE);
797: igs_ge_msg_stack.add;
798: igs_sc_gen_001.unset_ctx('R');
799: app_exception.raise_exception;
800: ELSE
801: igs_sc_gen_001.unset_ctx('R');
802: RAISE;

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

797: igs_ge_msg_stack.add;
798: igs_sc_gen_001.unset_ctx('R');
799: app_exception.raise_exception;
800: ELSE
801: igs_sc_gen_001.unset_ctx('R');
802: RAISE;
803: END IF;
804:
805: end INSERT_ROW;

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

980: x_segment_type=>X_SEGMENT_TYPE,
981: x_segment_group=>X_SEGMENT_GROUP);
982:
983: IF (x_mode = 'S') THEN
984: igs_sc_gen_001.set_ctx('R');
985: END IF;
986: update IGS_AD_TEST_SEGMENTS set
987: MIN_SCORE = NEW_REFERENCES.MIN_SCORE,
988: MAX_SCORE = NEW_REFERENCES.MAX_SCORE,

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

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

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

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

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

1025: IF (SQLCODE = (-28115)) THEN
1026: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1027: fnd_message.set_token ('ERR_CD', SQLCODE);
1028: igs_ge_msg_stack.add;
1029: igs_sc_gen_001.unset_ctx('R');
1030: app_exception.raise_exception;
1031: ELSE
1032: igs_sc_gen_001.unset_ctx('R');
1033: RAISE;

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

1028: igs_ge_msg_stack.add;
1029: igs_sc_gen_001.unset_ctx('R');
1030: app_exception.raise_exception;
1031: ELSE
1032: igs_sc_gen_001.unset_ctx('R');
1033: RAISE;
1034: END IF;
1035:
1036: end UPDATE_ROW;

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

1144: p_action => 'DELETE',
1145: x_rowid => X_ROWID
1146: );
1147: IF (x_mode = 'S') THEN
1148: igs_sc_gen_001.set_ctx('R');
1149: END IF;
1150: delete from IGS_AD_TEST_SEGMENTS
1151: where ROWID = X_ROWID;
1152: if (sql%notfound) then

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

1151: where ROWID = X_ROWID;
1152: if (sql%notfound) then
1153: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1154: igs_ge_msg_stack.add;
1155: igs_sc_gen_001.unset_ctx('R');
1156: app_exception.raise_exception;
1157: end if;
1158: IF (x_mode = 'S') THEN
1159: igs_sc_gen_001.unset_ctx('R');

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

1155: igs_sc_gen_001.unset_ctx('R');
1156: app_exception.raise_exception;
1157: end if;
1158: IF (x_mode = 'S') THEN
1159: igs_sc_gen_001.unset_ctx('R');
1160: END IF;
1161:
1162: After_DML (
1163: p_action => 'DELETE',