eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGS_AD_TRANSCRIPT_PKG dependencies on IGS_AD_TRANSCRIPT

Line 1: PACKAGE BODY igs_ad_transcript_pkg AS

1: PACKAGE BODY igs_ad_transcript_pkg AS
2: /* $Header: IGSAI82B.pls 120.2 2005/10/01 21:47:23 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_transcript%RowType;
5: new_references igs_ad_transcript%RowType;

Line 4: old_references igs_ad_transcript%RowType;

1: PACKAGE BODY igs_ad_transcript_pkg AS
2: /* $Header: IGSAI82B.pls 120.2 2005/10/01 21:47:23 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_transcript%RowType;
5: new_references igs_ad_transcript%RowType;
6: l_transcript_id igs_ad_transcript.transcript_id%TYPE;
7:
8: PROCEDURE check_uniqueness AS

Line 5: new_references igs_ad_transcript%RowType;

1: PACKAGE BODY igs_ad_transcript_pkg AS
2: /* $Header: IGSAI82B.pls 120.2 2005/10/01 21:47:23 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_transcript%RowType;
5: new_references igs_ad_transcript%RowType;
6: l_transcript_id igs_ad_transcript.transcript_id%TYPE;
7:
8: PROCEDURE check_uniqueness AS
9: /*

Line 6: l_transcript_id igs_ad_transcript.transcript_id%TYPE;

2: /* $Header: IGSAI82B.pls 120.2 2005/10/01 21:47:23 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_transcript%RowType;
5: new_references igs_ad_transcript%RowType;
6: l_transcript_id igs_ad_transcript.transcript_id%TYPE;
7:
8: PROCEDURE check_uniqueness AS
9: /*
10: || Created By : [email protected]

Line 19: SELECT 'A' FROM IGS_AD_TRANSCRIPT_V TRANS WHERE EDUCATION_ID = cp_education_id

15: || Who When What
16: || (reverse chronological order - newest change first)
17: */
18: CURSOR check_issuedate(cp_education_id IN NUMBER,cp_date_of_issue IN DATE) IS
19: SELECT 'A' FROM IGS_AD_TRANSCRIPT_V TRANS WHERE EDUCATION_ID = cp_education_id
20: AND DATE_OF_ISSUE = cp_date_of_issue
21: AND (new_references.transcript_id IS NULL OR new_references.transcript_id <> trans.transcript_id);
22: l_temp VARCHAR2(1);
23:

Line 126: FROM IGS_AD_TRANSCRIPT

122: ***************************************************************/
123:
124: CURSOR cur_old_ref_values IS
125: SELECT *
126: FROM IGS_AD_TRANSCRIPT
127: WHERE rowid = x_rowid;
128:
129: BEGIN
130:

Line 322: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TRANSCRIPT_TYPE'));

318: IF Upper(Column_Name) = 'TRANSCRIPT_TYPE' OR
319: Column_Name IS NULL THEN
320: IF NOT (new_references.transcript_type in ('OFFICIAL','UNOFFICIAL')) THEN
321: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
322: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TRANSCRIPT_TYPE'));
323: IGS_GE_MSG_STACK.ADD;
324: App_Exception.Raise_Exception;
325: END IF;
326: END IF;

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 461: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TRANSCRIPT_TYPE'));

457: 'TRANSCRIPT_TYPE',
458: new_references.transcript_type
459: ) THEN
460: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
461: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TRANSCRIPT_TYPE'));
462: IGS_GE_MSG_STACK.ADD;
463: App_Exception.Raise_Exception;
464: END IF;
465:

