APPS.IGS_FI_FEE_TYPE_PKG dependencies on IGS_FI_FEE_TYPE_ALL

Line 6: old_references IGS_FI_FEE_TYPE_ALL%RowType;

2: /* $Header: IGSSI37B.pls 120.3 2005/09/22 05:43:39 appldev ship $*/
3:
4:
5: l_rowid VARCHAR2(25);
6: old_references IGS_FI_FEE_TYPE_ALL%RowType;
7: new_references IGS_FI_FEE_TYPE_ALL%RowType;
8:
9: PROCEDURE Set_Column_Values (
10: p_action IN VARCHAR2,

Line 7: new_references IGS_FI_FEE_TYPE_ALL%RowType;

3:
4:
5: l_rowid VARCHAR2(25);
6: old_references IGS_FI_FEE_TYPE_ALL%RowType;
7: new_references IGS_FI_FEE_TYPE_ALL%RowType;
8:
9: PROCEDURE Set_Column_Values (
10: p_action IN VARCHAR2,
11: x_rowid IN VARCHAR2 ,

Line 43: FROM IGS_FI_FEE_TYPE_ALL

39: ----------------------------------------------------------------------------*/
40:
41: CURSOR cur_old_ref_values IS
42: SELECT *
43: FROM IGS_FI_FEE_TYPE_ALL
44: WHERE rowid = x_rowid;
45:
46: BEGIN
47:

Line 94: -- ON IGS_FI_FEE_TYPE_ALL

90: -- "OSS_TST".trg_ft_br_iud
91:
92: -- BEFORE INSERT OR DELETE OR UPDATE
93:
94: -- ON IGS_FI_FEE_TYPE_ALL
95:
96: -- FOR EACH ROW
97:
98: PROCEDURE BeforeRowInsertUpdateDelete1(

Line 300: -- ON IGS_FI_FEE_TYPE_ALL

296:
297: -- Trigger description :-
298: -- "OSS_TST".trg_ft_ar_u_hist
299: -- AFTER UPDATE
300: -- ON IGS_FI_FEE_TYPE_ALL
301: -- FOR EACH ROW
302:
303: PROCEDURE AfterRowUpdate2(
304: p_inserting IN BOOLEAN ,

Line 519: FROM igs_fi_fee_type_all

515: -- Removed FOR UPDATE NOWAIT clause in cur_rowid
516: -------------------------------------------------------------------
517: CURSOR cur_rowid IS
518: SELECT rowid
519: FROM igs_fi_fee_type_all
520: WHERE fee_type = x_fee_type ;
521:
522: lv_rowid cur_rowid%ROWTYPE;
523:

Line 662: cursor C is select ROWID from IGS_FI_FEE_TYPE_ALL

658: X_ORG_ID in NUMBER,
659: X_FEE_CLASS in VARCHAR2, --Bug 2175865
660: X_DESIGNATED_PAYMENT_FLAG IN VARCHAR2
661: ) AS
662: cursor C is select ROWID from IGS_FI_FEE_TYPE_ALL
663: where FEE_TYPE = X_FEE_TYPE;
664: X_LAST_UPDATE_DATE DATE;
665: X_LAST_UPDATED_BY NUMBER;
666: X_LAST_UPDATE_LOGIN NUMBER;

Line 709: insert into IGS_FI_FEE_TYPE_ALL (

705: x_last_updated_by=>X_LAST_UPDATED_BY,
706: x_last_update_login=>X_LAST_UPDATE_LOGIN
707: );
708:
709: insert into IGS_FI_FEE_TYPE_ALL (
710: FEE_TYPE,
711: S_FEE_TYPE,
712: S_FEE_TRIGGER_CAT,
713: DESCRIPTION,

Line 775: from IGS_FI_FEE_TYPE_ALL

771: CLOSED_IND,
772: COMMENTS,
773: FEE_CLASS, --Bug 2175865
774: designated_payment_flag
775: from IGS_FI_FEE_TYPE_ALL
776: where ROWID = X_ROWID
777: for update nowait;
778: tlinfo c1%rowtype;
779:

Line 874: update IGS_FI_FEE_TYPE_ALL set

870: x_last_update_login=>X_LAST_UPDATE_LOGIN
871: );
872:
873:
874: update IGS_FI_FEE_TYPE_ALL set
875: S_FEE_TYPE = NEW_REFERENCES.S_FEE_TYPE,
876: S_FEE_TRIGGER_CAT = NEW_REFERENCES.S_FEE_TRIGGER_CAT,
877: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
878: OPTIONAL_PAYMENT_IND = NEW_REFERENCES.OPTIONAL_PAYMENT_IND,

Line 914: CURSOR c1 is SELECT rowid FROM igs_fi_fee_type_all

910: X_ORG_ID in NUMBER,
911: X_FEE_CLASS in VARCHAR2, --Bug 2175865
912: X_DESIGNATED_PAYMENT_FLAG IN VARCHAR2
913: ) AS
914: CURSOR c1 is SELECT rowid FROM igs_fi_fee_type_all
915: WHERE FEE_TYPE = X_FEE_TYPE
916: ;
917: begin
918: OPEN c1;