APPS.IEX_WRITEOFFOBJ_PUB dependencies on IEX_WRITEOFFS

Line 400: from iex_writeoffs

396: l_stream okl_strm_type_b.code%TYPE;
397:
398: cursor c_get_obj_ver(p_WRITEOFF_ID IN NUMBER) is
399: select object_version_number
400: from iex_writeoffs
401: where WRITEOFF_ID =p_WRITEOFF_ID;
402:
403: BEGIN
404:

Line 455: IEX_WRITEOFFS_PVT.Update_writeoffs(

451: l_writeoff_rec.disposition_code := 'W';
452: --l_writeoff_rec.disposition_date := SYSDATE;
453: l_writeoff_rec.writeoff_id:=l_writeoff_obj_rec.writeoff_id;
454:
455: IEX_WRITEOFFS_PVT.Update_writeoffs(
456: P_Api_Version_Number =>l_api_version_number
457: ,P_Init_Msg_List =>'F'
458: ,P_Commit =>'T'
459: ,P_writeoffs_Rec =>l_writeoff_rec

Line 546: from iex_writeoffs

542: l_OBJECT_TYPE VARCHAR2(100);
543:
544: cursor c_get_obj_ver(p_WRITEOFF_ID IN NUMBER) is
545: select object_version_number,writeoff_reason
546: from iex_writeoffs
547: where WRITEOFF_ID =p_WRITEOFF_ID;
548:
549:
550: --bug 8258156 add ar_payment_schedules_all to get org id

Line 573: l_adj_reason_code iex_writeoffs.writeoff_reason%TYPE;

569: l_ajlv_rec ajlv_rec_type;
570: x_ajlv_rec ajlv_rec_type;
571: l_writeoff_obj_rec writeoff_obj_rec_type ;
572: l_writeoff_rec writeoff_rec_type ;
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;

Line 602: ** 5) update iex_writeoffs disposition code to APPROVED

598: /** 1) insert into okl_trx_ar_adjst_b and tl
599: ** 2) insert into okl_txl_adjst_lns_b and tl
600: ** 3) call okl_adjst_create_pvt to create adjsutment
601: ** 4) update iex_writeoff_objects with the adjustment ID
602: ** 5) update iex_writeoffs disposition code to APPROVED
603: ** 6) if writeoff type is CONTRACT then send asset mgr a termination notification */
604:
605: OPEN c_get_obj_ver(l_WRITEOFF_ID);
606: FETCH c_get_obj_ver INTO l_writeoff_rec.object_version_number, l_adj_reason_code;

Line 884: --update iex_writeoffs

880:
881: END LOOP;
882:
883: if l_ctr =1 THEN
884: --update iex_writeoffs
885: --prefix this message before writeoff record is updated
886: AddfailMsg( p_object => 'Writeoffs ', p_operation => 'UPDATE' );
887:
888: -- update iex_writeoff's dispostion_code;

Line 893: IEX_WRITEOFFS_PVT.Update_writeoffs(

889: l_writeoff_rec.disposition_code := 'A';
890: -- l_writeoff_rec.disposition_date := SYSDATE;
891: l_writeoff_rec.writeoff_id := l_writeoff_id;
892:
893: IEX_WRITEOFFS_PVT.Update_writeoffs(
894: P_Api_Version_Number => l_api_version_number
895: ,P_Init_Msg_List => 'F'
896: ,P_Commit => 'F'
897: ,P_writeoffs_Rec => l_writeoff_rec

Line 1017: from iex_writeoffs

1013: l_REQUEST_ID VARCHAR2(32627);
1014:
1015: cursor c_get_obj_ver(p_WRITEOFF_ID IN NUMBER) is
1016: select object_version_number
1017: from iex_writeoffs
1018: where WRITEOFF_ID =p_WRITEOFF_ID;
1019:
1020:
1021: l_api_name CONSTANT VARCHAR2(50) := 'REJECT_WRITEOFFS';

Line 1111: IEX_WRITEOFFS_PVT.Update_writeoffs(

1107: l_writeoff_rec.disposition_code := 'R';
1108: --l_writeoff_rec.disposition_date := SYSDATE;
1109: l_writeoff_rec.writeoff_id := l_writeoff_id;
1110:
1111: IEX_WRITEOFFS_PVT.Update_writeoffs(
1112: P_Api_Version_Number =>l_api_version_number
1113: ,P_Init_Msg_List =>'F'
1114: ,P_Commit =>'F'
1115: ,P_writeoffs_Rec =>l_writeoff_rec