APPS.IGS_FI_F_CAT_F_LBL_H_PKG dependencies on IGS_FI_F_CAT_F_LBL_H_ALL

Line 4: old_references IGS_FI_F_CAT_F_LBL_H_ALL%RowType;

1: package body IGS_FI_F_CAT_F_LBL_H_PKG AS
2: /* $Header: IGSSI46B.pls 115.9 2002/11/29 03:48:46 nsidana ship $*/
3: l_rowid VARCHAR2(25);
4: old_references IGS_FI_F_CAT_F_LBL_H_ALL%RowType;
5: new_references IGS_FI_F_CAT_F_LBL_H_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_F_CAT_F_LBL_H_ALL%RowType;

1: package body IGS_FI_F_CAT_F_LBL_H_PKG AS
2: /* $Header: IGSSI46B.pls 115.9 2002/11/29 03:48:46 nsidana ship $*/
3: l_rowid VARCHAR2(25);
4: old_references IGS_FI_F_CAT_F_LBL_H_ALL%RowType;
5: new_references IGS_FI_F_CAT_F_LBL_H_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 42: FROM IGS_FI_F_CAT_F_LBL_H_ALL

38: || into new_references.value.
39: ----------------------------------------------------------------------------*/
40: CURSOR cur_old_ref_values IS
41: SELECT *
42: FROM IGS_FI_F_CAT_F_LBL_H_ALL
43: WHERE rowid = x_rowid;
44: BEGIN
45: l_rowid := x_rowid;
46: -- Code for setting the Old and New Reference Values.

Line 166: FROM IGS_FI_F_CAT_F_LBL_H_ALL

162: x_hist_start_dt IN DATE
163: ) RETURN BOOLEAN AS
164: CURSOR cur_rowid IS
165: SELECT rowid
166: FROM IGS_FI_F_CAT_F_LBL_H_ALL
167: WHERE fee_cat = x_fee_cat
168: AND fee_cal_type = x_fee_cal_type
169: AND fee_ci_sequence_number = x_fee_ci_sequence_number
170: AND fee_type = x_fee_type

Line 303: cursor C is select ROWID from IGS_FI_F_CAT_F_LBL_H_ALL

299: || (reverse chronological order - newest change first)
300: || vvutukur 19-Jul-2002 Bug#2425767.removed parameter x_payment_hierarchy_rank,
301: || and from call to before_dml and insert statement.
302: ----------------------------------------------------------------------------*/
303: cursor C is select ROWID from IGS_FI_F_CAT_F_LBL_H_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 FEE_TYPE = X_FEE_TYPE

Line 353: insert into IGS_FI_F_CAT_F_LBL_H_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_F_CAT_F_LBL_H_ALL (
354: FEE_CAT,
355: FEE_CAL_TYPE,
356: FEE_CI_SEQUENCE_NUMBER,
357: FEE_TYPE,

Line 434: from IGS_FI_F_CAT_F_LBL_H_ALL

430: START_DT_ALIAS,
431: START_DAI_SEQUENCE_NUMBER,
432: S_CHG_METHOD_TYPE,
433: RUL_SEQUENCE_NUMBER
434: from IGS_FI_F_CAT_F_LBL_H_ALL
435: where ROWID=X_ROWID
436: for update nowait;
437: tlinfo c1%rowtype;
438: begin

Line 545: update IGS_FI_F_CAT_F_LBL_H_ALL set

541: x_last_update_date=>X_LAST_UPDATE_DATE,
542: x_last_updated_by=>X_LAST_UPDATED_BY,
543: x_last_update_login=>X_LAST_UPDATE_LOGIN
544: );
545: update IGS_FI_F_CAT_F_LBL_H_ALL set
546: HIST_END_DT = NEW_REFERENCES.HIST_END_DT,
547: HIST_WHO = NEW_REFERENCES.HIST_WHO,
548: FEE_LIABILITY_STATUS = NEW_REFERENCES.FEE_LIABILITY_STATUS,
549: START_DT_ALIAS = NEW_REFERENCES.START_DT_ALIAS,

Line 590: cursor c1 is select rowid from IGS_FI_F_CAT_F_LBL_H_ALL

586: || (reverse chronological order - newest change first)
587: || vvutukur 19-Jul-2002 Bug#2425767.removed parameter x_payment_hierarchy_rank,
588: || and from calls to insert_row and update_row.
589: ----------------------------------------------------------------------------*/
590: cursor c1 is select rowid from IGS_FI_F_CAT_F_LBL_H_ALL
591: where FEE_CAT = X_FEE_CAT
592: and FEE_CAL_TYPE = X_FEE_CAL_TYPE
593: and FEE_CI_SEQUENCE_NUMBER = X_FEE_CI_SEQUENCE_NUMBER
594: and FEE_TYPE = X_FEE_TYPE

Line 645: delete from IGS_FI_F_CAT_F_LBL_H_ALL

641: BEFORE_DML (
642: p_action=>'DELETE',
643: x_rowid=>X_ROWID
644: );
645: delete from IGS_FI_F_CAT_F_LBL_H_ALL
646: where ROWID=X_ROWID;
647: if (sql%notfound) then
648: raise no_data_found;
649: end if;