APPS.IGF_SL_DL_PNOTE_S_P_PKG dependencies on IGF_SL_DL_PNOTE_S_P_ALL

Line 5: old_references igf_sl_dl_pnote_s_p_all%ROWTYPE;

1: PACKAGE BODY igf_sl_dl_pnote_s_p_pkg AS
2: /* $Header: IGFLI29B.pls 115.4 2002/11/28 14:28:05 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_sl_dl_pnote_s_p_all%ROWTYPE;
6: new_references igf_sl_dl_pnote_s_p_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_sl_dl_pnote_s_p_all%ROWTYPE;

2: /* $Header: IGFLI29B.pls 115.4 2002/11/28 14:28:05 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_sl_dl_pnote_s_p_all%ROWTYPE;
6: new_references igf_sl_dl_pnote_s_p_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 49: FROM IGF_SL_DL_PNOTE_S_P_ALL

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

Line 146: FROM igf_sl_dl_pnote_s_p_all

142: || (reverse chronological order - newest change first)
143: */
144: CURSOR cur_rowid IS
145: SELECT rowid
146: FROM igf_sl_dl_pnote_s_p_all
147: WHERE pnsp_id = x_pnsp_id
148: FOR UPDATE NOWAIT;
149:
150: lv_rowid cur_rowid%RowType;

Line 181: FROM igf_sl_dl_pnote_s_p_all

177: || (reverse chronological order - newest change first)
178: */
179: CURSOR cur_rowid IS
180: SELECT rowid
181: FROM igf_sl_dl_pnote_s_p_all
182: WHERE ((loan_id = x_loan_id));
183:
184: lv_rowid cur_rowid%RowType;
185:

Line 337: FROM igf_sl_dl_pnote_s_p_all

333: || (reverse chronological order - newest change first)
334: */
335: CURSOR c IS
336: SELECT rowid
337: FROM igf_sl_dl_pnote_s_p_all
338: WHERE pnsp_id = x_pnsp_id;
339:
340: x_last_update_date DATE;
341: x_last_updated_by NUMBER;

Line 381: SELECT igf_sl_dl_pnote_s_p_all_s.NEXTVAL

377: igs_ge_msg_stack.add;
378: app_exception.raise_exception;
379: END IF;
380:
381: SELECT igf_sl_dl_pnote_s_p_all_s.NEXTVAL
382: INTO x_pnsp_id
383: FROM dual;
384:
385: new_references.org_id := igs_ge_gen_003.get_org_id;

Line 417: INSERT INTO igf_sl_dl_pnote_s_p_all (

413: x_last_updated_by => x_last_updated_by,
414: x_last_update_login => x_last_update_login
415: );
416:
417: INSERT INTO igf_sl_dl_pnote_s_p_all (
418: pnsp_id,
419: batch_seq_num,
420: loan_id,
421: loan_number,

Line 545: FROM igf_sl_dl_pnote_s_p_all

541: s_permt_zip,
542: s_email_addr,
543: s_phone,
544: status
545: FROM igf_sl_dl_pnote_s_p_all
546: WHERE rowid = x_rowid
547: FOR UPDATE NOWAIT;
548:
549: tlinfo c1%ROWTYPE;

Line 703: UPDATE igf_sl_dl_pnote_s_p_all

699: x_program_update_date := SYSDATE;
700: END IF;
701: END IF;
702:
703: UPDATE igf_sl_dl_pnote_s_p_all
704: SET
705: batch_seq_num = new_references.batch_seq_num,
706: loan_id = new_references.loan_id,
707: loan_number = new_references.loan_number,

Line 775: FROM igf_sl_dl_pnote_s_p_all

771: || (reverse chronological order - newest change first)
772: */
773: CURSOR c1 IS
774: SELECT rowid
775: FROM igf_sl_dl_pnote_s_p_all
776: WHERE pnsp_id = x_pnsp_id;
777:
778: BEGIN
779:

Line 860: DELETE FROM igf_sl_dl_pnote_s_p_all

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