APPS.JAI_MTL_TRXS_PKG dependencies on 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,

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

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