APPS.IGF_AW_CIT_LD_OVRD_PKG dependencies on IGF_AW_CIT_LD_OVRD_ALL

Line 5: old_references igf_aw_cit_ld_ovrd_all%ROWTYPE;

1: PACKAGE BODY igf_aw_cit_ld_ovrd_pkg AS
2: /* $Header: IGFWI52B.pls 115.2 2002/11/28 11:24:01 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_cit_ld_ovrd_all%ROWTYPE;
6: new_references igf_aw_cit_ld_ovrd_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_aw_cit_ld_ovrd_all%ROWTYPE;

2: /* $Header: IGFWI52B.pls 115.2 2002/11/28 11:24:01 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_cit_ld_ovrd_all%ROWTYPE;
6: new_references igf_aw_cit_ld_ovrd_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 37: FROM IGF_AW_CIT_LD_OVRD_ALL

33: */
34:
35: CURSOR cur_old_ref_values IS
36: SELECT *
37: FROM IGF_AW_CIT_LD_OVRD_ALL
38: WHERE rowid = x_rowid;
39:
40: BEGIN
41:

Line 132: FROM igf_aw_cit_ld_ovrd_all

128: || (reverse chronological order - newest change first)
129: */
130: CURSOR cur_rowid IS
131: SELECT rowid
132: FROM igf_aw_cit_ld_ovrd_all
133: WHERE cldo_id = x_cldo_id
134: FOR UPDATE NOWAIT;
135:
136: lv_rowid cur_rowid%RowType;

Line 170: FROM igf_aw_cit_ld_ovrd_all

166: || (reverse chronological order - newest change first)
167: */
168: CURSOR cur_rowid IS
169: SELECT rowid
170: FROM igf_aw_cit_ld_ovrd_all
171: WHERE ((ci_cal_type = x_ci_cal_type) AND
172: (ci_sequence_number = x_ci_sequence_number) AND
173: (coa_code = x_coa_code) AND
174: (item_code = x_item_code));

Line 293: FROM igf_aw_cit_ld_ovrd_all

289: || (reverse chronological order - newest change first)
290: */
291: CURSOR c IS
292: SELECT rowid
293: FROM igf_aw_cit_ld_ovrd_all
294: WHERE cldo_id = x_cldo_id;
295:
296: x_last_update_date DATE;
297: x_last_updated_by NUMBER;

Line 345: INSERT INTO igf_aw_cit_ld_ovrd_all (

341: x_last_updated_by => x_last_updated_by,
342: x_last_update_login => x_last_update_login
343: );
344:
345: INSERT INTO igf_aw_cit_ld_ovrd_all (
346: cldo_id,
347: coa_code,
348: ci_cal_type,
349: ci_sequence_number,

Line 417: FROM igf_aw_cit_ld_ovrd_all

413: item_code,
414: ld_cal_type,
415: ld_sequence_number,
416: ld_perct
417: FROM igf_aw_cit_ld_ovrd_all
418: WHERE rowid = x_rowid
419: FOR UPDATE NOWAIT;
420:
421: tlinfo c1%ROWTYPE;

Line 521: UPDATE igf_aw_cit_ld_ovrd_all

517: x_last_updated_by => x_last_updated_by,
518: x_last_update_login => x_last_update_login
519: );
520:
521: UPDATE igf_aw_cit_ld_ovrd_all
522: SET
523: coa_code = new_references.coa_code,
524: ci_cal_type = new_references.ci_cal_type,
525: ci_sequence_number = new_references.ci_sequence_number,

Line 565: FROM igf_aw_cit_ld_ovrd_all

561: || (reverse chronological order - newest change first)
562: */
563: CURSOR c1 IS
564: SELECT rowid
565: FROM igf_aw_cit_ld_ovrd_all
566: WHERE cldo_id = x_cldo_id;
567:
568: BEGIN
569:

Line 626: DELETE FROM igf_aw_cit_ld_ovrd_all

622: p_action => 'DELETE',
623: x_rowid => x_rowid
624: );
625:
626: DELETE FROM igf_aw_cit_ld_ovrd_all
627: WHERE rowid = x_rowid;
628:
629: IF (SQL%NOTFOUND) THEN
630: RAISE NO_DATA_FOUND;