APPS.IGS_AD_PS_APLINSTUNT_PKG dependencies on IGS_SC_GEN_001

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

1425: x_last_update_login => X_LAST_UPDATE_LOGIN,
1426: x_adm_ps_appl_inst_unit_id => X_ADM_PS_APPL_INST_UNIT_ID
1427: );
1428: IF (x_mode = 'S') THEN
1429: igs_sc_gen_001.set_ctx('R');
1430: END IF;
1431: insert into IGS_AD_PS_APLINSTUNT_ALL (
1432: ORG_ID,
1433: PERSON_ID,

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

1487: X_PROGRAM_UPDATE_DATE,
1488: IGS_AD_PS_APLINSTUNT_S.NEXTVAL
1489: );
1490: IF (x_mode = 'S') THEN
1491: igs_sc_gen_001.unset_ctx('R');
1492: END IF;
1493:
1494:
1495: open c;

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

1513: -- that the ownerof policy function does not have privilege to access.
1514: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
1515: fnd_message.set_token ('ERR_CD', SQLCODE);
1516: igs_ge_msg_stack.add;
1517: igs_sc_gen_001.unset_ctx('R');
1518: app_exception.raise_exception;
1519: ELSE
1520: igs_sc_gen_001.unset_ctx('R');
1521: RAISE;

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

1516: igs_ge_msg_stack.add;
1517: igs_sc_gen_001.unset_ctx('R');
1518: app_exception.raise_exception;
1519: ELSE
1520: igs_sc_gen_001.unset_ctx('R');
1521: RAISE;
1522: END IF;
1523:
1524: end INSERT_ROW;

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

1705: X_PROGRAM_UPDATE_DATE := SYSDATE;
1706: end if;
1707: end if;
1708: IF (x_mode = 'S') THEN
1709: igs_sc_gen_001.set_ctx('R');
1710: END IF;
1711: update IGS_AD_PS_APLINSTUNT_ALL set
1712: UV_VERSION_NUMBER = NEW_REFERENCES.UV_VERSION_NUMBER,
1713: CAL_TYPE = NEW_REFERENCES.CAL_TYPE,

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

1732: ;
1733: if (sql%notfound) then
1734: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1735: igs_ge_msg_stack.add;
1736: igs_sc_gen_001.unset_ctx('R');
1737: app_exception.raise_exception;
1738: end if;
1739: IF (x_mode = 'S') THEN
1740: igs_sc_gen_001.unset_ctx('R');

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

1736: igs_sc_gen_001.unset_ctx('R');
1737: app_exception.raise_exception;
1738: end if;
1739: IF (x_mode = 'S') THEN
1740: igs_sc_gen_001.unset_ctx('R');
1741: END IF;
1742:
1743: After_DML(
1744: p_action =>'UPDATE',

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

1849: p_action =>'DELETE',
1850: x_rowid => X_ROWID
1851: );
1852: IF (x_mode = 'S') THEN
1853: igs_sc_gen_001.set_ctx('R');
1854: END IF;
1855: delete from IGS_AD_PS_APLINSTUNT_ALL
1856: where ROWID = X_ROWID;
1857: if (sql%notfound) then

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

1856: where ROWID = X_ROWID;
1857: if (sql%notfound) then
1858: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1859: igs_ge_msg_stack.add;
1860: igs_sc_gen_001.unset_ctx('R');
1861: app_exception.raise_exception;
1862: end if;
1863: IF (x_mode = 'S') THEN
1864: igs_sc_gen_001.unset_ctx('R');

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

1860: igs_sc_gen_001.unset_ctx('R');
1861: app_exception.raise_exception;
1862: end if;
1863: IF (x_mode = 'S') THEN
1864: igs_sc_gen_001.unset_ctx('R');
1865: END IF;
1866:
1867: After_DML(
1868: p_action =>'DELETE',