APPS.IGF_SL_DL_SETUP_PKG dependencies on IGF_SL_DL_SETUP_ALL

Line 5: old_references igf_sl_dl_setup_all%ROWTYPE;

1: PACKAGE BODY igf_sl_dl_setup_pkg AS
2: /* $Header: IGFLI07B.pls 120.0 2005/06/01 15:12:03 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_sl_dl_setup_all%ROWTYPE;
6: new_references igf_sl_dl_setup_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_sl_dl_setup_all%ROWTYPE;

2: /* $Header: IGFLI07B.pls 120.0 2005/06/01 15:12:03 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_sl_dl_setup_all%ROWTYPE;
6: new_references igf_sl_dl_setup_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 48: FROM IGF_SL_DL_SETUP_ALL

44: */
45:
46: CURSOR cur_old_ref_values IS
47: SELECT *
48: FROM IGF_SL_DL_SETUP_ALL
49: WHERE rowid = x_rowid;
50:
51: BEGIN
52:

Line 170: FROM igf_sl_dl_setup_all

166: || (reverse chronological order - newest change first)
167: */
168: CURSOR cur_rowid IS
169: SELECT rowid
170: FROM igf_sl_dl_setup_all
171: WHERE dlset_id = x_dlset_id
172: FOR UPDATE NOWAIT;
173:
174: lv_rowid cur_rowid%RowType;

Line 206: FROM igf_sl_dl_setup_all

202: || (reverse chronological order - newest change first)
203: */
204: CURSOR cur_rowid IS
205: SELECT rowid
206: FROM igf_sl_dl_setup_all
207: WHERE ci_cal_type = x_ci_cal_type
208: AND ci_sequence_number = x_ci_sequence_number
209: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
210:

Line 243: FROM igf_sl_dl_setup_all

239: || (reverse chronological order - newest change first)
240: */
241: CURSOR cur_rowid IS
242: SELECT rowid
243: FROM igf_sl_dl_setup_all
244: WHERE ((ci_cal_type = x_cal_type) AND
245: (ci_sequence_number = x_sequence_number));
246:
247: lv_rowid cur_rowid%RowType;

Line 403: FROM igf_sl_dl_setup_all

399: || (reverse chronological order - newest change first)
400: */
401: CURSOR c IS
402: SELECT rowid
403: FROM igf_sl_dl_setup_all
404: WHERE dlset_id = x_dlset_id;
405:
406: x_last_update_date DATE;
407: x_last_updated_by NUMBER;

Line 409: l_org_id igf_sl_dl_setup_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;

405:
406: x_last_update_date DATE;
407: x_last_updated_by NUMBER;
408: x_last_update_login NUMBER;
409: l_org_id igf_sl_dl_setup_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;
410:
411: BEGIN
412:
413: x_last_update_date := SYSDATE;

Line 461: INSERT INTO igf_sl_dl_setup_all(

457: x_funding_method => x_funding_method
458:
459: );
460:
461: INSERT INTO igf_sl_dl_setup_all(
462: dlset_id,
463: ci_cal_type,
464: ci_sequence_number,
465: school_id,

Line 577: FROM igf_sl_dl_setup_all

573: org_id,
574: response_option_code,
575: funding_method
576:
577: FROM igf_sl_dl_setup_all
578: WHERE rowid = x_rowid
579: FOR UPDATE NOWAIT;
580:
581: tlinfo c1%ROWTYPE;

Line 711: UPDATE igf_sl_dl_setup_all

707: x_funding_method => x_funding_method
708:
709: );
710:
711: UPDATE igf_sl_dl_setup_all
712: SET
713: ci_cal_type = new_references.ci_cal_type,
714: ci_sequence_number = new_references.ci_sequence_number,
715: school_id = NULL,

Line 778: FROM igf_sl_dl_setup_all

774: || (reverse chronological order - newest change first)
775: */
776: CURSOR c1 IS
777: SELECT rowid
778: FROM igf_sl_dl_setup_all
779: WHERE dlset_id = x_dlset_id;
780:
781: BEGIN
782:

Line 859: DELETE FROM igf_sl_dl_setup_all

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