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.

APPS.IGS_PE_PERSENC_EFFCT_PKG dependencies on IGS_PE_PERSENC_EFFCT

Line 1: package body IGS_PE_PERSENC_EFFCT_PKG AS

1: package body IGS_PE_PERSENC_EFFCT_PKG AS
2: /* $Header: IGSNI16B.pls 115.9 2003/02/25 05:14:20 npalanis ship $ */
3:
4: l_rowid VARCHAR2(25);
5:

Line 6: old_references IGS_PE_PERSENC_EFFCT%RowType;

2: /* $Header: IGSNI16B.pls 115.9 2003/02/25 05:14:20 npalanis ship $ */
3:
4: l_rowid VARCHAR2(25);
5:
6: old_references IGS_PE_PERSENC_EFFCT%RowType;
7:
8: new_references IGS_PE_PERSENC_EFFCT%RowType;
9:
10:

Line 8: new_references IGS_PE_PERSENC_EFFCT%RowType;

4: l_rowid VARCHAR2(25);
5:
6: old_references IGS_PE_PERSENC_EFFCT%RowType;
7:
8: new_references IGS_PE_PERSENC_EFFCT%RowType;
9:
10:
11:
12: PROCEDURE Set_Column_Values (

Line 56: FROM IGS_PE_PERSENC_EFFCT

52: CURSOR cur_old_ref_values IS
53:
54: SELECT *
55:
56: FROM IGS_PE_PERSENC_EFFCT
57:
58: WHERE rowid = x_rowid;
59:
60:

Line 458: -- ON IGS_PE_PERSENC_EFFCT

454: -- "OSS_TST".trg_pee_ar_iu
455:
456: -- AFTER INSERT OR UPDATE
457:
458: -- ON IGS_PE_PERSENC_EFFCT
459:
460: -- FOR EACH ROW
461:
462:

Line 618: -- ON IGS_PE_PERSENC_EFFCT

614: -- "OSS_TST".trg_pee_as_iu
615:
616: -- AFTER INSERT OR UPDATE
617:
618: -- ON IGS_PE_PERSENC_EFFCT
619:
620:
621:
622:

Line 787: || Added the call igs_pe_fund_excl_pkg.get_fk_igs_pe_persenc_effct

783: || Known limitations, enhancements or remarks :
784: || Change History :
785: || Who When What
786: || pkpatel 04-OCT-2002 Bug NO: 2600842
787: || Added the call igs_pe_fund_excl_pkg.get_fk_igs_pe_persenc_effct
788: || (reverse chronological order - newest change first)
789: */
790: BEGIN
791:

Line 794: IGS_PE_COURSE_EXCL_PKG.GET_FK_IGS_PE_PERSENC_EFFCT (

790: BEGIN
791:
792:
793:
794: IGS_PE_COURSE_EXCL_PKG.GET_FK_IGS_PE_PERSENC_EFFCT (
795:
796: old_references.person_id,
797:
798: old_references.encumbrance_type,

Line 812: IGS_PE_CRS_GRP_EXCL_PKG.GET_FK_IGS_PE_PERSENC_EFFCT (

808: );
809:
810:
811:
812: IGS_PE_CRS_GRP_EXCL_PKG.GET_FK_IGS_PE_PERSENC_EFFCT (
813:
814: old_references.person_id,
815:
816: old_references.encumbrance_type,

Line 830: IGS_PE_PERS_UNT_EXCL_PKG.GET_FK_IGS_PE_PERSENC_EFFCT (

826: );
827:
828:
829:
830: IGS_PE_PERS_UNT_EXCL_PKG.GET_FK_IGS_PE_PERSENC_EFFCT (
831:
832: old_references.person_id,
833:
834: old_references.encumbrance_type,

Line 848: IGS_PE_UNT_REQUIRMNT_PKG.GET_FK_IGS_PE_PERSENC_EFFCT (

844: );
845:
846:
847:
848: IGS_PE_UNT_REQUIRMNT_PKG.GET_FK_IGS_PE_PERSENC_EFFCT (
849:
850: old_references.person_id,
851:
852: old_references.encumbrance_type,

Line 866: IGS_PE_UNT_SET_EXCL_PKG.GET_FK_IGS_PE_PERSENC_EFFCT (

862: );
863:
864:
865:
866: IGS_PE_UNT_SET_EXCL_PKG.GET_FK_IGS_PE_PERSENC_EFFCT (
867:
868: old_references.person_id,
869:
870: old_references.encumbrance_type,

Line 882: IGS_PE_FUND_EXCL_PKG.GET_FK_IGS_PE_PERSENC_EFFCT (

878: old_references.sequence_number
879:
880: );
881:
882: IGS_PE_FUND_EXCL_PKG.GET_FK_IGS_PE_PERSENC_EFFCT (
883:
884: old_references.person_id,
885:
886: old_references.encumbrance_type,

Line 924: FROM IGS_PE_PERSENC_EFFCT

920: CURSOR cur_rowid IS
921:
922: SELECT rowid
923:
924: FROM IGS_PE_PERSENC_EFFCT
925:
926: WHERE person_id = x_person_id
927:
928: AND encumbrance_type = x_encumbrance_type

Line 972: FROM IGS_PE_PERSENC_EFFCT

968: CURSOR cur_rowid IS
969:
970: SELECT rowid
971:
972: FROM IGS_PE_PERSENC_EFFCT
973:
974: WHERE restricted_attendance_type = x_attendance_type ;
975:
976:

Line 1025: FROM IGS_PE_PERSENC_EFFCT

1021: CURSOR cur_rowid IS
1022:
1023: SELECT rowid
1024:
1025: FROM IGS_PE_PERSENC_EFFCT
1026:
1027: WHERE person_id = x_person_id
1028:
1029: AND encumbrance_type = x_encumbrance_type

Line 1272: cursor C is select ROWID from IGS_PE_PERSENC_EFFCT

1268: X_RESTRICTED_ENROLMENT_CP in NUMBER,
1269: X_RESTRICTED_ATTENDANCE_TYPE in VARCHAR2,
1270: X_MODE in VARCHAR2
1271: ) AS
1272: cursor C is select ROWID from IGS_PE_PERSENC_EFFCT
1273: where PERSON_ID = X_PERSON_ID
1274: and ENCUMBRANCE_TYPE = X_ENCUMBRANCE_TYPE
1275: and PEN_START_DT = X_PEN_START_DT
1276: and S_ENCMB_EFFECT_TYPE = X_S_ENCMB_EFFECT_TYPE

Line 1343: insert into IGS_PE_PERSENC_EFFCT (

1339:
1340: );
1341:
1342:
1343: insert into IGS_PE_PERSENC_EFFCT (
1344: PERSON_ID,
1345: ENCUMBRANCE_TYPE,
1346: PEN_START_DT,
1347: S_ENCMB_EFFECT_TYPE,

Line 1414: from IGS_PE_PERSENC_EFFCT

1410: EXPIRY_DT,
1411: COURSE_CD,
1412: RESTRICTED_ENROLMENT_CP,
1413: RESTRICTED_ATTENDANCE_TYPE
1414: from IGS_PE_PERSENC_EFFCT
1415: where ROWID = X_ROWID
1416: for update nowait;
1417: tlinfo c1%rowtype;
1418:

Line 1531: update IGS_PE_PERSENC_EFFCT set

1527:
1528: );
1529:
1530:
1531: update IGS_PE_PERSENC_EFFCT set
1532: EXPIRY_DT = NEW_REFERENCES.EXPIRY_DT,
1533: COURSE_CD = NEW_REFERENCES.COURSE_CD,
1534: RESTRICTED_ENROLMENT_CP = NEW_REFERENCES.RESTRICTED_ENROLMENT_CP,
1535: RESTRICTED_ATTENDANCE_TYPE = NEW_REFERENCES.RESTRICTED_ATTENDANCE_TYPE,

Line 1570: cursor c1 is select rowid from IGS_PE_PERSENC_EFFCT

1566: X_RESTRICTED_ENROLMENT_CP in NUMBER,
1567: X_RESTRICTED_ATTENDANCE_TYPE in VARCHAR2,
1568: X_MODE in VARCHAR2
1569: ) AS
1570: cursor c1 is select rowid from IGS_PE_PERSENC_EFFCT
1571: where PERSON_ID = X_PERSON_ID
1572: and ENCUMBRANCE_TYPE = X_ENCUMBRANCE_TYPE
1573: and PEN_START_DT = X_PEN_START_DT
1574: and S_ENCMB_EFFECT_TYPE = X_S_ENCMB_EFFECT_TYPE

Line 1628: delete from IGS_PE_PERSENC_EFFCT

1624:
1625: x_rowid => X_ROWID
1626:
1627: );
1628: delete from IGS_PE_PERSENC_EFFCT
1629: where ROWID = X_ROWID;
1630: if (sql%notfound) then
1631: raise no_data_found;
1632: end if;

Line 1643: end IGS_PE_PERSENC_EFFCT_PKG;

1639:
1640: );
1641: end DELETE_ROW;
1642:
1643: end IGS_PE_PERSENC_EFFCT_PKG;