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 172: from iex_writeoff_objects iwob, okc_k_headers_b chr

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 ;

Line 379: l_writeoff_object_id IEX_writeoff_objects.writeoff_object_id%TYPE;

375:
376: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_WRITEOFFS';
377: l_api_name_full CONSTANT VARCHAR2(150):= g_pkg_name || '.' || l_api_name;
378: l_api_version_number CONSTANT NUMBER := 2.0;
379: l_writeoff_object_id IEX_writeoff_objects.writeoff_object_id%TYPE;
380: x_adj_id IEX_writeoff_objects.receviables_adjustment_id%TYPE;
381: l_return_status VARCHAR2(1);
382: l_msg_count NUMBER ;
383: l_msg_data VARCHAR2(32627);

Line 380: x_adj_id IEX_writeoff_objects.receviables_adjustment_id%TYPE;

376: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_WRITEOFFS';
377: l_api_name_full CONSTANT VARCHAR2(150):= g_pkg_name || '.' || l_api_name;
378: l_api_version_number CONSTANT NUMBER := 2.0;
379: l_writeoff_object_id IEX_writeoff_objects.writeoff_object_id%TYPE;
380: x_adj_id IEX_writeoff_objects.receviables_adjustment_id%TYPE;
381: l_return_status VARCHAR2(1);
382: l_msg_count NUMBER ;
383: l_msg_data VARCHAR2(32627);
384: l_message VARCHAR2(32627);

Line 386: l_object_version_number IEX_writeoff_objects.writeoff_object_id%TYPE;

382: l_msg_count NUMBER ;
383: l_msg_data VARCHAR2(32627);
384: l_message VARCHAR2(32627);
385:
386: l_object_version_number IEX_writeoff_objects.writeoff_object_id%TYPE;
387: l_adjv_rec adjv_rec_type;
388: x_adjv_rec adjv_rec_type;
389: l_ajlv_rec ajlv_rec_type;
390: x_ajlv_rec ajlv_rec_type;

