APPS.IGF_SL_CL_ORIG_ACK dependencies on IGF_SL_CL_RESP_R2_DTLS

Line 283: PROCEDURE insert_into_resp_r2(p_r2_record IN igf_sl_cl_resp_r2_dtls%ROWTYPE);

279: p_n_guarantee_amt IN igf_sl_cl_resp_r1_all.guarantee_amt%TYPE,
280: p_n_approved_amt IN igf_sl_cl_resp_r1_all.alt_approved_amt%TYPE
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);

Line 1214: TYPE tab_resp_r2 IS TABLE OF igf_sl_cl_resp_r2_dtls%ROWTYPE INDEX BY BINARY_INTEGER;

1210: r8_tab r8_tab_type;
1211:
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;

Line 6548: PROCEDURE insert_into_resp_r2(p_r2_record IN igf_sl_cl_resp_r2_dtls%ROWTYPE) AS

6544: );
6545: l_wf_parameter_list_t.DELETE;
6546: END raise_gamt_event;
6547:
6548: PROCEDURE insert_into_resp_r2(p_r2_record IN igf_sl_cl_resp_r2_dtls%ROWTYPE) AS
6549: ------------------------------------------------------------------
6550: --Created by : Sanil Madathil, Oracle IDC
6551: --Date created: 07 November 2004
6552: --

Line 6566: l_n_clresp2_id igf_sl_cl_resp_r2_dtls.clresp2_id%TYPE;

6562: --Change History:
6563: --Who When What
6564: ------------------------------------------------------------------
6565: l_v_rowid ROWID;
6566: l_n_clresp2_id igf_sl_cl_resp_r2_dtls.clresp2_id%TYPE;
6567: l_n_clrp1_id igf_sl_cl_resp_r1_all.clrp1_id%TYPE;
6568: rec_cl_resp_r2 igf_sl_cl_resp_r2_dtls%ROWTYPE;
6569:
6570: BEGIN

Line 6568: rec_cl_resp_r2 igf_sl_cl_resp_r2_dtls%ROWTYPE;

6564: ------------------------------------------------------------------
6565: l_v_rowid ROWID;
6566: l_n_clresp2_id igf_sl_cl_resp_r2_dtls.clresp2_id%TYPE;
6567: l_n_clrp1_id igf_sl_cl_resp_r1_all.clrp1_id%TYPE;
6568: rec_cl_resp_r2 igf_sl_cl_resp_r2_dtls%ROWTYPE;
6569:
6570: BEGIN
6571: l_v_rowid := NULL;
6572: l_n_clresp2_id := NULL;

Line 6578: p_v_string => 'invoking igf_sl_cl_resp_r2_dtls_pkg.insert_row for clrp1_id ='||l_n_clrp1_id

6574: l_n_clrp1_id := rec_cl_resp_r2.clrp1_id;
6575:
6576:
6577: log_to_fnd(p_v_module => 'insert_into_resp_r2',
6578: p_v_string => 'invoking igf_sl_cl_resp_r2_dtls_pkg.insert_row for clrp1_id ='||l_n_clrp1_id
6579: );
6580:
6581:
6582: igf_sl_cl_resp_r2_dtls_pkg.insert_row(

Line 6582: igf_sl_cl_resp_r2_dtls_pkg.insert_row(

6578: p_v_string => 'invoking igf_sl_cl_resp_r2_dtls_pkg.insert_row for clrp1_id ='||l_n_clrp1_id
6579: );
6580:
6581:
6582: igf_sl_cl_resp_r2_dtls_pkg.insert_row(
6583: x_rowid => l_v_rowid ,
6584: x_clresp2_id => l_n_clresp2_id ,
6585: x_clrp1_id => l_n_clrp1_id ,
6586: x_record_code_txt => rec_cl_resp_r2.record_code_txt,