eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEX_WRITEOFFOBJ_PUB dependencies on IEX_WRITEOFF_OBJECTS

Line 9: -- : 4) Procedure to update iex_writeoff_objects after creating

5: -- Purpose : 1) Procedure to populate OKL_TRX_ADJST_B and OKL_TXL_ADJSTS_LNS_B
6: -- : 2) Procedure to call OKL_WRAPPER OKL_CREATE_ADJ_PVT
7: -- : to create an adjustment
8: -- : 3) Procedure to check approval before creating a writeoff.
9: -- : 4) Procedure to update iex_writeoff_objects after creating
10:
11: G_FILE_NAME VARCHAR2(12) ;
12: PG_DEBUG NUMBER ;
13: wf_yes varchar2(1) ;

Line 178: from iex_writeoff_objects iwob, okc_k_headers_b chr

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 ;

Line 400: l_writeoff_object_id IEX_writeoff_objects.writeoff_object_id%TYPE;

396:
397: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_WRITEOFFS';
398: l_api_name_full CONSTANT VARCHAR2(150):= g_pkg_name || '.' || l_api_name;
399: l_api_version_number CONSTANT NUMBER := 2.0;
400: l_writeoff_object_id IEX_writeoff_objects.writeoff_object_id%TYPE;
401: x_adj_id IEX_writeoff_objects.receviables_adjustment_id%TYPE;
402: l_return_status VARCHAR2(1);
403: l_msg_count NUMBER ;
404: l_msg_data VARCHAR2(32627);

Line 401: x_adj_id IEX_writeoff_objects.receviables_adjustment_id%TYPE;

397: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_WRITEOFFS';
398: l_api_name_full CONSTANT VARCHAR2(150):= g_pkg_name || '.' || l_api_name;
399: l_api_version_number CONSTANT NUMBER := 2.0;
400: l_writeoff_object_id IEX_writeoff_objects.writeoff_object_id%TYPE;
401: x_adj_id IEX_writeoff_objects.receviables_adjustment_id%TYPE;
402: l_return_status VARCHAR2(1);
403: l_msg_count NUMBER ;
404: l_msg_data VARCHAR2(32627);
405: l_message VARCHAR2(32627);

Line 407: l_object_version_number IEX_writeoff_objects.writeoff_object_id%TYPE;

403: l_msg_count NUMBER ;
404: l_msg_data VARCHAR2(32627);
405: l_message VARCHAR2(32627);
406:
407: l_object_version_number IEX_writeoff_objects.writeoff_object_id%TYPE;
408: l_adjv_rec adjv_rec_type;
409: x_adjv_rec adjv_rec_type;
410: l_ajlv_rec ajlv_rec_type;
411: x_ajlv_rec ajlv_rec_type;

Line 440: IEX_WRITEOFF_OBJECTS_PUB.create_writeoff_objects(

436: l_writeoff_obj_rec.writeoff_status := 'W';
437: l_writeoff_obj_rec.writeoff_type := p_writeoff_type;
438: l_writeoff_obj_rec.writeoff_type_id := p_object_id;
439:
440: IEX_WRITEOFF_OBJECTS_PUB.create_writeoff_objects(
441: P_Api_Version_Number =>p_Api_Version_Number
442: ,P_Init_Msg_List =>P_Init_Msg_List
443: ,P_Commit =>p_commit
444: ,P_writeoff_obj_rec =>l_writeoff_obj_rec

Line 575: from iex_writeoff_objects io,ar_payment_schedules_all ap

571: --bug 8258156 add ar_payment_schedules_all to get org id
572: cursor c_get_writeoff_objects(p_WRITEOFF_ID IN NUMBER, p_request_id IN NUMBER) is
573: select writeoff_object_id, object_version_number, transaction_id,
574: adjustment_amount, contract_id, org_id
575: from iex_writeoff_objects io,ar_payment_schedules_all ap
576: where WRITEOFF_ID = p_WRITEOFF_ID
577: and writeoff_status ='W'
578: and transaction_id = payment_schedule_id(+)
579: and io.request_id = p_request_id;

Line 584: l_writeoff_object_id IEX_writeoff_objects.writeoff_object_id%TYPE;

580:
581: l_api_name CONSTANT VARCHAR2(50) := 'APPROVE_WRITEOFFS';
582: l_api_name_full CONSTANT VARCHAR2(150):= g_pkg_name || '.' || l_api_name;
583: l_api_version_number CONSTANT NUMBER := 2.0;
584: l_writeoff_object_id IEX_writeoff_objects.writeoff_object_id%TYPE;
585: x_adj_id IEX_writeoff_objects.receviables_adjustment_id%TYPE;
586: l_object_version_number IEX_writeoff_objects.object_version_number%TYPE;
587:
588: x_adjv_rec adjv_rec_type;

Line 585: x_adj_id IEX_writeoff_objects.receviables_adjustment_id%TYPE;

581: l_api_name CONSTANT VARCHAR2(50) := 'APPROVE_WRITEOFFS';
582: l_api_name_full CONSTANT VARCHAR2(150):= g_pkg_name || '.' || l_api_name;
583: l_api_version_number CONSTANT NUMBER := 2.0;
584: l_writeoff_object_id IEX_writeoff_objects.writeoff_object_id%TYPE;
585: x_adj_id IEX_writeoff_objects.receviables_adjustment_id%TYPE;
586: l_object_version_number IEX_writeoff_objects.object_version_number%TYPE;
587:
588: x_adjv_rec adjv_rec_type;
589: l_ajlv_rec ajlv_rec_type;

Line 586: l_object_version_number IEX_writeoff_objects.object_version_number%TYPE;

582: l_api_name_full CONSTANT VARCHAR2(150):= g_pkg_name || '.' || l_api_name;
583: l_api_version_number CONSTANT NUMBER := 2.0;
584: l_writeoff_object_id IEX_writeoff_objects.writeoff_object_id%TYPE;
585: x_adj_id IEX_writeoff_objects.receviables_adjustment_id%TYPE;
586: l_object_version_number IEX_writeoff_objects.object_version_number%TYPE;
587:
588: x_adjv_rec adjv_rec_type;
589: l_ajlv_rec ajlv_rec_type;
590: x_ajlv_rec ajlv_rec_type;

Line 621: ** 4) update iex_writeoff_objects with the adjustment ID

617: aname => 'WRITEOFF_TYPE');
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);

