APPS.IGS_FI_BILL_P_PLANS_PKG dependencies on IGS_FI_BILL_P_PLANS

Line 1: PACKAGE BODY igs_fi_bill_p_plans_pkg AS

1: PACKAGE BODY igs_fi_bill_p_plans_pkg AS
2: /* $Header: IGSSIE3B.pls 115.0 2003/08/26 07:20:01 smvk noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_bill_p_plans%ROWTYPE;

Line 5: old_references igs_fi_bill_p_plans%ROWTYPE;

1: PACKAGE BODY igs_fi_bill_p_plans_pkg AS
2: /* $Header: IGSSIE3B.pls 115.0 2003/08/26 07:20:01 smvk noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_bill_p_plans%ROWTYPE;
6: new_references igs_fi_bill_p_plans%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_fi_bill_p_plans%ROWTYPE;

2: /* $Header: IGSSIE3B.pls 115.0 2003/08/26 07:20:01 smvk noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_bill_p_plans%ROWTYPE;
6: new_references igs_fi_bill_p_plans%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 33: FROM igs_fi_bill_p_plans

29: */
30:
31: CURSOR cur_old_ref_values IS
32: SELECT *
33: FROM igs_fi_bill_p_plans
34: WHERE rowid = x_rowid;
35:
36: BEGIN
37:

Line 125: FROM igs_fi_bill_p_plans

121: || (reverse chronological order - newest change first)
122: */
123: CURSOR cur_rowid IS
124: SELECT rowid
125: FROM igs_fi_bill_p_plans
126: WHERE student_plan_id = x_student_plan_id
127: AND bill_id = x_bill_id;
128:
129: lv_rowid cur_rowid%RowType;

Line 160: FROM igs_fi_bill_p_plans

156: || (reverse chronological order - newest change first)
157: */
158: CURSOR cur_rowid IS
159: SELECT rowid
160: FROM igs_fi_bill_p_plans
161: WHERE ((student_plan_id = x_student_plan_id));
162:
163: lv_rowid cur_rowid%RowType;
164:

Line 305: fnd_message.set_token ('ROUTINE', 'IGS_FI_BILL_P_PLANS_PKG.INSERT_ROW');

301: x_program_update_date := SYSDATE;
302: END IF;
303: ELSE
304: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
305: fnd_message.set_token ('ROUTINE', 'IGS_FI_BILL_P_PLANS_PKG.INSERT_ROW');
306: igs_ge_msg_stack.add;
307: app_exception.raise_exception;
308: END IF;
309:

Line 324: INSERT INTO igs_fi_bill_p_plans (

320: x_last_updated_by => x_last_updated_by,
321: x_last_update_login => x_last_update_login
322: );
323:
324: INSERT INTO igs_fi_bill_p_plans (
325: student_plan_id,
326: bill_id,
327: plan_start_date,
328: plan_end_date,

Line 377: FROM igs_fi_bill_p_plans

373: CURSOR c1 IS
374: SELECT
375: plan_start_date,
376: plan_end_date
377: FROM igs_fi_bill_p_plans
378: WHERE rowid = x_rowid
379: FOR UPDATE NOWAIT;
380:
381: tlinfo c1%ROWTYPE;

Line 454: fnd_message.set_token ('ROUTINE', 'IGS_FI_BILL_P_PLANS_PKG.UPDATE_ROW');

450: x_last_update_login := -1;
451: END IF;
452: ELSE
453: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
454: fnd_message.set_token ('ROUTINE', 'IGS_FI_BILL_P_PLANS_PKG.UPDATE_ROW');
455: igs_ge_msg_stack.add;
456: app_exception.raise_exception;
457: END IF;
458:

Line 487: UPDATE igs_fi_bill_p_plans

483: x_program_update_date := SYSDATE;
484: END IF;
485: END IF;
486:
487: UPDATE igs_fi_bill_p_plans
488: SET
489: plan_start_date = new_references.plan_start_date,
490: plan_end_date = new_references.plan_end_date,
491: last_update_date = x_last_update_date,

Line 526: FROM igs_fi_bill_p_plans

522: || (reverse chronological order - newest change first)
523: */
524: CURSOR c1 IS
525: SELECT rowid
526: FROM igs_fi_bill_p_plans
527: WHERE student_plan_id = x_student_plan_id
528: AND bill_id = x_bill_id;
529:
530: BEGIN

Line 560: END igs_fi_bill_p_plans_pkg;

556: );
557:
558: END add_row;
559:
560: END igs_fi_bill_p_plans_pkg;