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_PS_OFR_PAT_PKG dependencies on IGS_PS_OFR_PAT

Line 1: package body IGS_PS_OFR_PAT_PKG AS

1: package body IGS_PS_OFR_PAT_PKG AS
2: /* $Header: IGSPI25B.pls 115.7 2002/11/29 02:13:15 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_OFR_PAT%RowType;

Line 5: old_references IGS_PS_OFR_PAT%RowType;

1: package body IGS_PS_OFR_PAT_PKG AS
2: /* $Header: IGSPI25B.pls 115.7 2002/11/29 02:13:15 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_OFR_PAT%RowType;
6: new_references IGS_PS_OFR_PAT%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_PS_OFR_PAT%RowType;

2: /* $Header: IGSPI25B.pls 115.7 2002/11/29 02:13:15 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_OFR_PAT%RowType;
6: new_references IGS_PS_OFR_PAT%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 45: FROM IGS_PS_OFR_PAT

41: ) AS
42:
43: CURSOR cur_old_ref_values IS
44: SELECT *
45: FROM IGS_PS_OFR_PAT
46: WHERE rowid = x_rowid;
47:
48: BEGIN
49:

Line 106: -- BEFORE INSERT OR UPDATE OR DELETE ON IGS_PS_OFR_PAT

102: END Set_Column_Values;
103:
104: -- Trigger description :-
105: -- "OSS_TST".TRG_COP_BR_IUD
106: -- BEFORE INSERT OR UPDATE OR DELETE ON IGS_PS_OFR_PAT
107: -- REFERENCING
108: -- NEW AS NEW
109: -- OLD AS OLD
110: -- FOR EACH ROW

Line 120: v_cal_type IGS_PS_OFR_PAT.cal_type%TYPE;

116: ) AS
117: v_message_name VARCHAR2(30);
118: v_course_cd IGS_PS_VER.course_cd%TYPE;
119: v_version_number IGS_PS_VER.version_number%TYPE;
120: v_cal_type IGS_PS_OFR_PAT.cal_type%TYPE;
121: v_ci_sequence_number IGS_PS_OFR_PAT.ci_sequence_number%TYPE;
122: BEGIN
123:
124: -- Set IGS_PS_OFR_OPT key.

Line 121: v_ci_sequence_number IGS_PS_OFR_PAT.ci_sequence_number%TYPE;

117: v_message_name VARCHAR2(30);
118: v_course_cd IGS_PS_VER.course_cd%TYPE;
119: v_version_number IGS_PS_VER.version_number%TYPE;
120: v_cal_type IGS_PS_OFR_PAT.cal_type%TYPE;
121: v_ci_sequence_number IGS_PS_OFR_PAT.ci_sequence_number%TYPE;
122: BEGIN
123:
124: -- Set IGS_PS_OFR_OPT key.
125: IF p_inserting THEN

Line 566: IGS_PS_OFR_PAT_NOTE_PKG.GET_UFK_IGS_PS_OFR_PAT(

562:
563: PROCEDURE Check_Child_Existance AS
564: BEGIN
565:
566: IGS_PS_OFR_PAT_NOTE_PKG.GET_UFK_IGS_PS_OFR_PAT(
567: old_references.cop_id
568: );
569:
570: IGS_PS_OFR_PAT_NOTE_PKG.GET_FK_IGS_PS_OFR_PAT(

Line 570: IGS_PS_OFR_PAT_NOTE_PKG.GET_FK_IGS_PS_OFR_PAT(

566: IGS_PS_OFR_PAT_NOTE_PKG.GET_UFK_IGS_PS_OFR_PAT(
567: old_references.cop_id
568: );
569:
570: IGS_PS_OFR_PAT_NOTE_PKG.GET_FK_IGS_PS_OFR_PAT(
571: old_references.course_cd,
572: old_references.version_number,
573: old_references.cal_type,
574: old_references.ci_sequence_number,

Line 588: IGS_PS_OFR_PAT_NOTE_PKG.GET_UFK_IGS_PS_OFR_PAT(old_references.cop_id

584: IF (((old_references.cop_id = new_references.cop_id)) OR
585: ((old_references.cop_id IS NULL)))THEN
586: NULL;
587: ELSE
588: IGS_PS_OFR_PAT_NOTE_PKG.GET_UFK_IGS_PS_OFR_PAT(old_references.cop_id
589: );
590: END IF;
591: END Check_UK_Child_Existance;
592:

Line 605: FROM IGS_PS_OFR_PAT

601: ) RETURN BOOLEAN AS
602:
603: CURSOR cur_rowid IS
604: SELECT rowid
605: FROM IGS_PS_OFR_PAT
606: WHERE course_cd = x_course_cd
607: AND version_number = x_version_number
608: AND cal_type = x_cal_type
609: AND ci_sequence_number = x_ci_sequence_number

Line 637: FROM IGS_PS_OFR_PAT

633: ) RETURN BOOLEAN AS
634:
635: CURSOR cur_rowid IS
636: SELECT rowid
637: FROM IGS_PS_OFR_PAT
638: WHERE cop_id = x_cop_id
639: AND (l_rowid IS NULL OR rowid <> l_rowid)
640:
641: FOR UPDATE NOWAIT;

Line 669: FROM IGS_PS_OFR_PAT

665: ) AS
666:
667: CURSOR cur_rowid IS
668: SELECT rowid
669: FROM IGS_PS_OFR_PAT
670: WHERE course_cd = x_course_cd
671: AND version_number = x_version_number
672: AND cal_type = x_cal_type
673: AND ci_sequence_number = x_ci_sequence_number ;

Line 702: FROM IGS_PS_OFR_PAT

698: ) AS
699:
700: CURSOR cur_rowid IS
701: SELECT rowid
702: FROM IGS_PS_OFR_PAT
703: WHERE course_cd = x_course_cd
704: AND version_number = x_version_number
705: AND cal_type = x_cal_type
706: AND location_cd = x_location_cd

Line 733: FROM IGS_PS_OFR_PAT

729: ) AS
730:
731: CURSOR cur_rowid IS
732: SELECT rowid
733: FROM IGS_PS_OFR_PAT
734: WHERE coo_id = x_coo_id ;
735:
736: lv_rowid cur_rowid%RowType;
737:

Line 760: FROM IGS_PS_OFR_PAT

756: ) AS
757:
758: CURSOR cur_rowid IS
759: SELECT rowid
760: FROM IGS_PS_OFR_PAT
761: WHERE grading_schema_cd = x_grading_schema_cd
762: AND gs_version_number = x_version_number ;
763:
764: lv_rowid cur_rowid%RowType;

Line 787: FROM IGS_PS_OFR_PAT

783: ) AS
784:
785: CURSOR cur_rowid IS
786: SELECT rowid
787: FROM IGS_PS_OFR_PAT
788: WHERE (adm_ass_officer_person_id = x_person_id )
789: OR (adm_contact_person_id = x_person_id );
790:
791: lv_rowid cur_rowid%RowType;

Line 974: cursor C is select ROWID from IGS_PS_OFR_PAT

970: X_GRADING_SCHEMA_CD in VARCHAR2,
971: X_GS_VERSION_NUMBER in NUMBER,
972: X_MODE in VARCHAR2 default 'R'
973: ) AS
974: cursor C is select ROWID from IGS_PS_OFR_PAT
975: where COURSE_CD = X_COURSE_CD
976: and CI_SEQUENCE_NUMBER = X_CI_SEQUENCE_NUMBER
977: and CAL_TYPE = X_CAL_TYPE
978: and VERSION_NUMBER = X_VERSION_NUMBER

Line 1055: insert into IGS_PS_OFR_PAT (

1051: x_last_updated_by => X_LAST_UPDATED_BY ,
1052: x_last_update_login => X_LAST_UPDATE_LOGIN
1053: );
1054:
1055: insert into IGS_PS_OFR_PAT (
1056: COURSE_CD,
1057: VERSION_NUMBER,
1058: CAL_TYPE,
1059: CI_SEQUENCE_NUMBER,

Line 1187: from IGS_PS_OFR_PAT

1183: ADM_ASS_OFFICER_PERSON_ID,
1184: ADM_CONTACT_PERSON_ID,
1185: GRADING_SCHEMA_CD,
1186: GS_VERSION_NUMBER
1187: from IGS_PS_OFR_PAT
1188: where ROWID = X_ROWID
1189: for update nowait;
1190: tlinfo c1%rowtype;
1191:

Line 1357: update IGS_PS_OFR_PAT set

1353: end if;
1354: end if;
1355:
1356:
1357: update IGS_PS_OFR_PAT set
1358: COP_ID = NEW_REFERENCES.COP_ID,
1359: COO_ID = NEW_REFERENCES.COO_ID,
1360: OFFERED_IND = NEW_REFERENCES.OFFERED_IND,
1361: CONFIRMED_OFFERING_IND = NEW_REFERENCES.CONFIRMED_OFFERING_IND,

Line 1423: cursor c1 is select rowid from IGS_PS_OFR_PAT

1419: X_GRADING_SCHEMA_CD in VARCHAR2,
1420: X_GS_VERSION_NUMBER in NUMBER,
1421: X_MODE in VARCHAR2 default 'R'
1422: ) AS
1423: cursor c1 is select rowid from IGS_PS_OFR_PAT
1424: where COURSE_CD = X_COURSE_CD
1425: and CI_SEQUENCE_NUMBER = X_CI_SEQUENCE_NUMBER
1426: and CAL_TYPE = X_CAL_TYPE
1427: and VERSION_NUMBER = X_VERSION_NUMBER

Line 1506: delete from IGS_PS_OFR_PAT

1502: Before_DML (
1503: p_action => 'DELETE',
1504: x_rowid => X_ROWID
1505: );
1506: delete from IGS_PS_OFR_PAT
1507: where ROWID = X_ROWID;
1508: if (sql%notfound) then
1509: raise no_data_found;
1510: end if;

Line 1517: end IGS_PS_OFR_PAT_PKG;

1513: x_rowid => X_ROWID
1514: );
1515: end DELETE_ROW;
1516:
1517: end IGS_PS_OFR_PAT_PKG;