APPS.IGS_FI_FIN_LT_PLAN_PKG dependencies on IGS_FI_FIN_LT_PLAN

Line 1: PACKAGE BODY igs_fi_fin_lt_plan_pkg AS

1: PACKAGE BODY igs_fi_fin_lt_plan_pkg AS
2: /* $Header: IGSSIB5B.pls 115.16 2003/09/16 10:22:14 vvutukur ship $ */
3: /* Change History
4: Who When What
5: vvutukur 07-Sep-2003 Enh#3045007.Payment Plans Build.Addition of 7 columns related to

Line 17: old_references igs_fi_fin_lt_plan%ROWTYPE;

13: */
14:
15:
16: l_rowid VARCHAR2(25);
17: old_references igs_fi_fin_lt_plan%ROWTYPE;
18: new_references igs_fi_fin_lt_plan%ROWTYPE;
19:
20: PROCEDURE set_column_values (
21: p_action IN VARCHAR2,

Line 18: new_references igs_fi_fin_lt_plan%ROWTYPE;

14:
15:
16: l_rowid VARCHAR2(25);
17: old_references igs_fi_fin_lt_plan%ROWTYPE;
18: new_references igs_fi_fin_lt_plan%ROWTYPE;
19:
20: PROCEDURE set_column_values (
21: p_action IN VARCHAR2,
22: x_rowid IN VARCHAR2 ,

Line 84: FROM IGS_FI_FIN_LT_PLAN

80: */
81:
82: CURSOR cur_old_ref_values IS
83: SELECT *
84: FROM IGS_FI_FIN_LT_PLAN
85: WHERE rowid = x_rowid;
86:
87: BEGIN
88:

Line 348: FROM igs_fi_fin_lt_plan

344: || (reverse chronological order - newest change first)
345: */
346: CURSOR cur_rowid IS
347: SELECT rowid
348: FROM igs_fi_fin_lt_plan
349: WHERE plan_name = x_plan_name
350: FOR UPDATE NOWAIT;
351:
352: lv_rowid cur_rowid%RowType;

Line 583: FROM igs_fi_fin_lt_plan

579: || payment plans.
580: */
581: CURSOR c IS
582: SELECT rowid
583: FROM igs_fi_fin_lt_plan
584: WHERE plan_name = x_plan_name;
585:
586: x_last_update_date DATE;
587: x_last_updated_by NUMBER;

Line 663: INSERT INTO igs_fi_fin_lt_plan (

659: x_payment_plan_minchgamt_nochg => x_payment_plan_minchgamt_nochg,
660: x_payment_plan_min_balance_amt => x_payment_plan_min_balance_amt
661: );
662:
663: INSERT INTO igs_fi_fin_lt_plan (
664: plan_name,
665: plan_type,
666: description,
667: closed_ind,

Line 871: FROM igs_fi_fin_lt_plan

867: payment_plan_max_charge_amt,
868: payment_plan_min_charge_amt,
869: payment_plan_minchgamt_nochg,
870: payment_plan_min_balance_amt
871: FROM igs_fi_fin_lt_plan
872: WHERE rowid = x_rowid
873: FOR UPDATE NOWAIT;
874:
875: tlinfo c1%ROWTYPE;

Line 1079: UPDATE igs_fi_fin_lt_plan

1075: x_payment_plan_minchgamt_nochg => x_payment_plan_minchgamt_nochg,
1076: x_payment_plan_min_balance_amt => x_payment_plan_min_balance_amt
1077: );
1078:
1079: UPDATE igs_fi_fin_lt_plan
1080: SET
1081: plan_type = new_references.plan_type,
1082: description = new_references.description,
1083: closed_ind = new_references.closed_ind,

Line 1193: FROM igs_fi_fin_lt_plan

1189: || payment plans.
1190: */
1191: CURSOR c1 IS
1192: SELECT rowid
1193: FROM igs_fi_fin_lt_plan
1194: WHERE plan_name = x_plan_name;
1195:
1196: BEGIN
1197:

Line 1322: DELETE FROM igs_fi_fin_lt_plan

1318: p_action => 'DELETE',
1319: x_rowid => x_rowid
1320: );
1321:
1322: DELETE FROM igs_fi_fin_lt_plan
1323: WHERE rowid = x_rowid;
1324:
1325: IF (SQL%NOTFOUND) THEN
1326: RAISE NO_DATA_FOUND;

Line 1332: END igs_fi_fin_lt_plan_pkg;

1328:
1329: END delete_row;
1330:
1331:
1332: END igs_fi_fin_lt_plan_pkg;