DBA Data[Home] [Help]

APPS.AP_APXUCPRP_XMLP_PKG dependencies on GL_SETS_OF_BOOKS

Line 254: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;

250: END; return (TRUE);
251: end;
252:
253: FUNCTION get_company_name RETURN BOOLEAN IS
254: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
255: l_name gl_sets_of_books.name%TYPE;
256: l_sob_id number;
257: BEGIN
258:

Line 255: l_name gl_sets_of_books.name%TYPE;

251: end;
252:
253: FUNCTION get_company_name RETURN BOOLEAN IS
254: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
255: l_name gl_sets_of_books.name%TYPE;
256: l_sob_id number;
257: BEGIN
258:
259: if P_SET_OF_BOOKS_ID is not null then

Line 265: FROM gl_sets_of_books

261: SELECT name,
262: chart_of_accounts_id
263: INTO l_name,
264: l_chart_of_accounts_id
265: FROM gl_sets_of_books
266: WHERE set_of_books_id = l_sob_id;
267:
268: c_company_name_header := l_name;
269: c_chart_of_accounts_id := l_chart_of_accounts_id;

Line 284: l_sob_type_code gl_sets_of_books.mrc_sob_type_code%TYPE;

280: END;
281:
282: FUNCTION GET_ORG_PLACEHOLDERS RETURN BOOLEAN IS
283: multi_org_installation fnd_product_groups.multi_org_flag%TYPE ;
284: l_sob_type_code gl_sets_of_books.mrc_sob_type_code%TYPE;
285: l_primary_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE;
286: l_org_id ap_system_parameters.org_id%TYPE;
287: BEGIN
288: SELECT multi_org_flag

Line 285: l_primary_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE;

281:
282: FUNCTION GET_ORG_PLACEHOLDERS RETURN BOOLEAN IS
283: multi_org_installation fnd_product_groups.multi_org_flag%TYPE ;
284: l_sob_type_code gl_sets_of_books.mrc_sob_type_code%TYPE;
285: l_primary_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE;
286: l_org_id ap_system_parameters.org_id%TYPE;
287: BEGIN
288: SELECT multi_org_flag
289: INTO multi_org_installation

Line 296: FROM gl_sets_of_books WHERE set_of_books_id = p_set_of_books_id;

292:
293: IF multi_org_installation = 'Y' THEN
294:
295: SELECT mrc_sob_type_code INTO l_sob_type_code
296: FROM gl_sets_of_books WHERE set_of_books_id = p_set_of_books_id;
297:
298:
299: IF l_sob_type_code = 'R' THEN
300: