APPS.IEX_WRITEOFFOBJ_PUB dependencies on IEX_WRITEOFFS

Line 421: from iex_writeoffs

417: l_stream okl_strm_type_b.code%TYPE;
418:
419: cursor c_get_obj_ver(p_WRITEOFF_ID IN NUMBER) is
420: select object_version_number
421: from iex_writeoffs
422: where WRITEOFF_ID =p_WRITEOFF_ID;
423:
424: BEGIN
425:

Line 476: IEX_WRITEOFFS_PVT.Update_writeoffs(

472: l_writeoff_rec.disposition_code := 'W';
473: --l_writeoff_rec.disposition_date := SYSDATE;
474: l_writeoff_rec.writeoff_id:=l_writeoff_obj_rec.writeoff_id;
475:
476: IEX_WRITEOFFS_PVT.Update_writeoffs(
477: P_Api_Version_Number =>l_api_version_number
478: ,P_Init_Msg_List =>'F'
479: ,P_Commit =>'T'
480: ,P_writeoffs_Rec =>l_writeoff_rec

Line 567: from iex_writeoffs

563: l_OBJECT_TYPE VARCHAR2(100);
564:
565: cursor c_get_obj_ver(p_WRITEOFF_ID IN NUMBER) is
566: select object_version_number,writeoff_reason
567: from iex_writeoffs
568: where WRITEOFF_ID =p_WRITEOFF_ID;
569:
570:
571: --bug 8258156 add ar_payment_schedules_all to get org id

Line 593: l_adj_reason_code iex_writeoffs.writeoff_reason%TYPE;

589: l_ajlv_rec ajlv_rec_type;
590: x_ajlv_rec ajlv_rec_type;
591: l_writeoff_obj_rec writeoff_obj_rec_type ;
592: l_writeoff_rec writeoff_rec_type ;
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;

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

618: /** 1) insert into okl_trx_ar_adjst_b and tl
619: ** 2) insert into okl_txl_adjst_lns_b and tl
620: ** 3) call okl_adjst_create_pvt to create adjsutment
621: ** 4) update iex_writeoff_objects with the adjustment ID
622: ** 5) update iex_writeoffs disposition code to APPROVED
623: ** 6) if writeoff type is CONTRACT then send asset mgr a termination notification */
624:
625: OPEN c_get_obj_ver(l_WRITEOFF_ID);
626: FETCH c_get_obj_ver INTO l_writeoff_rec.object_version_number, l_adj_reason_code;

Line 904: --update iex_writeoffs

900:
901: END LOOP;
902:
903: if l_ctr =1 THEN
904: --update iex_writeoffs
905: --prefix this message before writeoff record is updated
906: AddfailMsg( p_object => 'Writeoffs ', p_operation => 'UPDATE' );
907:
908: -- update iex_writeoff's dispostion_code;

Line 913: IEX_WRITEOFFS_PVT.Update_writeoffs(

909: l_writeoff_rec.disposition_code := 'A';
910: -- l_writeoff_rec.disposition_date := SYSDATE;
911: l_writeoff_rec.writeoff_id := l_writeoff_id;
912:
913: IEX_WRITEOFFS_PVT.Update_writeoffs(
914: P_Api_Version_Number => l_api_version_number
915: ,P_Init_Msg_List => 'F'
916: ,P_Commit => 'F'
917: ,P_writeoffs_Rec => l_writeoff_rec

Line 1037: from iex_writeoffs

1033: l_REQUEST_ID VARCHAR2(32627);
1034:
1035: cursor c_get_obj_ver(p_WRITEOFF_ID IN NUMBER) is
1036: select object_version_number
1037: from iex_writeoffs
1038: where WRITEOFF_ID =p_WRITEOFF_ID;
1039:
1040:
1041: l_api_name CONSTANT VARCHAR2(50) := 'REJECT_WRITEOFFS';

Line 1131: IEX_WRITEOFFS_PVT.Update_writeoffs(

1127: l_writeoff_rec.disposition_code := 'R';
1128: --l_writeoff_rec.disposition_date := SYSDATE;
1129: l_writeoff_rec.writeoff_id := l_writeoff_id;
1130:
1131: IEX_WRITEOFFS_PVT.Update_writeoffs(
1132: P_Api_Version_Number =>l_api_version_number
1133: ,P_Init_Msg_List =>'F'
1134: ,P_Commit =>'F'
1135: ,P_writeoffs_Rec =>l_writeoff_rec