[Home] [Help]
174: --where payment_schedule_id =p_object_id;
175:
176: cursor c_get_cont_invoices(p_object_id IN VARCHAR2,p_request_id IN NUMBER) is
177: select chr.contract_number, sum(iwob.adjustment_amount), chr.currency_code
178: from iex_writeoff_objects iwob, okc_k_headers_b chr
179: where chr.id = p_object_id
180: and iwob.contract_id = chr.id
181: and iwob.request_id = p_request_id
182: group by chr.contract_number,chr.currency_code ;
304: select rs.source_name, chr.contract_number
305: from iex_cases_all_b icas,
306: jtf_rs_resource_extns rs,
307: iex_case_objects ico,
308: okc_k_headers_b chr
309: where ico.cas_id = icas.cas_id
310: and icas.owner_resource_id = rs.resource_id(+)
311: and chr.id = ico.object_id
312: and chr.id = to_number(p_object_id);
411: x_ajlv_rec ajlv_rec_type;
412: l_writeoff_obj_rec writeoff_obj_rec_type ;
413: l_writeoff_rec writeoff_rec_type ;
414: l_code_combination_id ar_adjustments.code_combination_ID%TYPE;
415: l_contract_number okc_k_headers_b.contract_number%TYPE;
416: l_product okl_products_v.name%TYPE;
417: l_stream okl_strm_type_b.code%TYPE;
418:
419: cursor c_get_obj_ver(p_WRITEOFF_ID IN NUMBER) is
593: l_adj_reason_code iex_writeoffs.writeoff_reason%TYPE;
594: l_ctr NUMBER;
595:
596: l_code_combination_id ar_adjustments.code_combination_ID%TYPE;
597: l_contract_number okc_k_headers_b.contract_number%TYPE;
598:
599: BEGIN
600:
601: if funcmode <> 'RUN' then
714: iex_debug_pub.logmessage ('Error in retreiving Code combination ');
715: END IF;
716:
717: select contract_number into l_contract_number
718: from okc_k_headers_b
719: where id=i.contract_id;
720:
721: fnd_message.set_name('IEX', 'IEX_WRITEOFFOBJ_CODE_COMB');
722: fnd_message.set_token('CONTRACT_NUMBER', l_contract_number);