APPS.IGF_SL_CL_ORIG_ACK dependencies on IGF_SL_CL_RESP_R7_DTLS

Line 287: PROCEDURE insert_into_resp_r7(p_r7_record IN igf_sl_cl_resp_r7_dtls%ROWTYPE);

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);
290:
291: PROCEDURE process_change_records (p_n_clrp1_id IN igf_sl_cl_resp_r1_all.clrp1_id%TYPE,

Line 1218: TYPE tab_resp_r7 IS TABLE OF igf_sl_cl_resp_r7_dtls%ROWTYPE INDEX BY BINARY_INTEGER;

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;
1221: v_tab_clchrs_dtls tab_clchrs_dtls;
1222: l_n_ctr_r2 NUMBER;

Line 6643: PROCEDURE insert_into_resp_r7(p_r7_record IN igf_sl_cl_resp_r7_dtls%ROWTYPE) AS

6639: );
6640:
6641: END insert_into_resp_r3;
6642:
6643: PROCEDURE insert_into_resp_r7(p_r7_record IN igf_sl_cl_resp_r7_dtls%ROWTYPE) AS
6644: ------------------------------------------------------------------
6645: --Created by : Sanil Madathil, Oracle IDC
6646: --Date created: 07 November 2004
6647: --

Line 6661: l_n_clresp7_id igf_sl_cl_resp_r7_dtls.clresp7_id%TYPE;

6657: --Change History:
6658: --Who When What
6659: ------------------------------------------------------------------
6660: l_v_rowid ROWID;
6661: l_n_clresp7_id igf_sl_cl_resp_r7_dtls.clresp7_id%TYPE;
6662: l_n_clrp1_id igf_sl_cl_resp_r1_all.clrp1_id%TYPE;
6663: rec_cl_resp_r7 igf_sl_cl_resp_r7_dtls%ROWTYPE;
6664:
6665: BEGIN

Line 6663: rec_cl_resp_r7 igf_sl_cl_resp_r7_dtls%ROWTYPE;

6659: ------------------------------------------------------------------
6660: l_v_rowid ROWID;
6661: l_n_clresp7_id igf_sl_cl_resp_r7_dtls.clresp7_id%TYPE;
6662: l_n_clrp1_id igf_sl_cl_resp_r1_all.clrp1_id%TYPE;
6663: rec_cl_resp_r7 igf_sl_cl_resp_r7_dtls%ROWTYPE;
6664:
6665: BEGIN
6666: l_v_rowid := NULL;
6667: l_n_clresp7_id := NULL;

Line 6676: igf_sl_cl_resp_r7_dtls_pkg.insert_row(

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,
6678: x_clresp7_id => l_n_clresp7_id,
6679: x_clrp1_id => l_n_clrp1_id,
6680: x_record_code_txt => rec_cl_resp_r7.record_code_txt,