APPS.IGF_AW_FRLOG_PKG dependencies on IGF_AW_FRLOG_ALL

Line 5: old_references igf_aw_frlog_all%ROWTYPE;

1: PACKAGE BODY igf_aw_frlog_pkg AS
2: /* $Header: IGFWI29B.pls 115.4 2002/11/28 14:40:32 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_frlog_all%ROWTYPE;
6: new_references igf_aw_frlog_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_aw_frlog_all%ROWTYPE;

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

Line 33: FROM IGF_AW_FRLOG_ALL

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

Line 125: FROM igf_aw_frlog_all

121: || (reverse chronological order - newest change first)
122: */
123: CURSOR cur_rowid IS
124: SELECT rowid
125: FROM igf_aw_frlog_all
126: WHERE frlog_id = x_frlog_id
127: FOR UPDATE NOWAIT;
128:
129: lv_rowid cur_rowid%RowType;

Line 160: FROM igf_aw_frlog_all

156: || (reverse chronological order - newest change first)
157: */
158: CURSOR cur_rowid IS
159: SELECT rowid
160: FROM igf_aw_frlog_all
161: WHERE ((frol_id = x_frol_id));
162:
163: lv_rowid cur_rowid%RowType;
164:

Line 195: FROM igf_aw_frlog_all

191: || (reverse chronological order - newest change first)
192: */
193: CURSOR cur_rowid IS
194: SELECT rowid
195: FROM igf_aw_frlog_all
196: WHERE ((fund_id = x_fund_id));
197:
198: lv_rowid cur_rowid%RowType;
199:

Line 303: FROM igf_aw_frlog_all

299: || (reverse chronological order - newest change first)
300: */
301: CURSOR c IS
302: SELECT rowid
303: FROM igf_aw_frlog_all
304: WHERE frlog_id = x_frlog_id;
305:
306: x_last_update_date DATE;
307: x_last_updated_by NUMBER;

Line 367: INSERT INTO igf_aw_frlog_all (

363: x_last_updated_by => x_last_updated_by,
364: x_last_update_login => x_last_update_login
365: );
366:
367: INSERT INTO igf_aw_frlog_all (
368: frlog_id,
369: frol_id,
370: fund_id,
371: rollover_fund_id,

Line 431: FROM igf_aw_frlog_all

427: SELECT
428: frol_id,
429: fund_id,
430: rollover_fund_id
431: FROM igf_aw_frlog_all
432: WHERE rowid = x_rowid
433: FOR UPDATE NOWAIT;
434:
435: tlinfo c1%ROWTYPE;

Line 541: UPDATE igf_aw_frlog_all

537: x_program_update_date := SYSDATE;
538: END IF;
539: END IF;
540:
541: UPDATE igf_aw_frlog_all
542: SET
543: frol_id = new_references.frol_id,
544: fund_id = new_references.fund_id,
545: rollover_fund_id = new_references.rollover_fund_id,

Line 581: FROM igf_aw_frlog_all

577: || (reverse chronological order - newest change first)
578: */
579: CURSOR c1 IS
580: SELECT rowid
581: FROM igf_aw_frlog_all
582: WHERE frlog_id = x_frlog_id;
583:
584: BEGIN
585:

Line 634: DELETE FROM igf_aw_frlog_all

630: p_action => 'DELETE',
631: x_rowid => x_rowid
632: );
633:
634: DELETE FROM igf_aw_frlog_all
635: WHERE rowid = x_rowid;
636:
637: IF (SQL%NOTFOUND) THEN
638: RAISE NO_DATA_FOUND;