APPS.IGS_PE_TYP_INSTANCES_PKG dependencies on IGS_SC_GEN_001

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

1211: x_org_id=>igs_ge_gen_003.get_org_id,
1212: x_emplmnt_category_code => x_emplmnt_category_code
1213: );
1214: IF (x_mode = 'S') THEN
1215: igs_sc_gen_001.set_ctx('R');
1216: END IF;
1217: insert into IGS_PE_TYP_INSTANCES_ALL (
1218: PERSON_ID
1219: ,COURSE_CD

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

1261: ,NEW_REFERENCES.ORG_ID
1262: ,NEW_REFERENCES.EMPLMNT_CATEGORY_CODE
1263: );
1264: IF (x_mode = 'S') THEN
1265: igs_sc_gen_001.unset_ctx('R');
1266: END IF;
1267:
1268: open c;
1269: fetch c into X_ROWID;

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

1280: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
1281: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
1282: fnd_message.set_token ('ERR_CD', SQLCODE);
1283: igs_ge_msg_stack.add;
1284: igs_sc_gen_001.unset_ctx('R');
1285: app_exception.raise_exception;
1286: ELSE
1287: igs_sc_gen_001.unset_ctx('R');
1288: RAISE;

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

1283: igs_ge_msg_stack.add;
1284: igs_sc_gen_001.unset_ctx('R');
1285: app_exception.raise_exception;
1286: ELSE
1287: igs_sc_gen_001.unset_ctx('R');
1288: RAISE;
1289: END IF;
1290:
1291: end INSERT_ROW;

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

1486: x_last_update_login=>X_LAST_UPDATE_LOGIN,
1487: x_emplmnt_category_code => X_EMPLMNT_CATEGORY_CODE
1488: );
1489: IF (x_mode = 'S') THEN
1490: igs_sc_gen_001.set_ctx('R');
1491: END IF;
1492: update IGS_PE_TYP_INSTANCES_ALL set
1493: PERSON_ID = NEW_REFERENCES.PERSON_ID,
1494: COURSE_CD = NEW_REFERENCES.COURSE_CD,

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

1511: where ROWID = X_ROWID;
1512: if (sql%notfound) then
1513: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1514: igs_ge_msg_stack.add;
1515: igs_sc_gen_001.unset_ctx('R');
1516: app_exception.raise_exception;
1517: end if;
1518: IF (x_mode = 'S') THEN
1519: igs_sc_gen_001.unset_ctx('R');

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

1515: igs_sc_gen_001.unset_ctx('R');
1516: app_exception.raise_exception;
1517: end if;
1518: IF (x_mode = 'S') THEN
1519: igs_sc_gen_001.unset_ctx('R');
1520: END IF;
1521:
1522:
1523: After_DML (

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

1529: IF (SQLCODE = (-28115)) THEN
1530: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1531: fnd_message.set_token ('ERR_CD', SQLCODE);
1532: igs_ge_msg_stack.add;
1533: igs_sc_gen_001.unset_ctx('R');
1534: app_exception.raise_exception;
1535: ELSE
1536: igs_sc_gen_001.unset_ctx('R');
1537: RAISE;

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

1532: igs_ge_msg_stack.add;
1533: igs_sc_gen_001.unset_ctx('R');
1534: app_exception.raise_exception;
1535: ELSE
1536: igs_sc_gen_001.unset_ctx('R');
1537: RAISE;
1538: END IF;
1539:
1540: end UPDATE_ROW;

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

1646: p_action => 'DELETE',
1647: x_rowid => X_ROWID
1648: );
1649: IF (x_mode = 'S') THEN
1650: igs_sc_gen_001.set_ctx('R');
1651: END IF;
1652: delete from IGS_PE_TYP_INSTANCES_ALL
1653: where ROWID = X_ROWID;
1654: if (sql%notfound) then

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

1653: where ROWID = X_ROWID;
1654: if (sql%notfound) then
1655: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1656: igs_ge_msg_stack.add;
1657: igs_sc_gen_001.unset_ctx('R');
1658: app_exception.raise_exception;
1659: end if;
1660: IF (x_mode = 'S') THEN
1661: igs_sc_gen_001.unset_ctx('R');

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

1657: igs_sc_gen_001.unset_ctx('R');
1658: app_exception.raise_exception;
1659: end if;
1660: IF (x_mode = 'S') THEN
1661: igs_sc_gen_001.unset_ctx('R');
1662: END IF;
1663:
1664: After_DML (
1665: p_action => 'DELETE',