APPS.IGS_AV_STND_UNIT_PKG dependencies on IGS_SC_GEN_001

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

1365: X_DEG_AUD_DETAIL_ID => X_DEG_AUD_DETAIL_ID
1366: );
1367:
1368: IF (x_mode = 'S') THEN
1369: igs_sc_gen_001.set_ctx('R');
1370: END IF;
1371: INSERT INTO IGS_AV_STND_UNIT_ALL (
1372: PERSON_ID,
1373: AS_COURSE_CD,

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

1449: X_PROGRAM_UPDATE_DATE,
1450: NEW_REFERENCES.DEG_AUD_DETAIL_ID
1451: );
1452: IF (x_mode = 'S') THEN
1453: igs_sc_gen_001.unset_ctx('R');
1454: END IF;
1455:
1456: open c1;
1457: fetch c1 into X_ROWID;

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

1470: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
1471: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
1472: fnd_message.set_token ('ERR_CD', SQLCODE);
1473: igs_ge_msg_stack.add;
1474: igs_sc_gen_001.unset_ctx('R');
1475: app_exception.raise_exception;
1476: ELSE
1477: igs_sc_gen_001.unset_ctx('R');
1478: RAISE;

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

1473: igs_ge_msg_stack.add;
1474: igs_sc_gen_001.unset_ctx('R');
1475: app_exception.raise_exception;
1476: ELSE
1477: igs_sc_gen_001.unset_ctx('R');
1478: RAISE;
1479: END IF;
1480:
1481: end INSERT_ROW;

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

1695: end if ;
1696: end if;
1697:
1698: IF (x_mode = 'S') THEN
1699: igs_sc_gen_001.set_ctx('R');
1700: END IF;
1701: UPDATE IGS_AV_STND_UNIT_ALL SET
1702: S_ADV_STND_GRANTING_STATUS = X_S_ADV_STND_GRANTING_STATUS,
1703: CREDIT_PERCENTAGE = NULL,

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

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

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

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

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

1748: IF (SQLCODE = (-28115)) THEN
1749: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1750: fnd_message.set_token ('ERR_CD', SQLCODE);
1751: igs_ge_msg_stack.add;
1752: igs_sc_gen_001.unset_ctx('R');
1753: app_exception.raise_exception;
1754: ELSE
1755: igs_sc_gen_001.unset_ctx('R');
1756: RAISE;

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

1751: igs_ge_msg_stack.add;
1752: igs_sc_gen_001.unset_ctx('R');
1753: app_exception.raise_exception;
1754: ELSE
1755: igs_sc_gen_001.unset_ctx('R');
1756: RAISE;
1757: END IF;
1758:
1759: end UPDATE_ROW;

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

1879: p_action => 'DELETE',
1880: x_rowid => X_ROWID
1881: );
1882: IF (x_mode = 'S') THEN
1883: igs_sc_gen_001.set_ctx('R');
1884: END IF;
1885: delete from IGS_AV_STND_UNIT_ALL
1886: where ROWID = X_ROWID ;
1887: if (sql%notfound) then

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

1886: where ROWID = X_ROWID ;
1887: if (sql%notfound) then
1888: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1889: igs_ge_msg_stack.add;
1890: igs_sc_gen_001.unset_ctx('R');
1891: app_exception.raise_exception;
1892: end if;
1893: IF (x_mode = 'S') THEN
1894: igs_sc_gen_001.unset_ctx('R');

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

1890: igs_sc_gen_001.unset_ctx('R');
1891: app_exception.raise_exception;
1892: end if;
1893: IF (x_mode = 'S') THEN
1894: igs_sc_gen_001.unset_ctx('R');
1895: END IF;
1896:
1897: After_DML(
1898: p_action => 'DELETE',