APPS.IGF_SL_DL_LOR_CRRESP_PKG dependencies on IGF_SL_DL_LOR_CRRESP_ALL

Line 5: old_references igf_sl_dl_lor_crresp_all%ROWTYPE;

1: PACKAGE BODY igf_sl_dl_lor_crresp_pkg AS
2: /* $Header: IGFLI15B.pls 115.6 2003/02/20 15:40:03 sjadhav ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_sl_dl_lor_crresp_all%ROWTYPE;
6: new_references igf_sl_dl_lor_crresp_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_sl_dl_lor_crresp_all%ROWTYPE;

2: /* $Header: IGFLI15B.pls 115.6 2003/02/20 15:40:03 sjadhav ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_sl_dl_lor_crresp_all%ROWTYPE;
6: new_references igf_sl_dl_lor_crresp_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 41: FROM igf_sl_dl_lor_crresp_all

37: */
38:
39: CURSOR cur_old_ref_values IS
40: SELECT *
41: FROM igf_sl_dl_lor_crresp_all
42: WHERE rowid = x_rowid;
43:
44: BEGIN
45:

Line 129: FROM igf_sl_dl_lor_crresp_all

125: || (reverse chronological order - newest change first)
126: */
127: CURSOR cur_rowid IS
128: SELECT rowid
129: FROM igf_sl_dl_lor_crresp_all
130: WHERE lor_resp_num = x_lor_resp_num
131: FOR UPDATE NOWAIT;
132:
133: lv_rowid cur_rowid%RowType;

Line 164: FROM igf_sl_dl_lor_crresp_all

160: || (reverse chronological order - newest change first)
161: */
162: CURSOR cur_rowid IS
163: SELECT rowid
164: FROM igf_sl_dl_lor_crresp_all
165: WHERE ((dbth_id = x_dbth_id));
166:
167: lv_rowid cur_rowid%RowType;
168:

Line 293: FROM igf_sl_dl_lor_crresp_all

289: || (reverse chronological order - newest change first)
290: */
291: CURSOR c IS
292: SELECT rowid
293: FROM igf_sl_dl_lor_crresp_all
294: WHERE lor_resp_num = x_lor_resp_num;
295:
296: x_last_update_date DATE;
297: x_last_updated_by NUMBER;

Line 303: l_org_id igf_sl_dl_lor_crresp_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;

299: x_request_id NUMBER;
300: x_program_id NUMBER;
301: x_program_application_id NUMBER;
302: x_program_update_date DATE;
303: l_org_id igf_sl_dl_lor_crresp_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;
304:
305: BEGIN
306:
307: x_last_update_date := SYSDATE;

Line 363: INSERT INTO igf_sl_dl_lor_crresp_all (

359: x_mpn_type => x_mpn_type,
360: x_mpn_indicator => x_mpn_indicator
361: );
362:
363: INSERT INTO igf_sl_dl_lor_crresp_all (
364: lor_resp_num,
365: dbth_id,
366: loan_number,
367: credit_override,

Line 457: FROM igf_sl_dl_lor_crresp_all

453: mpn_status,
454: mpn_id,
455: mpn_type,
456: mpn_indicator
457: FROM igf_sl_dl_lor_crresp_all
458: WHERE rowid = x_rowid
459: FOR UPDATE NOWAIT;
460:
461: tlinfo c1%ROWTYPE;

Line 588: UPDATE igf_sl_dl_lor_crresp_all

584: x_program_update_date := SYSDATE;
585: END IF;
586: END IF;
587:
588: UPDATE igf_sl_dl_lor_crresp_all
589: SET
590: dbth_id = new_references.dbth_id,
591: loan_number = new_references.loan_number,
592: credit_override = new_references.credit_override,

Line 642: FROM igf_sl_dl_lor_crresp_all

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

Line 709: DELETE FROM igf_sl_dl_lor_crresp_all

705: p_action => 'DELETE',
706: x_rowid => x_rowid
707: );
708:
709: DELETE FROM igf_sl_dl_lor_crresp_all
710: WHERE rowid = x_rowid;
711:
712: IF (SQL%NOTFOUND) THEN
713: RAISE NO_DATA_FOUND;