[Home] [Help]
168: --where payment_schedule_id =p_object_id;
169:
170: cursor c_get_cont_invoices(p_object_id IN VARCHAR2,p_request_id IN NUMBER) is
171: select chr.contract_number, sum(iwob.adjustment_amount), chr.currency_code
172: from iex_writeoff_objects iwob, okc_k_headers_b chr
173: where chr.id = p_object_id
174: and iwob.contract_id = chr.id
175: and iwob.request_id = p_request_id
176: group by chr.contract_number,chr.currency_code ;
289: select rs.source_name, chr.contract_number
290: from iex_cases_all_b icas,
291: jtf_rs_resource_extns rs,
292: iex_case_objects ico,
293: okc_k_headers_b chr
294: where ico.cas_id = icas.cas_id
295: and icas.owner_resource_id = rs.resource_id(+)
296: and chr.id = ico.object_id
297: and chr.id = to_number(p_object_id);
390: x_ajlv_rec ajlv_rec_type;
391: l_writeoff_obj_rec writeoff_obj_rec_type ;
392: l_writeoff_rec writeoff_rec_type ;
393: l_code_combination_id ar_adjustments.code_combination_ID%TYPE;
394: l_contract_number okc_k_headers_b.contract_number%TYPE;
395: l_product okl_products_v.name%TYPE;
396: l_stream okl_strm_type_b.code%TYPE;
397:
398: cursor c_get_obj_ver(p_WRITEOFF_ID IN NUMBER) is
573: l_adj_reason_code iex_writeoffs.writeoff_reason%TYPE;
574: l_ctr NUMBER;
575:
576: l_code_combination_id ar_adjustments.code_combination_ID%TYPE;
577: l_contract_number okc_k_headers_b.contract_number%TYPE;
578:
579: BEGIN
580:
581: if funcmode <> 'RUN' then
694: iex_debug_pub.logmessage ('Error in retreiving Code combination ');
695: END IF;
696:
697: select contract_number into l_contract_number
698: from okc_k_headers_b
699: where id=i.contract_id;
700:
701: fnd_message.set_name('IEX', 'IEX_WRITEOFFOBJ_CODE_COMB');
702: fnd_message.set_token('CONTRACT_NUMBER', l_contract_number);