APPS.IGS_AS_SU_SETATMPT_PKG dependencies on IGS_SC_GEN_001

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

1513: x_attribute20=>X_ATTRIBUTE20
1514: );
1515: --
1516: IF (x_mode = 'S') THEN
1517: igs_sc_gen_001.set_ctx('R');
1518: END IF;
1519: INSERT INTO IGS_AS_SU_SETATMPT (
1520: PERSON_ID,
1521: COURSE_CD,

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

1619: NEW_REFERENCES.ATTRIBUTE19,
1620: NEW_REFERENCES.ATTRIBUTE20
1621: );
1622: IF (x_mode = 'S') THEN
1623: igs_sc_gen_001.unset_ctx('R');
1624: END IF;
1625:
1626: OPEN c;
1627: FETCH c INTO X_ROWID;

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

1641: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
1642: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
1643: fnd_message.set_token ('ERR_CD', SQLCODE);
1644: igs_ge_msg_stack.add;
1645: igs_sc_gen_001.unset_ctx('R');
1646: app_exception.raise_exception;
1647: ELSE
1648: igs_sc_gen_001.unset_ctx('R');
1649: RAISE;

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

1644: igs_ge_msg_stack.add;
1645: igs_sc_gen_001.unset_ctx('R');
1646: app_exception.raise_exception;
1647: ELSE
1648: igs_sc_gen_001.unset_ctx('R');
1649: RAISE;
1650: END IF;
1651:
1652: END INSERT_ROW;

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

1993: --
1994: --
1995: END IF;
1996: IF (x_mode = 'S') THEN
1997: igs_sc_gen_001.set_ctx('R');
1998: END IF;
1999: UPDATE IGS_AS_SU_SETATMPT SET
2000: US_VERSION_NUMBER = NEW_REFERENCES.US_VERSION_NUMBER,
2001: SELECTION_DT = NEW_REFERENCES.SELECTION_DT,

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

2044: WHERE ROWID = X_ROWID;
2045: IF (SQL%NOTFOUND) THEN
2046: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
2047: igs_ge_msg_stack.add;
2048: igs_sc_gen_001.unset_ctx('R');
2049: app_exception.raise_exception;
2050: END IF;
2051: IF (x_mode = 'S') THEN
2052: igs_sc_gen_001.unset_ctx('R');

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

2048: igs_sc_gen_001.unset_ctx('R');
2049: app_exception.raise_exception;
2050: END IF;
2051: IF (x_mode = 'S') THEN
2052: igs_sc_gen_001.unset_ctx('R');
2053: END IF;
2054:
2055: --
2056: After_DML(

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

2063: IF (SQLCODE = (-28115)) THEN
2064: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
2065: fnd_message.set_token ('ERR_CD', SQLCODE);
2066: igs_ge_msg_stack.add;
2067: igs_sc_gen_001.unset_ctx('R');
2068: app_exception.raise_exception;
2069: ELSE
2070: igs_sc_gen_001.unset_ctx('R');
2071: RAISE;

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

2066: igs_ge_msg_stack.add;
2067: igs_sc_gen_001.unset_ctx('R');
2068: app_exception.raise_exception;
2069: ELSE
2070: igs_sc_gen_001.unset_ctx('R');
2071: RAISE;
2072: END IF;
2073:
2074: END UPDATE_ROW;

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

2230: x_rowid => X_ROWID
2231: );
2232: --
2233: IF (x_mode = 'S') THEN
2234: igs_sc_gen_001.set_ctx('R');
2235: END IF;
2236: DELETE FROM IGS_AS_SU_SETATMPT
2237: WHERE ROWID = X_ROWID;
2238: IF (SQL%NOTFOUND) THEN

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

2237: WHERE ROWID = X_ROWID;
2238: IF (SQL%NOTFOUND) THEN
2239: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
2240: igs_ge_msg_stack.add;
2241: igs_sc_gen_001.unset_ctx('R');
2242: app_exception.raise_exception;
2243: END IF;
2244: IF (x_mode = 'S') THEN
2245: igs_sc_gen_001.unset_ctx('R');

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

2241: igs_sc_gen_001.unset_ctx('R');
2242: app_exception.raise_exception;
2243: END IF;
2244: IF (x_mode = 'S') THEN
2245: igs_sc_gen_001.unset_ctx('R');
2246: END IF;
2247:
2248: --
2249: After_DML(