Line 419: IEX_WRITEOFF_OBJECTS_PUB.create_writeoff_objects(

415: l_writeoff_obj_rec.writeoff_status := 'W';
416: l_writeoff_obj_rec.writeoff_type := p_writeoff_type;
417: l_writeoff_obj_rec.writeoff_type_id := p_object_id;
418:
419: IEX_WRITEOFF_OBJECTS_PUB.create_writeoff_objects(
420: P_Api_Version_Number =>p_Api_Version_Number
421: ,P_Init_Msg_List =>P_Init_Msg_List
422: ,P_Commit =>p_commit
423: ,P_writeoff_obj_rec =>l_writeoff_obj_rec

Line 554: from iex_writeoff_objects io,ar_payment_schedules_all ap

550: --bug 8258156 add ar_payment_schedules_all to get org id
551: cursor c_get_writeoff_objects(p_WRITEOFF_ID IN NUMBER, p_request_id IN NUMBER) is
552: select writeoff_object_id, object_version_number, transaction_id,
553: adjustment_amount, contract_id, org_id
554: from iex_writeoff_objects io,ar_payment_schedules_all ap
555: where WRITEOFF_ID = p_WRITEOFF_ID
556: and writeoff_status ='W'
557: and transaction_id = payment_schedule_id(+)
558: and io.request_id = p_request_id;

Line 563: l_writeoff_object_id IEX_writeoff_objects.writeoff_object_id%TYPE;

559:
560: l_api_name CONSTANT VARCHAR2(50) := 'APPROVE_WRITEOFFS';
561: l_api_name_full CONSTANT VARCHAR2(150):= g_pkg_name || '.' || l_api_name;
562: l_api_version_number CONSTANT NUMBER := 2.0;
563: l_writeoff_object_id IEX_writeoff_objects.writeoff_object_id%TYPE;
564: x_adj_id IEX_writeoff_objects.receviables_adjustment_id%TYPE;
565: l_object_version_number IEX_writeoff_objects.object_version_number%TYPE;
566:
567: l_adjv_rec adjv_rec_type;

Line 564: x_adj_id IEX_writeoff_objects.receviables_adjustment_id%TYPE;

560: l_api_name CONSTANT VARCHAR2(50) := 'APPROVE_WRITEOFFS';
561: l_api_name_full CONSTANT VARCHAR2(150):= g_pkg_name || '.' || l_api_name;
562: l_api_version_number CONSTANT NUMBER := 2.0;
563: l_writeoff_object_id IEX_writeoff_objects.writeoff_object_id%TYPE;
564: x_adj_id IEX_writeoff_objects.receviables_adjustment_id%TYPE;
565: l_object_version_number IEX_writeoff_objects.object_version_number%TYPE;
566:
567: l_adjv_rec adjv_rec_type;
568: x_adjv_rec adjv_rec_type;

Line 565: l_object_version_number IEX_writeoff_objects.object_version_number%TYPE;

561: l_api_name_full CONSTANT VARCHAR2(150):= g_pkg_name || '.' || l_api_name;
562: l_api_version_number CONSTANT NUMBER := 2.0;
563: l_writeoff_object_id IEX_writeoff_objects.writeoff_object_id%TYPE;
564: x_adj_id IEX_writeoff_objects.receviables_adjustment_id%TYPE;
565: l_object_version_number IEX_writeoff_objects.object_version_number%TYPE;
566:
567: l_adjv_rec adjv_rec_type;
568: x_adjv_rec adjv_rec_type;
569: l_ajlv_rec ajlv_rec_type;

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

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

Line 824: --else adjustment created and update iex_writeoff_objects

820: IEx_debug_pub.logmessage ('After caling OKL Adj API and adj_id ' || x_adj_id);
821: end if;
822: END IF;
823:
824: --else adjustment created and update iex_writeoff_objects
825: --with the adjustment ID
826: --populate the writeoff_obect rec
827:
828: if x_adj_id IS NOT NULL then

Line 844: --update iex_writeoff_objects

840: result := wf_engine.eng_completed ||':'||wf_no;
841: return;
842: end if;
843:
844: --update iex_writeoff_objects
845: --prefix this message before writeoff record is updated
846: AddfailMsg( p_object => 'Writeoff Object ',
847: p_operation => 'UPDATE' );
848:

Line 849: IEX_WRITEOFF_OBJECTS_PUB.update_writeoff_objects(

845: --prefix this message before writeoff record is updated
846: AddfailMsg( p_object => 'Writeoff Object ',
847: p_operation => 'UPDATE' );
848:
849: IEX_WRITEOFF_OBJECTS_PUB.update_writeoff_objects(
850: P_Api_Version_Number =>l_Api_Version_Number
851: ,P_Init_Msg_List =>'F'
852: ,P_Commit =>'F'
853: ,P_writeoff_obj_rec =>l_writeoff_obj_rec

Line 1025: IEX_writeoff_objects.writeoff_object_id%TYPE;

1021: l_api_name CONSTANT VARCHAR2(50) := 'REJECT_WRITEOFFS';
1022: l_api_name_full CONSTANT VARCHAR2(150):= g_pkg_name || '.' || l_api_name;
1023: l_api_version_number CONSTANT NUMBER := 2.0;
1024: l_object_version_number
1025: IEX_writeoff_objects.writeoff_object_id%TYPE;
1026:
1027: l_writeoff_rec writeoff_rec_type ;
1028: l_writeoff_obj_rec writeoff_obj_rec_type ;
1029:

Line 1034: from iex_writeoff_objects

1030: cursor c_get_writeoff_objects(p_WRITEOFF_ID IN NUMBER,
1031: p_REQUEST_ID IN NUMBER) is
1032: select writeoff_object_id,
1033: object_version_number
1034: from iex_writeoff_objects
1035: where WRITEOFF_ID =p_WRITEOFF_ID
1036: and writeoff_status ='W'
1037: and request_id =p_request_id;
1038:

Line 1061: --update iex_writeoff_objects

1057: FETCH c_get_obj_ver INTO l_writeoff_rec.object_version_number;
1058: CLOSE c_get_obj_ver;
1059:
1060:
1061: --update iex_writeoff_objects
1062: --prefix this message before writeoff record is updated
1063: AddfailMsg( p_object => 'Writeoff Object ',
1064: p_operation => 'UPDATE' );
1065:

Line 1072: IEX_WRITEOFF_OBJECTS_PUB.update_writeoff_objects(

1068: l_writeoff_obj_rec.writeoff_object_id :=i.writeoff_object_id;
1069: l_writeoff_obj_rec.writeoff_status :='R';
1070: l_writeoff_obj_rec.object_version_number :=i.object_version_number;
1071:
1072: IEX_WRITEOFF_OBJECTS_PUB.update_writeoff_objects(
1073: P_Api_Version_Number =>l_Api_Version_Number
1074: ,P_Init_Msg_List =>'F'
1075: ,P_Commit =>'F'
1076: ,P_writeoff_obj_rec =>l_writeoff_obj_rec

Line 1101: --update iex_writeoff_objects

1097: END IF;
1098:
1099: END LOOP;
1100:
1101: --update iex_writeoff_objects
1102: --prefix this message before writeoff record is updated
1103: AddfailMsg( p_object => 'Writeoffs ',
1104: p_operation => 'UPDATE' );
1105: