APPS.IGF_SL_CL_RESP_R7_DTLS_PKG dependencies on IGF_SL_CL_RESP_R7_DTLS

Line 1: PACKAGE BODY igf_sl_cl_resp_r7_dtls_pkg AS

1: PACKAGE BODY igf_sl_cl_resp_r7_dtls_pkg AS
2: /* $Header: IGFLI39B.pls 120.0 2005/06/01 14:49:33 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_sl_cl_resp_r7_dtls%ROWTYPE;

Line 5: old_references igf_sl_cl_resp_r7_dtls%ROWTYPE;

1: PACKAGE BODY igf_sl_cl_resp_r7_dtls_pkg AS
2: /* $Header: IGFLI39B.pls 120.0 2005/06/01 14:49:33 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_sl_cl_resp_r7_dtls%ROWTYPE;
6: new_references igf_sl_cl_resp_r7_dtls%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_sl_cl_resp_r7_dtls%ROWTYPE;

2: /* $Header: IGFLI39B.pls 120.0 2005/06/01 14:49:33 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_sl_cl_resp_r7_dtls%ROWTYPE;
6: new_references igf_sl_cl_resp_r7_dtls%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 44: FROM igf_sl_cl_resp_r7_dtls

40: */
41:
42: CURSOR cur_old_ref_values IS
43: SELECT *
44: FROM igf_sl_cl_resp_r7_dtls
45: WHERE rowid = x_rowid;
46:
47: BEGIN
48:

Line 119: FROM igf_sl_cl_resp_r7_dtls

115: ) AS
116:
117: CURSOR cur_rowid IS
118: SELECT rowid
119: FROM igf_sl_cl_resp_r7_dtls
120: WHERE ((clrp1_id = x_clrp1_id));
121:
122: lv_rowid cur_rowid%RowType;
123:

Line 155: FROM igf_sl_cl_resp_r7_dtls

151: || (reverse chronological order - newest change first)
152: */
153: CURSOR cur_rowid IS
154: SELECT rowid
155: FROM igf_sl_cl_resp_r7_dtls
156: WHERE clresp7_id = x_clresp7_id
157: FOR UPDATE NOWAIT;
158:
159: lv_rowid cur_rowid%RowType;

Line 334: fnd_message.set_token ('ROUTINE', 'IGF_SL_CL_RESP_R7_DTLS_PKG.INSERT_ROW');

330: x_program_update_date := SYSDATE;
331: END IF;
332: ELSE
333: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
334: fnd_message.set_token ('ROUTINE', 'IGF_SL_CL_RESP_R7_DTLS_PKG.INSERT_ROW');
335: igs_ge_msg_stack.add;
336: app_exception.raise_exception;
337: END IF;
338:

Line 366: INSERT INTO igf_sl_cl_resp_r7_dtls (

362: x_last_updated_by => x_last_updated_by,
363: x_last_update_login => x_last_update_login
364: );
365:
366: INSERT INTO igf_sl_cl_resp_r7_dtls (
367: clresp7_id,
368: clrp1_id,
369: record_code_txt,
370: layout_owner_code_txt,

Line 392: igf_sl_cl_resp_r7_dtls_s.NEXTVAL,

388: program_id,
389: program_application_id,
390: program_update_date
391: ) VALUES (
392: igf_sl_cl_resp_r7_dtls_s.NEXTVAL,
393: new_references.clrp1_id,
394: new_references.record_code_txt,
395: new_references.layout_owner_code_txt,
396: new_references.layout_identifier_code_txt,

Line 464: FROM igf_sl_cl_resp_r7_dtls

460: borrower_temp_add_state_txt,
461: borrower_temp_add_zip_num,
462: borrower_temp_add_zip_xtn_num,
463: borrower_forgn_postal_code_txt
464: FROM igf_sl_cl_resp_r7_dtls
465: WHERE rowid = x_rowid
466: FOR UPDATE NOWAIT;
467:
468: tlinfo c1%ROWTYPE;

Line 564: fnd_message.set_token ('ROUTINE', 'IGF_SL_CL_RESP_R7_DTLS_PKG.UPDATE_ROW');

560: x_last_update_login := -1;
561: END IF;
562: ELSE
563: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
564: fnd_message.set_token ('ROUTINE', 'IGF_SL_CL_RESP_R7_DTLS_PKG.UPDATE_ROW');
565: igs_ge_msg_stack.add;
566: app_exception.raise_exception;
567: END IF;
568:

Line 608: UPDATE igf_sl_cl_resp_r7_dtls

604: x_program_update_date := SYSDATE;
605: END IF;
606: END IF;
607:
608: UPDATE igf_sl_cl_resp_r7_dtls
609: SET
610: clrp1_id = new_references.clrp1_id,
611: record_code_txt = new_references.record_code_txt,
612: layout_owner_code_txt = new_references.layout_owner_code_txt,

Line 670: FROM igf_sl_cl_resp_r7_dtls

666: || (reverse chronological order - newest change first)
667: */
668: CURSOR c1 IS
669: SELECT rowid
670: FROM igf_sl_cl_resp_r7_dtls
671: WHERE clresp7_id = x_clresp7_id;
672:
673: BEGIN
674:

Line 745: DELETE FROM igf_sl_cl_resp_r7_dtls

741: p_action => 'DELETE',
742: x_rowid => x_rowid
743: );
744:
745: DELETE FROM igf_sl_cl_resp_r7_dtls
746: WHERE rowid = x_rowid;
747:
748: IF (SQL%NOTFOUND) THEN
749: RAISE NO_DATA_FOUND;

Line 755: END igf_sl_cl_resp_r7_dtls_pkg;

751:
752: END delete_row;
753:
754:
755: END igf_sl_cl_resp_r7_dtls_pkg;