APPS.IGS_AV_STND_UNIT_LVL_PKG dependencies on IGS_SC_GEN_001

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

1276: X_UNIT_LEVEL_MARK => X_UNIT_LEVEL_MARK
1277: );
1278:
1279: IF (x_mode = 'S') THEN
1280: igs_sc_gen_001.set_ctx('R');
1281: END IF;
1282: insert into IGS_AV_STND_UNIT_LVL_ALL (
1283: PERSON_ID,
1284: AS_COURSE_CD,

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

1352: NEW_REFERENCES.QUAL_DETS_ID,
1353: NEW_REFERENCES.UNIT_LEVEL_MARK
1354: );
1355: IF (x_mode = 'S') THEN
1356: igs_sc_gen_001.unset_ctx('R');
1357: END IF;
1358:
1359:
1360: open c;

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

1373: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
1374: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
1375: fnd_message.set_token ('ERR_CD', SQLCODE);
1376: igs_ge_msg_stack.add;
1377: igs_sc_gen_001.unset_ctx('R');
1378: app_exception.raise_exception;
1379: ELSE
1380: igs_sc_gen_001.unset_ctx('R');
1381: RAISE;

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

1376: igs_ge_msg_stack.add;
1377: igs_sc_gen_001.unset_ctx('R');
1378: app_exception.raise_exception;
1379: ELSE
1380: igs_sc_gen_001.unset_ctx('R');
1381: RAISE;
1382: END IF;
1383:
1384: end INSERT_ROW;

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

1603: end if ;
1604: end if ;
1605:
1606: IF (x_mode = 'S') THEN
1607: igs_sc_gen_001.set_ctx('R');
1608: END IF;
1609: UPDATE IGS_AV_STND_UNIT_LVL_ALL SET
1610: S_ADV_STND_GRANTING_STATUS = NEW_REFERENCES.S_ADV_STND_GRANTING_STATUS,
1611: CREDIT_POINTS = NEW_REFERENCES.CREDIT_POINTS,

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

1634: where rowid = X_ROWID ;
1635: if (sql%notfound) then
1636: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1637: igs_ge_msg_stack.add;
1638: igs_sc_gen_001.unset_ctx('R');
1639: app_exception.raise_exception;
1640: end if;
1641: IF (x_mode = 'S') THEN
1642: igs_sc_gen_001.unset_ctx('R');

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

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

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

1651: IF (SQLCODE = (-28115)) THEN
1652: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1653: fnd_message.set_token ('ERR_CD', SQLCODE);
1654: igs_ge_msg_stack.add;
1655: igs_sc_gen_001.unset_ctx('R');
1656: app_exception.raise_exception;
1657: ELSE
1658: igs_sc_gen_001.unset_ctx('R');
1659: RAISE;

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

1654: igs_ge_msg_stack.add;
1655: igs_sc_gen_001.unset_ctx('R');
1656: app_exception.raise_exception;
1657: ELSE
1658: igs_sc_gen_001.unset_ctx('R');
1659: RAISE;
1660: END IF;
1661: end UPDATE_ROW;
1662:

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

1774: p_action => 'DELETE',
1775: x_rowid => X_ROWID
1776: );
1777: IF (x_mode = 'S') THEN
1778: igs_sc_gen_001.set_ctx('R');
1779: END IF;
1780: delete from IGS_AV_STND_UNIT_LVL_ALL
1781: where ROWID = X_ROWID ;
1782: if (sql%notfound) then

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

1781: where ROWID = X_ROWID ;
1782: if (sql%notfound) then
1783: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1784: igs_ge_msg_stack.add;
1785: igs_sc_gen_001.unset_ctx('R');
1786: app_exception.raise_exception;
1787: end if;
1788: IF (x_mode = 'S') THEN
1789: igs_sc_gen_001.unset_ctx('R');

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

1785: igs_sc_gen_001.unset_ctx('R');
1786: app_exception.raise_exception;
1787: end if;
1788: IF (x_mode = 'S') THEN
1789: igs_sc_gen_001.unset_ctx('R');
1790: END IF;
1791:
1792: After_DML(
1793: p_action => 'DELETE',