APPS.IGF_SP_STD_FC_PKG dependencies on IGF_SP_STD_FC_ALL

Line 5: old_references igf_sp_std_fc_all%ROWTYPE;

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

Line 6: new_references igf_sp_std_fc_all%ROWTYPE;

2: /* $Header: IGFPI05B.pls 115.2 2003/03/19 08:50:13 smadathi noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_sp_std_fc_all%ROWTYPE;
6: new_references igf_sp_std_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_std_fc_all

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

Line 172: FROM igf_sp_std_fc_all

168: || (reverse chronological order - newest change first)
169: */
170: CURSOR cur_rowid IS
171: SELECT rowid
172: FROM igf_sp_std_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_std_fc_all

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

Line 244: FROM igf_sp_std_fc_all

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

Line 278: FROM igf_sp_std_fc_all

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

Line 400: FROM igf_sp_std_fc_all

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

Line 449: INSERT INTO igf_sp_std_fc_all (

445: x_last_updated_by => x_last_updated_by,
446: x_last_update_login => x_last_update_login
447: );
448:
449: INSERT INTO igf_sp_std_fc_all (
450: fee_cls_id,
451: spnsr_stdnt_id,
452: fee_class,
453: fee_percent,

Line 509: FROM igf_sp_std_fc_all

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

Line 604: UPDATE igf_sp_std_fc_all

600: x_last_updated_by => x_last_updated_by,
601: x_last_update_login => x_last_update_login
602: );
603:
604: UPDATE igf_sp_std_fc_all
605: SET
606: spnsr_stdnt_id = new_references.spnsr_stdnt_id,
607: fee_class = new_references.fee_class,
608: fee_percent = new_references.fee_percent,

Line 642: FROM igf_sp_std_fc_all

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

Line 697: DELETE FROM igf_sp_std_fc_all

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