APPS.IGS_AD_HZ_ACAD_HIST_PKG dependencies on IGS_SC_GEN_001

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

618: );
619:
620:
621: IF (x_mode = 'S') THEN
622: igs_sc_gen_001.set_ctx('R');
623: END IF;
624: INSERT INTO igs_ad_hz_acad_hist (
625: recalc_total_cp_attempted,
626: recalc_total_cp_earned,

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

730: x_program_update_date,
731: x_program_id
732: )RETURNING HZ_ACAD_HIST_ID INTO X_HZ_ACAD_HIST_ID;
733: IF (x_mode = 'S') THEN
734: igs_sc_gen_001.unset_ctx('R');
735: END IF;
736:
737:
738: OPEN c;

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

749: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
750: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
751: fnd_message.set_token ('ERR_CD', SQLCODE);
752: igs_ge_msg_stack.add;
753: igs_sc_gen_001.unset_ctx('R');
754: app_exception.raise_exception;
755: ELSE
756: igs_sc_gen_001.unset_ctx('R');
757: RAISE;

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

752: igs_ge_msg_stack.add;
753: igs_sc_gen_001.unset_ctx('R');
754: app_exception.raise_exception;
755: ELSE
756: igs_sc_gen_001.unset_ctx('R');
757: RAISE;
758: END IF;
759: END insert_row;
760:

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

1097: x_last_update_login => x_last_update_login
1098: );
1099:
1100: IF (x_mode = 'S') THEN
1101: igs_sc_gen_001.set_ctx('R');
1102: END IF;
1103: UPDATE igs_ad_hz_acad_hist
1104: SET
1105: recalc_total_cp_attempted = new_references.recalc_total_cp_attempted,

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

1157:
1158: IF (SQL%NOTFOUND) THEN
1159: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1160: igs_ge_msg_stack.add;
1161: igs_sc_gen_001.unset_ctx('R');
1162: app_exception.raise_exception;
1163: END IF;
1164: IF (x_mode = 'S') THEN
1165: igs_sc_gen_001.unset_ctx('R');

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

1161: igs_sc_gen_001.unset_ctx('R');
1162: app_exception.raise_exception;
1163: END IF;
1164: IF (x_mode = 'S') THEN
1165: igs_sc_gen_001.unset_ctx('R');
1166: END IF;
1167:
1168:
1169:

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

1172: IF (SQLCODE = (-28115)) THEN
1173: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1174: fnd_message.set_token ('ERR_CD', SQLCODE);
1175: igs_ge_msg_stack.add;
1176: igs_sc_gen_001.unset_ctx('R');
1177: app_exception.raise_exception;
1178: ELSE
1179: igs_sc_gen_001.unset_ctx('R');
1180: RAISE;

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

1175: igs_ge_msg_stack.add;
1176: igs_sc_gen_001.unset_ctx('R');
1177: app_exception.raise_exception;
1178: ELSE
1179: igs_sc_gen_001.unset_ctx('R');
1180: RAISE;
1181: END IF;
1182: END update_row;
1183:

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

1380: x_rowid => x_rowid
1381: );
1382:
1383: IF (x_mode = 'S') THEN
1384: igs_sc_gen_001.set_ctx('R');
1385: END IF;
1386: DELETE FROM igs_ad_hz_acad_hist
1387: WHERE rowid = x_rowid;
1388:

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

1388:
1389: IF (SQL%NOTFOUND) THEN
1390: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1391: igs_ge_msg_stack.add;
1392: igs_sc_gen_001.unset_ctx('R');
1393: app_exception.raise_exception;
1394: END IF;
1395: IF (x_mode = 'S') THEN
1396: igs_sc_gen_001.unset_ctx('R');

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

1392: igs_sc_gen_001.unset_ctx('R');
1393: app_exception.raise_exception;
1394: END IF;
1395: IF (x_mode = 'S') THEN
1396: igs_sc_gen_001.unset_ctx('R');
1397: END IF;
1398:
1399:
1400: END delete_row;