APPS.IGS_AD_TRANSCRIPT_PKG dependencies on IGS_AD_TRANSCRIPT_S

Line 407: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TRANSCRIPT_SOURCE'));

403: 'TRANSCRIPT_SOURCE',
404: 'N'
405: ) THEN
406: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
407: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TRANSCRIPT_SOURCE'));
408: IGS_GE_MSG_STACK.ADD;
409: App_Exception.Raise_Exception;
410: END IF;
411:

Line 447: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TRANSCRIPT_STATUS'));

443: 'TRANSCRIPT_STATUS',
444: new_references.transcript_status
445: ) THEN
446: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
447: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TRANSCRIPT_STATUS'));
448: IGS_GE_MSG_STACK.ADD;
449: App_Exception.Raise_Exception;
450: END IF;
451:

Line 954: SELECT IGS_AD_TRANSCRIPT_S.NEXTVAL INTO L_TRANSCRIPT_ID FROM DUAL;

950:
951: IF X_TRANSCRIPT_ID IS NOT NULL THEN
952: L_TRANSCRIPT_ID:= X_TRANSCRIPT_ID;
953: ELSE
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');

Line 999: ,L_TRANSCRIPT_ID --IGS_AD_TRANSCRIPT_S.NEXTVAL

995:
996: ) values (
997: NEW_REFERENCES.QUINTILE_RANK
998: ,NEW_REFERENCES.PERCENTILE_RANK
999: ,L_TRANSCRIPT_ID --IGS_AD_TRANSCRIPT_S.NEXTVAL
1000: ,NEW_REFERENCES.EDUCATION_ID
1001: ,NEW_REFERENCES.TRANSCRIPT_STATUS
1002: ,NEW_REFERENCES.TRANSCRIPT_SOURCE
1003: ,NEW_REFERENCES.DATE_OF_RECEIPT

Line 1340: update IGS_AD_TRANSCRIPT set

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,
1343: EDUCATION_ID = NEW_REFERENCES.EDUCATION_ID,
1344: TRANSCRIPT_STATUS = NEW_REFERENCES.TRANSCRIPT_STATUS,