APPS.AP_INVOICE_DISTRIBUTIONS_PKG dependencies on GL_CODE_COMBINATIONS

Line 86: segment_val gl_code_combinations.SEGMENT1%TYPE;

82: FUNCTION Get_UOM(X_CCID IN NUMBER, X_Ch_Of_Accts_Id IN NUMBER)
83: RETURN VARCHAR2
84: IS
85: column_name VARCHAR2(20) := '';
86: segment_val gl_code_combinations.SEGMENT1%TYPE;
87: uom gl_stat_account_uom.unit_of_measure%TYPE;
88: status VARCHAR2(10) := '';
89: industry VARCHAR2(10) := '';
90:

Line 134: from gl_code_combinations

130: 'SEGMENT28', segment28,
131: 'SEGMENT29', segment29,
132: 'SEGMENT30', segment30)
133: into segment_val
134: from gl_code_combinations
135: where code_combination_id = X_CCID;
136:
137: select unit_of_measure
138: into uom

Line 3819: l_account_type GL_CODE_COMBINATIONS.ACCOUNT_TYPE%TYPE;

3815: l_dist_ccid
3816: AP_INVOICE_DISTRIBUTIONS.DIST_CODE_COMBINATION_ID%TYPE;
3817: l_base_currency_code AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE;
3818: l_chart_of_accounts_id GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE;
3819: l_account_type GL_CODE_COMBINATIONS.ACCOUNT_TYPE%TYPE;
3820: l_assets_tracking_flag
3821: AP_INVOICE_DISTRIBUTIONS.ASSETS_TRACKING_FLAG%TYPE;
3822: l_employee_id AP_SUPPLIERS.EMPLOYEE_ID%TYPE;
3823: l_accounting_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;

Line 4322: FROM gl_code_combinations

4318: debug_info := 'Get account type for ccid' || l_dist_ccid;
4319: BEGIN
4320: SELECT account_type
4321: INTO l_account_type
4322: FROM gl_code_combinations
4323: WHERE code_combination_id = l_dist_ccid;
4324:
4325: EXCEPTION
4326: When no_data_found THEN

Line 4803: l_account_type GL_CODE_COMBINATIONS.ACCOUNT_TYPE%TYPE;

4799: l_po_ccid PO_DISTRIBUTIONS.CODE_COMBINATION_ID%TYPE;
4800: l_dist_ccid AP_INVOICE_DISTRIBUTIONS.DIST_CODE_COMBINATION_ID%TYPE;
4801: l_dist_code_concat VARCHAR2(2000);
4802: l_employee_id AP_SUPPLIERS.EMPLOYEE_ID%TYPE;
4803: l_account_type GL_CODE_COMBINATIONS.ACCOUNT_TYPE%TYPE;
4804: user_id NUMBER;
4805: l_msg_application VARCHAR2(25);
4806: l_msg_type VARCHAR2(25);
4807: l_msg_token1 VARCHAR2(30);

Line 5189: FROM gl_code_combinations

5185: -------------------------------------------------------------------
5186: BEGIN
5187: SELECT account_type
5188: INTO l_account_type
5189: FROM gl_code_combinations
5190: WHERE code_combination_id = l_dist_ccid;
5191:
5192: EXCEPTION
5193: WHEN no_data_found THEN

Line 5339: l_account_type GL_CODE_COMBINATIONS.ACCOUNT_TYPE%TYPE;

5335: l_org_id AP_INVOICE_LINES.ORG_ID%TYPE;
5336: l_sob_id AP_INVOICE_LINES.SET_OF_BOOKS_ID%TYPE;
5337: l_base_currency_code AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE;
5338: l_chart_of_accounts_id GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE;
5339: l_account_type GL_CODE_COMBINATIONS.ACCOUNT_TYPE%TYPE;
5340: l_invoice_date AP_INVOICES.INVOICE_DATE%TYPE;
5341: l_vendor_id AP_INVOICES.VENDOR_ID%TYPE;
5342: l_invoice_amount AP_INVOICES.INVOICE_AMOUNT%TYPE;
5343: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;