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_ENT_PT_REF_CD_PKG dependencies on IGS_PS_ENT_PT_REF_CD

Line 1: package body IGS_PS_ENT_PT_REF_CD_PKG AS

1: package body IGS_PS_ENT_PT_REF_CD_PKG AS
2: /* $Header: IGSPI10B.pls 120.1 2006/05/29 07:29:39 sarakshi noship $ */
3:
4: --sarakshi 20-Apr-2002 As a part of the bug #2146753 removed the call to the function
5: -- igs_ps_val_ceprc.crsp_val_ceprc_uref from beforerowinsertupdatedelete1

Line 10: old_references IGS_PS_ENT_PT_REF_CD%RowType;

6: -- Also addd few columns in lock_row,update_row which were missing.
7: --sarakshi 27-Apr-2006 Bug#5165619, modified check_parent_existance and created procedure GET_FK_IGS_PS_OFR_UNIT_SET
8:
9: l_rowid VARCHAR2(25);
10: old_references IGS_PS_ENT_PT_REF_CD%RowType;
11: new_references IGS_PS_ENT_PT_REF_CD%RowType;
12:
13: PROCEDURE Set_Column_Values (
14: p_action IN VARCHAR2,

Line 11: new_references IGS_PS_ENT_PT_REF_CD%RowType;

7: --sarakshi 27-Apr-2006 Bug#5165619, modified check_parent_existance and created procedure GET_FK_IGS_PS_OFR_UNIT_SET
8:
9: l_rowid VARCHAR2(25);
10: old_references IGS_PS_ENT_PT_REF_CD%RowType;
11: new_references IGS_PS_ENT_PT_REF_CD%RowType;
12:
13: PROCEDURE Set_Column_Values (
14: p_action IN VARCHAR2,
15: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 38: FROM IGS_PS_ENT_PT_REF_CD

34: ) AS
35:
36: CURSOR cur_old_ref_values IS
37: SELECT *
38: FROM IGS_PS_ENT_PT_REF_CD
39: WHERE rowid = x_rowid;
40:
41: BEGIN
42:

Line 89: -- ON IGS_PS_ENT_PT_REF_CD

85:
86: -- Trigger description :-
87: -- "OSS_TST".trg_ceprc_br_iud
88: -- BEFORE INSERT OR DELETE OR UPDATE
89: -- ON IGS_PS_ENT_PT_REF_CD
90: -- FOR EACH ROW
91:
92: PROCEDURE BeforeRowInsertUpdateDelete1(
93: p_inserting IN BOOLEAN DEFAULT FALSE,

Line 463: FROM IGS_PS_ENT_PT_REF_CD

459: RETURN BOOLEAN AS
460:
461: CURSOR cur_rowid IS
462: SELECT rowid
463: FROM IGS_PS_ENT_PT_REF_CD
464: WHERE course_cd = x_course_cd
465: AND version_number = x_version_number
466: AND cal_type = x_cal_type
467: AND location_cd = x_location_cd

Line 501: FROM IGS_PS_ENT_PT_REF_CD

497: ) AS
498:
499: CURSOR cur_rowid IS
500: SELECT rowid
501: FROM IGS_PS_ENT_PT_REF_CD
502: WHERE course_cd = x_course_cd
503: AND version_number = x_version_number
504: AND cal_type = x_cal_type
505: AND location_cd = x_location_cd

Line 532: FROM IGS_PS_ENT_PT_REF_CD

528: ) AS
529:
530: CURSOR cur_rowid IS
531: SELECT rowid
532: FROM IGS_PS_ENT_PT_REF_CD
533: WHERE coo_id = x_coo_id ;
534:
535: lv_rowid cur_rowid%RowType;
536:

Line 558: FROM IGS_PS_ENT_PT_REF_CD

554: ) AS
555:
556: CURSOR cur_rowid IS
557: SELECT rowid
558: FROM IGS_PS_ENT_PT_REF_CD
559: WHERE reference_cd_type = x_reference_cd_type ;
560:
561: lv_rowid cur_rowid%RowType;
562:

