eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JA_CN_AR_RBD_EXPORT_PKG dependencies on JA_CN_DFF_ASSIGNMENTS

Line 1074: lv_attribute_column4bill_num ja_cn_dff_assignments.attribute_column%TYPE;

1070: RETURN VARCHAR2
1071: IS
1072: lv_bill_num VARCHAR(50) := NULL;
1073: lv_context_code VARCHAR(255) := NULL;
1074: lv_attribute_column4bill_num ja_cn_dff_assignments.attribute_column%TYPE;
1075: lv_cursor_sql VARCHAR(200);
1076: TYPE ref_cursor is REF CURSOR;
1077: v_bill_num_row ref_cursor;
1078: lv_procedure_name VARCHAR2(40) := 'Get_Remittance_Bill_Number';

Line 1087: FROM ja_cn_dff_assignments

1083: CURSOR dff_assignments_cur
1084: IS
1085: SELECT attribute_column
1086: ,context_code
1087: FROM ja_cn_dff_assignments
1088: WHERE chart_of_accounts_id = pn_coa_id --parameter: pn_coa_id
1089: AND dff_title_code = 'ARTR';
1090:
1091: BEGIN

Line 1660: lr_dff_assignments_row ja_cn_dff_assignments%ROWTYPE;

1656: lv_balance_side FND_LOOKUP_VALUES.MEANING%TYPE;
1657: lv_functional_currency fnd_currencies_vl.NAME%TYPE;
1658:
1659: ln_flex_value_set_id fnd_id_flex_segments.flex_value_set_id%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;

Line 1661: lv_attribute_column4bill_num ja_cn_dff_assignments.attribute_column%TYPE;

1657: lv_functional_currency fnd_currencies_vl.NAME%TYPE;
1658:
1659: ln_flex_value_set_id fnd_id_flex_segments.flex_value_set_id%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;

Line 1662: lv_attribute_column4bal_side ja_cn_dff_assignments.attribute_column%TYPE;

1658:
1659: ln_flex_value_set_id fnd_id_flex_segments.flex_value_set_id%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;

Line 2382: FROM ja_cn_dff_assignments

2378: --Cursor for getting the Attribute Column for storing the Remittance Bill Number and Balance Side
2379: CURSOR dff_assignments_cur
2380: IS
2381: SELECT *
2382: FROM ja_cn_dff_assignments
2383: WHERE chart_of_accounts_id = pn_coa_id
2384: AND (dff_title_code = 'ACBS' -- Balance Side
2385: OR dff_title_code = 'ARTR' -- Remittance Bill Number for Transaction
2386: );