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 289: lv_parent_trx_type JAI_RCV_TRANSACTIONS.transaction_type%type;

285:
286: r_mtl_trx c_mtl_trx%ROWTYPE;
287:
288: /* start bgowrava for forward porting Bug#5636560 */
289: lv_parent_trx_type JAI_RCV_TRANSACTIONS.transaction_type%type;
290: CURSOR c_parent_trx_type is
291: SELECT transaction_type
292: from JAI_RCV_TRANSACTIONS
293: where transaction_id = pr_new.parent_transaction_id;

Line 292: from JAI_RCV_TRANSACTIONS

288: /* start bgowrava for forward porting Bug#5636560 */
289: lv_parent_trx_type JAI_RCV_TRANSACTIONS.transaction_type%type;
290: CURSOR c_parent_trx_type is
291: SELECT transaction_type
292: from JAI_RCV_TRANSACTIONS
293: where transaction_id = pr_new.parent_transaction_id;
294: /* End bgowrava for Bug#5636560 */
295:
296: --Function Added by Sanjikum for Bug #4105721

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

297: FUNCTION get_deliver_unit_price(p_shipment_line_id IN NUMBER)
298: RETURN NUMBER
299: IS
300: PRAGMA AUTONOMOUS_TRANSACTION;
301: CURSOR c_deliver_unit_price(cp_transaction_type rcv_transactions.transaction_type%type) IS
302: SELECT po_unit_price
303: FROM rcv_transactions
304: WHERE shipment_line_id = p_shipment_line_id
305: AND transaction_type = cp_transaction_type ; /* 'DELIVER'; Ramananda for removal of SQL LITERALs */

Line 303: FROM rcv_transactions

299: IS
300: PRAGMA AUTONOMOUS_TRANSACTION;
301: CURSOR c_deliver_unit_price(cp_transaction_type rcv_transactions.transaction_type%type) IS
302: SELECT po_unit_price
303: FROM rcv_transactions
304: WHERE shipment_line_id = p_shipment_line_id
305: AND transaction_type = cp_transaction_type ; /* 'DELIVER'; Ramananda for removal of SQL LITERALs */
306:
307: r_deliver_unit_price c_deliver_unit_price%ROWTYPE;

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

433: modified an if condition to assign a proper value to lv_called_from variable. if a wrong value is assigned, then
434: India RTP may not process the transaction
435:
436: 22 25/03/2005 Vijay Shankar for Bug#4250171. Version:115.11
437: Code is modified to populate JAI_RCV_TRANSACTIONS even if the transaction is created through an
438: OPM Receipt/Return. This modification is done, so that VAT Processing of OPM Receipt happens through Discrete code
439:
440: 23 07/04/2005 Harshita for Bug #4285064 Version : 115.12
441:

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

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

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

443: through a DFF : invoice no, invoice_date, Claim Cenvat On Receipt etc.
444: This DFF is provided at two places, header and line.
445: Information from the header DFF is captured into the rcv_shipment_headers table.
446: Information from the lines DFF is captured into the rcv_transactions table.
447: This information is retrieved into our base tables JAI_RCV_TRANSACTIONS and JAI_RCV_LINES.
448: At this time, a facility has been provided for the user to default the information
449: given at the header level DFF to all the lines only if these columns are null at the
450: line level. Else the information in the line level DFF is sustained.
451: For this NVL conditions have been added where this information gets defaulted.

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

501: Added an if condition to return from the trigger if parent transaction type of CORRECT is
502: NOT IN (RECEIVE, MATCH, DELIVER, RETURN TO RECEIVING , RETURN TO VENDOR).
503: The reson is, we support once these transaction types
504:
505: added a cursor c_parent_trx_type to fetch transaction_type of parent_transaction_id from ja_in_rcv_transactions
506:
507: Dependancy due to this bug: None
508:
509: 32. 20-Feb-2007 CSahoo, BUG#5344225, File Version 120.4

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

524: Following approach was taken in case RTP was fired in the ONLINE MODE.
525: -------------------------------------------------------------------------
526: Added code to check if variable gv_group_id is null.
527: if yes,
528: a) Get the group_id of the base table rcv_transactions
529: b) Call the India - RTP concurrent passing the Shipment Header Id and the group id of rcv_transactions.
530: c) Set the variable gv_group_id to the group_id passed.
531: else
532: null ;

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

525: -------------------------------------------------------------------------
526: Added code to check if variable gv_group_id is null.
527: if yes,
528: a) Get the group_id of the base table rcv_transactions
529: b) Call the India - RTP concurrent passing the Shipment Header Id and the group id of rcv_transactions.
530: c) Set the variable gv_group_id to the group_id passed.
531: else
532: null ;
533:

Line 609: jai_rcv_transactions_pkg.insert_row(

605: /* following insert is moved from bottom to here to take care of OPM Functionality also */
606: IF pr_new.transaction_type in ( 'RECEIVE', 'DELIVER', 'RETURN TO RECEIVING',
607: 'RETURN TO VENDOR', 'CORRECT', 'MATCH')
608: THEN
609: jai_rcv_transactions_pkg.insert_row(
610: P_SHIPMENT_HEADER_ID => pr_new.shipment_header_id,
611: P_SHIPMENT_LINE_ID => pr_new.shipment_line_id,
612: P_TRANSACTION_ID => pr_new.transaction_id,
613: P_TRANSACTION_DATE => pr_new.transaction_date,