DBA Data[Home] [Help]

APPS.AP_INVOICE_LINES_PKG dependencies on GL_SETS_OF_BOOKS

Line 55: X_chart_of_accounts_id IN GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE,

51: X_exchange_rate_type IN AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE,
52: X_exchange_date IN AP_INVOICES.EXCHANGE_DATE%TYPE,
53: X_invoice_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
54: X_base_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
55: X_chart_of_accounts_id IN GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE,
56: X_Error_Code OUT NOCOPY VARCHAR2,
57: X_Debug_Info OUT NOCOPY VARCHAR2,
58: X_Debug_Context OUT NOCOPY VARCHAR2,
59: X_msg_application OUT NOCOPY VARCHAR2,

Line 1218: l_chart_of_accounts_id GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE;

1214: SELECT *
1215: FROM AP_INVOICES
1216: WHERE invoice_id = x_invoice_id;
1217:
1218: l_chart_of_accounts_id GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE;
1219: l_set_of_books_id GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE;
1220: l_base_currency_code AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE;
1221:
1222: l_invoice_line_rec AP_INVOICES_PKG.r_invoice_line_rec;

Line 1219: l_set_of_books_id GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE;

1215: FROM AP_INVOICES
1216: WHERE invoice_id = x_invoice_id;
1217:
1218: l_chart_of_accounts_id GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE;
1219: l_set_of_books_id GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE;
1220: l_base_currency_code AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE;
1221:
1222: l_invoice_line_rec AP_INVOICES_PKG.r_invoice_line_rec;
1223:

Line 1465: FROM ap_system_parameters ap, gl_sets_of_books gsob

1461: SELECT gsob.chart_of_accounts_id,
1462: ap.base_currency_code
1463: INTO l_chart_of_accounts_id,
1464: l_base_currency_code
1465: FROM ap_system_parameters ap, gl_sets_of_books gsob
1466: WHERE ap.set_of_books_id = gsob.set_of_books_id
1467: AND ap.set_of_books_id = l_set_of_books_id
1468: AND ap.org_id = l_invoice_line_rec.org_id;
1469: