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.JAI_AR_RCTLA_TRIGGER_PKG dependencies on JAI_AR_TRX_INS_LINES_T

Line 179: JAI_AR_TRX_INS_LINES_T for customer trx id and trx line id and also the

175:
176: S.No. Description
177:
178: 1 Sriram - Bug # 2590650 - Added delete statements to delete from the
179: JAI_AR_TRX_INS_LINES_T for customer trx id and trx line id and also the
180: JAI_AR_TRXS table
181:
182: 2 Sriram - Bug # 2618503
183: If the line being deleted corresponds to a return order or a sales order then

Line 280: DELETE JAI_AR_TRX_INS_LINES_T

276: WHERE LINK_TO_CUST_TRX_LINE_ID = v_customer_trx_line_id;
277:
278: -- the followining delete from temp_lines_insert added by sriram bug # 2590650
279:
280: DELETE JAI_AR_TRX_INS_LINES_T
281: WHERE CUSTOMER_TRX_ID = v_customer_trx_id
282: AND
283: LINK_TO_CUST_TRX_LINE_ID = v_customer_trx_line_id;
284:

Line 2761: commented a delete statement on JAI_AR_TRX_INS_LINES_T table which is redundant and causing deadlock problems

2757: The variable v_tax_count was not re-initialised to zero , as a result code flow is not entering into an if condition
2758: because of the static value of 1 it has initially and hence all taxes are not flowing into the AR invoice.
2759:
2760: 23. 2004/11/03 Vijay Shankar for Bug# 3985561 (Porting of Bug#3651923), Version: 115.2
2761: commented a delete statement on JAI_AR_TRX_INS_LINES_T table which is redundant and causing deadlock problems
2762: This DELETE statement is executed in Concurrent process where in taxes are defaulted from OM to AR
2763: * HIGH DEPENDENCY for future bugs *
2764:
2765: 24. 29-nov-2004 ssumaith - bug# 4037690 - File version 115.4

Line 4378: --DELETE JAI_AR_TRX_INS_LINES_T

4374:
4375: -- Vijay Shankar for Bug# 3985561
4376: -- commented the following delete statement as this is not required in this trigger.
4377: -- This statement is executed in Concurrent process to default taxes from OM to AR
4378: --DELETE JAI_AR_TRX_INS_LINES_T
4379: --WHERE customer_trx_line_id = v_customer_trx_line_id;
4380:
4381: IF v_old_customer_trx_id <> v_header_id THEN
4382: UPDATE JAI_AR_TRX_LINES

Line 5885: DELETE JAI_AR_TRX_INS_LINES_T

5881: OPEN OLD_CUSTOMER_TRX_ID_CUR;
5882: FETCH OLD_CUSTOMER_TRX_ID_CUR INTO v_old_customer_trx_id;
5883: CLOSE OLD_CUSTOMER_TRX_ID_CUR;
5884:
5885: DELETE JAI_AR_TRX_INS_LINES_T
5886: WHERE Customer_Trx_Line_Id = v_customer_trx_line_id;
5887:
5888: IF v_old_customer_trx_id <> v_header_id THEN
5889: UPDATE JAI_AR_TRX_LINES