APPS.IGS_AD_TRANSCRIPT_PKG dependencies on IGS_SC_GEN_001

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

954: SELECT IGS_AD_TRANSCRIPT_S.NEXTVAL INTO L_TRANSCRIPT_ID FROM DUAL;
955: END IF;
956:
957: IF (x_mode = 'S') THEN
958: igs_sc_gen_001.set_ctx('R');
959: END IF;
960: insert into IGS_AD_TRANSCRIPT (
961: QUINTILE_RANK
962: ,PERCENTILE_RANK

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

1030: ,NEW_REFERENCES.CORE_CURRICULUM_VALUE
1031:
1032: )RETURNING TRANSCRIPT_ID INTO X_TRANSCRIPT_ID;
1033: IF (x_mode = 'S') THEN
1034: igs_sc_gen_001.unset_ctx('R');
1035: END IF;
1036:
1037: l_transcript_id := X_TRANSCRIPT_ID;
1038: open c;

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

1050: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
1051: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
1052: fnd_message.set_token ('ERR_CD', SQLCODE);
1053: igs_ge_msg_stack.add;
1054: igs_sc_gen_001.unset_ctx('R');
1055: app_exception.raise_exception;
1056: ELSE
1057: igs_sc_gen_001.unset_ctx('R');
1058: RAISE;

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

1053: igs_ge_msg_stack.add;
1054: igs_sc_gen_001.unset_ctx('R');
1055: app_exception.raise_exception;
1056: ELSE
1057: igs_sc_gen_001.unset_ctx('R');
1058: RAISE;
1059: END IF;
1060:
1061: end INSERT_ROW;

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

1334: end if;
1335: end if;
1336:
1337: IF (x_mode = 'S') THEN
1338: igs_sc_gen_001.set_ctx('R');
1339: END IF;
1340: update IGS_AD_TRANSCRIPT set
1341: QUINTILE_RANK = NEW_REFERENCES.QUINTILE_RANK,
1342: PERCENTILE_RANK = NEW_REFERENCES.PERCENTILE_RANK,

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

1372: where ROWID = X_ROWID;
1373: if (sql%notfound) then
1374: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1375: igs_ge_msg_stack.add;
1376: igs_sc_gen_001.unset_ctx('R');
1377: app_exception.raise_exception;
1378: end if;
1379: IF (x_mode = 'S') THEN
1380: igs_sc_gen_001.unset_ctx('R');

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

1376: igs_sc_gen_001.unset_ctx('R');
1377: app_exception.raise_exception;
1378: end if;
1379: IF (x_mode = 'S') THEN
1380: igs_sc_gen_001.unset_ctx('R');
1381: END IF;
1382:
1383:
1384: After_DML (

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

1390: IF (SQLCODE = (-28115)) THEN
1391: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1392: fnd_message.set_token ('ERR_CD', SQLCODE);
1393: igs_ge_msg_stack.add;
1394: igs_sc_gen_001.unset_ctx('R');
1395: app_exception.raise_exception;
1396: ELSE
1397: igs_sc_gen_001.unset_ctx('R');
1398: RAISE;

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

1393: igs_ge_msg_stack.add;
1394: igs_sc_gen_001.unset_ctx('R');
1395: app_exception.raise_exception;
1396: ELSE
1397: igs_sc_gen_001.unset_ctx('R');
1398: RAISE;
1399: END IF;
1400:
1401: end UPDATE_ROW;

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

1539: p_action => 'DELETE',
1540: x_rowid => X_ROWID
1541: );
1542: IF (x_mode = 'S') THEN
1543: igs_sc_gen_001.set_ctx('R');
1544: END IF;
1545: delete from IGS_AD_TRANSCRIPT
1546: where ROWID = X_ROWID;
1547: if (sql%notfound) then

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

1546: where ROWID = X_ROWID;
1547: if (sql%notfound) then
1548: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1549: igs_ge_msg_stack.add;
1550: igs_sc_gen_001.unset_ctx('R');
1551: app_exception.raise_exception;
1552: end if;
1553: IF (x_mode = 'S') THEN
1554: igs_sc_gen_001.unset_ctx('R');

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

1550: igs_sc_gen_001.unset_ctx('R');
1551: app_exception.raise_exception;
1552: end if;
1553: IF (x_mode = 'S') THEN
1554: igs_sc_gen_001.unset_ctx('R');
1555: END IF;
1556:
1557: After_DML (
1558: p_action => 'DELETE',