DBA Data[Home] [Help]

APPS.JAI_JMCR_TRIGGER_PKG dependencies on JAI_AR_TRX_LINES

Line 142: UPDATE JAI_AR_TRX_LINES

138: IF nvl(v_quantity,0) = 0 THEN
139: v_quantity := -nvl(pr_old.quantity_applied,0);
140: END IF;
141:
142: UPDATE JAI_AR_TRX_LINES
143: SET matched_quantity = nvl(matched_quantity,0) + v_quantity
144: WHERE Customer_Trx_Line_Id = v_ref_line;
145: */
146:

Line 154: UPDATE JAI_AR_TRX_LINES

150:
151: --end if;
152:
153: FOR rec IN tax_amount_cur LOOP
154: UPDATE JAI_AR_TRX_LINES
155: SET tax_amount = rec.tax_amount,
156: total_amount = line_amount + rec.tax_amount
157: WHERE Customer_Trx_Line_Id = v_ref_line;
158: