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_OPEN_API_PKG dependencies on JAI_AR_TRX_INS_LINES_T

Line 5506: ||Populate temporary table JAI_AR_TRX_INS_LINES_T

5502:
5503:
5504:
5505: /*
5506: ||Populate temporary table JAI_AR_TRX_INS_LINES_T
5507: */
5508: PROCEDURE populate_temp_table(
5509: pn_interface_line_id IN JAI_INTERFACE_LINES_ALL.INTERFACE_LINE_ID%TYPE,
5510: pn_customer_trx_id IN ra_customer_trx_all.customer_trx_id%type,

Line 5637: FROM JAI_AR_TRX_INS_LINES_T

5633: WHERE customer_trx_id = v_customer_trx_id;
5634:
5635: CURSOR Insert_Update_Cur(p_customer_trx_line_id IN NUMBER) IS
5636: SELECT INSERT_UPDATE_FLAG
5637: FROM JAI_AR_TRX_INS_LINES_T
5638: WHERE customer_trx_id = V_CUSTOMER_TRX_ID
5639: AND Customer_trx_line_id = p_customer_trx_line_id
5640: ORDER BY CUSTOMER_TRX_LINE_ID;
5641:

Line 5813: FROM JAI_AR_TRX_INS_LINES_T b

5809: FOR TAX_TYPE_REC IN TAX_TYPE_CUR LOOP
5810:
5811: SELECT COUNT(*)
5812: INTO v_counter
5813: FROM JAI_AR_TRX_INS_LINES_T b
5814: WHERE b.LINK_TO_CUST_TRX_LINE_ID = pn_customer_trx_line_id
5815: AND b.customer_trx_line_id = Tax_Type_Rec.LINE_ID;
5816:
5817: IF (upper(Tax_Type_Rec.T_Type) = 'VAT REVERSAL') THEN

Line 6112: INSERT INTO JAI_AR_TRX_INS_LINES_T

6108: IF NVL(v_counter, 0) = 0 THEN
6109:
6110:
6111:
6112: INSERT INTO JAI_AR_TRX_INS_LINES_T
6113: (
6114: INTERFACE_FLAG,--added by zhiwei for Open Interface ER 20101116
6115: extended_amount,
6116: customer_trx_line_id,

Line 6164: UPDATE JAI_AR_TRX_INS_LINES_T

6160: v_org_id, -- added by sriram bug # 2779967
6161: tax_type_rec.tax_line_no); -- added by sriram - bug # 2769439
6162: ELSE
6163:
6164: UPDATE JAI_AR_TRX_INS_LINES_T
6165: SET extended_amount = TAX_TYPE_REC.tax_amt,
6166: set_of_books_id = v_books_id,
6167: line_type = v_line_type,
6168: uom_code = TAX_TYPE_REC.uom,

Line 6215: --get the data from JAI_AR_TRX_INS_LINES_T for customer_trx_id and link_to_cust_trx_line_id

6211: WHERE customer_trx_id = cp_customer_trx_id
6212: AND account_class IN
6213: (lv_account_class_tax, lv_account_class_freight);
6214:
6215: --get the data from JAI_AR_TRX_INS_LINES_T for customer_trx_id and link_to_cust_trx_line_id
6216: CURSOR cur_temp_lines_insert(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE, cp_link_to_cust_trx_line_id JAI_AR_TRX_INS_LINES_T.link_to_cust_trx_line_id%TYPE DEFAULT NULL) IS
6217: SELECT *
6218: FROM JAI_AR_TRX_INS_LINES_T
6219: WHERE customer_trx_id = cp_customer_trx_id

Line 6216: CURSOR cur_temp_lines_insert(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE, cp_link_to_cust_trx_line_id JAI_AR_TRX_INS_LINES_T.link_to_cust_trx_line_id%TYPE DEFAULT NULL) IS

6212: AND account_class IN
6213: (lv_account_class_tax, lv_account_class_freight);
6214:
6215: --get the data from JAI_AR_TRX_INS_LINES_T for customer_trx_id and link_to_cust_trx_line_id
6216: CURSOR cur_temp_lines_insert(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE, cp_link_to_cust_trx_line_id JAI_AR_TRX_INS_LINES_T.link_to_cust_trx_line_id%TYPE DEFAULT NULL) IS
6217: SELECT *
6218: FROM JAI_AR_TRX_INS_LINES_T
6219: WHERE customer_trx_id = cp_customer_trx_id
6220: AND link_to_cust_trx_line_id =

Line 6218: FROM JAI_AR_TRX_INS_LINES_T

6214:
6215: --get the data from JAI_AR_TRX_INS_LINES_T for customer_trx_id and link_to_cust_trx_line_id
6216: CURSOR cur_temp_lines_insert(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE, cp_link_to_cust_trx_line_id JAI_AR_TRX_INS_LINES_T.link_to_cust_trx_line_id%TYPE DEFAULT NULL) IS
6217: SELECT *
6218: FROM JAI_AR_TRX_INS_LINES_T
6219: WHERE customer_trx_id = cp_customer_trx_id
6220: AND link_to_cust_trx_line_id =
6221: NVL(cp_link_to_cust_trx_line_id, link_to_cust_trx_line_id)
6222: ORDER BY link_to_cust_trx_line_id, customer_trx_line_id;

Line 6735: FROM JAI_AR_TRX_INS_LINES_T

6731: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
6732:
6733: CURSOR count_cur IS
6734: SELECT count(customer_trx_line_id)
6735: FROM JAI_AR_TRX_INS_LINES_T
6736: WHERE customer_trx_id = pn_customer_trx_id;
6737:
6738: v_exter_code_combination_id JAI_INTERFACE_TAX_LINES_ALL.CODE_COMBINATION_ID%TYPE;
6739: v_exter_percent NUMBER;

Line 6786: FROM JAI_AR_TRX_INS_LINES_T

6782: CREATED_BY,
6783: LAST_UPDATE_LOGIN,
6784: INSERT_UPDATE_FLAG,
6785: LINE_NUMBER --ADD BY ZHIWEI
6786: FROM JAI_AR_TRX_INS_LINES_T
6787: WHERE customer_trx_id = pn_customer_trx_id
6788: and link_to_cust_trx_line_id = pn_customer_trx_line_id
6789: order by CUSTOMER_TRX_LINE_ID;
6790:

Line 6809: FROM JAI_AR_TRX_INS_LINES_T

6805: SELECT DISTINCT gl_date
6806: FROM RA_CUST_TRX_LINE_GL_DIST_ALL
6807: WHERE CUSTOMER_TRX_LINE_ID IN
6808: (SELECT LINK_TO_CUST_TRX_LINE_ID
6809: FROM JAI_AR_TRX_INS_LINES_T
6810: WHERE customer_trx_id = pn_customer_trx_id);
6811:
6812:
6813: CURSOR MAX_LINE_CUR(p_cust_link_line_id IN NUMBER, p_line_type IN VARCHAR2) IS

Line 6822: FROM JAI_AR_TRX_INS_LINES_T

6818:
6819:
6820: CURSOR LINK_LINE_CUR IS
6821: SELECT LINK_TO_CUST_TRX_LINE_ID, ERROR_FLAG --added the error_flag condition to process the records,which got stuck up
6822: FROM JAI_AR_TRX_INS_LINES_T
6823: WHERE customer_trx_id = pn_customer_trx_id
6824: AND LINK_TO_CUST_TRX_LINE_ID = pn_customer_trx_line_id;
6825:
6826:

Line 6831: JAI_AR_TRX_INS_LINES_T C

6827: CURSOR PREVIOUS_AMOUNT_CUR IS
6828: SELECT A.AMOUNT, A.ACCTD_AMOUNT
6829: FROM RA_CUST_TRX_LINE_GL_DIST_ALL A,
6830: RA_CUSTOMER_TRX_LINES_ALL B,
6831: JAI_AR_TRX_INS_LINES_T C
6832: WHERE A.CUSTOMER_TRX_LINE_ID = B.CUSTOMER_TRX_LINE_ID
6833: AND B.LINK_TO_CUST_TRX_LINE_ID = C.LINK_TO_CUST_TRX_LINE_ID
6834: AND C.CUSTOMER_TRX_ID = pn_customer_trx_id
6835: AND A.ACCOUNT_CLASS IN (lv_tax_const, lv_freight_acc_class)

Line 7326: Delete JAI_AR_TRX_INS_LINES_T

7322: INTO ln_tax_line_exists;
7323: CLOSE cur_chk_jai_tax_dtls;
7324:
7325: IF nvl(ln_tax_line_exists, 0) <> 1 THEN
7326: Delete JAI_AR_TRX_INS_LINES_T
7327: WHERE customer_trx_line_id = temp_rec.customer_trx_line_id
7328: AND link_to_cust_trx_line_id =
7329: temp_rec.link_to_cust_trx_line_id;
7330:

Line 7878: DELETE JAI_AR_TRX_INS_LINES_T

7874: end if; --END 22-MAR-02 FOR PROPER UPDATION
7875:
7876: v_sql_num := 33;
7877:
7878: DELETE JAI_AR_TRX_INS_LINES_T
7879: WHERE customer_trx_id = pn_customer_trx_id
7880: and link_to_cust_trx_line_id = pn_customer_trx_line_id;
7881:
7882: v_sql_num := 34;

Line 7902: UPDATE JAI_AR_TRX_INS_LINES_T

7898: when others then
7899: p_process_message := SUBSTR(SQLERRM, 1, 230);
7900: ROLLBACK TO TEMP_CUR_BLK_SVP;
7901:
7902: UPDATE JAI_AR_TRX_INS_LINES_T
7903: SET ERROR_FLAG = 'R', ERR_MESG = p_process_message
7904: WHERE CUSTOMER_TRX_ID = pn_customer_trx_id
7905: AND LINK_TO_CUST_TRX_LINE_ID = pn_customer_trx_line_id;
7906:

Line 7988: UPDATE JAI_AR_TRX_INS_LINES_T

7984:
7985: WHEN OTHERS THEN
7986:
7987: p_process_message := SUBSTR(SQLERRM, 1, 230);
7988: UPDATE JAI_AR_TRX_INS_LINES_T
7989: SET ERROR_FLAG = 'R', ERR_MESG = p_process_message
7990: WHERE CUSTOMER_TRX_ID = pn_customer_trx_id
7991: AND LINK_TO_CUST_TRX_LINE_ID = pn_customer_trx_line_id;
7992:

Line 8307: --THE PROCEDURE insert_line_t WILL BE FIRED TO POPULATE DATA INTO TABLE JAI_AR_TRX_INS_LINES_T

8303:
8304: --AFTER UPDATE TAXAMOUNT AND TOTALAMOUNT OF JAI_AR_TRX_LINES ,
8305: --TRIGGER JAI_JAR_TL_ARIUD_T1 WILL BE INVOKED, IF OPEN_INTF_SOURCE = 'OPENINTF' THEN RETURN, SO THE TRIGGER WILL DO NOTHING FOR OPEN INTERFACE
8306: --
8307: --THE PROCEDURE insert_line_t WILL BE FIRED TO POPULATE DATA INTO TABLE JAI_AR_TRX_INS_LINES_T
8308: --DETAILS REFER TO IN JAI_JAR_TL_TRIGGER_PKG.ARU_T1
8309: --
8310:
8311: ln_phase := 90.8;