APPS.IGS_FI_PERSON_HOLDS_PKG dependencies on IGS_FI_PERSON_HOLDS

Line 1: PACKAGE BODY igs_fi_person_holds_pkg AS

1: PACKAGE BODY igs_fi_person_holds_pkg AS
2: /* $Header: IGSSIB2B.pls 115.14 2003/09/19 12:31:18 smadathi ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_person_holds%ROWTYPE;

Line 5: old_references igs_fi_person_holds%ROWTYPE;

1: PACKAGE BODY igs_fi_person_holds_pkg AS
2: /* $Header: IGSSIB2B.pls 115.14 2003/09/19 12:31:18 smadathi ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_person_holds%ROWTYPE;
6: new_references igs_fi_person_holds%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_fi_person_holds%ROWTYPE;

2: /* $Header: IGSSIB2B.pls 115.14 2003/09/19 12:31:18 smadathi ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_person_holds%ROWTYPE;
6: new_references igs_fi_person_holds%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 ,

Line 43: FROM igs_fi_person_holds

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

Line 186: FROM igs_fi_person_holds

182: || (reverse chronological order - newest change first)
183: */
184: CURSOR cur_rowid IS
185: SELECT rowid
186: FROM igs_fi_person_holds
187: WHERE person_id = x_person_id
188: AND hold_type = x_hold_type
189: AND hold_start_dt = x_hold_start_dt
190: FOR UPDATE NOWAIT;

Line 222: FROM igs_fi_person_holds

218: || (reverse chronological order - newest change first)
219: */
220: CURSOR cur_rowid IS
221: SELECT rowid
222: FROM igs_fi_person_holds
223: WHERE ((hold_plan_name = x_hold_plan_name));
224:
225: lv_rowid cur_rowid%RowType;
226:

Line 257: FROM igs_fi_person_holds

253: || (reverse chronological order - newest change first)
254: */
255: CURSOR cur_rowid IS
256: SELECT rowid
257: FROM igs_fi_person_holds
258: WHERE ((hold_type = x_encumbrance_type));
259:
260: lv_rowid cur_rowid%RowType;
261:

Line 328: FROM igs_fi_person_holds

324: || (reverse chronological order - newest change first)
325: */
326: CURSOR cur_rowid IS
327: SELECT rowid
328: FROM igs_fi_person_holds
329: WHERE ((fee_cal_type = x_cal_type) AND
330: (fee_ci_sequence_number = x_sequence_number));
331:
332: lv_rowid cur_rowid%RowType;

Line 487: FROM igs_fi_person_holds

483: || (reverse chronological order - newest change first)
484: */
485: CURSOR c IS
486: SELECT rowid
487: FROM igs_fi_person_holds
488: WHERE person_id = x_person_id
489: AND hold_type = x_hold_type
490: AND hold_start_dt = x_hold_start_dt;
491:

Line 557: INSERT INTO igs_fi_person_holds (

553: x_student_plan_id => x_student_plan_id,
554: x_last_instlmnt_due_date => x_last_instlmnt_due_date
555: );
556:
557: INSERT INTO igs_fi_person_holds (
558: person_id,
559: hold_plan_name,
560: hold_type,
561: hold_start_dt,

Line 657: FROM igs_fi_person_holds

653: fee_type_invoice_amount,
654: release_credit_id,
655: student_plan_id ,
656: last_instlmnt_due_date
657: FROM igs_fi_person_holds
658: WHERE rowid = x_rowid
659: FOR UPDATE NOWAIT;
660:
661: tlinfo c1%ROWTYPE;

Line 795: UPDATE igs_fi_person_holds

791: x_program_update_date := SYSDATE;
792: END IF;
793: END IF;
794:
795: UPDATE igs_fi_person_holds
796: SET
797: hold_plan_name = new_references.hold_plan_name,
798: process_start_dt = new_references.process_start_dt,
799: process_end_dt = new_references.process_end_dt,

Line 853: FROM igs_fi_person_holds

849: || (reverse chronological order - newest change first)
850: */
851: CURSOR c1 IS
852: SELECT rowid
853: FROM igs_fi_person_holds
854: WHERE person_id = x_person_id
855: AND hold_type = x_hold_type
856: AND hold_start_dt = x_hold_start_dt;
857:

Line 928: DELETE FROM igs_fi_person_holds

924: p_action => 'DELETE',
925: x_rowid => x_rowid
926: );
927:
928: DELETE FROM igs_fi_person_holds
929: WHERE rowid = x_rowid;
930:
931: IF (SQL%NOTFOUND) THEN
932: RAISE NO_DATA_FOUND;

Line 938: END igs_fi_person_holds_pkg;

934:
935: END delete_row;
936:
937:
938: END igs_fi_person_holds_pkg;