DBA Data[Home] [Help]

APPS.AP_INVOICE_LINES_PKG dependencies on GL_SETS_OF_BOOKS

Line 41: X_chart_of_accounts_id IN GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE,

37: X_exchange_rate_type IN AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE,
38: X_exchange_date IN AP_INVOICES.EXCHANGE_DATE%TYPE,
39: X_invoice_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
40: X_base_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
41: X_chart_of_accounts_id IN GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE,
42: X_Error_Code OUT NOCOPY VARCHAR2,
43: X_Debug_Info OUT NOCOPY VARCHAR2,
44: X_Debug_Context OUT NOCOPY VARCHAR2,
45: X_msg_application OUT NOCOPY VARCHAR2,

Line 1164: l_chart_of_accounts_id GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE;

1160: SELECT *
1161: FROM AP_INVOICES
1162: WHERE invoice_id = x_invoice_id;
1163:
1164: l_chart_of_accounts_id GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE;
1165: l_set_of_books_id GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE;
1166: l_base_currency_code AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE;
1167:
1168: l_invoice_line_rec AP_INVOICES_PKG.r_invoice_line_rec;

Line 1165: l_set_of_books_id GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE;

1161: FROM AP_INVOICES
1162: WHERE invoice_id = x_invoice_id;
1163:
1164: l_chart_of_accounts_id GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE;
1165: l_set_of_books_id GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE;
1166: l_base_currency_code AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE;
1167:
1168: l_invoice_line_rec AP_INVOICES_PKG.r_invoice_line_rec;
1169:

Line 1411: FROM ap_system_parameters ap, gl_sets_of_books gsob

1407: SELECT gsob.chart_of_accounts_id,
1408: ap.base_currency_code
1409: INTO l_chart_of_accounts_id,
1410: l_base_currency_code
1411: FROM ap_system_parameters ap, gl_sets_of_books gsob
1412: WHERE ap.set_of_books_id = gsob.set_of_books_id
1413: AND ap.set_of_books_id = l_set_of_books_id
1414: AND ap.org_id = l_invoice_line_rec.org_id;
1415: