APPS.IGF_SL_CL_RESP_R3_DTLS_PKG dependencies on IGF_SL_CL_RESP_R3_DTLS

Line 1: PACKAGE BODY igf_sl_cl_resp_r3_dtls_pkg AS

1: PACKAGE BODY igf_sl_cl_resp_r3_dtls_pkg AS
2: /* $Header: IGFLI38B.pls 120.0 2005/06/01 15:04:02 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_sl_cl_resp_r3_dtls%ROWTYPE;

Line 5: old_references igf_sl_cl_resp_r3_dtls%ROWTYPE;

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

Line 6: new_references igf_sl_cl_resp_r3_dtls%ROWTYPE;

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

Line 37: FROM igf_sl_cl_resp_r3_dtls

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

Line 112: FROM igf_sl_cl_resp_r3_dtls

108: || (reverse chronological order - newest change first)
109: */
110: CURSOR cur_rowid IS
111: SELECT rowid
112: FROM igf_sl_cl_resp_r3_dtls
113: WHERE clresp3_id = x_clresp3_id
114: FOR UPDATE NOWAIT;
115:
116: lv_rowid cur_rowid%RowType;

Line 138: FROM igf_sl_cl_resp_r3_dtls

134: ) AS
135:
136: CURSOR cur_rowid IS
137: SELECT rowid
138: FROM igf_sl_cl_resp_r3_dtls
139: WHERE ((clrp1_id = x_clrp1_id));
140:
141: lv_rowid cur_rowid%RowType;
142:

Line 296: fnd_message.set_token ('ROUTINE', 'IGF_SL_CL_RESP_R3_DTLS_PKG.INSERT_ROW');

292: x_program_update_date := SYSDATE;
293: END IF;
294: ELSE
295: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
296: fnd_message.set_token ('ROUTINE', 'IGF_SL_CL_RESP_R3_DTLS_PKG.INSERT_ROW');
297: igs_ge_msg_stack.add;
298: app_exception.raise_exception;
299: END IF;
300:

Line 321: INSERT INTO igf_sl_cl_resp_r3_dtls (

317: x_last_updated_by => x_last_updated_by,
318: x_last_update_login => x_last_update_login
319: );
320:
321: INSERT INTO igf_sl_cl_resp_r3_dtls (
322: clresp3_id,
323: clrp1_id,
324: record_code_txt,
325: message_1_text,

Line 340: igf_sl_cl_resp_r3_dtls_s.NEXTVAL,

336: program_id,
337: program_application_id,
338: program_update_date
339: ) VALUES (
340: igf_sl_cl_resp_r3_dtls_s.NEXTVAL,
341: new_references.clrp1_id,
342: new_references.record_code_txt,
343: new_references.message_1_text,
344: new_references.message_2_text,

Line 391: FROM igf_sl_cl_resp_r3_dtls

387: message_2_text,
388: message_3_text,
389: message_4_text,
390: message_5_text
391: FROM igf_sl_cl_resp_r3_dtls
392: WHERE rowid = x_rowid
393: FOR UPDATE NOWAIT;
394:
395: tlinfo c1%ROWTYPE;

Line 477: fnd_message.set_token ('ROUTINE', 'IGF_SL_CL_RESP_R3_DTLS_PKG.UPDATE_ROW');

473: x_last_update_login := -1;
474: END IF;
475: ELSE
476: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
477: fnd_message.set_token ('ROUTINE', 'IGF_SL_CL_RESP_R3_DTLS_PKG.UPDATE_ROW');
478: igs_ge_msg_stack.add;
479: app_exception.raise_exception;
480: END IF;
481:

Line 514: UPDATE igf_sl_cl_resp_r3_dtls

510: x_program_update_date := SYSDATE;
511: END IF;
512: END IF;
513:
514: UPDATE igf_sl_cl_resp_r3_dtls
515: SET
516: clrp1_id = new_references.clrp1_id,
517: record_code_txt = new_references.record_code_txt,
518: message_1_text = new_references.message_1_text,

Line 562: FROM igf_sl_cl_resp_r3_dtls

558: || (reverse chronological order - newest change first)
559: */
560: CURSOR c1 IS
561: SELECT rowid
562: FROM igf_sl_cl_resp_r3_dtls
563: WHERE clresp3_id = x_clresp3_id;
564:
565: BEGIN
566:

Line 623: DELETE FROM igf_sl_cl_resp_r3_dtls

619: p_action => 'DELETE',
620: x_rowid => x_rowid
621: );
622:
623: DELETE FROM igf_sl_cl_resp_r3_dtls
624: WHERE rowid = x_rowid;
625:
626: IF (SQL%NOTFOUND) THEN
627: RAISE NO_DATA_FOUND;

Line 633: END igf_sl_cl_resp_r3_dtls_pkg;

629:
630: END delete_row;
631:
632:
633: END igf_sl_cl_resp_r3_dtls_pkg;