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 160: JAI_AR_TRX_INS_LINES_T for customer trx id and trx line id and also the

156:
157: S.No. Description
158:
159: 1 Sriram - Bug # 2590650 - Added delete statements to delete from the
160: JAI_AR_TRX_INS_LINES_T for customer trx id and trx line id and also the
161: JAI_AR_TRXS table
162:
163: 2 Sriram - Bug # 2618503
164: If the line being deleted corresponds to a return order or a sales order then

Line 254: DELETE JAI_AR_TRX_INS_LINES_T

250: WHERE LINK_TO_CUST_TRX_LINE_ID = v_customer_trx_line_id;
251:
252: -- the followining delete from temp_lines_insert added by sriram bug # 2590650
253:
254: DELETE JAI_AR_TRX_INS_LINES_T
255: WHERE CUSTOMER_TRX_ID = v_customer_trx_id
256: AND
257: LINK_TO_CUST_TRX_LINE_ID = v_customer_trx_line_id;
258:

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

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

Line 4049: --DELETE JAI_AR_TRX_INS_LINES_T

4045:
4046: -- Vijay Shankar for Bug# 3985561
4047: -- commented the following delete statement as this is not required in this trigger.
4048: -- This statement is executed in Concurrent process to default taxes from OM to AR
4049: --DELETE JAI_AR_TRX_INS_LINES_T
4050: --WHERE customer_trx_line_id = v_customer_trx_line_id;
4051:
4052: IF v_old_customer_trx_id <> v_header_id THEN
4053: UPDATE JAI_AR_TRX_LINES

Line 4811: DELETE JAI_AR_TRX_INS_LINES_T

4807: OPEN OLD_CUSTOMER_TRX_ID_CUR;
4808: FETCH OLD_CUSTOMER_TRX_ID_CUR INTO v_old_customer_trx_id;
4809: CLOSE OLD_CUSTOMER_TRX_ID_CUR;
4810:
4811: DELETE JAI_AR_TRX_INS_LINES_T
4812: WHERE Customer_Trx_Line_Id = v_customer_trx_line_id;
4813:
4814: IF v_old_customer_trx_id <> v_header_id THEN
4815: UPDATE JAI_AR_TRX_LINES