APPS.IGS_FI_BILL_PLN_CRD_PKG dependencies on IGS_FI_BILL_PLN_CRD

Line 1: PACKAGE BODY igs_fi_bill_pln_crd_pkg AS

1: PACKAGE BODY igs_fi_bill_pln_crd_pkg AS
2: /* $Header: IGSSIC4B.pls 115.3 2002/11/29 04:06:54 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_bill_pln_crd%ROWTYPE;

Line 5: old_references igs_fi_bill_pln_crd%ROWTYPE;

1: PACKAGE BODY igs_fi_bill_pln_crd_pkg AS
2: /* $Header: IGSSIC4B.pls 115.3 2002/11/29 04:06:54 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_bill_pln_crd%ROWTYPE;
6: new_references igs_fi_bill_pln_crd%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_fi_bill_pln_crd%ROWTYPE;

2: /* $Header: IGSSIC4B.pls 115.3 2002/11/29 04:06:54 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_bill_pln_crd%ROWTYPE;
6: new_references igs_fi_bill_pln_crd%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 39: FROM igs_fi_bill_pln_crd

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

Line 166: FROM igs_fi_bill_pln_crd

162: || (reverse chronological order - newest change first)
163: */
164: CURSOR cur_rowid IS
165: SELECT rowid
166: FROM igs_fi_bill_pln_crd
167: WHERE bill_id = x_bill_id
168: AND award_id = x_award_id
169: AND disb_num = x_disb_num
170: FOR UPDATE NOWAIT;

Line 203: FROM igs_fi_bill_pln_crd

199: || (reverse chronological order - newest change first)
200: */
201: CURSOR cur_rowid IS
202: SELECT rowid
203: FROM igs_fi_bill_pln_crd
204: WHERE ((bill_id = x_bill_id));
205:
206: lv_rowid cur_rowid%RowType;
207:

Line 238: FROM igs_fi_bill_pln_crd

234: || (reverse chronological order - newest change first)
235: */
236: CURSOR cur_rowid IS
237: SELECT rowid
238: FROM igs_fi_bill_pln_crd
239: WHERE ((fund_id = x_fund_id));
240:
241: lv_rowid cur_rowid%RowType;
242:

Line 274: FROM igs_fi_bill_pln_crd

270: || (reverse chronological order - newest change first)
271: */
272: CURSOR cur_rowid IS
273: SELECT rowid
274: FROM igs_fi_bill_pln_crd
275: WHERE ((fee_cal_type = x_cal_type) AND
276: (fee_ci_sequence_number = x_sequence_number));
277:
278: lv_rowid cur_rowid%RowType;

Line 311: FROM igs_fi_bill_pln_crd

307: || (reverse chronological order - newest change first)
308: */
309: CURSOR cur_rowid IS
310: SELECT rowid
311: FROM igs_fi_bill_pln_crd
312: WHERE ((award_id = x_award_id) AND
313: (disb_num = x_disb_num));
314:
315: lv_rowid cur_rowid%RowType;

Line 441: FROM igs_fi_bill_pln_crd

437: || (reverse chronological order - newest change first)
438: */
439: CURSOR c IS
440: SELECT rowid
441: FROM igs_fi_bill_pln_crd
442: WHERE bill_id = x_bill_id
443: AND award_id = x_award_id
444: AND disb_num = x_disb_num;
445:

Line 506: INSERT INTO igs_fi_bill_pln_crd (

502: x_last_update_login => x_last_update_login,
503: x_bill_desc => x_bill_desc
504: );
505:
506: INSERT INTO igs_fi_bill_pln_crd (
507: bill_id,
508: award_id,
509: disb_num,
510: pln_credit_date,

Line 587: FROM igs_fi_bill_pln_crd

583: fee_cal_type,
584: fee_ci_sequence_number,
585: pln_credit_amount,
586: bill_desc
587: FROM igs_fi_bill_pln_crd
588: WHERE rowid = x_rowid
589: FOR UPDATE NOWAIT;
590:
591: tlinfo c1%ROWTYPE;

Line 711: UPDATE igs_fi_bill_pln_crd

707: x_program_update_date := SYSDATE;
708: END IF;
709: END IF;
710:
711: UPDATE igs_fi_bill_pln_crd
712: SET
713: pln_credit_date = new_references.pln_credit_date,
714: fund_id = new_references.fund_id,
715: fee_cal_type = new_references.fee_cal_type,

Line 760: FROM igs_fi_bill_pln_crd

756: || (reverse chronological order - newest change first)
757: */
758: CURSOR c1 IS
759: SELECT rowid
760: FROM igs_fi_bill_pln_crd
761: WHERE bill_id = x_bill_id
762: AND award_id = x_award_id
763: AND disb_num = x_disb_num;
764:

Line 825: DELETE FROM igs_fi_bill_pln_crd

821: p_action => 'DELETE',
822: x_rowid => x_rowid
823: );
824:
825: DELETE FROM igs_fi_bill_pln_crd
826: WHERE rowid = x_rowid;
827:
828: IF (SQL%NOTFOUND) THEN
829: RAISE NO_DATA_FOUND;

Line 835: END igs_fi_bill_pln_crd_pkg;

831:
832: END delete_row;
833:
834:
835: END igs_fi_bill_pln_crd_pkg;