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_RCV_TAX_PKG dependencies on RCV_TRANSACTIONS_INTERFACE

Line 627: /*lv_mobile_txn_flag rcv_transactions_interface.mobile_txn%TYPE;

623:
624: /* Start Vijay Shankar for Bug#4199929 */
625: lv_tax_change_on_roi_recpts JAI_CMN_INVENTORY_ORGS.tax_change_on_open_int_recpts%TYPE;
626: lv_tax_change_on_wms_recpts JAI_CMN_INVENTORY_ORGS.tax_change_on_wms_recpts%TYPE;
627: /*lv_mobile_txn_flag rcv_transactions_interface.mobile_txn%TYPE;
628: above declaration fails incase client has a lower BASE VERSION like 11.5.5
629: So modified as below so that the procedure gets compiled. 4252036(4245089)
630: */
631: lv_mobile_txn_flag VARCHAR2(2);

Line 632: lv_open_interace_receipt_flag rcv_transactions_interface.validation_flag%TYPE;

628: above declaration fails incase client has a lower BASE VERSION like 11.5.5
629: So modified as below so that the procedure gets compiled. 4252036(4245089)
630: */
631: lv_mobile_txn_flag VARCHAR2(2);
632: lv_open_interace_receipt_flag rcv_transactions_interface.validation_flag%TYPE;
633: lv_dynamic_sql VARCHAR2(1000);
634: lv_profile_val VARCHAR2(10);
635:
636: CURSOR c_interface_trx_dtl(cp_interface_transaction_id IN NUMBER) IS

Line 639: FROM rcv_transactions_interface

635:
636: CURSOR c_interface_trx_dtl(cp_interface_transaction_id IN NUMBER) IS
637: /* SELECT nvl(validation_flag, 'N') validation_flag commented by Vijay Shankar for bug#4240265 */
638: SELECT decode(header_interface_id, null, 'N', 'Y') imported_receipt_flag
639: FROM rcv_transactions_interface
640: WHERE interface_transaction_id = cp_interface_transaction_id;
641: /* End Vijay Shankar for Bug#4199929 */
642:
643: CURSOR c_iproc_profile IS

Line 675: lv_dynamic_sql := 'select nvl(mobile_txn, ''N'') mobile_txn FROM rcv_transactions_interface WHERE interface_transaction_id = :1';

671: END LOOP;
672:
673: /* Start, Vijay Shankar for Bug#4199929 */
674: /* following is written to give control to clients so that for open interface receipts the value returned is 'Y' */
675: lv_dynamic_sql := 'select nvl(mobile_txn, ''N'') mobile_txn FROM rcv_transactions_interface WHERE interface_transaction_id = :1';
676: BEGIN
677: execute immediate lv_dynamic_sql into lv_mobile_txn_flag using p_interface_transaction_id;
678: EXCEPTION
679: WHEN OTHERS THEN