APPS.IGS_AS_SU_ATMPT_ITM_PKG dependencies on IGS_SC_GEN_001

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

897: x_penalty_applied_flag => x_penalty_applied_flag
898: );
899:
900: IF (x_mode = 'S') THEN
901: igs_sc_gen_001.set_ctx('R');
902: END IF;
903: INSERT INTO igs_as_su_atmpt_itm
904: (person_id, course_cd, unit_cd, cal_type,
905: ci_sequence_number, ass_id, creation_dt,

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

941: new_references.midterm_weight_qty, new_references.final_mandatory_type_code,
942: new_references.final_weight_qty, new_references.submitted_date, new_references.waived_flag,
943: new_references.penalty_applied_flag);
944: IF (x_mode = 'S') THEN
945: igs_sc_gen_001.unset_ctx('R');
946: END IF;
947:
948: OPEN c;
949: FETCH c INTO x_rowid;

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

959: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
960: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
961: fnd_message.set_token ('ERR_CD', SQLCODE);
962: igs_ge_msg_stack.add;
963: igs_sc_gen_001.unset_ctx('R');
964: app_exception.raise_exception;
965: ELSE
966: igs_sc_gen_001.unset_ctx('R');
967: RAISE;

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

962: igs_ge_msg_stack.add;
963: igs_sc_gen_001.unset_ctx('R');
964: app_exception.raise_exception;
965: ELSE
966: igs_sc_gen_001.unset_ctx('R');
967: RAISE;
968: END IF;
969: END insert_row;
970:

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

1458: x_program_update_date := SYSDATE;
1459: END IF;
1460: END IF;
1461: IF (x_mode = 'S') THEN
1462: igs_sc_gen_001.set_ctx('R');
1463: END IF;
1464: UPDATE igs_as_su_atmpt_itm
1465: SET attempt_number = new_references.attempt_number,
1466: outcome_dt = new_references.outcome_dt,

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

1515: WHERE ROWID = x_rowid;
1516: IF (SQL%NOTFOUND) THEN
1517: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1518: igs_ge_msg_stack.add;
1519: igs_sc_gen_001.unset_ctx('R');
1520: app_exception.raise_exception;
1521: END IF;
1522: IF (x_mode = 'S') THEN
1523: igs_sc_gen_001.unset_ctx('R');

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

1519: igs_sc_gen_001.unset_ctx('R');
1520: app_exception.raise_exception;
1521: END IF;
1522: IF (x_mode = 'S') THEN
1523: igs_sc_gen_001.unset_ctx('R');
1524: END IF;
1525:
1526: after_dml (p_action => 'UPDATE', x_rowid => x_rowid);
1527:

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

1530: IF (SQLCODE = (-28115)) THEN
1531: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1532: fnd_message.set_token ('ERR_CD', SQLCODE);
1533: igs_ge_msg_stack.add;
1534: igs_sc_gen_001.unset_ctx('R');
1535: app_exception.raise_exception;
1536: ELSE
1537: igs_sc_gen_001.unset_ctx('R');
1538: RAISE;

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

1533: igs_ge_msg_stack.add;
1534: igs_sc_gen_001.unset_ctx('R');
1535: app_exception.raise_exception;
1536: ELSE
1537: igs_sc_gen_001.unset_ctx('R');
1538: RAISE;
1539: END IF;
1540: END update_row;
1541:

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

1726: x_mode IN VARCHAR2) AS
1727: BEGIN
1728: before_dml (p_action => 'DELETE', x_rowid => x_rowid);
1729: IF (x_mode = 'S') THEN
1730: igs_sc_gen_001.set_ctx('R');
1731: END IF;
1732: DELETE FROM igs_as_su_atmpt_itm
1733: WHERE ROWID = x_rowid;
1734: IF (SQL%NOTFOUND) THEN

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

1733: WHERE ROWID = x_rowid;
1734: IF (SQL%NOTFOUND) THEN
1735: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1736: igs_ge_msg_stack.add;
1737: igs_sc_gen_001.unset_ctx('R');
1738: app_exception.raise_exception;
1739: END IF;
1740: IF (x_mode = 'S') THEN
1741: igs_sc_gen_001.unset_ctx('R');

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

1737: igs_sc_gen_001.unset_ctx('R');
1738: app_exception.raise_exception;
1739: END IF;
1740: IF (x_mode = 'S') THEN
1741: igs_sc_gen_001.unset_ctx('R');
1742: END IF;
1743:
1744: after_dml (p_action => 'DELETE', x_rowid => x_rowid);
1745: END delete_row;