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 3990: l_account_type GL_CODE_COMBINATIONS.ACCOUNT_TYPE%TYPE;

3986: l_dist_ccid
3987: AP_INVOICE_DISTRIBUTIONS.DIST_CODE_COMBINATION_ID%TYPE;
3988: l_base_currency_code AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE;
3989: l_chart_of_accounts_id GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE;
3990: l_account_type GL_CODE_COMBINATIONS.ACCOUNT_TYPE%TYPE;
3991: l_assets_tracking_flag
3992: AP_INVOICE_DISTRIBUTIONS.ASSETS_TRACKING_FLAG%TYPE;
3993: l_employee_id AP_SUPPLIERS.EMPLOYEE_ID%TYPE;
3994: l_accounting_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;

Line 4614: FROM gl_code_combinations

4610: debug_info := 'Get account type for ccid' || l_dist_ccid;
4611: BEGIN
4612: SELECT account_type
4613: INTO l_account_type
4614: FROM gl_code_combinations
4615: WHERE code_combination_id = l_dist_ccid;
4616:
4617: EXCEPTION
4618: When no_data_found THEN

Line 5236: l_account_type GL_CODE_COMBINATIONS.ACCOUNT_TYPE%TYPE;

5232: l_distribution_class AP_INVOICE_DISTRIBUTIONS.DISTRIBUTION_CLASS%TYPE;
5233: l_dist_ccid AP_INVOICE_DISTRIBUTIONS.DIST_CODE_COMBINATION_ID%TYPE;
5234: l_base_currency_code AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE;
5235: l_chart_of_accounts_id GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE;
5236: l_account_type GL_CODE_COMBINATIONS.ACCOUNT_TYPE%TYPE;
5237: l_assets_tracking_flag AP_INVOICE_DISTRIBUTIONS.ASSETS_TRACKING_FLAG%TYPE;
5238: l_employee_id AP_SUPPLIERS.EMPLOYEE_ID%TYPE;
5239: l_accounting_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;
5240: l_open_gl_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;

Line 5457: FROM gl_code_combinations

5453: debug_info := 'Get account type for ccid ' || l_dist_ccid;
5454: BEGIN
5455: SELECT account_type
5456: INTO l_account_type
5457: FROM gl_code_combinations
5458: WHERE code_combination_id = l_dist_ccid;
5459:
5460: EXCEPTION
5461: WHEN no_data_found THEN

Line 6086: l_account_type GL_CODE_COMBINATIONS.ACCOUNT_TYPE%TYPE;

6082: l_po_ccid PO_DISTRIBUTIONS.CODE_COMBINATION_ID%TYPE;
6083: l_dist_ccid AP_INVOICE_DISTRIBUTIONS.DIST_CODE_COMBINATION_ID%TYPE;
6084: l_dist_code_concat VARCHAR2(2000);
6085: l_employee_id AP_SUPPLIERS.EMPLOYEE_ID%TYPE;
6086: l_account_type GL_CODE_COMBINATIONS.ACCOUNT_TYPE%TYPE;
6087: user_id NUMBER;
6088: l_msg_application VARCHAR2(25);
6089: l_msg_type VARCHAR2(25);
6090: l_msg_token1 VARCHAR2(30);

Line 6547: FROM gl_code_combinations

6543: -------------------------------------------------------------------
6544: BEGIN
6545: SELECT account_type
6546: INTO l_account_type
6547: FROM gl_code_combinations
6548: WHERE code_combination_id = l_dist_ccid;
6549:
6550: EXCEPTION
6551: WHEN no_data_found THEN

Line 6701: l_account_type GL_CODE_COMBINATIONS.ACCOUNT_TYPE%TYPE;

6697: l_org_id AP_INVOICE_LINES.ORG_ID%TYPE;
6698: l_sob_id AP_INVOICE_LINES.SET_OF_BOOKS_ID%TYPE;
6699: l_base_currency_code AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE;
6700: l_chart_of_accounts_id GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE;
6701: l_account_type GL_CODE_COMBINATIONS.ACCOUNT_TYPE%TYPE;
6702: l_invoice_date AP_INVOICES.INVOICE_DATE%TYPE;
6703: l_vendor_id AP_INVOICES.VENDOR_ID%TYPE;
6704: l_invoice_amount AP_INVOICES.INVOICE_AMOUNT%TYPE;
6705: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;