DBA Data[Home] [Help]

APPS.JA_CN_AR_RBD_EXPORT_PKG dependencies on AR_GTA_TRX_HEADERS_ALL

Line 1002: lv_vat_invoice_number AR_GTA_TRX_HEADERS_ALL.Gt_Invoice_Number%TYPE;

998: lv_procedure_name VARCHAR2(40) := 'Get_VAT_Invoice_Number';
999: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1000: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1001:
1002: lv_vat_invoice_number AR_GTA_TRX_HEADERS_ALL.Gt_Invoice_Number%TYPE;
1003:
1004: --Cursor for getting VAT invoice number from Golden Tax Invoice for transaction
1005: CURSOR vat_invoice_number_cur
1006: IS

Line 1008: FROM AR_GTA_TRX_HEADERS_ALL

1004: --Cursor for getting VAT invoice number from Golden Tax Invoice for transaction
1005: CURSOR vat_invoice_number_cur
1006: IS
1007: SELECT GT_INVOICE_NUMBER
1008: FROM AR_GTA_TRX_HEADERS_ALL
1009: WHERE RA_TRX_ID = pn_customer_trx_id
1010: AND RA_GL_PERIOD = pv_period_name
1011: AND SOURCE = 'GT';
1012:

Line 1664: lv_vat_invoice_number AR_GTA_TRX_HEADERS_ALL.Gt_Invoice_Number%TYPE;

1660: lr_dff_assignments_row ja_cn_dff_assignments%ROWTYPE;
1661: lv_attribute_column4bill_num ja_cn_dff_assignments.attribute_column%TYPE;
1662: lv_attribute_column4bal_side ja_cn_dff_assignments.attribute_column%TYPE;
1663: lv_transaction_exported_flag VARCHAR2(1);
1664: lv_vat_invoice_number AR_GTA_TRX_HEADERS_ALL.Gt_Invoice_Number%TYPE;
1665: lv_contract_number_column RA_BATCH_SOURCES_ALL.Default_Reference%TYPE;
1666: ln_journal_number NUMBER;
1667: ln_applied_journal_number NUMBER;
1668: ln_functional_amount NUMBER;