APPS.IGF_SL_EDIT_REPORT_PKG dependencies on IGF_SL_EDIT_REPORT_ALL

Line 5: old_references igf_sl_edit_report_all%ROWTYPE;

1: PACKAGE BODY igf_sl_edit_report_pkg AS
2: /* $Header: IGFLI20B.pls 115.5 2002/11/28 14:26:02 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_sl_edit_report_all%ROWTYPE;
6: new_references igf_sl_edit_report_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_sl_edit_report_all%ROWTYPE;

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

Line 36: FROM IGF_SL_EDIT_REPORT_ALL

32: */
33:
34: CURSOR cur_old_ref_values IS
35: SELECT *
36: FROM IGF_SL_EDIT_REPORT_ALL
37: WHERE rowid = x_rowid;
38:
39: BEGIN
40:

Line 94: FROM igf_sl_edit_report_all

90: || (reverse chronological order - newest change first)
91: */
92: CURSOR cur_rowid IS
93: SELECT rowid
94: FROM igf_sl_edit_report_all
95: WHERE edtr_id = x_edtr_id
96: FOR UPDATE NOWAIT;
97:
98: lv_rowid cur_rowid%RowType;

Line 207: FROM igf_sl_edit_report_all

203: || (reverse chronological order - newest change first)
204: */
205: CURSOR c IS
206: SELECT rowid
207: FROM igf_sl_edit_report_all
208: WHERE edtr_id = x_edtr_id;
209:
210: x_last_update_date DATE;
211: x_last_updated_by NUMBER;

Line 217: l_org_id igf_sl_edit_report_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;

213: x_request_id NUMBER;
214: x_program_id NUMBER;
215: x_program_application_id NUMBER;
216: x_program_update_date DATE;
217: l_org_id igf_sl_edit_report_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;
218:
219: BEGIN
220:
221: x_last_update_date := SYSDATE;

Line 273: INSERT INTO igf_sl_edit_report_all(

269: x_last_updated_by => x_last_updated_by,
270: x_last_update_login => x_last_update_login
271: );
272:
273: INSERT INTO igf_sl_edit_report_all(
274: edtr_id,
275: loan_number,
276: orig_chg_code,
277: sl_error_type,

Line 350: FROM igf_sl_edit_report_all

346: sl_error_code,
347: field_name,
348: field_value,
349: org_id
350: FROM igf_sl_edit_report_all
351: WHERE rowid = x_rowid
352: FOR UPDATE NOWAIT;
353:
354: tlinfo c1%ROWTYPE;

Line 469: UPDATE igf_sl_edit_report_all

465: x_program_update_date := SYSDATE;
466: END IF;
467: END IF;
468:
469: UPDATE igf_sl_edit_report_all
470: SET
471: loan_number = new_references.loan_number,
472: orig_chg_code = new_references.orig_chg_code,
473: sl_error_type = new_references.sl_error_type,

Line 515: FROM igf_sl_edit_report_all

511: || (reverse chronological order - newest change first)
512: */
513: CURSOR c1 IS
514: SELECT rowid
515: FROM igf_sl_edit_report_all
516: WHERE edtr_id = x_edtr_id;
517:
518: BEGIN
519:

Line 574: DELETE FROM igf_sl_edit_report_all

570: p_action => 'DELETE',
571: x_rowid => x_rowid
572: );
573:
574: DELETE FROM igf_sl_edit_report_all
575: WHERE rowid = x_rowid;
576:
577: IF (SQL%NOTFOUND) THEN
578: RAISE NO_DATA_FOUND;