APPS.IGS_AD_APPL_PKG dependencies on IGS_SC_GEN_001

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

1300: x_appl_fee_amt => x_appl_fee_amt
1301: );
1302:
1303: IF (x_mode = 'S') THEN
1304: igs_sc_gen_001.set_ctx('R');
1305: END IF;
1306: insert into IGS_AD_APPL_ALL (
1307: PERSON_ID,
1308: ORG_ID,

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

1368: new_references.alt_appl_id,
1369: new_references.appl_fee_amt
1370: );
1371: IF (x_mode = 'S') THEN
1372: igs_sc_gen_001.unset_ctx('R');
1373: END IF;
1374:
1375:
1376: open c;

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

1386: );
1387: EXCEPTION
1388: WHEN OTHERS THEN
1389: IF (x_mode = 'S') THEN
1390: igs_sc_gen_001.unset_ctx('R');
1391: END IF;
1392: IF SQLCODE = '-28115' OR SQLCODE = '-28113' OR SQLCODE = '-28111' THEN
1393: -- Code to handle Security Policy error raised
1394: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.

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

1603:
1604: /* Removed the Commencement Period details (Acad and Adm calendars) from the update statement
1605: as they should not be allowed to update for an existing application. Bug: 2772337 */
1606: IF (x_mode = 'S') THEN
1607: igs_sc_gen_001.set_ctx('R');
1608: END IF;
1609: update IGS_AD_APPL_ALL set
1610: APPL_DT = NEW_REFERENCES.APPL_DT,
1611: ADM_APPL_STATUS = NEW_REFERENCES.ADM_APPL_STATUS,

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

1631: if (sql%notfound) then
1632: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1633: igs_ge_msg_stack.add;
1634: IF (x_mode = 'S') THEN
1635: igs_sc_gen_001.unset_ctx('R');
1636: END IF;
1637: app_exception.raise_exception;
1638: end if;
1639: IF (x_mode = 'S') THEN

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

1636: END IF;
1637: app_exception.raise_exception;
1638: end if;
1639: IF (x_mode = 'S') THEN
1640: igs_sc_gen_001.unset_ctx('R');
1641: END IF;
1642:
1643: After_DML (
1644: p_action => 'UPDATE',

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

1646: );
1647: EXCEPTION
1648: WHEN OTHERS THEN
1649: IF (x_mode = 'S') THEN
1650: igs_sc_gen_001.unset_ctx('R');
1651: END IF;
1652: IF SQLCODE = '-28115' OR SQLCODE = '-28113' OR SQLCODE = '-28111' THEN
1653: -- Code to handle Security Policy error raised
1654: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.

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

1762: x_rowid => X_ROWID
1763: );
1764:
1765: IF (x_mode = 'S') THEN
1766: igs_sc_gen_001.set_ctx('R');
1767: END IF;
1768: delete from IGS_AD_APPL_ALL
1769: where ROWID = X_ROWID;
1770: if (sql%notfound) then

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

1770: if (sql%notfound) then
1771: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1772: igs_ge_msg_stack.add;
1773: IF (x_mode = 'S') THEN
1774: igs_sc_gen_001.unset_ctx('R');
1775: END IF;
1776: app_exception.raise_exception;
1777: end if;
1778: IF (x_mode = 'S') THEN

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

1775: END IF;
1776: app_exception.raise_exception;
1777: end if;
1778: IF (x_mode = 'S') THEN
1779: igs_sc_gen_001.unset_ctx('R');
1780: END IF;
1781:
1782: After_DML (
1783: p_action => 'DELETE',

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

1785: );
1786: EXCEPTION
1787: WHEN OTHERS THEN
1788: IF (x_mode = 'S') THEN
1789: igs_sc_gen_001.unset_ctx('R');
1790: END IF;
1791: IF SQLCODE = '-28115' OR SQLCODE = '-28113' OR SQLCODE = '-28111' THEN
1792: -- Code to handle Security Policy error raised
1793: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.