APPS.IGF_SP_STDNT_REL_PKG dependencies on IGF_SP_STDNT_REL_ALL

Line 5: old_references igf_sp_stdnt_rel_all%ROWTYPE;

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

Line 6: new_references igf_sp_stdnt_rel_all%ROWTYPE;

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

Line 38: FROM igf_sp_stdnt_rel_all

34: */
35:
36: CURSOR cur_old_ref_values IS
37: SELECT *
38: FROM igf_sp_stdnt_rel_all
39: WHERE rowid = x_rowid;
40:
41: BEGIN
42:

Line 196: FROM igf_sp_stdnt_rel_all

192: || (reverse chronological order - newest change first)
193: */
194: CURSOR cur_rowid IS
195: SELECT rowid
196: FROM igf_sp_stdnt_rel_all
197: WHERE spnsr_stdnt_id = x_spnsr_stdnt_id
198: FOR UPDATE NOWAIT;
199:
200: lv_rowid cur_rowid%RowType;

Line 234: FROM igf_sp_stdnt_rel_all

230: || (reverse chronological order - newest change first)
231: */
232: CURSOR cur_rowid IS
233: SELECT rowid
234: FROM igf_sp_stdnt_rel_all
235: WHERE fund_id = x_fund_id
236: AND base_id = x_base_id
237: AND ld_cal_type = x_ld_cal_type
238: AND ld_sequence_number = x_ld_sequence_number

Line 272: FROM igf_sp_stdnt_rel_all

268: || (reverse chronological order - newest change first)
269: */
270: CURSOR cur_rowid IS
271: SELECT rowid
272: FROM igf_sp_stdnt_rel_all
273: WHERE ((person_id = x_party_id));
274:
275: lv_rowid cur_rowid%RowType;
276:

Line 308: FROM igf_sp_stdnt_rel_all

304: || (reverse chronological order - newest change first)
305: */
306: CURSOR cur_rowid IS
307: SELECT rowid
308: FROM igf_sp_stdnt_rel_all
309: WHERE ((ld_cal_type = x_cal_type) AND
310: (ld_sequence_number = x_sequence_number));
311:
312: lv_rowid cur_rowid%RowType;

Line 344: FROM igf_sp_stdnt_rel_all

340: || (reverse chronological order - newest change first)
341: */
342: CURSOR cur_rowid IS
343: SELECT rowid
344: FROM igf_sp_stdnt_rel_all
345: WHERE ((base_id = x_base_id));
346:
347: lv_rowid cur_rowid%RowType;
348:

Line 379: FROM igf_sp_stdnt_rel_all

375: || (reverse chronological order - newest change first)
376: */
377: CURSOR cur_rowid IS
378: SELECT rowid
379: FROM igf_sp_stdnt_rel_all
380: WHERE ((fund_id = x_fund_id));
381:
382: lv_rowid cur_rowid%RowType;
383:

Line 513: FROM igf_sp_stdnt_rel_all

509: || (reverse chronological order - newest change first)
510: */
511: CURSOR c IS
512: SELECT rowid
513: FROM igf_sp_stdnt_rel_all
514: WHERE spnsr_stdnt_id = x_spnsr_stdnt_id;
515:
516: x_last_update_date DATE;
517: x_last_updated_by NUMBER;

Line 566: INSERT INTO igf_sp_stdnt_rel_all (

562: x_last_updated_by => x_last_updated_by,
563: x_last_update_login => x_last_update_login
564: );
565:
566: INSERT INTO igf_sp_stdnt_rel_all (
567: spnsr_stdnt_id,
568: fund_id,
569: base_id,
570: person_id,

Line 642: FROM igf_sp_stdnt_rel_all

638: ld_sequence_number,
639: tot_spnsr_amount,
640: min_credit_points,
641: min_attendance_type
642: FROM igf_sp_stdnt_rel_all
643: WHERE rowid = x_rowid
644: FOR UPDATE NOWAIT;
645:
646: tlinfo c1%ROWTYPE;

Line 749: UPDATE igf_sp_stdnt_rel_all

745: x_last_updated_by => x_last_updated_by,
746: x_last_update_login => x_last_update_login
747: );
748:
749: UPDATE igf_sp_stdnt_rel_all
750: SET
751: fund_id = new_references.fund_id,
752: base_id = new_references.base_id,
753: person_id = new_references.person_id,

Line 795: FROM igf_sp_stdnt_rel_all

791: || (reverse chronological order - newest change first)
792: */
793: CURSOR c1 IS
794: SELECT rowid
795: FROM igf_sp_stdnt_rel_all
796: WHERE spnsr_stdnt_id = x_spnsr_stdnt_id;
797:
798: BEGIN
799:

Line 858: DELETE FROM igf_sp_stdnt_rel_all

854: p_action => 'DELETE',
855: x_rowid => x_rowid
856: );
857:
858: DELETE FROM igf_sp_stdnt_rel_all
859: WHERE rowid = x_rowid;
860:
861: IF (SQL%NOTFOUND) THEN
862: RAISE NO_DATA_FOUND;