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_RT_TRIGGER_PKG dependencies on RCV_TRANSACTIONS

Line 133: Fix: Added cursor to pick deliver_to_location_id from PO_REQUISITION_LINES_ALL if location_id is null in rcv_transactions

129: check is required for org location set up.
130:
131: 10. 29-Jun-2012 mmurtuza for bug 14176672
132: Description: +:R12.1:INTERNAL ORDER STRUCK IN SHIPPED STATUS
133: Fix: Added cursor to pick deliver_to_location_id from PO_REQUISITION_LINES_ALL if location_id is null in rcv_transactions
134: and passed the same to cursor chk_org_setup_is_present when checking localization setup.
135:
136: 11. 13-Aug-2012 Bug 14010660
137: Description: Excise Invoice Number and Date provided in ASN is not reflected in Receipts

Line 143: Fix: Added cursor get_rma_loc to location_id from hr_locations_all if location_id is null in rcv_transactions

139: Fix: Fetched Excise Invoice Number and Date from ASN and populated the same to Localized Receipt Tables
140:
141: 12. 13-Dec-2012 mmurtuza for bug 15936238
142: Description: INDIA LOC - RECEIVING RMA RECEIPT FAILS
143: Fix: Added cursor get_rma_loc to location_id from hr_locations_all if location_id is null in rcv_transactions
144: and passed the same to cursor chk_org_setup_is_present when checking localization setup.
145:
146: 13. 21-Dec-2012 vkavulur for bug #14852106
147: Description - In case correction is done for a receipt without claiming the cenvat, an error has to be shown

Line 149: data into rcv transactions if -ve correction is being done by the user without claiming the cenvat

145:
146: 13. 21-Dec-2012 vkavulur for bug #14852106
147: Description - In case correction is done for a receipt without claiming the cenvat, an error has to be shown
148: Fix - Added raise application error in BRI_T1 procedure so that it can stop further processing and insertion of
149: data into rcv transactions if -ve correction is being done by the user without claiming the cenvat
150: --------------------------------------------------------------------------------------------
151:
152: -------------------------------------------------------------------------------------------
153:

Line 358: lv_parent_trx_type JAI_RCV_TRANSACTIONS.transaction_type%type;

354:
355: r_mtl_trx c_mtl_trx%ROWTYPE;
356:
357: /* start bgowrava for forward porting Bug#5636560 */
358: lv_parent_trx_type JAI_RCV_TRANSACTIONS.transaction_type%type;
359: CURSOR c_parent_trx_type is
360: SELECT transaction_type
361: from JAI_RCV_TRANSACTIONS
362: where transaction_id = pr_new.parent_transaction_id;

Line 361: from JAI_RCV_TRANSACTIONS

357: /* start bgowrava for forward porting Bug#5636560 */
358: lv_parent_trx_type JAI_RCV_TRANSACTIONS.transaction_type%type;
359: CURSOR c_parent_trx_type is
360: SELECT transaction_type
361: from JAI_RCV_TRANSACTIONS
362: where transaction_id = pr_new.parent_transaction_id;
363: /* End bgowrava for Bug#5636560 */
364: /*Bug 14010660 - Start*/
365: CURSOR c_excise_inv_number(p_shipment_header_id NUMBER)

Line 410: FROM jai_rcv_transactions

406: /* Added for bug #14852106*//*Start*/
407: CURSOR get_claim_details(p_shipment_line_id NUMBER)
408: IS
409: SELECT CENVAT_AMOUNT, CENVAT_CLAIMED_PTG
410: FROM jai_rcv_transactions
411: WHERE shipment_line_id = p_shipment_line_id
412: AND transaction_type = 'RECEIVE';
413:
414: ln_cenvat_amt NUMBER := 0;

Line 423: CURSOR c_deliver_unit_price(cp_transaction_type rcv_transactions.transaction_type%type) IS

419: FUNCTION get_deliver_unit_price(p_shipment_line_id IN NUMBER)
420: RETURN NUMBER
421: IS
422: PRAGMA AUTONOMOUS_TRANSACTION;
423: CURSOR c_deliver_unit_price(cp_transaction_type rcv_transactions.transaction_type%type) IS
424: SELECT po_unit_price
425: FROM rcv_transactions
426: WHERE shipment_line_id = p_shipment_line_id
427: AND transaction_type = cp_transaction_type ; /* 'DELIVER'; Ramananda for removal of SQL LITERALs */

Line 425: FROM rcv_transactions

