APPS.IGS_FI_PP_INSTLMNTS_PKG dependencies on IGS_FI_PP_INSTLMNTS

Line 1: PACKAGE BODY igs_fi_pp_instlmnts_pkg AS

1: PACKAGE BODY igs_fi_pp_instlmnts_pkg AS
2: /* $Header: IGSSIE1B.pls 115.1 2003/09/08 16:12:59 shtatiko noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_pp_instlmnts%ROWTYPE;

Line 5: old_references igs_fi_pp_instlmnts%ROWTYPE;

1: PACKAGE BODY igs_fi_pp_instlmnts_pkg AS
2: /* $Header: IGSSIE1B.pls 115.1 2003/09/08 16:12:59 shtatiko noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_pp_instlmnts%ROWTYPE;
6: new_references igs_fi_pp_instlmnts%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_fi_pp_instlmnts%ROWTYPE;

2: /* $Header: IGSSIE1B.pls 115.1 2003/09/08 16:12:59 shtatiko noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_pp_instlmnts%ROWTYPE;
6: new_references igs_fi_pp_instlmnts%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 39: FROM igs_fi_pp_instlmnts

35: */
36:
37: CURSOR cur_old_ref_values IS
38: SELECT *
39: FROM igs_fi_pp_instlmnts
40: WHERE rowid = x_rowid;
41:
42: BEGIN
43:

Line 161: FROM igs_fi_pp_instlmnts

157: || (reverse chronological order - newest change first)
158: */
159: CURSOR cur_rowid IS
160: SELECT rowid
161: FROM igs_fi_pp_instlmnts
162: WHERE installment_id = x_installment_id
163: FOR UPDATE NOWAIT;
164:
165: lv_rowid cur_rowid%RowType;

Line 197: FROM igs_fi_pp_instlmnts

193: || (reverse chronological order - newest change first)
194: */
195: CURSOR cur_rowid IS
196: SELECT rowid
197: FROM igs_fi_pp_instlmnts
198: WHERE student_plan_id = x_student_plan_id
199: AND installment_line_num = x_installment_line_num
200: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
201:

Line 234: FROM igs_fi_pp_instlmnts

230: || (reverse chronological order - newest change first)
231: */
232: CURSOR cur_rowid IS
233: SELECT rowid
234: FROM igs_fi_pp_instlmnts
235: WHERE student_plan_id = x_student_plan_id
236: AND due_date = x_due_date
237: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
238:

Line 270: FROM igs_fi_pp_instlmnts

266: || (reverse chronological order - newest change first)
267: */
268: CURSOR cur_rowid IS
269: SELECT rowid
270: FROM igs_fi_pp_instlmnts
271: WHERE ((student_plan_id = x_student_plan_id));
272:
273: lv_rowid cur_rowid%RowType;
274:

Line 439: fnd_message.set_token ('ROUTINE', 'IGS_FI_PP_INSTLMNTS_PKG.INSERT_ROW');

435: x_program_update_date := SYSDATE;
436: END IF;
437: ELSE
438: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
439: fnd_message.set_token ('ROUTINE', 'IGS_FI_PP_INSTLMNTS_PKG.INSERT_ROW');
440: igs_ge_msg_stack.add;
441: app_exception.raise_exception;
442: END IF;
443:

Line 466: INSERT INTO igs_fi_pp_instlmnts (

462: x_last_updated_by => x_last_updated_by,
463: x_last_update_login => x_last_update_login
464: );
465:
466: INSERT INTO igs_fi_pp_instlmnts (
467: installment_id,
468: student_plan_id,
469: installment_line_num,
470: due_day,

Line 487: igs_fi_pp_instlmnts_s.NEXTVAL,

483: program_id,
484: program_application_id,
485: program_update_date
486: ) VALUES (
487: igs_fi_pp_instlmnts_s.NEXTVAL,
488: new_references.student_plan_id,
489: new_references.installment_line_num,
490: new_references.due_day,
491: new_references.due_month_code,

Line 544: FROM igs_fi_pp_instlmnts

540: due_date,
541: installment_amt,
542: due_amt,
543: penalty_flag
544: FROM igs_fi_pp_instlmnts
545: WHERE rowid = x_rowid
546: FOR UPDATE NOWAIT;
547:
548: tlinfo c1%ROWTYPE;

Line 634: fnd_message.set_token ('ROUTINE', 'IGS_FI_PP_INSTLMNTS_PKG.UPDATE_ROW');

630: x_last_update_login := -1;
631: END IF;
632: ELSE
633: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
634: fnd_message.set_token ('ROUTINE', 'IGS_FI_PP_INSTLMNTS_PKG.UPDATE_ROW');
635: igs_ge_msg_stack.add;
636: app_exception.raise_exception;
637: END IF;
638:

Line 673: UPDATE igs_fi_pp_instlmnts

669: x_program_update_date := SYSDATE;
670: END IF;
671: END IF;
672:
673: UPDATE igs_fi_pp_instlmnts
674: SET
675: student_plan_id = new_references.student_plan_id,
676: installment_line_num = new_references.installment_line_num,
677: due_day = new_references.due_day,

Line 725: FROM igs_fi_pp_instlmnts

721: || (reverse chronological order - newest change first)
722: */
723: CURSOR c1 IS
724: SELECT rowid
725: FROM igs_fi_pp_instlmnts
726: WHERE installment_id = x_installment_id;
727:
728: BEGIN
729:

Line 790: DELETE FROM igs_fi_pp_instlmnts

786: p_action => 'DELETE',
787: x_rowid => x_rowid
788: );
789:
790: DELETE FROM igs_fi_pp_instlmnts
791: WHERE rowid = x_rowid;
792:
793: IF (SQL%NOTFOUND) THEN
794: RAISE NO_DATA_FOUND;

Line 800: END igs_fi_pp_instlmnts_pkg;

796:
797: END delete_row;
798:
799:
800: END igs_fi_pp_instlmnts_pkg;