APPS.IGF_AW_FUND_TD_MAP_PKG dependencies on IGF_AW_FUND_TD_MAP

Line 1: PACKAGE BODY igf_aw_fund_td_map_pkg AS

1: PACKAGE BODY igf_aw_fund_td_map_pkg AS
2: /* $Header: IGFWI50B.pls 115.2 2002/11/28 11:23:34 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_fund_td_map_all%ROWTYPE;

Line 5: old_references igf_aw_fund_td_map_all%ROWTYPE;

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

Line 6: new_references igf_aw_fund_td_map_all%ROWTYPE;

2: /* $Header: IGFWI50B.pls 115.2 2002/11/28 11:23:34 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_fund_td_map_all%ROWTYPE;
6: new_references igf_aw_fund_td_map_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 32: FROM igf_aw_fund_td_map_all

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

Line 148: FROM igf_aw_fund_td_map_all

144: || (reverse chronological order - newest change first)
145: */
146: CURSOR cur_rowid IS
147: SELECT rowid
148: FROM igf_aw_fund_td_map_all
149: WHERE ftodo_id = x_ftodo_id
150: FOR UPDATE NOWAIT;
151:
152: lv_rowid cur_rowid%RowType;

Line 184: FROM igf_aw_fund_td_map

180: || (reverse chronological order - newest change first)
181: */
182: CURSOR cur_rowid IS
183: SELECT rowid
184: FROM igf_aw_fund_td_map
185: WHERE fund_id = x_fund_id
186: AND item_sequence_number = x_item_sequence_number
187: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
188:

Line 220: FROM igf_aw_fund_td_map_all

216: || (reverse chronological order - newest change first)
217: */
218: CURSOR cur_rowid IS
219: SELECT rowid
220: FROM igf_aw_fund_td_map_all
221: WHERE ((fund_id = x_fund_id));
222:
223: lv_rowid cur_rowid%RowType;
224:

Line 255: FROM igf_aw_fund_td_map_all

251: || (reverse chronological order - newest change first)
252: */
253: CURSOR cur_rowid IS
254: SELECT rowid
255: FROM igf_aw_fund_td_map_all
256: WHERE ((item_sequence_number = x_todo_number));
257:
258: lv_rowid cur_rowid%RowType;
259:

Line 365: FROM igf_aw_fund_td_map_all

361: || (reverse chronological order - newest change first)
362: */
363: CURSOR c IS
364: SELECT rowid
365: FROM igf_aw_fund_td_map_all
366: WHERE ftodo_id = x_ftodo_id;
367:
368: x_last_update_date DATE;
369: x_last_updated_by NUMBER;

Line 393: SELECT igf_aw_fund_td_map_s.NEXTVAL

389: igs_ge_msg_stack.add;
390: app_exception.raise_exception;
391: END IF;
392:
393: SELECT igf_aw_fund_td_map_s.NEXTVAL
394: INTO x_ftodo_id
395: FROM dual;
396:
397: new_references.org_id := igs_ge_gen_003.get_org_id;

Line 412: INSERT INTO igf_aw_fund_td_map_all (

408: x_last_updated_by => x_last_updated_by,
409: x_last_update_login => x_last_update_login
410: );
411:
412: INSERT INTO igf_aw_fund_td_map_all (
413: ftodo_id,
414: fund_id,
415: item_sequence_number,
416: org_id,

Line 464: FROM igf_aw_fund_td_map_all

460: CURSOR c1 IS
461: SELECT
462: fund_id,
463: item_sequence_number
464: FROM igf_aw_fund_td_map_all
465: WHERE rowid = x_rowid
466: FOR UPDATE NOWAIT;
467:
468: tlinfo c1%ROWTYPE;

Line 553: UPDATE igf_aw_fund_td_map_all

549: x_last_updated_by => x_last_updated_by,
550: x_last_update_login => x_last_update_login
551: );
552:
553: UPDATE igf_aw_fund_td_map_all
554: SET
555: fund_id = new_references.fund_id,
556: item_sequence_number = new_references.item_sequence_number,
557: last_update_date = x_last_update_date,

Line 587: FROM igf_aw_fund_td_map_all

583: || (reverse chronological order - newest change first)
584: */
585: CURSOR c1 IS
586: SELECT rowid
587: FROM igf_aw_fund_td_map_all
588: WHERE ftodo_id = x_ftodo_id;
589:
590: BEGIN
591:

Line 638: DELETE FROM igf_aw_fund_td_map_all

634: p_action => 'DELETE',
635: x_rowid => x_rowid
636: );
637:
638: DELETE FROM igf_aw_fund_td_map_all
639: WHERE rowid = x_rowid;
640:
641: IF (SQL%NOTFOUND) THEN
642: RAISE NO_DATA_FOUND;

Line 648: END igf_aw_fund_td_map_pkg;

644:
645: END delete_row;
646:
647:
648: END igf_aw_fund_td_map_pkg;