APPS.IGS_PS_COO_AD_UNIT_S_PKG dependencies on IGS_PS_COO_AD_UNIT_S

Line 1: package body IGS_PS_COO_AD_UNIT_S_PKG AS

1: package body IGS_PS_COO_AD_UNIT_S_PKG AS
2: /* $Header: IGSPI02B.pls 120.1 2006/05/29 07:35:15 sarakshi noship $ */
3:
4: --Who When What
5: --sarakshi 27-Apr-2006 Bug#5165619, modified check_parent_existance and created procedure GET_FK_IGS_PS_OFR_UNIT_SET

Line 8: old_references IGS_PS_COO_AD_UNIT_S%RowType;

4: --Who When What
5: --sarakshi 27-Apr-2006 Bug#5165619, modified check_parent_existance and created procedure GET_FK_IGS_PS_OFR_UNIT_SET
6:
7: l_rowid VARCHAR2(25);
8: old_references IGS_PS_COO_AD_UNIT_S%RowType;
9: new_references IGS_PS_COO_AD_UNIT_S%RowType;
10:
11: PROCEDURE Set_Column_Values (
12: p_action IN VARCHAR2,

Line 9: new_references IGS_PS_COO_AD_UNIT_S%RowType;

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

Line 32: FROM IGS_PS_COO_AD_UNIT_S

28: ) AS
29:
30: CURSOR cur_old_ref_values IS
31: SELECT *
32: FROM IGS_PS_COO_AD_UNIT_S
33: WHERE rowid = x_rowid;
34:
35: BEGIN
36:

Line 272: FROM IGS_PS_COO_AD_UNIT_S

268: RETURN BOOLEAN AS
269:
270: CURSOR cur_rowid IS
271: SELECT rowid
272: FROM IGS_PS_COO_AD_UNIT_S
273: WHERE course_cd = x_course_cd
274: AND crv_version_number = x_crv_version_number
275: AND cal_type = x_cal_type
276: AND location_cd = x_location_cd

Line 312: FROM IGS_PS_COO_AD_UNIT_S

308: ) AS
309:
310: CURSOR cur_rowid IS
311: SELECT rowid
312: FROM IGS_PS_COO_AD_UNIT_S
313: WHERE course_cd = x_course_cd
314: AND crv_version_number = x_version_number
315: AND cal_type = x_cal_type
316: AND location_cd = x_location_cd

Line 345: FROM IGS_PS_COO_AD_UNIT_S

341: ) AS
342:
343: CURSOR cur_rowid IS
344: SELECT rowid
345: FROM IGS_PS_COO_AD_UNIT_S
346: WHERE unit_set_cd = x_unit_set_cd
347: AND us_version_number = x_version_number ;
348:
349: lv_rowid cur_rowid%RowType;

Line 386: FROM IGS_PS_COO_AD_UNIT_S

382: (reverse chronological order - newest change first)
383: ***************************************************************/
384: CURSOR cur_rowid IS
385: SELECT rowid
386: FROM IGS_PS_COO_AD_UNIT_S
387: WHERE course_cd = x_course_cd
388: AND crv_version_number = x_version_number
389: AND cal_type = x_cal_type
390: AND unit_set_cd = x_unit_set_cd

Line 518: cursor C is select ROWID from IGS_PS_COO_AD_UNIT_S

514: X_UNIT_SET_CD in VARCHAR2,
515: X_US_VERSION_NUMBER in NUMBER,
516: X_MODE in VARCHAR2 default 'R'
517: ) as
518: cursor C is select ROWID from IGS_PS_COO_AD_UNIT_S
519: where COURSE_CD = X_COURSE_CD
520: and CRV_VERSION_NUMBER = X_CRV_VERSION_NUMBER
521: and CAL_TYPE = X_CAL_TYPE
522: and LOCATION_CD = X_LOCATION_CD

Line 570: insert into IGS_PS_COO_AD_UNIT_S (

566: x_last_updated_by => X_LAST_UPDATED_BY ,
567: x_last_update_login => X_LAST_UPDATE_LOGIN
568: );
569:
570: insert into IGS_PS_COO_AD_UNIT_S (
571: COURSE_CD,
572: CRV_VERSION_NUMBER,
573: CAL_TYPE,
574: LOCATION_CD,

Line 630: from IGS_PS_COO_AD_UNIT_S

626: X_UNIT_SET_CD in VARCHAR2,
627: X_US_VERSION_NUMBER in NUMBER
628: ) as
629: cursor c1 is select ROWID
630: from IGS_PS_COO_AD_UNIT_S
631: where ROWID = X_ROWID
632: for update nowait;
633: tlinfo c1%rowtype;
634:

Line 660: delete from IGS_PS_COO_AD_UNIT_S

656: p_action => 'DELETE',
657: x_rowid => X_ROWID
658: );
659:
660: delete from IGS_PS_COO_AD_UNIT_S
661: where ROWID = X_ROWID;
662: if (sql%notfound) then
663: raise no_data_found;
664: end if;

Line 673: end IGS_PS_COO_AD_UNIT_S_PKG;

669: );
670:
671: end DELETE_ROW;
672:
673: end IGS_PS_COO_AD_UNIT_S_PKG;