APPS.IGS_AS_SU_STMPTOUT_PKG dependencies on IGS_SC_GEN_001

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

1224: x_manual_override_flag => x_manual_override_flag,
1225: x_show_on_academic_histry_flag => x_show_on_academic_histry_flag
1226: );
1227: IF (x_mode = 'S') THEN
1228: igs_sc_gen_001.set_ctx('R');
1229: END IF;
1230: INSERT INTO igs_as_su_stmptout_all
1231: (org_id, person_id, course_cd, unit_cd,
1232: cal_type, ci_sequence_number, ci_start_dt,

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

1270: new_references.incomp_default_mark, new_references.comments, new_references.uoo_id,
1271: new_references.mark_capped_flag, new_references.release_date, new_references.manual_override_flag,
1272: new_references.show_on_academic_histry_flag);
1273: IF (x_mode = 'S') THEN
1274: igs_sc_gen_001.unset_ctx('R');
1275: END IF;
1276:
1277: OPEN c;
1278: FETCH c INTO x_rowid;

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

1288: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
1289: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
1290: fnd_message.set_token ('ERR_CD', SQLCODE);
1291: igs_ge_msg_stack.add;
1292: igs_sc_gen_001.unset_ctx('R');
1293: app_exception.raise_exception;
1294: ELSE
1295: igs_sc_gen_001.unset_ctx('R');
1296: RAISE;

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

1291: igs_ge_msg_stack.add;
1292: igs_sc_gen_001.unset_ctx('R');
1293: app_exception.raise_exception;
1294: ELSE
1295: igs_sc_gen_001.unset_ctx('R');
1296: RAISE;
1297: END IF;
1298: END insert_row;
1299:

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

1773: x_program_update_date := SYSDATE;
1774: END IF;
1775: END IF;
1776: IF (x_mode = 'S') THEN
1777: igs_sc_gen_001.set_ctx('R');
1778: END IF;
1779: UPDATE igs_as_su_stmptout_all
1780: SET ci_start_dt = new_references.ci_start_dt,
1781: ci_end_dt = new_references.ci_end_dt,

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

1832: WHERE ROWID = x_rowid;
1833: IF (SQL%NOTFOUND) THEN
1834: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1835: igs_ge_msg_stack.add;
1836: igs_sc_gen_001.unset_ctx('R');
1837: app_exception.raise_exception;
1838: END IF;
1839: IF (x_mode = 'S') THEN
1840: igs_sc_gen_001.unset_ctx('R');

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

1836: igs_sc_gen_001.unset_ctx('R');
1837: app_exception.raise_exception;
1838: END IF;
1839: IF (x_mode = 'S') THEN
1840: igs_sc_gen_001.unset_ctx('R');
1841: END IF;
1842:
1843: after_dml (p_action => 'UPDATE', x_rowid => x_rowid);
1844:

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

1847: IF (SQLCODE = (-28115)) THEN
1848: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1849: fnd_message.set_token ('ERR_CD', SQLCODE);
1850: igs_ge_msg_stack.add;
1851: igs_sc_gen_001.unset_ctx('R');
1852: app_exception.raise_exception;
1853: ELSE
1854: igs_sc_gen_001.unset_ctx('R');
1855: RAISE;

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

1850: igs_ge_msg_stack.add;
1851: igs_sc_gen_001.unset_ctx('R');
1852: app_exception.raise_exception;
1853: ELSE
1854: igs_sc_gen_001.unset_ctx('R');
1855: RAISE;
1856: END IF;
1857: END update_row;
1858:

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

2048: x_mode IN VARCHAR2) AS
2049: BEGIN
2050: before_dml (p_action => 'DELETE', x_rowid => x_rowid);
2051: IF (x_mode = 'S') THEN
2052: igs_sc_gen_001.set_ctx('R');
2053: END IF;
2054: DELETE FROM igs_as_su_stmptout_all
2055: WHERE ROWID = x_rowid;
2056: IF (SQL%NOTFOUND) THEN

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

2055: WHERE ROWID = x_rowid;
2056: IF (SQL%NOTFOUND) THEN
2057: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
2058: igs_ge_msg_stack.add;
2059: igs_sc_gen_001.unset_ctx('R');
2060: app_exception.raise_exception;
2061: END IF;
2062: IF (x_mode = 'S') THEN
2063: igs_sc_gen_001.unset_ctx('R');

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

2059: igs_sc_gen_001.unset_ctx('R');
2060: app_exception.raise_exception;
2061: END IF;
2062: IF (x_mode = 'S') THEN
2063: igs_sc_gen_001.unset_ctx('R');
2064: END IF;
2065:
2066: after_dml (p_action => 'DELETE', x_rowid => x_rowid);
2067: END delete_row;