APPS.IGS_FI_HOLD_PLAN_PKG dependencies on IGS_FI_HOLD_PLAN

Line 1: PACKAGE BODY igs_fi_hold_plan_pkg AS

1: PACKAGE BODY igs_fi_hold_plan_pkg AS
2: /* $Header: IGSSIA6B.pls 115.18 2003/09/12 10:24:46 vvutukur ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_hold_plan%ROWTYPE;

Line 5: old_references igs_fi_hold_plan%ROWTYPE;

1: PACKAGE BODY igs_fi_hold_plan_pkg AS
2: /* $Header: IGSSIA6B.pls 115.18 2003/09/12 10:24:46 vvutukur ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_hold_plan%ROWTYPE;
6: new_references igs_fi_hold_plan%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_fi_hold_plan%ROWTYPE;

2: /* $Header: IGSSIA6B.pls 115.18 2003/09/12 10:24:46 vvutukur ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_hold_plan%ROWTYPE;
6: new_references igs_fi_hold_plan%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 ,

Line 42: FROM igs_fi_hold_plan

38: */
39:
40: CURSOR cur_old_ref_values IS
41: SELECT *
42: FROM igs_fi_hold_plan
43: WHERE rowid = x_rowid;
44:
45: BEGIN
46:

Line 137: || igs_fi_hold_plns_pkg.get_fk_igs_fi_hold_plan

133: || Known limitations, enhancements or remarks :
134: || Change History :
135: || Who When What
136: || smadathi 18-dec-2002 Enh Bug 2566615. Removed
137: || igs_fi_hold_plns_pkg.get_fk_igs_fi_hold_plan
138: || call
139: || (reverse chronological order - newest change first)
140: */
141: BEGIN

Line 144: igs_fi_person_holds_pkg.get_fk_igs_fi_hold_plan (

140: */
141: BEGIN
142:
143:
144: igs_fi_person_holds_pkg.get_fk_igs_fi_hold_plan (
145: old_references.hold_plan_name
146: );
147:
148: END check_child_existance;

Line 165: FROM igs_fi_hold_plan

161: || (reverse chronological order - newest change first)
162: */
163: CURSOR cur_rowid IS
164: SELECT rowid
165: FROM igs_fi_hold_plan
166: WHERE hold_plan_name = x_hold_plan_name
167: FOR UPDATE NOWAIT;
168:
169: lv_rowid cur_rowid%RowType;

Line 199: FROM igs_fi_hold_plan

195: || (reverse chronological order - newest change first)
196: */
197: CURSOR cur_rowid IS
198: SELECT rowid
199: FROM igs_fi_hold_plan
200: WHERE ((hold_type = x_encumbrance_type));
201:
202: lv_rowid cur_rowid%RowType;
203:

Line 362: FROM igs_fi_hold_plan

358: || (reverse chronological order - newest change first)
359: */
360: CURSOR c IS
361: SELECT rowid
362: FROM igs_fi_hold_plan
363: WHERE hold_plan_name = x_hold_plan_name;
364:
365: x_last_update_date DATE;
366: x_last_updated_by NUMBER;

Line 411: INSERT INTO igs_fi_hold_plan (

407: x_payment_plan_threshold_amt => x_payment_plan_threshold_amt,
408: x_payment_plan_threshold_pcent => x_payment_plan_threshold_pcent
409: );
410:
411: INSERT INTO igs_fi_hold_plan (
412: hold_plan_name,
413: hold_plan_desc,
414: hold_plan_level,
415: hold_type,

Line 495: FROM igs_fi_hold_plan

491: fee_type,
492: offset_days,
493: payment_plan_threshold_amt,
494: payment_plan_threshold_pcent
495: FROM igs_fi_hold_plan
496: WHERE rowid = x_rowid
497: FOR UPDATE NOWAIT;
498:
499: tlinfo c1%ROWTYPE;

Line 610: UPDATE igs_fi_hold_plan

606: x_payment_plan_threshold_amt => x_payment_plan_threshold_amt,
607: x_payment_plan_threshold_pcent => x_payment_plan_threshold_pcent
608: );
609:
610: UPDATE igs_fi_hold_plan
611: SET
612: hold_plan_desc = new_references.hold_plan_desc,
613: hold_plan_level = new_references.hold_plan_level,
614: hold_type = new_references.hold_type,

Line 662: FROM igs_fi_hold_plan

658: || (reverse chronological order - newest change first)
659: */
660: CURSOR c1 IS
661: SELECT rowid
662: FROM igs_fi_hold_plan
663: WHERE hold_plan_name = x_hold_plan_name;
664:
665: BEGIN
666:

Line 729: DELETE FROM igs_fi_hold_plan

725: p_action => 'DELETE',
726: x_rowid => x_rowid
727: );
728:
729: DELETE FROM igs_fi_hold_plan
730: WHERE rowid = x_rowid;
731:
732: IF (SQL%NOTFOUND) THEN
733: RAISE NO_DATA_FOUND;

Line 738: END igs_fi_hold_plan_pkg;

734: END IF;
735:
736: END delete_row;
737:
738: END igs_fi_hold_plan_pkg;