APPS.IGS_FI_REFUND_INT_PKG dependencies on IGS_FI_REFUND_INT_ALL

Line 5: old_references igs_fi_refund_int_all%ROWTYPE;

1: PACKAGE BODY igs_fi_refund_int_pkg AS
2: /* $Header: IGSSIC3B.pls 115.8 2003/02/19 08:05:43 pathipat noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_refund_int_all%ROWTYPE;
6: new_references igs_fi_refund_int_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_fi_refund_int_all%ROWTYPE;

2: /* $Header: IGSSIC3B.pls 115.8 2003/02/19 08:05:43 pathipat noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_refund_int_all%ROWTYPE;
6: new_references igs_fi_refund_int_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 ,

Line 67: FROM igs_fi_refund_int_all

63: */
64:
65: CURSOR cur_old_ref_values IS
66: SELECT *
67: FROM igs_fi_refund_int_all
68: WHERE rowid = x_rowid;
69:
70: BEGIN
71:

Line 298: FROM igs_fi_refund_int_all

294: || (reverse chronological order - newest change first)
295: */
296: CURSOR cur_rowid IS
297: SELECT rowid
298: FROM igs_fi_refund_int_all
299: WHERE refund_id = x_refund_id
300: FOR UPDATE NOWAIT;
301:
302: lv_rowid cur_rowid%RowType;

Line 333: FROM igs_fi_refund_int_all

329: || (reverse chronological order - newest change first)
330: */
331: CURSOR cur_rowid IS
332: SELECT rowid
333: FROM igs_fi_refund_int_all
334: WHERE ((refund_id = x_refund_id));
335:
336: lv_rowid cur_rowid%RowType;
337:

Line 368: FROM igs_fi_refund_int_all

364: || (reverse chronological order - newest change first)
365: */
366: CURSOR cur_rowid IS
367: SELECT rowid
368: FROM igs_fi_refund_int_all
369: WHERE ((invoice_id = x_invoice_id));
370:
371: lv_rowid cur_rowid%RowType;
372:

Line 403: FROM igs_fi_refund_int_all

399: || (reverse chronological order - newest change first)
400: */
401: CURSOR cur_rowid IS
402: SELECT rowid
403: FROM igs_fi_refund_int_all
404: WHERE ((source_refund_id = x_refund_id));
405:
406: lv_rowid cur_rowid%RowType;
407:

Line 619: FROM igs_fi_refund_int_all

615: || (reverse chronological order - newest change first)
616: */
617: CURSOR c IS
618: SELECT rowid
619: FROM igs_fi_refund_int_all
620: WHERE refund_id = x_refund_id;
621:
622: x_last_update_date DATE;
623: x_last_updated_by NUMBER;

Line 714: INSERT INTO igs_fi_refund_int_all (

710: x_last_update_login => x_last_update_login,
711: x_gl_date => x_gl_date
712: );
713:
714: INSERT INTO igs_fi_refund_int_all (
715: refund_id,
716: voucher_date,
717: person_id,
718: pay_person_id,

Line 911: FROM igs_fi_refund_int_all

907: attribute18,
908: attribute19,
909: attribute20,
910: gl_date
911: FROM igs_fi_refund_int_all
912: WHERE rowid = x_rowid
913: FOR UPDATE NOWAIT;
914:
915: tlinfo c1%ROWTYPE;

Line 1121: UPDATE igs_fi_refund_int_all

1117: x_program_update_date := SYSDATE;
1118: END IF;
1119: END IF;
1120:
1121: UPDATE igs_fi_refund_int_all
1122: SET
1123: voucher_date = new_references.voucher_date,
1124: person_id = new_references.person_id,
1125: pay_person_id = new_references.pay_person_id,

Line 1228: FROM igs_fi_refund_int_all

1224: || (reverse chronological order - newest change first)
1225: */
1226: CURSOR c1 IS
1227: SELECT rowid
1228: FROM igs_fi_refund_int_all
1229: WHERE refund_id = x_refund_id;
1230:
1231: BEGIN
1232:

Line 1347: DELETE FROM igs_fi_refund_int_all

1343: p_action => 'DELETE',
1344: x_rowid => x_rowid
1345: );
1346:
1347: DELETE FROM igs_fi_refund_int_all
1348: WHERE rowid = x_rowid;
1349:
1350: IF (SQL%NOTFOUND) THEN
1351: RAISE NO_DATA_FOUND;