APPS.IGS_FI_FEE_CAT_CI_HT_PKG dependencies on IGS_FI_FEE_CAT_CI_HT_ALL

Line 4: old_references IGS_FI_FEE_CAT_CI_HT_ALL%RowType;

1: package body IGS_FI_FEE_CAT_CI_HT_PKG AS
2: /* $Header: IGSSI24B.pls 115.7 2002/11/29 03:44:10 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_FI_FEE_CAT_CI_HT_ALL%RowType;
5: new_references IGS_FI_FEE_CAT_CI_HT_ALL%RowType;
6: PROCEDURE Set_Column_Values (
7: p_action IN VARCHAR2,
8: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 5: new_references IGS_FI_FEE_CAT_CI_HT_ALL%RowType;

1: package body IGS_FI_FEE_CAT_CI_HT_PKG AS
2: /* $Header: IGSSI24B.pls 115.7 2002/11/29 03:44:10 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_FI_FEE_CAT_CI_HT_ALL%RowType;
5: new_references IGS_FI_FEE_CAT_CI_HT_ALL%RowType;
6: PROCEDURE Set_Column_Values (
7: p_action IN VARCHAR2,
8: x_rowid IN VARCHAR2 DEFAULT NULL,
9: x_fee_cat IN VARCHAR2 DEFAULT NULL,

Line 31: FROM IGS_FI_FEE_CAT_CI_HT_ALL

27: x_last_update_login IN NUMBER DEFAULT NULL
28: ) AS
29: CURSOR cur_old_ref_values IS
30: SELECT *
31: FROM IGS_FI_FEE_CAT_CI_HT_ALL
32: WHERE rowid = x_rowid;
33: BEGIN
34: l_rowid := x_rowid;
35: -- Code for setting the Old and New Reference Values.

Line 187: FROM IGS_FI_FEE_CAT_CI_HT_ALL

183: x_hist_start_dt IN DATE
184: ) RETURN BOOLEAN AS
185: CURSOR cur_rowid IS
186: SELECT rowid
187: FROM IGS_FI_FEE_CAT_CI_HT_ALL
188: WHERE fee_cat = x_fee_cat
189: AND fee_cal_type = x_fee_cal_type
190: AND fee_ci_sequence_number = x_fee_ci_sequence_number
191: AND hist_start_dt = x_hist_start_dt

Line 303: cursor C is select ROWID from IGS_FI_FEE_CAT_CI_HT_ALL

299: X_RETRO_DAI_SEQUENCE_NUMBER in NUMBER,
300: X_ORG_ID in NUMBER,
301: X_MODE in VARCHAR2 default 'R'
302: ) AS
303: cursor C is select ROWID from IGS_FI_FEE_CAT_CI_HT_ALL
304: where FEE_CAT = X_FEE_CAT
305: and FEE_CAL_TYPE = X_FEE_CAL_TYPE
306: and FEE_CI_SEQUENCE_NUMBER = X_FEE_CI_SEQUENCE_NUMBER
307: and HIST_START_DT = X_HIST_START_DT;

Line 353: insert into IGS_FI_FEE_CAT_CI_HT_ALL (

349: x_last_update_date=>X_LAST_UPDATE_DATE,
350: x_last_updated_by=>X_LAST_UPDATED_BY,
351: x_last_update_login=>X_LAST_UPDATE_LOGIN
352: );
353: insert into IGS_FI_FEE_CAT_CI_HT_ALL (
354: FEE_CAT,
355: FEE_CAL_TYPE,
356: FEE_CI_SEQUENCE_NUMBER,
357: HIST_START_DT,

Line 428: from IGS_FI_FEE_CAT_CI_HT_ALL

424: END_DT_ALIAS,
425: END_DAI_SEQUENCE_NUMBER,
426: RETRO_DT_ALIAS,
427: RETRO_DAI_SEQUENCE_NUMBER
428: from IGS_FI_FEE_CAT_CI_HT_ALL
429: where ROWID = X_ROWID
430: for update nowait;
431: tlinfo c1%rowtype;
432: begin

Line 536: update IGS_FI_FEE_CAT_CI_HT_ALL set

532: x_last_update_date=>X_LAST_UPDATE_DATE,
533: x_last_updated_by=>X_LAST_UPDATED_BY,
534: x_last_update_login=>X_LAST_UPDATE_LOGIN
535: );
536: update IGS_FI_FEE_CAT_CI_HT_ALL set
537: HIST_END_DT = NEW_REFERENCES.HIST_END_DT,
538: HIST_WHO = NEW_REFERENCES.HIST_WHO,
539: FEE_CAT_CI_STATUS = NEW_REFERENCES.FEE_CAT_CI_STATUS,
540: START_DT_ALIAS = NEW_REFERENCES.START_DT_ALIAS,

Line 572: cursor c1 is select rowid from IGS_FI_FEE_CAT_CI_HT_ALL

568: X_RETRO_DAI_SEQUENCE_NUMBER in NUMBER,
569: X_ORG_ID in NUMBER,
570: X_MODE in VARCHAR2 default 'R'
571: ) AS
572: cursor c1 is select rowid from IGS_FI_FEE_CAT_CI_HT_ALL
573: where FEE_CAT = X_FEE_CAT
574: and FEE_CAL_TYPE = X_FEE_CAL_TYPE
575: and FEE_CI_SEQUENCE_NUMBER = X_FEE_CI_SEQUENCE_NUMBER
576: and HIST_START_DT = X_HIST_START_DT

Line 628: delete from IGS_FI_FEE_CAT_CI_HT_ALL

624: Before_DML (
625: p_action => 'DELETE',
626: x_rowid => X_ROWID
627: );
628: delete from IGS_FI_FEE_CAT_CI_HT_ALL
629: where ROWID = X_ROWID;
630: if (sql%notfound) then
631: raise no_data_found;
632: end if;