Line 844: --else adjustment created and update iex_writeoff_objects

840: IEx_debug_pub.logmessage ('After caling OKL Adj API and adj_id ' || x_adj_id);
841: end if;
842: END IF;
843:
844: --else adjustment created and update iex_writeoff_objects
845: --with the adjustment ID
846: --populate the writeoff_obect rec
847:
848: if x_adj_id IS NOT NULL then

Line 864: --update iex_writeoff_objects

860: result := wf_engine.eng_completed ||':'||wf_no;
861: return;
862: end if;
863:
864: --update iex_writeoff_objects
865: --prefix this message before writeoff record is updated
866: AddfailMsg( p_object => 'Writeoff Object ',
867: p_operation => 'UPDATE' );
868:

Line 869: IEX_WRITEOFF_OBJECTS_PUB.update_writeoff_objects(

865: --prefix this message before writeoff record is updated
866: AddfailMsg( p_object => 'Writeoff Object ',
867: p_operation => 'UPDATE' );
868:
869: IEX_WRITEOFF_OBJECTS_PUB.update_writeoff_objects(
870: P_Api_Version_Number =>l_Api_Version_Number
871: ,P_Init_Msg_List =>'F'
872: ,P_Commit =>'F'
873: ,P_writeoff_obj_rec =>l_writeoff_obj_rec

Line 1045: IEX_writeoff_objects.writeoff_object_id%TYPE;

1041: l_api_name CONSTANT VARCHAR2(50) := 'REJECT_WRITEOFFS';
1042: l_api_name_full CONSTANT VARCHAR2(150):= g_pkg_name || '.' || l_api_name;
1043: l_api_version_number CONSTANT NUMBER := 2.0;
1044: l_object_version_number
1045: IEX_writeoff_objects.writeoff_object_id%TYPE;
1046:
1047: l_writeoff_rec writeoff_rec_type ;
1048: l_writeoff_obj_rec writeoff_obj_rec_type ;
1049:

Line 1054: from iex_writeoff_objects

1050: cursor c_get_writeoff_objects(p_WRITEOFF_ID IN NUMBER,
1051: p_REQUEST_ID IN NUMBER) is
1052: select writeoff_object_id,
1053: object_version_number
1054: from iex_writeoff_objects
1055: where WRITEOFF_ID =p_WRITEOFF_ID
1056: and writeoff_status ='W'
1057: and request_id =p_request_id;
1058:

Line 1081: --update iex_writeoff_objects

1077: FETCH c_get_obj_ver INTO l_writeoff_rec.object_version_number;
1078: CLOSE c_get_obj_ver;
1079:
1080:
1081: --update iex_writeoff_objects
1082: --prefix this message before writeoff record is updated
1083: AddfailMsg( p_object => 'Writeoff Object ',
1084: p_operation => 'UPDATE' );
1085:

Line 1092: IEX_WRITEOFF_OBJECTS_PUB.update_writeoff_objects(

1088: l_writeoff_obj_rec.writeoff_object_id :=i.writeoff_object_id;
1089: l_writeoff_obj_rec.writeoff_status :='R';
1090: l_writeoff_obj_rec.object_version_number :=i.object_version_number;
1091:
1092: IEX_WRITEOFF_OBJECTS_PUB.update_writeoff_objects(
1093: P_Api_Version_Number =>l_Api_Version_Number
1094: ,P_Init_Msg_List =>'F'
1095: ,P_Commit =>'F'
1096: ,P_writeoff_obj_rec =>l_writeoff_obj_rec

Line 1121: --update iex_writeoff_objects

1117: END IF;
1118:
1119: END LOOP;
1120:
1121: --update iex_writeoff_objects
1122: --prefix this message before writeoff record is updated
1123: AddfailMsg( p_object => 'Writeoffs ',
1124: p_operation => 'UPDATE' );
1125: