APPS.IGS_FI_BILL_INSTLS_PKG dependencies on IGS_FI_BILL_INSTLS

Line 1: PACKAGE BODY igs_fi_bill_instls_pkg AS

1: PACKAGE BODY igs_fi_bill_instls_pkg AS
2: /* $Header: IGSSIE4B.pls 115.0 2003/08/26 07:22:23 smvk noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_bill_instls%ROWTYPE;

Line 5: old_references igs_fi_bill_instls%ROWTYPE;

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

Line 6: new_references igs_fi_bill_instls%ROWTYPE;

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

Line 36: FROM igs_fi_bill_instls

32: */
33:
34: CURSOR cur_old_ref_values IS
35: SELECT *
36: FROM igs_fi_bill_instls
37: WHERE rowid = x_rowid;
38:
39: BEGIN
40:

Line 147: FROM igs_fi_bill_instls

143: || (reverse chronological order - newest change first)
144: */
145: CURSOR cur_rowid IS
146: SELECT rowid
147: FROM igs_fi_bill_instls
148: WHERE student_plan_id = x_student_plan_id
149: AND bill_id = x_bill_id
150: AND installment_id = x_installment_id;
151:

Line 304: fnd_message.set_token ('ROUTINE', 'IGS_FI_BILL_INSTLS_PKG.INSERT_ROW');

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

Line 326: INSERT INTO igs_fi_bill_instls (

322: x_last_updated_by => x_last_updated_by,
323: x_last_update_login => x_last_update_login
324: );
325:
326: INSERT INTO igs_fi_bill_instls (
327: student_plan_id,
328: bill_id,
329: installment_id,
330: installment_line_num,

Line 390: FROM igs_fi_bill_instls

386: installment_line_num,
387: installment_due_date,
388: installment_amt,
389: due_amt
390: FROM igs_fi_bill_instls
391: WHERE rowid = x_rowid
392: FOR UPDATE NOWAIT;
393:
394: tlinfo c1%ROWTYPE;

Line 472: fnd_message.set_token ('ROUTINE', 'IGS_FI_BILL_INSTLS_PKG.UPDATE_ROW');

468: x_last_update_login := -1;
469: END IF;
470: ELSE
471: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
472: fnd_message.set_token ('ROUTINE', 'IGS_FI_BILL_INSTLS_PKG.UPDATE_ROW');
473: igs_ge_msg_stack.add;
474: app_exception.raise_exception;
475: END IF;
476:

Line 508: UPDATE igs_fi_bill_instls

504: x_program_update_date := SYSDATE;
505: END IF;
506: END IF;
507:
508: UPDATE igs_fi_bill_instls
509: SET
510: installment_line_num = new_references.installment_line_num,
511: installment_due_date = new_references.installment_due_date,
512: installment_amt = new_references.installment_amt,

Line 552: FROM igs_fi_bill_instls

548: || (reverse chronological order - newest change first)
549: */
550: CURSOR c1 IS
551: SELECT rowid
552: FROM igs_fi_bill_instls
553: WHERE student_plan_id = x_student_plan_id
554: AND bill_id = x_bill_id
555: AND installment_id = x_installment_id;
556:

Line 593: END igs_fi_bill_instls_pkg;

589: );
590:
591: END add_row;
592:
593: END igs_fi_bill_instls_pkg;