APPS.IGF_AP_TAX_PKG dependencies on IGF_AP_TAX_ALL

Line 5: old_references igf_ap_tax_all%ROWTYPE;

1: PACKAGE BODY igf_ap_tax_pkg AS
2: /* $Header: IGFAI20B.pls 115.7 2002/11/28 13:56:25 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_ap_tax_all%ROWTYPE;
6: new_references igf_ap_tax_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_ap_tax_all%ROWTYPE;

2: /* $Header: IGFAI20B.pls 115.7 2002/11/28 13:56:25 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_ap_tax_all%ROWTYPE;
6: new_references igf_ap_tax_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 32: FROM IGF_AP_TAX_ALL

28: */
29:
30: CURSOR cur_old_ref_values IS
31: SELECT *
32: FROM IGF_AP_TAX_ALL
33: WHERE rowid = x_rowid;
34:
35: BEGIN
36:

Line 112: FROM igf_ap_tax_all

108: || (reverse chronological order - newest change first)
109: */
110: CURSOR cur_rowid IS
111: SELECT rowid
112: FROM igf_ap_tax_all
113: WHERE base_id = x_base_id
114: FOR UPDATE NOWAIT;
115:
116: lv_rowid cur_rowid%RowType;

Line 149: FROM igf_ap_tax_all

145: || (reverse chronological order - newest change first)
146: */
147: CURSOR cur_rowid IS
148: SELECT rowid
149: FROM igf_ap_tax_all
150: WHERE ((base_id = x_base_id));
151:
152: lv_rowid cur_rowid%RowType;
153:

Line 254: FROM igf_ap_tax_all

250: || (reverse chronological order - newest change first)
251: */
252: CURSOR c IS
253: SELECT rowid
254: FROM igf_ap_tax_all
255: WHERE base_id = x_base_id;
256:
257: x_last_update_date DATE;
258: x_last_updated_by NUMBER;

Line 261: l_org_id igf_ap_tax_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;

257: x_last_update_date DATE;
258: x_last_updated_by NUMBER;
259: x_last_update_login NUMBER;
260:
261: l_org_id igf_ap_tax_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;
262:
263: BEGIN
264:
265: x_last_update_date := SYSDATE;

Line 297: INSERT INTO igf_ap_tax_all (

293: x_last_updated_by => x_last_updated_by,
294: x_last_update_login => x_last_update_login
295: );
296:
297: INSERT INTO igf_ap_tax_all (
298: base_id,
299: taxes_paid,
300: agi,
301: creation_date,

Line 350: FROM igf_ap_tax_all

346: SELECT
347: taxes_paid,
348: agi,
349: org_id
350: FROM igf_ap_tax_all
351: WHERE rowid = x_rowid
352: FOR UPDATE NOWAIT;
353:
354: tlinfo c1%ROWTYPE;

Line 441: UPDATE igf_ap_tax_all

437: x_last_updated_by => x_last_updated_by,
438: x_last_update_login => x_last_update_login
439: );
440:
441: UPDATE igf_ap_tax_all
442: SET
443: taxes_paid = new_references.taxes_paid,
444: agi = new_references.agi,
445: last_update_date = x_last_update_date,

Line 475: FROM igf_ap_tax_all

471: || (reverse chronological order - newest change first)
472: */
473: CURSOR c1 IS
474: SELECT rowid
475: FROM igf_ap_tax_all
476: WHERE base_id = x_base_id;
477:
478: BEGIN
479:

Line 526: DELETE FROM igf_ap_tax_all

522: p_action => 'DELETE',
523: x_rowid => x_rowid
524: );
525:
526: DELETE FROM igf_ap_tax_all
527: WHERE rowid = x_rowid;
528:
529: IF (SQL%NOTFOUND) THEN
530: RAISE NO_DATA_FOUND;