APPS.IGF_SL_DL_CHG_RESP_PKG dependencies on IGF_SL_DL_CHG_RESP_ALL

Line 5: old_references igf_sl_dl_chg_resp_all%ROWTYPE;

1: PACKAGE BODY igf_sl_dl_chg_resp_pkg AS
2: /* $Header: IGFLI18B.pls 115.9 2002/11/28 14:25:33 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_sl_dl_chg_resp_all%ROWTYPE;
6: new_references igf_sl_dl_chg_resp_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_sl_dl_chg_resp_all%ROWTYPE;

2: /* $Header: IGFLI18B.pls 115.9 2002/11/28 14:25:33 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_sl_dl_chg_resp_all%ROWTYPE;
6: new_references igf_sl_dl_chg_resp_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 38: FROM igf_sl_dl_chg_resp_all

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

Line 124: FROM igf_sl_dl_chg_resp_all

120: || (reverse chronological order - newest change first)
121: */
122: CURSOR cur_rowid IS
123: SELECT rowid
124: FROM igf_sl_dl_chg_resp_all
125: WHERE resp_num = x_resp_num
126: FOR UPDATE NOWAIT;
127:
128: lv_rowid cur_rowid%RowType;

Line 159: FROM igf_sl_dl_chg_resp_all

155: || (reverse chronological order - newest change first)
156: */
157: CURSOR cur_rowid IS
158: SELECT rowid
159: FROM igf_sl_dl_chg_resp_all
160: WHERE ((dbth_id = x_dbth_id));
161:
162: lv_rowid cur_rowid%RowType;
163:

Line 282: FROM igf_sl_dl_chg_resp_all

278: || (reverse chronological order - newest change first)
279: */
280: CURSOR c IS
281: SELECT rowid
282: FROM igf_sl_dl_chg_resp_all
283: WHERE resp_num = x_resp_num;
284:
285: x_last_update_date DATE;
286: x_last_updated_by NUMBER;

Line 292: l_org_id igf_sl_dl_chg_resp_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;

288: x_request_id NUMBER;
289: x_program_id NUMBER;
290: x_program_application_id NUMBER;
291: x_program_update_date DATE;
292: l_org_id igf_sl_dl_chg_resp_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;
293:
294: BEGIN
295:
296: x_last_update_date := SYSDATE;

Line 350: INSERT INTO igf_sl_dl_chg_resp_all (

346: x_last_updated_by => x_last_updated_by,
347: x_last_update_login => x_last_update_login
348: );
349:
350: INSERT INTO igf_sl_dl_chg_resp_all (
351: resp_num,
352: dbth_id,
353: batch_id,
354: loan_number,

Line 435: FROM igf_sl_dl_chg_resp_all

431: new_value,
432: loan_ident_err_code,
433: status,
434: org_id
435: FROM igf_sl_dl_chg_resp_all
436: WHERE rowid = x_rowid
437: FOR UPDATE NOWAIT;
438:
439: tlinfo c1%ROWTYPE;

Line 560: UPDATE igf_sl_dl_chg_resp_all

556: x_program_update_date := SYSDATE;
557: END IF;
558: END IF;
559:
560: UPDATE igf_sl_dl_chg_resp_all
561: SET
562: dbth_id = new_references.dbth_id,
563: batch_id = new_references.batch_id,
564: loan_number = new_references.loan_number,

Line 610: FROM igf_sl_dl_chg_resp_all

606: || (reverse chronological order - newest change first)
607: */
608: CURSOR c1 IS
609: SELECT rowid
610: FROM igf_sl_dl_chg_resp_all
611: WHERE resp_num = x_resp_num;
612:
613: BEGIN
614:

Line 673: DELETE FROM igf_sl_dl_chg_resp_all

669: p_action => 'DELETE',
670: x_rowid => x_rowid
671: );
672:
673: DELETE FROM igf_sl_dl_chg_resp_all
674: WHERE rowid = x_rowid;
675:
676: IF (SQL%NOTFOUND) THEN
677: RAISE NO_DATA_FOUND;