[Home] [Help]
23: CALLED_FROM_JAINRTVN CONSTANT VARCHAR2(30) := 'JAINRTVN';
24: CALLED_FROM_JAITIGRTV CONSTANT VARCHAR2(30) := 'JAITIGRTV';
25: CALLED_FROM_FND_REQUEST CONSTANT VARCHAR2(30) := 'Batch';
26:
27: /* MAPPING for JAI_RCV_TRANSACTIONS Attributes incase of transaction_type = 'RETURN TO VENDOR'
28: attribute1 => EXCISE_INVOICE_GENERATION_ACTION
29: attribute2 => VAT_INVOICE_GENERATION_ACTION
30: attribute3 => EXCISE_INVOICE_GENERATION_BATCH_NO
31: attribute4 => VAT_INVOICE_GENERATION_BATCH_NO
74: /*bgowrava for forward porting Bug#5756676..end*/
75:
76: CURSOR c_trx(cp_transaction_id IN NUMBER) IS
77: SELECT *
78: FROM JAI_RCV_TRANSACTIONS
79: WHERE transaction_id = cp_transaction_id;
80:
81: CURSOR c_base_trx(cp_transaction_id IN NUMBER) IS
82: SELECT shipment_header_id, shipment_line_id, transaction_type, quantity, unit_of_measure, uom_code,
85: , routing_header_id -- porting of Bug#3949109 (3927371)
86: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. , attribute3 online_claim_flag
87: , source_document_code, po_header_id -- Vijay Shankar for Bug#3940588
88: , po_line_location_id --pramasub FP of Bug #4281841
89: FROM rcv_transactions
90: WHERE transaction_id = cp_transaction_id;
91:
92: CURSOR c_excise_invoice_no(cp_shipment_line_id IN NUMBER) IS
93: SELECT excise_invoice_no, excise_invoice_date, online_claim_flag