Line 482: Igs_Ad_Term_Details_Pkg.Get_FK_Igs_Ad_Transcript (

478: ***************************************************************/
479:
480: BEGIN
481:
482: Igs_Ad_Term_Details_Pkg.Get_FK_Igs_Ad_Transcript (
483: old_references.transcript_id
484: );
485:
486: END Check_Child_Existance;

Line 505: FROM igs_ad_transcript

501: ***************************************************************/
502:
503: CURSOR cur_rowid IS
504: SELECT rowid
505: FROM igs_ad_transcript
506: WHERE transcript_id = x_transcript_id
507: FOR UPDATE NOWAIT;
508:
509: lv_rowid cur_rowid%RowType;

Line 541: FROM igs_ad_transcript

537: ***************************************************************/
538:
539: CURSOR cur_rowid IS
540: SELECT rowid
541: FROM igs_ad_transcript
542: WHERE education_id = x_education_id ;
543:
544: lv_rowid cur_rowid%RowType;
545:

Line 579: FROM igs_ad_transcript

575: ***************************************************************/
576:
577: CURSOR cur_rowid IS
578: SELECT rowid
579: FROM igs_ad_transcript
580: WHERE conv_gs_id = x_code_id ;
581:
582: lv_rowid cur_rowid%RowType;
583:

Line 586: FROM igs_ad_transcript

582: lv_rowid cur_rowid%RowType;
583:
584: CURSOR cur_rowid2 IS
585: SELECT rowid
586: FROM igs_ad_transcript
587: WHERE transcript_source = x_code_id ;
588:
589: lv_rowid2 cur_rowid2%RowType;
590:

Line 593: FROM igs_ad_transcript

589: lv_rowid2 cur_rowid2%RowType;
590:
591: CURSOR cur_rowid3 IS
592: SELECT rowid
593: FROM igs_ad_transcript
594: WHERE entered_gs_id = x_code_id ;
595:
596: lv_rowid3 cur_rowid3%RowType;
597:

Line 790: IF IGS_AD_TRANSCRIPT_PKG.TRN_CRT_MODE = 'NI' THEN

786: l_rowid := x_rowid;
787:
788: IF (p_action = 'INSERT') THEN
789: -- Call all the procedures related to After Insert.
790: IF IGS_AD_TRANSCRIPT_PKG.TRN_CRT_MODE = 'NI' THEN
791: OPEN c_person_id(new_references.education_id);
792: FETCH c_person_id INTO person_id_rec;
793: CLOSE c_person_id;
794: igs_ad_wf_001.transcript_entrd_event(

Line 871: cursor C is select ROWID from IGS_AD_TRANSCRIPT

867: override_id and override_date
868: Bug No : 2097333
869: ***************************************************************/
870:
871: cursor C is select ROWID from IGS_AD_TRANSCRIPT
872: where TRANSCRIPT_ID= X_TRANSCRIPT_ID
873: ;
874: X_LAST_UPDATE_DATE DATE ;
875: X_LAST_UPDATED_BY NUMBER ;

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 960: insert into IGS_AD_TRANSCRIPT (

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
963: ,TRANSCRIPT_ID
964: ,EDUCATION_ID

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 1133: from IGS_AD_TRANSCRIPT

1129: , DATE_OF_ISSUE
1130: -- Added for new field Ravishar / 14-sep-2004
1131: , CORE_CURRICULUM_VALUE
1132:
1133: from IGS_AD_TRANSCRIPT
1134: where ROWID = X_ROWID
1135: for update nowait;
1136: tlinfo c1%rowtype;
1137: begin

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,

Line 1449: cursor c1 is select ROWID from IGS_AD_TRANSCRIPT

1445: Bug No: 2097333
1446:
1447: ***************************************************************/
1448:
1449: cursor c1 is select ROWID from IGS_AD_TRANSCRIPT
1450: where TRANSCRIPT_ID= X_TRANSCRIPT_ID
1451: ;
1452: L_MODE VARCHAR2(1);
1453: begin

Line 1545: delete from IGS_AD_TRANSCRIPT

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
1548: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1549: igs_ge_msg_stack.add;

Line 1562: END igs_ad_transcript_pkg;

1558: p_action => 'DELETE',
1559: x_rowid => X_ROWID
1560: );
1561: end DELETE_ROW;
1562: END igs_ad_transcript_pkg;