APPS.IGF_SL_CL_RESP_R2_DTLS_PKG dependencies on IGF_SL_CL_RESP_R2_DTLS

Line 1: PACKAGE BODY igf_sl_cl_resp_r2_dtls_pkg AS

1: PACKAGE BODY igf_sl_cl_resp_r2_dtls_pkg AS
2: /* $Header: IGFLI37B.pls 120.0 2005/06/01 15:19:42 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_sl_cl_resp_r2_dtls%ROWTYPE;

Line 5: old_references igf_sl_cl_resp_r2_dtls%ROWTYPE;

1: PACKAGE BODY igf_sl_cl_resp_r2_dtls_pkg AS
2: /* $Header: IGFLI37B.pls 120.0 2005/06/01 15:19:42 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_sl_cl_resp_r2_dtls%ROWTYPE;
6: new_references igf_sl_cl_resp_r2_dtls%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_sl_cl_resp_r2_dtls%ROWTYPE;

2: /* $Header: IGFLI37B.pls 120.0 2005/06/01 15:19:42 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_sl_cl_resp_r2_dtls%ROWTYPE;
6: new_references igf_sl_cl_resp_r2_dtls%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 35: FROM igf_sl_cl_resp_r2_dtls

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

Line 102: FROM igf_sl_cl_resp_r2_dtls

98: ) RETURN BOOLEAN AS
99:
100: CURSOR cur_rowid IS
101: SELECT rowid
102: FROM igf_sl_cl_resp_r2_dtls
103: WHERE clresp2_id = x_clresp2_id
104: FOR UPDATE NOWAIT;
105:
106: lv_rowid cur_rowid%RowType;

Line 129: FROM igf_sl_cl_resp_r2_dtls

125: ) AS
126:
127: CURSOR cur_rowid IS
128: SELECT rowid
129: FROM igf_sl_cl_resp_r2_dtls
130: WHERE ((clrp1_id = x_clrp1_id));
131:
132: lv_rowid cur_rowid%RowType;
133:

Line 281: fnd_message.set_token ('ROUTINE', 'IGF_SL_CL_RESP_R2_DTLS_PKG.INSERT_ROW');

277: x_program_update_date := SYSDATE;
278: END IF;
279: ELSE
280: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
281: fnd_message.set_token ('ROUTINE', 'IGF_SL_CL_RESP_R2_DTLS_PKG.INSERT_ROW');
282: igs_ge_msg_stack.add;
283: app_exception.raise_exception;
284: END IF;
285:

Line 304: INSERT INTO igf_sl_cl_resp_r2_dtls (

300: x_last_updated_by => x_last_updated_by,
301: x_last_update_login => x_last_update_login
302: );
303:
304: INSERT INTO igf_sl_cl_resp_r2_dtls (
305: clresp2_id,
306: clrp1_id,
307: record_code_txt,
308: uniq_layout_vend_code,

Line 321: igf_sl_cl_resp_r2_dtls_s.NEXTVAL,

317: program_id,
318: program_application_id,
319: program_update_date
320: ) VALUES (
321: igf_sl_cl_resp_r2_dtls_s.NEXTVAL,
322: new_references.clrp1_id,
323: new_references.record_code_txt,
324: new_references.uniq_layout_vend_code,
325: new_references.uniq_layout_ident_code,

Line 366: FROM igf_sl_cl_resp_r2_dtls

362: record_code_txt,
363: uniq_layout_vend_code,
364: uniq_layout_ident_code,
365: filler_txt
366: FROM igf_sl_cl_resp_r2_dtls
367: WHERE rowid = x_rowid
368: FOR UPDATE NOWAIT;
369:
370: tlinfo c1%ROWTYPE;

Line 448: fnd_message.set_token ('ROUTINE', 'IGF_SL_CL_RESP_R2_DTLS_PKG.UPDATE_ROW');

444: x_last_update_login := -1;
445: END IF;
446: ELSE
447: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
448: fnd_message.set_token ('ROUTINE', 'IGF_SL_CL_RESP_R2_DTLS_PKG.UPDATE_ROW');
449: igs_ge_msg_stack.add;
450: app_exception.raise_exception;
451: END IF;
452:

Line 483: UPDATE igf_sl_cl_resp_r2_dtls

479: x_program_update_date := SYSDATE;
480: END IF;
481: END IF;
482:
483: UPDATE igf_sl_cl_resp_r2_dtls
484: SET
485: clrp1_id = new_references.clrp1_id,
486: record_code_txt = new_references.record_code_txt,
487: uniq_layout_vend_code = new_references.uniq_layout_vend_code,

Line 527: FROM igf_sl_cl_resp_r2_dtls

523: || (reverse chronological order - newest change first)
524: */
525: CURSOR c1 IS
526: SELECT rowid
527: FROM igf_sl_cl_resp_r2_dtls
528: WHERE x_clresp2_id = clresp2_id;
529:
530: BEGIN
531:

Line 584: DELETE FROM igf_sl_cl_resp_r2_dtls

580: p_action => 'DELETE',
581: x_rowid => x_rowid
582: );
583:
584: DELETE FROM igf_sl_cl_resp_r2_dtls
585: WHERE rowid = x_rowid;
586:
587: IF (SQL%NOTFOUND) THEN
588: RAISE NO_DATA_FOUND;

Line 594: END igf_sl_cl_resp_r2_dtls_pkg;

590:
591: END delete_row;
592:
593:
594: END igf_sl_cl_resp_r2_dtls_pkg;