APPS.IGF_AW_FUND_TP_PKG dependencies on IGF_AW_FUND_TP_ALL

Line 5: old_references igf_aw_fund_tp_all%ROWTYPE;

1: PACKAGE BODY igf_aw_fund_tp_pkg AS
2: /* $Header: IGFWI17B.pls 115.11 2003/11/10 05:51:23 veramach ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_fund_tp_all%ROWTYPE;
6: new_references igf_aw_fund_tp_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_aw_fund_tp_all%ROWTYPE;

2: /* $Header: IGFWI17B.pls 115.11 2003/11/10 05:51:23 veramach ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_fund_tp_all%ROWTYPE;
6: new_references igf_aw_fund_tp_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_FUND_TP_ALL

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

Line 130: FROM igf_aw_fund_tp_all

126: || (reverse chronological order - newest change first)
127: */
128: CURSOR cur_rowid IS
129: SELECT rowid
130: FROM igf_aw_fund_tp_all
131: WHERE fund_id = x_fund_id
132: AND tp_cal_type = x_tp_cal_type
133: AND tp_sequence_number = x_tp_sequence_number
134: FOR UPDATE NOWAIT;

Line 168: FROM igf_aw_fund_tp_all

164: || (reverse chronological order - newest change first)
165: */
166: CURSOR cur_rowid IS
167: SELECT rowid
168: FROM igf_aw_fund_tp_all
169: WHERE ((tp_cal_type = x_cal_type) AND
170: (tp_sequence_number = x_sequence_number));
171:
172: lv_rowid cur_rowid%RowType;

Line 204: FROM igf_aw_fund_tp_all

200: || (reverse chronological order - newest change first)
201: */
202: CURSOR cur_rowid IS
203: SELECT rowid
204: FROM igf_aw_fund_tp_all
205: WHERE ((fund_id = x_fund_id));
206:
207: lv_rowid cur_rowid%RowType;
208:

Line 316: FROM igf_aw_fund_tp_all

312: || (reverse chronological order - newest change first)
313: */
314: CURSOR c IS
315: SELECT rowid
316: FROM igf_aw_fund_tp_all
317: WHERE fund_id = x_fund_id
318: AND tp_cal_type = x_tp_cal_type
319: AND tp_sequence_number = x_tp_sequence_number;
320:

Line 362: INSERT INTO igf_aw_fund_tp_all (

358: x_last_updated_by => x_last_updated_by,
359: x_last_update_login => x_last_update_login
360: );
361:
362: INSERT INTO igf_aw_fund_tp_all (
363: fund_id,
364: tp_cal_type,
365: tp_sequence_number,
366: tp_perct,

Line 416: FROM igf_aw_fund_tp_all

412: */
413: CURSOR c1 IS
414: SELECT
415: tp_perct
416: FROM igf_aw_fund_tp_all
417: WHERE rowid = x_rowid
418: FOR UPDATE NOWAIT;
419:
420: tlinfo c1%ROWTYPE;

Line 506: UPDATE igf_aw_fund_tp_all

502: x_last_updated_by => x_last_updated_by,
503: x_last_update_login => x_last_update_login
504: );
505:
506: UPDATE igf_aw_fund_tp_all
507: SET
508: tp_perct = new_references.tp_perct,
509: last_update_date = x_last_update_date,
510: last_updated_by = x_last_updated_by,

Line 540: FROM igf_aw_fund_tp_all

536: || (reverse chronological order - newest change first)
537: */
538: CURSOR c1 IS
539: SELECT rowid
540: FROM igf_aw_fund_tp_all
541: WHERE fund_id = x_fund_id
542: AND tp_cal_type = x_tp_cal_type
543: AND tp_sequence_number = x_tp_sequence_number;
544:

Line 595: DELETE FROM igf_aw_fund_tp_all

591: p_action => 'DELETE',
592: x_rowid => x_rowid
593: );
594:
595: DELETE FROM igf_aw_fund_tp_all
596: WHERE rowid = x_rowid;
597:
598: IF (SQL%NOTFOUND) THEN
599: RAISE NO_DATA_FOUND;