APPS.IGF_SL_DL_PNOTE_RESP_PKG dependencies on IGF_SL_DL_PNOTE_RESP_ALL

Line 5: old_references igf_sl_dl_pnote_resp_all%ROWTYPE;

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

Line 6: new_references igf_sl_dl_pnote_resp_all%ROWTYPE;

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

Line 40: FROM IGF_SL_DL_PNOTE_RESP_ALL

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

Line 147: FROM igf_sl_dl_pnote_resp_all

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

Line 182: FROM igf_sl_dl_pnote_resp_all

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

Line 316: FROM igf_sl_dl_pnote_resp_all

312: || (reverse chronological order - newest change first)
313: */
314: CURSOR c IS
315: SELECT rowid
316: FROM igf_sl_dl_pnote_resp_all
317: WHERE dlpnr_id = x_dlpnr_id;
318:
319: x_last_update_date DATE;
320: x_last_updated_by NUMBER;

Line 360: SELECT igf_sl_dl_pnote_resp_all_s.NEXTVAL

356: igs_ge_msg_stack.add;
357: app_exception.raise_exception;
358: END IF;
359:
360: SELECT igf_sl_dl_pnote_resp_all_s.NEXTVAL
361: INTO x_dlpnr_id
362: FROM dual;
363:
364: new_references.org_id := igs_ge_gen_003.get_org_id;

Line 387: INSERT INTO igf_sl_dl_pnote_resp_all (

383: x_last_update_login => x_last_update_login,
384: x_elec_mpn_ind => x_elec_mpn_ind
385: );
386:
387: INSERT INTO igf_sl_dl_pnote_resp_all (
388: dlpnr_id,
389: dbth_id,
390: pnote_ack_date,
391: pnote_batch_id,

Line 479: FROM igf_sl_dl_pnote_resp_all

475: mpn_ind,
476: pnote_accept_amt,
477: status,
478: elec_mpn_ind
479: FROM igf_sl_dl_pnote_resp_all
480: WHERE rowid = x_rowid
481: FOR UPDATE NOWAIT;
482:
483: tlinfo c1%ROWTYPE;

Line 610: UPDATE igf_sl_dl_pnote_resp_all

606: x_program_update_date := SYSDATE;
607: END IF;
608: END IF;
609:
610: UPDATE igf_sl_dl_pnote_resp_all
611: SET
612: dbth_id = new_references.dbth_id,
613: pnote_ack_date = new_references.pnote_ack_date,
614: pnote_batch_id = new_references.pnote_batch_id,

Line 664: FROM igf_sl_dl_pnote_resp_all

660: || (reverse chronological order - newest change first)
661: */
662: CURSOR c1 IS
663: SELECT rowid
664: FROM igf_sl_dl_pnote_resp_all
665: WHERE dlpnr_id = x_dlpnr_id;
666:
667: BEGIN
668:

Line 731: DELETE FROM igf_sl_dl_pnote_resp_all

727: p_action => 'DELETE',
728: x_rowid => x_rowid
729: );
730:
731: DELETE FROM igf_sl_dl_pnote_resp_all
732: WHERE rowid = x_rowid;
733:
734: IF (SQL%NOTFOUND) THEN
735: RAISE NO_DATA_FOUND;