APPS.IGS_AD_TER_EDU_PKG dependencies on IGS_AD_TER_EDU

Line 1: package body IGS_AD_TER_EDU_PKG as

1: package body IGS_AD_TER_EDU_PKG as
2: /* $Header: IGSAI54B.pls 115.6 2003/10/30 13:20:48 rghosh ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AD_TER_EDU%RowType;

Line 5: old_references IGS_AD_TER_EDU%RowType;

1: package body IGS_AD_TER_EDU_PKG as
2: /* $Header: IGSAI54B.pls 115.6 2003/10/30 13:20:48 rghosh ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AD_TER_EDU%RowType;
6: new_references IGS_AD_TER_EDU%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_AD_TER_EDU%RowType;

2: /* $Header: IGSAI54B.pls 115.6 2003/10/30 13:20:48 rghosh ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AD_TER_EDU%RowType;
6: new_references IGS_AD_TER_EDU%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 43: FROM IGS_AD_TER_EDU

39: ) as
40:
41: CURSOR cur_old_ref_values IS
42: SELECT *
43: FROM IGS_AD_TER_EDU
44: WHERE rowid = x_rowid;
45:
46: BEGIN
47:

Line 496: IGS_AD_TER_ED_UNI_AT_PKG.GET_FK_IGS_AD_TER_EDU (

492:
493: PROCEDURE Check_Child_Existance AS
494: BEGIN
495:
496: IGS_AD_TER_ED_UNI_AT_PKG.GET_FK_IGS_AD_TER_EDU (
497: old_references.person_id,
498: old_references.sequence_number
499: );
500:

Line 510: FROM IGS_AD_TER_EDU

506: )return BOOLEAN AS
507:
508: CURSOR cur_rowid IS
509: SELECT rowid
510: FROM IGS_AD_TER_EDU
511: WHERE person_id = x_person_id
512: AND sequence_number = x_sequence_number
513: FOR UPDATE NOWAIT;
514:

Line 537: FROM IGS_AD_TER_EDU

533: ) AS
534:
535: CURSOR cur_rowid IS
536: SELECT rowid
537: FROM IGS_AD_TER_EDU
538: WHERE country_cd = x_country_cd ;
539:
540: lv_rowid cur_rowid%RowType;
541:

Line 564: FROM IGS_AD_TER_EDU

560: ) AS
561:
562: CURSOR cur_rowid IS
563: SELECT rowid
564: FROM IGS_AD_TER_EDU
565: WHERE honours_level = x_honours_level ;
566:
567: lv_rowid cur_rowid%RowType;
568:

Line 590: FROM IGS_AD_TER_EDU

586: ) AS
587:
588: CURSOR cur_rowid IS
589: SELECT rowid
590: FROM IGS_AD_TER_EDU
591: WHERE institution_cd = x_institution_cd ;
592:
593: lv_rowid cur_rowid%RowType;
594:

Line 616: FROM IGS_AD_TER_EDU

612: ) AS
613:
614: CURSOR cur_rowid IS
615: SELECT rowid
616: FROM IGS_AD_TER_EDU
617: WHERE language_component = x_language_cd
618: OR language_of_tuition = x_language_cd ;
619:
620: lv_rowid cur_rowid%RowType;

Line 644: FROM IGS_AD_TER_EDU

640: ) AS
641:
642: CURSOR cur_rowid IS
643: SELECT rowid
644: FROM IGS_AD_TER_EDU
645: WHERE person_id = x_person_id ;
646:
647: lv_rowid cur_rowid%RowType;
648:

Line 664: PROCEDURE GET_FK_IGS_AD_TER_EDU_LV_COM (

660: Close cur_rowid;
661:
662: END GET_FK_IGS_PE_PERSON;
663:
664: PROCEDURE GET_FK_IGS_AD_TER_EDU_LV_COM (
665: x_tertiary_edu_lvl_comp IN VARCHAR2
666: ) AS
667:
668: CURSOR cur_rowid IS

Line 670: FROM IGS_AD_TER_EDU

666: ) AS
667:
668: CURSOR cur_rowid IS
669: SELECT rowid
670: FROM IGS_AD_TER_EDU
671: WHERE tertiary_edu_lvl_comp = x_tertiary_edu_lvl_comp ;
672:
673: lv_rowid cur_rowid%RowType;
674:

Line 688: END GET_FK_IGS_AD_TER_EDU_LV_COM;

684: Return;
685: END IF;
686: Close cur_rowid;
687:
688: END GET_FK_IGS_AD_TER_EDU_LV_COM;
689:
690: PROCEDURE GET_FK_IGS_AD_TER_EDU_LVL_QF (
691: x_tertiary_edu_lvl_qual IN VARCHAR2
692: ) AS

Line 690: PROCEDURE GET_FK_IGS_AD_TER_EDU_LVL_QF (

686: Close cur_rowid;
687:
688: END GET_FK_IGS_AD_TER_EDU_LV_COM;
689:
690: PROCEDURE GET_FK_IGS_AD_TER_EDU_LVL_QF (
691: x_tertiary_edu_lvl_qual IN VARCHAR2
692: ) AS
693:
694: CURSOR cur_rowid IS

Line 696: FROM IGS_AD_TER_EDU

692: ) AS
693:
694: CURSOR cur_rowid IS
695: SELECT rowid
696: FROM IGS_AD_TER_EDU
697: WHERE tertiary_edu_lvl_qual = x_tertiary_edu_lvl_qual ;
698:
699: lv_rowid cur_rowid%RowType;
700:

Line 714: END GET_FK_IGS_AD_TER_EDU_LVL_QF;

710: Return;
711: END IF;
712: Close cur_rowid;
713:
714: END GET_FK_IGS_AD_TER_EDU_LVL_QF;
715:
716: PROCEDURE Before_DML (
717: p_action IN VARCHAR2,
718: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 855: cursor C is select ROWID from IGS_AD_TER_EDU

851: X_COUNTRY_CD in VARCHAR2,
852: X_NOTES in VARCHAR2,
853: X_MODE in VARCHAR2 default 'R'
854: ) as
855: cursor C is select ROWID from IGS_AD_TER_EDU
856: where PERSON_ID = X_PERSON_ID
857: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER;
858: X_LAST_UPDATE_DATE DATE;
859: X_LAST_UPDATED_BY NUMBER;

Line 930: insert into IGS_AD_TER_EDU (

926: x_last_update_date => X_LAST_UPDATE_DATE,
927: x_last_updated_by => X_LAST_UPDATED_BY,
928: x_last_update_login => X_LAST_UPDATE_LOGIN
929: );
930: insert into IGS_AD_TER_EDU (
931: PERSON_ID,
932: SEQUENCE_NUMBER,
933: TERTIARY_EDU_LVL_COMP,
934: EXCLUSION_IND,

Line 1060: from IGS_AD_TER_EDU

1056: LANGUAGE_OF_TUITION,
1057: STATE_CD,
1058: COUNTRY_CD,
1059: NOTES
1060: from IGS_AD_TER_EDU
1061: where ROWID = X_ROWID
1062: for update nowait;
1063: tlinfo c1%rowtype;
1064:

Line 1245: update IGS_AD_TER_EDU set

1241: X_PROGRAM_UPDATE_DATE := SYSDATE;
1242: end if;
1243: end if;
1244:
1245: update IGS_AD_TER_EDU set
1246: TERTIARY_EDU_LVL_COMP = NEW_REFERENCES.TERTIARY_EDU_LVL_COMP,
1247: EXCLUSION_IND = NEW_REFERENCES.EXCLUSION_IND,
1248: INSTITUTION_CD = NEW_REFERENCES.INSTITUTION_CD,
1249: INSTITUTION_NAME = NEW_REFERENCES.INSTITUTION_NAME,

Line 1312: cursor c1 is select rowid from IGS_AD_TER_EDU

1308: X_COUNTRY_CD in VARCHAR2,
1309: X_NOTES in VARCHAR2,
1310: X_MODE in VARCHAR2 default 'R'
1311: ) as
1312: cursor c1 is select rowid from IGS_AD_TER_EDU
1313: where PERSON_ID = X_PERSON_ID
1314: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER
1315: ;
1316: begin

Line 1386: delete from IGS_AD_TER_EDU

1382: Before_DML (
1383: p_action => 'DELETE',
1384: x_rowid => X_ROWID
1385: );
1386: delete from IGS_AD_TER_EDU
1387: where ROWID = X_ROWID;
1388: if (sql%notfound) then
1389: raise no_data_found;
1390: end if;

Line 1397: end IGS_AD_TER_EDU_PKG;

1393: x_rowid => X_ROWID
1394: );
1395: end DELETE_ROW;
1396:
1397: end IGS_AD_TER_EDU_PKG;