APPS.IGS_EN_UNITSETFEETRG_PKG dependencies on IGS_EN_UNITSETFEETRG

Line 1: package body IGS_EN_UNITSETFEETRG_PKG as

1: package body IGS_EN_UNITSETFEETRG_PKG as
2: /* $Header: IGSEI11B.pls 115.5 2003/02/12 10:21:21 shtatiko ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_EN_UNITSETFEETRG%RowType;
5: new_references IGS_EN_UNITSETFEETRG%RowType;

Line 4: old_references IGS_EN_UNITSETFEETRG%RowType;

1: package body IGS_EN_UNITSETFEETRG_PKG as
2: /* $Header: IGSEI11B.pls 115.5 2003/02/12 10:21:21 shtatiko ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_EN_UNITSETFEETRG%RowType;
5: new_references IGS_EN_UNITSETFEETRG%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_EN_UNITSETFEETRG%RowType;

1: package body IGS_EN_UNITSETFEETRG_PKG as
2: /* $Header: IGSEI11B.pls 115.5 2003/02/12 10:21:21 shtatiko ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_EN_UNITSETFEETRG%RowType;
5: new_references IGS_EN_UNITSETFEETRG%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 28: FROM IGS_EN_UNITSETFEETRG

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

Line 74: -- ON IGS_EN_UNITSETFEETRG

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

Line 122: -- ON IGS_EN_UNITSETFEETRG

118:
119: -- Trigger description :-
120: -- "OSS_TST".trg_usft_ar_iu
121: -- AFTER INSERT OR UPDATE
122: -- ON IGS_EN_UNITSETFEETRG
123: -- FOR EACH ROW
124:
125: PROCEDURE AfterRowInsertUpdate2(
126: p_inserting IN BOOLEAN DEFAULT FALSE,

Line 306: FROM IGS_EN_UNITSETFEETRG

302: ) RETURN BOOLEAN AS
303:
304: CURSOR cur_rowid IS
305: SELECT rowid
306: FROM IGS_EN_UNITSETFEETRG
307: WHERE fee_cat= x_fee_cat
308: AND fee_cal_type = x_fee_cal_type
309: AND fee_ci_sequence_number = x_fee_ci_sequence_number
310: AND fee_type = x_fee_type

Line 342: FROM IGS_EN_UNITSETFEETRG

338: ) AS
339:
340: CURSOR cur_rowid IS
341: SELECT rowid
342: FROM IGS_EN_UNITSETFEETRG
343: WHERE fee_cat = x_fee_cat
344: AND fee_cal_type = x_fee_cal_type
345: AND fee_ci_sequence_number = x_fee_ci_sequence_number
346: AND fee_type = x_fee_type

Line 373: FROM IGS_EN_UNITSETFEETRG

369: ) AS
370:
371: CURSOR cur_rowid IS
372: SELECT rowid
373: FROM IGS_EN_UNITSETFEETRG
374: WHERE unit_set_cd = x_unit_set_cd
375: AND version_number = x_version_number ;
376:
377: lv_rowid cur_rowid%RowType;

Line 518: cursor C is select ROWID from IGS_EN_UNITSETFEETRG

514: X_FEE_TRIGGER_GROUP_NUMBER in NUMBER,
515: X_LOGICAL_DELETE_DT in DATE,
516: X_MODE in VARCHAR2 default 'R'
517: ) AS
518: cursor C is select ROWID from IGS_EN_UNITSETFEETRG
519: where FEE_CAT = X_FEE_CAT
520: and FEE_CAL_TYPE = X_FEE_CAL_TYPE
521: and FEE_CI_SEQUENCE_NUMBER = X_FEE_CI_SEQUENCE_NUMBER
522: and FEE_TYPE = X_FEE_TYPE

Line 566: insert into IGS_EN_UNITSETFEETRG (

562: x_last_update_date => X_LAST_UPDATE_DATE,
563: x_last_updated_by => X_LAST_UPDATED_BY,
564: x_last_update_login => X_LAST_UPDATE_LOGIN
565: );
566: insert into IGS_EN_UNITSETFEETRG (
567: FEE_CAT,
568: FEE_CAL_TYPE,
569: FEE_CI_SEQUENCE_NUMBER,
570: FEE_TYPE,

Line 626: from IGS_EN_UNITSETFEETRG

622: ) AS
623: cursor c1 is select
624: FEE_TRIGGER_GROUP_NUMBER,
625: LOGICAL_DELETE_DT
626: from IGS_EN_UNITSETFEETRG
627: where ROWID = X_ROWID
628: for update nowait;
629: tlinfo c1%rowtype;
630:

Line 712: update IGS_EN_UNITSETFEETRG set

708: x_last_update_date => X_LAST_UPDATE_DATE,
709: x_last_updated_by => X_LAST_UPDATED_BY,
710: x_last_update_login => X_LAST_UPDATE_LOGIN
711: );
712: update IGS_EN_UNITSETFEETRG set
713: FEE_TRIGGER_GROUP_NUMBER = NEW_REFERENCES.FEE_TRIGGER_GROUP_NUMBER,
714: LOGICAL_DELETE_DT = NEW_REFERENCES.LOGICAL_DELETE_DT,
715: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
716: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 742: cursor c1 is select rowid from IGS_EN_UNITSETFEETRG

738: X_FEE_TRIGGER_GROUP_NUMBER in NUMBER,
739: X_LOGICAL_DELETE_DT in DATE,
740: X_MODE in VARCHAR2 default 'R'
741: ) AS
742: cursor c1 is select rowid from IGS_EN_UNITSETFEETRG
743: where FEE_CAT = X_FEE_CAT
744: and FEE_CAL_TYPE = X_FEE_CAL_TYPE
745: and FEE_CI_SEQUENCE_NUMBER = X_FEE_CI_SEQUENCE_NUMBER
746: and FEE_TYPE = X_FEE_TYPE

Line 793: delete from IGS_EN_UNITSETFEETRG

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

Line 804: end IGS_EN_UNITSETFEETRG_PKG;

800: x_rowid => X_ROWID
801: );
802: end DELETE_ROW;
803:
804: end IGS_EN_UNITSETFEETRG_PKG;