APPS.IGS_FI_BILL_PKG dependencies on IGS_FI_BILL_ALL

Line 5: old_references igs_fi_bill_all%ROWTYPE;

1: PACKAGE BODY igs_fi_bill_pkg AS
2: /* $Header: IGSSIB6B.pls 115.9 2002/12/05 06:18:55 shtatiko ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_bill_all%ROWTYPE;
6: new_references igs_fi_bill_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_fi_bill_all%ROWTYPE;

2: /* $Header: IGSSIB6B.pls 115.9 2002/12/05 06:18:55 shtatiko ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_bill_all%ROWTYPE;
6: new_references igs_fi_bill_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 43: FROM IGS_FI_BILL_ALL

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

Line 215: FROM igs_fi_bill_all

211: || (reverse chronological order - newest change first)
212: */
213: CURSOR cur_rowid IS
214: SELECT rowid
215: FROM igs_fi_bill_all
216: WHERE bill_id = x_bill_id
217: FOR UPDATE NOWAIT;
218:
219: lv_rowid cur_rowid%RowType;

Line 251: FROM igs_fi_bill_all

247: || (reverse chronological order - newest change first)
248: */
249: CURSOR cur_rowid IS
250: SELECT rowid
251: FROM igs_fi_bill_all
252: WHERE cut_off_date = x_cut_off_date
253: AND person_id = x_person_id
254: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
255:

Line 286: FROM igs_fi_bill_all

282: || (reverse chronological order - newest change first)
283: */
284: CURSOR cur_rowid IS
285: SELECT rowid
286: FROM igs_fi_bill_all
287: WHERE ((person_id = x_party_id));
288:
289: lv_rowid cur_rowid%RowType;
290:

Line 432: FROM igs_fi_bill_all

428: || to_pay_amount
429: */
430: CURSOR c IS
431: SELECT rowid
432: FROM igs_fi_bill_all
433: WHERE bill_id = x_bill_id;
434:
435: x_last_update_date DATE;
436: x_last_updated_by NUMBER;

Line 503: INSERT INTO igs_fi_bill_all (

499: x_last_updated_by => x_last_updated_by,
500: x_last_update_login => x_last_update_login
501: );
502:
503: INSERT INTO igs_fi_bill_all (
504: bill_id,
505: org_id,
506: bill_number,
507: bill_date,

Line 601: FROM igs_fi_bill_all

597: closing_balance,
598: printed_flag,
599: print_date,
600: to_pay_amount
601: FROM igs_fi_bill_all
602: WHERE rowid = x_rowid
603: FOR UPDATE NOWAIT;
604:
605: tlinfo c1%ROWTYPE;

Line 737: UPDATE igs_fi_bill_all

733: x_program_update_date := SYSDATE;
734: END IF;
735: END IF;
736:
737: UPDATE igs_fi_bill_all
738: SET
739: bill_number = new_references.bill_number,
740: bill_date = new_references.bill_date,
741: due_date = new_references.due_date,

Line 795: FROM igs_fi_bill_all

791: || to_pay_amount
792: */
793: CURSOR c1 IS
794: SELECT rowid
795: FROM igs_fi_bill_all
796: WHERE bill_id = x_bill_id;
797:
798: BEGIN
799:

Line 864: DELETE FROM igs_fi_bill_all

860: p_action => 'DELETE',
861: x_rowid => x_rowid
862: );
863:
864: DELETE FROM igs_fi_bill_all
865: WHERE rowid = x_rowid;
866:
867: IF (SQL%NOTFOUND) THEN
868: RAISE NO_DATA_FOUND;