421: IS
422: PRAGMA AUTONOMOUS_TRANSACTION;
423: CURSOR c_deliver_unit_price(cp_transaction_type rcv_transactions.transaction_type%type) IS
424: SELECT po_unit_price
425: FROM rcv_transactions
426: WHERE shipment_line_id = p_shipment_line_id
427: AND transaction_type = cp_transaction_type ; /* 'DELIVER'; Ramananda for removal of SQL LITERALs */
428:
429: r_deliver_unit_price c_deliver_unit_price%ROWTYPE;

Line 559: Code is modified to populate JAI_RCV_TRANSACTIONS even if the transaction is created through an

555: modified an if condition to assign a proper value to lv_called_from variable. if a wrong value is assigned, then
556: India RTP may not process the transaction
557:
558: 22 25/03/2005 Vijay Shankar for Bug#4250171. Version:115.11
559: Code is modified to populate JAI_RCV_TRANSACTIONS even if the transaction is created through an
560: OPM Receipt/Return. This modification is done, so that VAT Processing of OPM Receipt happens through Discrete code
561:
562: 23 07/04/2005 Harshita for Bug #4285064 Version : 115.12
563:

Line 568: Information from the lines DFF is captured into the rcv_transactions table.

564: When a user creates a new receipt against a purchase order, he needs to enter the following information
565: through a DFF : invoice no, invoice_date, Claim Cenvat On Receipt etc.
566: This DFF is provided at two places, header and line.
567: Information from the header DFF is captured into the rcv_shipment_headers table.
568: Information from the lines DFF is captured into the rcv_transactions table.
569: This information is retrieved into our base tables JAI_RCV_TRANSACTIONS and JAI_RCV_LINES.
570: At this time, a facility has been provided for the user to default the information
571: given at the header level DFF to all the lines only if these columns are null at the
572: line level. Else the information in the line level DFF is sustained.

Line 569: This information is retrieved into our base tables JAI_RCV_TRANSACTIONS and JAI_RCV_LINES.

565: through a DFF : invoice no, invoice_date, Claim Cenvat On Receipt etc.
566: This DFF is provided at two places, header and line.
567: Information from the header DFF is captured into the rcv_shipment_headers table.
568: Information from the lines DFF is captured into the rcv_transactions table.
569: This information is retrieved into our base tables JAI_RCV_TRANSACTIONS and JAI_RCV_LINES.
570: At this time, a facility has been provided for the user to default the information
571: given at the header level DFF to all the lines only if these columns are null at the
572: line level. Else the information in the line level DFF is sustained.
573: For this NVL conditions have been added where this information gets defaulted.

Line 627: added a cursor c_parent_trx_type to fetch transaction_type of parent_transaction_id from ja_in_rcv_transactions

623: Added an if condition to return from the trigger if parent transaction type of CORRECT is
624: NOT IN (RECEIVE, MATCH, DELIVER, RETURN TO RECEIVING , RETURN TO VENDOR).
625: The reson is, we support once these transaction types
626:
627: added a cursor c_parent_trx_type to fetch transaction_type of parent_transaction_id from ja_in_rcv_transactions
628:
629: Dependancy due to this bug: None
630:
631: 32. 20-Feb-2007 CSahoo, BUG#5344225, File Version 120.4

Line 650: a) Get the group_id of the base table rcv_transactions

646: Following approach was taken in case RTP was fired in the ONLINE MODE.
647: -------------------------------------------------------------------------
648: Added code to check if variable gv_group_id is null.
649: if yes,
650: a) Get the group_id of the base table rcv_transactions
651: b) Call the India - RTP concurrent passing the Shipment Header Id and the group id of rcv_transactions.
652: c) Set the variable gv_group_id to the group_id passed.
653: else
654: null ;

Line 651: b) Call the India - RTP concurrent passing the Shipment Header Id and the group id of rcv_transactions.

647: -------------------------------------------------------------------------
648: Added code to check if variable gv_group_id is null.
649: if yes,
650: a) Get the group_id of the base table rcv_transactions
651: b) Call the India - RTP concurrent passing the Shipment Header Id and the group id of rcv_transactions.
652: c) Set the variable gv_group_id to the group_id passed.
653: else
654: null ;
655:

Line 746: jai_rcv_transactions_pkg.insert_row(

742: /* following insert is moved from bottom to here to take care of OPM Functionality also */
743: IF pr_new.transaction_type in ( 'RECEIVE', 'DELIVER', 'RETURN TO RECEIVING',
744: 'RETURN TO VENDOR', 'CORRECT', 'MATCH')
745: THEN
746: jai_rcv_transactions_pkg.insert_row(
747: P_SHIPMENT_HEADER_ID => pr_new.shipment_header_id,
748: P_SHIPMENT_LINE_ID => pr_new.shipment_line_id,
749: P_TRANSACTION_ID => pr_new.transaction_id,
750: P_TRANSACTION_DATE => pr_new.transaction_date,