APPS.IGF_AW_FUND_EXCL_PKG dependencies on IGF_AW_FUND_EXCL_ALL

Line 5: old_references igf_aw_fund_excl_all%ROWTYPE;

1: PACKAGE BODY igf_aw_fund_excl_pkg AS
2: /* $Header: IGFWI15B.pls 115.8 2002/11/28 14:38:42 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_fund_excl_all%ROWTYPE;
6: new_references igf_aw_fund_excl_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_aw_fund_excl_all%ROWTYPE;

2: /* $Header: IGFWI15B.pls 115.8 2002/11/28 14:38:42 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_fund_excl_all%ROWTYPE;
6: new_references igf_aw_fund_excl_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 31: FROM IGF_AW_FUND_EXCL_ALL

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

Line 122: FROM igf_aw_fund_excl_all

118: || (reverse chronological order - newest change first)
119: */
120: CURSOR cur_rowid IS
121: SELECT rowid
122: FROM igf_aw_fund_excl_all
123: WHERE fund_id = x_fund_id
124: AND fund_code = x_fund_code
125: FOR UPDATE NOWAIT;
126:

Line 158: FROM igf_aw_fund_excl_all

154: || (reverse chronological order - newest change first)
155: */
156: CURSOR cur_rowid IS
157: SELECT rowid
158: FROM igf_aw_fund_excl_all
159: WHERE ((fund_id = x_fund_id));
160:
161: lv_rowid cur_rowid%RowType;
162:

Line 191: l_org_id igf_aw_fund_excl_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;

187: || Change History :
188: || Who When What
189: || (reverse chronological order - newest change first)
190: */
191: l_org_id igf_aw_fund_excl_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;
192: CURSOR cur_rowid IS
193: SELECT rowid
194: FROM igf_aw_fund_excl_all
195: WHERE ((fund_code = x_fund_code))

Line 194: FROM igf_aw_fund_excl_all

190: */
191: l_org_id igf_aw_fund_excl_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;
192: CURSOR cur_rowid IS
193: SELECT rowid
194: FROM igf_aw_fund_excl_all
195: WHERE ((fund_code = x_fund_code))
196: AND NVL(org_id, NVL(l_org_id, -99)) = NVL(l_org_id, -99);
197:
198: lv_rowid cur_rowid%RowType;

Line 299: FROM igf_aw_fund_excl_all

295: || (reverse chronological order - newest change first)
296: */
297: CURSOR c IS
298: SELECT rowid
299: FROM igf_aw_fund_excl_all
300: WHERE fund_id = x_fund_id
301: AND fund_code = x_fund_code;
302:
303: x_last_update_date DATE;

Line 306: l_org_id igf_aw_fund_excl_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;

302:
303: x_last_update_date DATE;
304: x_last_updated_by NUMBER;
305: x_last_update_login NUMBER;
306: l_org_id igf_aw_fund_excl_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;
307:
308: BEGIN
309:
310: x_last_update_date := SYSDATE;

Line 341: INSERT INTO igf_aw_fund_excl_all (

337: x_last_updated_by => x_last_updated_by,
338: x_last_update_login => x_last_update_login
339: );
340:
341: INSERT INTO igf_aw_fund_excl_all (
342: fund_id,
343: fund_code,
344: creation_date,
345: created_by,

Line 389: FROM igf_aw_fund_excl_all

385: */
386: CURSOR c1 IS
387: SELECT
388: rowid
389: FROM igf_aw_fund_excl_all
390: WHERE rowid = x_rowid
391: FOR UPDATE NOWAIT;
392:
393: tlinfo c1%ROWTYPE;

Line 433: DELETE FROM igf_aw_fund_excl_all

429: p_action => 'DELETE',
430: x_rowid => x_rowid
431: );
432:
433: DELETE FROM igf_aw_fund_excl_all
434: WHERE rowid = x_rowid;
435:
436: IF (SQL%NOTFOUND) THEN
437: RAISE NO_DATA_FOUND;