APPS.IGF_AW_ITEM_PKG dependencies on IGF_AW_ITEM

Line 1: PACKAGE BODY igf_aw_item_pkg AS

1: PACKAGE BODY igf_aw_item_pkg AS
2: /* $Header: IGFWI02B.pls 115.10 2003/12/05 16:07:01 ugummall ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_item%ROWTYPE;

Line 5: old_references igf_aw_item%ROWTYPE;

1: PACKAGE BODY igf_aw_item_pkg AS
2: /* $Header: IGFWI02B.pls 115.10 2003/12/05 16:07:01 ugummall ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_item%ROWTYPE;
6: new_references igf_aw_item%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_aw_item%ROWTYPE;

2: /* $Header: IGFWI02B.pls 115.10 2003/12/05 16:07:01 ugummall ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_item%ROWTYPE;
6: new_references igf_aw_item%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 33: FROM IGF_AW_ITEM

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

Line 86: igf_aw_coa_grp_item_pkg.get_fk_igf_aw_item (

82: || (reverse chronological order - newest change first)
83: */
84: BEGIN
85:
86: igf_aw_coa_grp_item_pkg.get_fk_igf_aw_item (
87: old_references.item_code
88: );
89:
90: igf_aw_coa_items_pkg.get_fk_igf_aw_item(

Line 90: igf_aw_coa_items_pkg.get_fk_igf_aw_item(

86: igf_aw_coa_grp_item_pkg.get_fk_igf_aw_item (
87: old_references.item_code
88: );
89:
90: igf_aw_coa_items_pkg.get_fk_igf_aw_item(
91: old_references.item_code
92: );
93:
94: END check_child_existance;

Line 112: FROM igf_aw_item

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

Line 221: FROM igf_aw_item

217: || (reverse chronological order - newest change first)
218: */
219: CURSOR c IS
220: SELECT rowid
221: FROM igf_aw_item
222: WHERE item_code = x_item_code;
223:
224: x_last_update_date DATE;
225: x_last_updated_by NUMBER;

Line 263: INSERT INTO igf_aw_item (

259: x_last_update_login => x_last_update_login,
260: x_item_category_code => x_item_category_code
261: );
262:
263: INSERT INTO igf_aw_item (
264: item_code,
265: description,
266: active,
267: creation_date,

Line 317: FROM igf_aw_item

313: SELECT
314: description,
315: active,
316: item_category_code
317: FROM igf_aw_item
318: WHERE rowid = x_rowid
319: FOR UPDATE NOWAIT;
320:
321: tlinfo c1%ROWTYPE;

Line 409: UPDATE igf_aw_item

405: x_last_update_login => x_last_update_login,
406: x_item_category_code => x_item_category_code
407: );
408:
409: UPDATE igf_aw_item
410: SET
411: description = new_references.description,
412: active = new_references.active,
413: last_update_date = x_last_update_date,

Line 445: FROM igf_aw_item

441: || (reverse chronological order - newest change first)
442: */
443: CURSOR c1 IS
444: SELECT rowid
445: FROM igf_aw_item
446: WHERE item_code = x_item_code;
447:
448: BEGIN
449:

Line 498: DELETE FROM igf_aw_item

494: p_action => 'DELETE',
495: x_rowid => x_rowid
496: );
497:
498: DELETE FROM igf_aw_item
499: WHERE rowid = x_rowid;
500:
501: IF (SQL%NOTFOUND) THEN
502: RAISE NO_DATA_FOUND;

Line 507: END igf_aw_item_pkg;

503: END IF;
504:
505: END delete_row;
506:
507: END igf_aw_item_pkg;