APPS.IGS_FI_FEE_TYPE_CI_H_PKG dependencies on IGS_FI_FEE_TYPE_CI_H_ALL

Line 7: old_references IGS_FI_FEE_TYPE_CI_H_ALL%RowType;

3:
4:
5: l_rowid VARCHAR2(25);
6:
7: old_references IGS_FI_FEE_TYPE_CI_H_ALL%RowType;
8:
9: new_references IGS_FI_FEE_TYPE_CI_H_ALL%RowType;
10:
11:

Line 9: new_references IGS_FI_FEE_TYPE_CI_H_ALL%RowType;

5: l_rowid VARCHAR2(25);
6:
7: old_references IGS_FI_FEE_TYPE_CI_H_ALL%RowType;
8:
9: new_references IGS_FI_FEE_TYPE_CI_H_ALL%RowType;
10:
11:
12:
13: PROCEDURE Set_Column_Values (

Line 87: FROM IGS_FI_FEE_TYPE_CI_H_ALL

83: CURSOR cur_old_ref_values IS
84:
85: SELECT *
86:
87: FROM IGS_FI_FEE_TYPE_CI_H_ALL
88:
89: WHERE rowid = x_rowid;
90:
91:

Line 373: FROM IGS_FI_FEE_TYPE_CI_H_ALL

369:
370:
371: CURSOR cur_rowid IS
372: SELECT rowid
373: FROM IGS_FI_FEE_TYPE_CI_H_ALL
374: WHERE fee_type = x_fee_type
375: AND fee_cal_type = x_fee_cal_type
376: AND fee_ci_sequence_number = x_fee_ci_sequence_number
377: AND hist_start_dt = x_hist_start_dt

Line 591: cursor C is select ROWID from IGS_FI_FEE_TYPE_CI_H_ALL

587: || gurprsin 18-Jun-2005 Bug# 3392088 , Added 2 new columns scope_rul_sequence_num and elm_rng_order_name.
588: || vvutukur 19-Jul-2002 Bug#2425767.removed parameter x_payment_hierarchy_rank,
589: || and from call to before_dml procedure,from insert statement.
590: ----------------------------------------------------------------------------*/
591: cursor C is select ROWID from IGS_FI_FEE_TYPE_CI_H_ALL
592: where FEE_TYPE = X_FEE_TYPE
593: and FEE_CAL_TYPE = X_FEE_CAL_TYPE
594: and HIST_START_DT = X_HIST_START_DT
595: and FEE_CI_SEQUENCE_NUMBER = X_FEE_CI_SEQUENCE_NUMBER;

Line 676: insert into IGS_FI_FEE_TYPE_CI_H_ALL (

672: x_elm_rng_order_name => X_elm_rng_order_name
673: );
674:
675:
676: insert into IGS_FI_FEE_TYPE_CI_H_ALL (
677: FEE_TYPE,
678: FEE_CAL_TYPE,
679: FEE_CI_SEQUENCE_NUMBER,
680: HIST_START_DT,

Line 788: from IGS_FI_FEE_TYPE_CI_H_ALL

784: INITIAL_DEFAULT_AMOUNT,
785: NONZERO_BILLABLE_CP_FLAG,
786: SCOPE_RUL_SEQUENCE_NUM,
787: ELM_RNG_ORDER_NAME
788: from IGS_FI_FEE_TYPE_CI_H_ALL
789: where ROWID = X_ROWID
790: for update nowait;
791: tlinfo c1%rowtype;
792:

Line 966: update IGS_FI_FEE_TYPE_CI_H_ALL set

962: x_nonzero_billable_cp_flag => X_NONZERO_BILLABLE_CP_FLAG,
963: x_scope_rul_sequence_num => X_SCOPE_RUL_SEQUENCE_NUM,
964: x_elm_rng_order_name => X_ELM_RNG_ORDER_NAME
965: );
966: update IGS_FI_FEE_TYPE_CI_H_ALL set
967: HIST_END_DT = NEW_REFERENCES.HIST_END_DT,
968: HIST_WHO = NEW_REFERENCES.HIST_WHO,
969: FEE_TYPE_CI_STATUS = NEW_REFERENCES.FEE_TYPE_CI_STATUS,
970: START_DT_ALIAS = NEW_REFERENCES.START_DT_ALIAS,

Line 1028: cursor c1 is select rowid from IGS_FI_FEE_TYPE_CI_H_ALL

1024: || gurprsin 18-Jun-2005 Bug# 3392088 , Added 2 new columns scope_rul_sequence_num and elm_rng_order_name.
1025: || vvutukur 19-Jul-2002 Bug#2425767.removed parameter x_payment_hierarchy_rank,
1026: || and from calls to procedures insert_row and update_row.
1027: ----------------------------------------------------------------------------*/
1028: cursor c1 is select rowid from IGS_FI_FEE_TYPE_CI_H_ALL
1029: where FEE_TYPE = X_FEE_TYPE
1030: and FEE_CAL_TYPE = X_FEE_CAL_TYPE
1031: and HIST_START_DT = X_HIST_START_DT
1032: and FEE_CI_SEQUENCE_NUMBER = X_FEE_CI_SEQUENCE_NUMBER

Line 1098: delete from IGS_FI_FEE_TYPE_CI_H_ALL

1094: Before_DML (
1095: p_action => 'DELETE',
1096: x_rowid => X_ROWID
1097: );
1098: delete from IGS_FI_FEE_TYPE_CI_H_ALL
1099: where ROWID = X_ROWID;
1100: if (sql%notfound) then
1101: raise no_data_found;
1102: end if;