APPS.JAI_MTL_TRXS_PKG dependencies on RCV_TRANSACTIONS

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

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

Line 35: receipt_qty JAI_RCV_TRANSACTIONS.quantity%type,

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

Line 46: excise_invoice_no JAI_RCV_TRANSACTIONS.excise_invoice_no%type,

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

Line 47: excise_invoice_date JAI_RCV_TRANSACTIONS.excise_invoice_date%type);

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

Line 138: p_transaction_id IN rcv_transactions.transaction_id%TYPE DEFAULT NULL,

134: PROCEDURE claim_balance_cgvat(
135: p_term_id IN jai_rgm_terms.term_id%TYPE DEFAULT NULL,
136: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE DEFAULT NULL,
137: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,
138: p_transaction_id IN rcv_transactions.transaction_id%TYPE DEFAULT NULL,
139: p_tax_type IN jai_cmn_taxes_all.tax_type%TYPE DEFAULT NULL,
140: p_tax_id IN jai_cmn_taxes_all.tax_id%TYPE DEFAULT NULL,
141: p_receipt_num IN VARCHAR2,
142: P_applied_qty IN NUMBER,