[Home] [Help]
492: AND rownum = 1
493: )
494: EXCISE_INV_DATE
495: FROM
496: RCV_HEADERS_INTERFACE RHI
497: WHERE
498: RHI.receipt_header_id = p_shipment_header_id;
499: CURSOR c_is_shipment_asn(p_shipment_header_id NUMBER)
500: IS
711: lv_profile_val VARCHAR2(10);
712:
713: CURSOR c_interface_trx_dtl(cp_interface_transaction_id IN NUMBER) IS
714: /*cursor query changed for bug 8486273 - on successful import, rows will be deleted
715: * from rcv_transactions_interface. We should check rcv_headers_interface table instead,
716: * where data would be retained until being purged. It should be noted that the group_id
717: * link between rcv_transactions and rcv_headers_interface is not one-one, but it is enough
718: * to establish that the receipt is imported through open interface.
719: bug 8594501 - earlier query caused mutating table error, as it hit the rcv_transactions
713: CURSOR c_interface_trx_dtl(cp_interface_transaction_id IN NUMBER) IS
714: /*cursor query changed for bug 8486273 - on successful import, rows will be deleted
715: * from rcv_transactions_interface. We should check rcv_headers_interface table instead,
716: * where data would be retained until being purged. It should be noted that the group_id
717: * link between rcv_transactions and rcv_headers_interface is not one-one, but it is enough
718: * to establish that the receipt is imported through open interface.
719: bug 8594501 - earlier query caused mutating table error, as it hit the rcv_transactions
720: * table for the same row which triggered this procedure (not committed yet). For this,
721: * group_id is being passed as a procedure parameter from the trigger.*/
728: /* Reverted the change in R12 Query added by nprashar for bug # 8566481
729: SELECT 'Y'
730: FROM dual
731: WHERE EXISTS (SELECT 1
732: FROM RCV_HEADERS_INTERFACE RHI
733: WHERE RHI.group_id = p_group_id);*/
734:
735: CURSOR c_iproc_profile IS
736: SELECT fnd_profile.value('JA_ACCESS_IPROC_TAX')