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_UNIT_SET_PKG dependencies on IGS_PS_OFR_UNIT_SET

Line 1: package body IGS_PS_OFR_UNIT_SET_PKG AS

1: package body IGS_PS_OFR_UNIT_SET_PKG AS
2: /* $Header: IGSPI26B.pls 120.1 2006/05/29 07:39:18 sarakshi noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_OFR_UNIT_SET%RowType;

Line 5: old_references IGS_PS_OFR_UNIT_SET%RowType;

1: package body IGS_PS_OFR_UNIT_SET_PKG AS
2: /* $Header: IGSPI26B.pls 120.1 2006/05/29 07:39:18 sarakshi noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_OFR_UNIT_SET%RowType;
6: new_references IGS_PS_OFR_UNIT_SET%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_PS_OFR_UNIT_SET%RowType;

2: /* $Header: IGSPI26B.pls 120.1 2006/05/29 07:39:18 sarakshi noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_OFR_UNIT_SET%RowType;
6: new_references IGS_PS_OFR_UNIT_SET%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 28: FROM IGS_PS_OFR_UNIT_SET

24: ) AS
25:
26: CURSOR cur_old_ref_values IS
27: SELECT *
28: FROM IGS_PS_OFR_UNIT_SET
29: WHERE rowid = x_rowid;
30:
31: BEGIN
32:

Line 73: -- ON IGS_PS_OFR_UNIT_SET

69:
70: -- Trigger description :-
71: -- "OSS_TST".trg_cous_br_iu
72: -- BEFORE INSERT OR UPDATE
73: -- ON IGS_PS_OFR_UNIT_SET
74: -- FOR EACH ROW
75:
76: PROCEDURE BeforeRowInsertUpdate1(
77: p_inserting IN BOOLEAN DEFAULT FALSE,

Line 266: IGS_PS_OF_OPT_UNT_ST_PKG.GET_FK_IGS_PS_OFR_UNIT_SET (

262: sarakshi 27-APR-2006 Bug#5165619, added child existance for IGS_PS_ENT_PT_REF_CD and IGS_PS_COO_AD_UNIT_S
263: ***************************************************************/
264: BEGIN
265:
266: IGS_PS_OF_OPT_UNT_ST_PKG.GET_FK_IGS_PS_OFR_UNIT_SET (
267: old_references.course_cd,
268: old_references.crv_version_number,
269: old_references.cal_type,
270: old_references.unit_set_cd,

Line 273: IGS_PS_OF_UNT_SET_RL_PKG.GET_FK_IGS_PS_OFR_UNIT_SET (

269: old_references.cal_type,
270: old_references.unit_set_cd,
271: old_references.us_version_number
272: );
273: IGS_PS_OF_UNT_SET_RL_PKG.GET_FK_IGS_PS_OFR_UNIT_SET (
274: old_references.course_cd,
275: old_references.crv_version_number,
276: old_references.cal_type,
277: old_references.unit_set_cd,

Line 283: IGS_PS_ENT_PT_REF_CD_PKG.GET_FK_IGS_PS_OFR_UNIT_SET (

279: );
280:
281: --Added following child table check for bug#5165619
282: --IGS_PS_ENT_PT_REF_CD (program entry point reference codes)
283: IGS_PS_ENT_PT_REF_CD_PKG.GET_FK_IGS_PS_OFR_UNIT_SET (
284: old_references.course_cd,
285: old_references.crv_version_number,
286: old_references.cal_type,
287: old_references.unit_set_cd,

Line 293: IGS_PS_COO_AD_UNIT_S_PKG.GET_FK_IGS_PS_OFR_UNIT_SET (

289: );
290:
291:
292: --IGS_PS_COO_AD_UNIT_S (Program Offering option admission categories)
293: IGS_PS_COO_AD_UNIT_S_PKG.GET_FK_IGS_PS_OFR_UNIT_SET (
294: old_references.course_cd,
295: old_references.crv_version_number,
296: old_references.cal_type,
297: old_references.unit_set_cd,

Line 302: IGS_HE_POOUS_ALL_PKG.GET_FK_IGS_PS_OFR_UNIT_SET (

298: old_references.us_version_number
299: );
300:
301: --IGS_HE_POOUS_ALL
302: IGS_HE_POOUS_ALL_PKG.GET_FK_IGS_PS_OFR_UNIT_SET (
303: old_references.course_cd,
304: old_references.crv_version_number,
305: old_references.cal_type,
306: old_references.unit_set_cd,

Line 311: IGS_HE_POOUS_OU_ALL_PKG.GET_FK_IGS_PS_OFR_UNIT_SET (

307: old_references.us_version_number
308: );
309:
310: --IGS_HE_POOUS_OU
311: IGS_HE_POOUS_OU_ALL_PKG.GET_FK_IGS_PS_OFR_UNIT_SET (
312: old_references.course_cd,
313: old_references.crv_version_number,
314: old_references.cal_type,
315: old_references.unit_set_cd,

Line 320: IGS_AS_SU_SETATMPT_PKG.GET_FK_IGS_PS_OFR_UNIT_SET (

316: old_references.us_version_number
317: );
318:
319: --IGS_HE_POOUS_OU
320: IGS_AS_SU_SETATMPT_PKG.GET_FK_IGS_PS_OFR_UNIT_SET (
321: old_references.course_cd,
322: old_references.crv_version_number,
323: old_references.cal_type,
324: old_references.unit_set_cd,

Line 342: FROM IGS_PS_OFR_UNIT_SET

338: ) RETURN BOOLEAN AS
339:
340: CURSOR cur_rowid IS
341: SELECT rowid
342: FROM IGS_PS_OFR_UNIT_SET
343: WHERE course_cd = x_course_cd
344: AND crv_version_number = x_crv_version_number
345: AND cal_type = x_cal_type
346: AND unit_set_cd = x_unit_set_cd

Line 374: FROM IGS_PS_OFR_UNIT_SET

370: ) AS
371:
372: CURSOR cur_rowid IS
373: SELECT rowid
374: FROM IGS_PS_OFR_UNIT_SET
375: WHERE course_cd = x_course_cd
376: AND crv_version_number = x_version_number
377: AND cal_type = x_cal_type ;
378:

Line 403: FROM IGS_PS_OFR_UNIT_SET

399: ) AS
400:
401: CURSOR cur_rowid IS
402: SELECT rowid
403: FROM IGS_PS_OFR_UNIT_SET
404: WHERE unit_set_cd = x_unit_set_cd
405: AND us_version_number = x_version_number ;
406:
407: lv_rowid cur_rowid%RowType;

Line 531: cursor C is select ROWID from IGS_PS_OFR_UNIT_SET

527: X_ONLY_AS_SUB_IND in VARCHAR2,
528: X_SHOW_ON_OFFICIAL_NTFCTN_IND in VARCHAR2,
529: X_MODE in VARCHAR2 default 'R'
530: ) AS
531: cursor C is select ROWID from IGS_PS_OFR_UNIT_SET
532: where COURSE_CD = X_COURSE_CD
533: and CRV_VERSION_NUMBER = X_CRV_VERSION_NUMBER
534: and CAL_TYPE = X_CAL_TYPE
535: and UNIT_SET_CD = X_UNIT_SET_CD

Line 577: insert into IGS_PS_OFR_UNIT_SET (

573: x_last_updated_by => X_LAST_UPDATED_BY ,
574: x_last_update_login => X_LAST_UPDATE_LOGIN
575: );
576:
577: insert into IGS_PS_OFR_UNIT_SET (
578: COURSE_CD,
579: CRV_VERSION_NUMBER,
580: CAL_TYPE,
581: UNIT_SET_CD,

Line 635: from IGS_PS_OFR_UNIT_SET

631: cursor c1 is select
632: OVERRIDE_TITLE,
633: ONLY_AS_SUB_IND,
634: SHOW_ON_OFFICIAL_NTFCTN_IND
635: from IGS_PS_OFR_UNIT_SET
636: where ROWID = X_ROWID
637: for update nowait;
638: tlinfo c1%rowtype;
639:

Line 718: update IGS_PS_OFR_UNIT_SET set

714: x_last_update_date => X_LAST_UPDATE_DATE ,
715: x_last_updated_by => X_LAST_UPDATED_BY ,
716: x_last_update_login => X_LAST_UPDATE_LOGIN
717: );
718: update IGS_PS_OFR_UNIT_SET set
719: OVERRIDE_TITLE = NEW_REFERENCES.OVERRIDE_TITLE,
720: ONLY_AS_SUB_IND = NEW_REFERENCES.ONLY_AS_SUB_IND,
721: SHOW_ON_OFFICIAL_NTFCTN_IND = NEW_REFERENCES.SHOW_ON_OFFICIAL_NTFCTN_IND,
722: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 748: cursor c1 is select rowid from IGS_PS_OFR_UNIT_SET

744: X_ONLY_AS_SUB_IND in VARCHAR2,
745: X_SHOW_ON_OFFICIAL_NTFCTN_IND in VARCHAR2,
746: X_MODE in VARCHAR2 default 'R'
747: ) AS
748: cursor c1 is select rowid from IGS_PS_OFR_UNIT_SET
749: where COURSE_CD = X_COURSE_CD
750: and CRV_VERSION_NUMBER = X_CRV_VERSION_NUMBER
751: and CAL_TYPE = X_CAL_TYPE
752: and UNIT_SET_CD = X_UNIT_SET_CD

Line 795: delete from IGS_PS_OFR_UNIT_SET

791: Before_DML (
792: p_action => 'DELETE',
793: x_rowid => X_ROWID
794: );
795: delete from IGS_PS_OFR_UNIT_SET
796: where ROWID = X_ROWID;
797: if (sql%notfound) then
798: raise no_data_found;
799: end if;

Line 806: end IGS_PS_OFR_UNIT_SET_PKG;

802: x_rowid => X_ROWID
803: );
804: end DELETE_ROW;
805:
806: end IGS_PS_OFR_UNIT_SET_PKG;