Line 585: FROM IGS_PS_ENT_PT_REF_CD

581: ) AS
582:
583: CURSOR cur_rowid IS
584: SELECT rowid
585: FROM IGS_PS_ENT_PT_REF_CD
586: WHERE unit_set_cd = x_unit_set_cd
587: AND us_version_number = x_version_number ;
588:
589: lv_rowid cur_rowid%RowType;

Line 625: FROM IGS_PS_ENT_PT_REF_CD

621: (reverse chronological order - newest change first)
622: ***************************************************************/
623: CURSOR cur_rowid IS
624: SELECT rowid
625: FROM IGS_PS_ENT_PT_REF_CD
626: WHERE course_cd = x_course_cd
627: AND version_number = x_version_number
628: AND cal_type = x_cal_type
629: AND unit_set_cd = x_unit_set_cd

Line 812: cursor C is select ROWID from IGS_PS_ENT_PT_REF_CD

808: X_REFERENCE_CD in VARCHAR2,
809: X_DESCRIPTION in VARCHAR2,
810: X_MODE in VARCHAR2 default 'R'
811: ) AS
812: cursor C is select ROWID from IGS_PS_ENT_PT_REF_CD
813: where COURSE_CD = X_COURSE_CD
814: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER
815: and REFERENCE_CD_TYPE = X_REFERENCE_CD_TYPE
816: and ATTENDANCE_TYPE = X_ATTENDANCE_TYPE

Line 867: insert into IGS_PS_ENT_PT_REF_CD (

863: x_last_updated_by => X_LAST_UPDATED_BY ,
864: x_last_update_login => X_LAST_UPDATE_LOGIN
865: );
866:
867: insert into IGS_PS_ENT_PT_REF_CD (
868: COURSE_CD,
869: VERSION_NUMBER,
870: CAL_TYPE,
871: LOCATION_CD,

Line 953: from IGS_PS_ENT_PT_REF_CD

949: UNIT_SET_CD,
950: US_VERSION_NUMBER,
951: REFERENCE_CD,
952: DESCRIPTION
953: from IGS_PS_ENT_PT_REF_CD
954: where ROWID = X_ROWID
955: for update nowait;
956: tlinfo c1%rowtype;
957:

Line 1064: update IGS_PS_ENT_PT_REF_CD set

1060: x_last_updated_by => X_LAST_UPDATED_BY ,
1061: x_last_update_login => X_LAST_UPDATE_LOGIN
1062: );
1063:
1064: update IGS_PS_ENT_PT_REF_CD set
1065: --added by sarakshi, bug#2146753
1066: course_cd=new_references.course_cd,
1067: version_number=new_references.version_number,
1068: cal_type=new_references.cal_type,

Line 1113: cursor c1 is select rowid from IGS_PS_ENT_PT_REF_CD

1109: X_REFERENCE_CD in VARCHAR2,
1110: X_DESCRIPTION in VARCHAR2,
1111: X_MODE in VARCHAR2 default 'R'
1112: ) AS
1113: cursor c1 is select rowid from IGS_PS_ENT_PT_REF_CD
1114: where COURSE_CD = X_COURSE_CD
1115: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER
1116: and REFERENCE_CD_TYPE = X_REFERENCE_CD_TYPE
1117: and ATTENDANCE_TYPE = X_ATTENDANCE_TYPE

Line 1173: delete from IGS_PS_ENT_PT_REF_CD

1169: Before_DML (
1170: p_action => 'DELETE',
1171: x_rowid => X_ROWID
1172: );
1173: delete from IGS_PS_ENT_PT_REF_CD
1174: where ROWID = X_ROWID;
1175: if (sql%notfound) then
1176: raise no_data_found;
1177: end if;

Line 1184: end IGS_PS_ENT_PT_REF_CD_PKG;

1180: x_rowid => X_ROWID
1181: );
1182: end DELETE_ROW;
1183:
1184: end IGS_PS_ENT_PT_REF_CD_PKG;