DBA Data[Home] [Help]

APPS.JAI_MTL_TRXS_PKG dependencies on JAI_RCV_TRANSACTIONS

Line 32: type claimrec is record(receipt_num JAI_RCV_TRANSACTIONS.receipt_num%type,

28: p_vat_invoice_no IN VARCHAR2,
29: p_process_status OUT NOCOPY VARCHAR2,
30: p_process_message OUT NOCOPY VARCHAR2);
31:
32: type claimrec is record(receipt_num JAI_RCV_TRANSACTIONS.receipt_num%type,
33: receipt_qty JAI_RCV_TRANSACTIONS.quantity%type,
34: claimed_ptg JAI_RCV_CENVAT_CLAIMS.cenvat_claimed_ptg%type,
35: qty_to_claim JAI_RCV_CENVAT_CLAIMS.quantity_for_2nd_claim%type,
36: cenvat_amt_to_apply JAI_RCV_CENVAT_CLAIMS.cenvat_amt_for_2nd_claim%type,

Line 33: receipt_qty JAI_RCV_TRANSACTIONS.quantity%type,

29: p_process_status OUT NOCOPY VARCHAR2,
30: p_process_message OUT NOCOPY VARCHAR2);
31:
32: type claimrec is record(receipt_num JAI_RCV_TRANSACTIONS.receipt_num%type,
33: receipt_qty JAI_RCV_TRANSACTIONS.quantity%type,
34: claimed_ptg JAI_RCV_CENVAT_CLAIMS.cenvat_claimed_ptg%type,
35: qty_to_claim JAI_RCV_CENVAT_CLAIMS.quantity_for_2nd_claim%type,
36: cenvat_amt_to_apply JAI_RCV_CENVAT_CLAIMS.cenvat_amt_for_2nd_claim%type,
37: shipment_line_id JAI_RCV_CENVAT_CLAIMS.shipment_line_id%type,

Line 44: excise_invoice_no JAI_RCV_TRANSACTIONS.excise_invoice_no%type,

40: other_cenvat_amt_to_apply JAI_RCV_CENVAT_CLAIMS.other_cenvat_amt_for_2nd_claim%type ,
41: cenvat_amount JAI_RCV_CENVAT_CLAIMS.cenvat_amount%type,
42: other_cenvat_Amt JAI_RCV_CENVAT_CLAIMS.other_cenvat_Amt%type,
43: transaction_id JAI_RCV_CENVAT_CLAIMS.transaction_id%type,
44: excise_invoice_no JAI_RCV_TRANSACTIONS.excise_invoice_no%type,
45: excise_invoice_date JAI_RCV_TRANSACTIONS.excise_invoice_date%type);
46:
47: type claimcur is ref cursor return claimrec;
48:

Line 45: excise_invoice_date JAI_RCV_TRANSACTIONS.excise_invoice_date%type);

41: cenvat_amount JAI_RCV_CENVAT_CLAIMS.cenvat_amount%type,
42: other_cenvat_Amt JAI_RCV_CENVAT_CLAIMS.other_cenvat_Amt%type,
43: transaction_id JAI_RCV_CENVAT_CLAIMS.transaction_id%type,
44: excise_invoice_no JAI_RCV_TRANSACTIONS.excise_invoice_no%type,
45: excise_invoice_date JAI_RCV_TRANSACTIONS.excise_invoice_date%type);
46:
47: type claimcur is ref cursor return claimrec;
48:
49: PROCEDURE cenvat_recpt_det(block_data in OUT NOCOPY claimcur,