APPS.IGF_SL_CL_ORIG_ACK dependencies on IGF_SL_CL_RESP_R3_DTLS

Line 285: PROCEDURE insert_into_resp_r3(p_r3_record IN igf_sl_cl_resp_r3_dtls%ROWTYPE);

281: );
282:
283: PROCEDURE insert_into_resp_r2(p_r2_record IN igf_sl_cl_resp_r2_dtls%ROWTYPE);
284:
285: PROCEDURE insert_into_resp_r3(p_r3_record IN igf_sl_cl_resp_r3_dtls%ROWTYPE);
286:
287: PROCEDURE insert_into_resp_r7(p_r7_record IN igf_sl_cl_resp_r7_dtls%ROWTYPE);
288:
289: PROCEDURE insert_into_resp_r6(p_r6_record IN igf_sl_clchrs_dtls%ROWTYPE);

Line 1216: TYPE tab_resp_r3 IS TABLE OF igf_sl_cl_resp_r3_dtls%ROWTYPE INDEX BY BINARY_INTEGER;

1212: rec_cl_resp_r1 igf_sl_cl_resp_r1_all%ROWTYPE;
1213:
1214: TYPE tab_resp_r2 IS TABLE OF igf_sl_cl_resp_r2_dtls%ROWTYPE INDEX BY BINARY_INTEGER;
1215: v_tab_resp_r2 tab_resp_r2;
1216: TYPE tab_resp_r3 IS TABLE OF igf_sl_cl_resp_r3_dtls%ROWTYPE INDEX BY BINARY_INTEGER;
1217: v_tab_resp_r3 tab_resp_r3;
1218: TYPE tab_resp_r7 IS TABLE OF igf_sl_cl_resp_r7_dtls%ROWTYPE INDEX BY BINARY_INTEGER;
1219: v_tab_resp_r7 tab_resp_r7;
1220: TYPE tab_clchrs_dtls IS TABLE OF igf_sl_clchrs_dtls%ROWTYPE INDEX BY BINARY_INTEGER;

Line 6595: PROCEDURE insert_into_resp_r3(p_r3_record IN igf_sl_cl_resp_r3_dtls%ROWTYPE) AS

6591: );
6592: END insert_into_resp_r2;
6593:
6594:
6595: PROCEDURE insert_into_resp_r3(p_r3_record IN igf_sl_cl_resp_r3_dtls%ROWTYPE) AS
6596: ------------------------------------------------------------------
6597: --Created by : Sanil Madathil, Oracle IDC
6598: --Date created: 07 November 2004
6599: --

Line 6613: l_n_clresp3_id igf_sl_cl_resp_r3_dtls.clresp3_id%TYPE;

6609: --Change History:
6610: --Who When What
6611: ------------------------------------------------------------------
6612: l_v_rowid ROWID;
6613: l_n_clresp3_id igf_sl_cl_resp_r3_dtls.clresp3_id%TYPE;
6614: l_n_clrp1_id igf_sl_cl_resp_r1_all.clrp1_id%TYPE;
6615: rec_cl_resp_r3 igf_sl_cl_resp_r3_dtls%ROWTYPE;
6616:
6617: BEGIN

Line 6615: rec_cl_resp_r3 igf_sl_cl_resp_r3_dtls%ROWTYPE;

6611: ------------------------------------------------------------------
6612: l_v_rowid ROWID;
6613: l_n_clresp3_id igf_sl_cl_resp_r3_dtls.clresp3_id%TYPE;
6614: l_n_clrp1_id igf_sl_cl_resp_r1_all.clrp1_id%TYPE;
6615: rec_cl_resp_r3 igf_sl_cl_resp_r3_dtls%ROWTYPE;
6616:
6617: BEGIN
6618: l_v_rowid := NULL;
6619: l_n_clresp3_id := NULL;

Line 6625: p_v_string => 'invoking igf_sl_cl_resp_r3_dtls_pkg.insert_row for clrp1_id ='||l_n_clrp1_id

6621: l_n_clrp1_id := rec_cl_resp_r3.clrp1_id;
6622:
6623:
6624: log_to_fnd(p_v_module => 'insert_into_resp_r3',
6625: p_v_string => 'invoking igf_sl_cl_resp_r3_dtls_pkg.insert_row for clrp1_id ='||l_n_clrp1_id
6626: );
6627:
6628: igf_sl_cl_resp_r3_dtls_pkg.insert_row(
6629: x_rowid => l_v_rowid,

Line 6628: igf_sl_cl_resp_r3_dtls_pkg.insert_row(

6624: log_to_fnd(p_v_module => 'insert_into_resp_r3',
6625: p_v_string => 'invoking igf_sl_cl_resp_r3_dtls_pkg.insert_row for clrp1_id ='||l_n_clrp1_id
6626: );
6627:
6628: igf_sl_cl_resp_r3_dtls_pkg.insert_row(
6629: x_rowid => l_v_rowid,
6630: x_clresp3_id => l_n_clresp3_id,
6631: x_clrp1_id => l_n_clrp1_id,
6632: x_record_code_txt => rec_cl_resp_r3.record_code_txt,

Line 6673: p_v_string => 'invoking igf_sl_cl_resp_r3_dtls_pkg.insert_row for clrp1_id ='||l_n_clrp1_id

6669: l_n_clrp1_id := rec_cl_resp_r7.clrp1_id;
6670:
6671:
6672: log_to_fnd(p_v_module => 'insert_into_resp_r7',
6673: p_v_string => 'invoking igf_sl_cl_resp_r3_dtls_pkg.insert_row for clrp1_id ='||l_n_clrp1_id
6674: );
6675:
6676: igf_sl_cl_resp_r7_dtls_pkg.insert_row(
6677: x_rowid => l_v_rowid,