APPS.IGF_SP_FC_PKG dependencies on IGF_SP_FC_ALL

Line 5: old_references igf_sp_fc_all%ROWTYPE;

1: PACKAGE BODY igf_sp_fc_pkg AS
2: /* $Header: IGFPI01B.pls 115.2 2003/03/19 08:49:40 smadathi noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_sp_fc_all%ROWTYPE;
6: new_references igf_sp_fc_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_sp_fc_all%ROWTYPE;

2: /* $Header: IGFPI01B.pls 115.2 2003/03/19 08:49:40 smadathi noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_sp_fc_all%ROWTYPE;
6: new_references igf_sp_fc_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 34: FROM igf_sp_fc_all

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

Line 172: FROM igf_sp_fc_all

168: || (reverse chronological order - newest change first)
169: */
170: CURSOR cur_rowid IS
171: SELECT rowid
172: FROM igf_sp_fc_all
173: WHERE fee_cls_id = x_fee_cls_id
174: FOR UPDATE NOWAIT;
175:
176: lv_rowid cur_rowid%RowType;

Line 208: FROM igf_sp_fc_all

204: || (reverse chronological order - newest change first)
205: */
206: CURSOR cur_rowid IS
207: SELECT rowid
208: FROM igf_sp_fc_all
209: WHERE fund_id = x_fund_id
210: AND fee_class = x_fee_class
211: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
212:

Line 244: FROM igf_sp_fc_all

240: || (reverse chronological order - newest change first)
241: */
242: CURSOR cur_rowid IS
243: SELECT rowid
244: FROM igf_sp_fc_all
245: WHERE ((fund_id = x_fund_id));
246:
247: lv_rowid cur_rowid%RowType;
248:

Line 279: FROM igf_sp_fc_all

275: || (reverse chronological order - newest change first)
276: */
277: CURSOR cur_rowid IS
278: SELECT rowid
279: FROM igf_sp_fc_all
280: WHERE ((fee_class = x_fee_class));
281:
282: lv_rowid cur_rowid%RowType;
283:

Line 401: FROM igf_sp_fc_all

397: || (reverse chronological order - newest change first)
398: */
399: CURSOR c IS
400: SELECT rowid
401: FROM igf_sp_fc_all
402: WHERE fee_cls_id = x_fee_cls_id;
403:
404: x_last_update_date DATE;
405: x_last_updated_by NUMBER;

Line 450: INSERT INTO igf_sp_fc_all (

446: x_last_updated_by => x_last_updated_by,
447: x_last_update_login => x_last_update_login
448: );
449:
450: INSERT INTO igf_sp_fc_all (
451: fee_cls_id,
452: fund_id,
453: fee_class,
454: fee_percent,

Line 510: FROM igf_sp_fc_all

506: fund_id,
507: fee_class,
508: fee_percent,
509: max_amount
510: FROM igf_sp_fc_all
511: WHERE rowid = x_rowid
512: FOR UPDATE NOWAIT;
513:
514: tlinfo c1%ROWTYPE;

Line 605: UPDATE igf_sp_fc_all

601: x_last_updated_by => x_last_updated_by,
602: x_last_update_login => x_last_update_login
603: );
604:
605: UPDATE igf_sp_fc_all
606: SET
607: fund_id = new_references.fund_id,
608: fee_class = new_references.fee_class,
609: fee_percent = new_references.fee_percent,

Line 643: FROM igf_sp_fc_all

639: || (reverse chronological order - newest change first)
640: */
641: CURSOR c1 IS
642: SELECT rowid
643: FROM igf_sp_fc_all
644: WHERE fee_cls_id = x_fee_cls_id;
645:
646: BEGIN
647:

Line 698: DELETE FROM igf_sp_fc_all

694: p_action => 'DELETE',
695: x_rowid => x_rowid
696: );
697:
698: DELETE FROM igf_sp_fc_all
699: WHERE rowid = x_rowid;
700:
701: IF (SQL%NOTFOUND) THEN
702: RAISE NO_DATA_FOUND;