APPS.IGS_FI_FEE_TYPE_PKG dependencies on IGS_FI_FEE_TYPE

Line 1: package body IGS_FI_FEE_TYPE_PKG AS

1: package body IGS_FI_FEE_TYPE_PKG AS
2: /* $Header: IGSSI37B.pls 120.3 2005/09/22 05:43:39 appldev ship $*/
3:
4:
5: l_rowid VARCHAR2(25);

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 128: CURSOR cur_act_ft(cp_s_fee_type IN igs_fi_fee_type.s_fee_type%TYPE,

124: FROM igs_fi_inv_int
125: WHERE fee_type = p_fee_type;
126:
127: ---cursor to get the number of active fee types of system fee type 'DOCUMENT' and 'REFUND' system fee type
128: CURSOR cur_act_ft(cp_s_fee_type IN igs_fi_fee_type.s_fee_type%TYPE,
129: cp_fee_type IN igs_fi_fee_type.fee_type%TYPE) IS
130: SELECT count('x')
131: FROM igs_fi_fee_type
132: WHERE s_fee_type = cp_s_fee_type

Line 129: cp_fee_type IN igs_fi_fee_type.fee_type%TYPE) IS

125: WHERE fee_type = p_fee_type;
126:
127: ---cursor to get the number of active fee types of system fee type 'DOCUMENT' and 'REFUND' system fee type
128: CURSOR cur_act_ft(cp_s_fee_type IN igs_fi_fee_type.s_fee_type%TYPE,
129: cp_fee_type IN igs_fi_fee_type.fee_type%TYPE) IS
130: SELECT count('x')
131: FROM igs_fi_fee_type
132: WHERE s_fee_type = cp_s_fee_type
133: AND fee_type <> cp_fee_type

Line 131: FROM igs_fi_fee_type

127: ---cursor to get the number of active fee types of system fee type 'DOCUMENT' and 'REFUND' system fee type
128: CURSOR cur_act_ft(cp_s_fee_type IN igs_fi_fee_type.s_fee_type%TYPE,
129: cp_fee_type IN igs_fi_fee_type.fee_type%TYPE) IS
130: SELECT count('x')
131: FROM igs_fi_fee_type
132: WHERE s_fee_type = cp_s_fee_type
133: AND fee_type <> cp_fee_type
134: AND closed_ind='N';
135:

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;

Line 953: END igs_fi_fee_type_pkg;

949: X_DESIGNATED_PAYMENT_FLAG );
950: END add_row;
951:
952:
953: END igs_fi_fee_type_pkg;