APPS.JAI_AR_TAX_LINES_PKG dependencies on JAI_AR_TRX_INS_LINES_T

Line 483: FROM JAI_AR_TRX_INS_LINES_T b

479: FOR TAX_TYPE_REC IN TAX_TYPE_CUR LOOP
480:
481: SELECT COUNT(*)
482: INTO v_counter
483: FROM JAI_AR_TRX_INS_LINES_T b
484: WHERE b.LINK_TO_CUST_TRX_LINE_ID = pr_new.Customer_Trx_Line_Id
485: AND b.customer_trx_line_id = Tax_Type_Rec.LINE_ID;
486:
487: IF tax_type_rec.t_type = 'Freight' THEN

Line 753: UPDATE JAI_AR_TRX_INS_LINES_T

749: pn_org_id => v_org_id,
750: pn_line_number => tax_type_rec.tax_line_no);
751:
752: ELSIF (v_counter > 0 AND pv_action = JAI_CONSTANTS.updating) THEN
753: UPDATE JAI_AR_TRX_INS_LINES_T
754: SET extended_amount = TAX_TYPE_REC.tax_amt,
755: set_of_books_id = v_books_id,
756: line_type = v_line_type,
757: uom_code = TAX_TYPE_REC.uom,

Line 1093: INSERT INTO JAI_AR_TRX_INS_LINES_T

1089: lv_debug_info);
1090:
1091: END IF;
1092:
1093: INSERT INTO JAI_AR_TRX_INS_LINES_T
1094: (extended_amount,
1095: customer_trx_line_id,
1096: customer_trx_id,
1097: set_of_books_id,

Line 1142: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME || lv_api_name,'1 record inserted into table JAI_AR_TRX_INS_LINES_T.');

1138: pv_source,
1139: pn_org_id,
1140: pn_line_number);
1141: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1142: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME || lv_api_name,'1 record inserted into table JAI_AR_TRX_INS_LINES_T.');
1143: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME || lv_api_name,'JAI_AR_TAX_LINES_PKG.INSERT_TAX_LINES_TEMP.END');
1144: END IF;
1145: EXCEPTION
1146: WHEN OTHERS THEN

Line 1150: substr('Error inserting table JAI_AR_TRX_INS_LINES_T. ' ||

1146: WHEN OTHERS THEN
1147: IF G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL THEN
1148: FND_LOG.STRING(G_LEVEL_UNEXPECTED,
1149: G_MODULE_NAME || lv_api_name,
1150: substr('Error inserting table JAI_AR_TRX_INS_LINES_T. ' ||
1151: sqlerrm,1,4000));
1152: END IF;
1153: RAISE le;
1154: END INSERT_TAX_LINES_TEMP;