APPS.AP_UTILITIES_PKG dependencies on GL_SETS_OF_BOOKS

Line 810: from gl_sets_of_books g

806: select substrb((g.SHORT_NAME || decode(g.mrc_sob_type_code, 'N', NULL,
807: decode(l_multi_cur, 'N', NULL,
808: ': ' || substr(g.currency_code, 1, 5)))),1,60)
809: into l_wnd_context
810: from gl_sets_of_books g
811: , ap_system_parameters aps
812: where aps.SET_OF_BOOKS_ID = g.SET_OF_BOOKS_ID;
813: EXCEPTION
814: WHEN NO_DATA_FOUND THEN

Line 853: from gl_sets_of_books g,

849: || decode(g.mrc_sob_type_code, 'N', NULL,
850: decode(l_multi_cur, 'N', NULL,
851: ': ' || substr(g.currency_code, 1, 5)))),1,60)
852: into l_wnd_context
853: from gl_sets_of_books g,
854: ap_system_parameters aps,
855: hr_operating_units h
856: where h.organization_id = to_number(l_id)
857: --Bug 13975870

Line 925: FROM gl_sets_of_books

921:
922:
923: SELECT chart_of_accounts_id
924: INTO l_chart_of_accounts_id
925: FROM gl_sets_of_books
926: WHERE set_of_books_id = p_set_of_books_id;
927:
928: debug_info := 'Get segment delimiter';
929:

Line 1313: FROM gl_sets_of_books

1309:
1310:
1311: SELECT chart_of_accounts_id
1312: INTO l_chart_of_accounts_id
1313: FROM gl_sets_of_books
1314: WHERE set_of_books_id = p_set_of_books_id;
1315:
1316: debug_info := 'Get segment delimiter';
1317:

Line 1672: FROM gl_sets_of_books

1668: debug_info := 'Select Charts of Account';
1669:
1670: SELECT chart_of_accounts_id
1671: INTO l_chart_of_accounts_id
1672: FROM gl_sets_of_books
1673: WHERE set_of_books_id = p_set_of_books_id;
1674:
1675: debug_info := 'Get Segment Delimiter';
1676:

Line 2247: l_chart_of_accts_id GL_SETS_OF_BOOKS.chart_of_accounts_id%TYPE;

2243: l_curr_calling_sequence VARCHAR2(2000);
2244: G_flex_qualifier_name VARCHAR2(100);
2245: l_primary_sob_id AP_SYSTEM_PARAMETERS.set_of_books_id%TYPE;
2246: l_liability_post_lookup_code AP_SYSTEM_PARAMETERS.liability_post_lookup_code%TYPE;
2247: l_chart_of_accts_id GL_SETS_OF_BOOKS.chart_of_accounts_id%TYPE;
2248: G_flex_segment_num NUMBER;
2249:
2250:
2251: BEGIN

Line 2262: FROM gl_sets_of_books

2258: where org_id = nvl(AP_UTILITIES_PKG.g_org_id,org_id); /*Bug11720134*/
2259:
2260: SELECT chart_of_accounts_id
2261: INTO l_chart_of_accts_id
2262: FROM gl_sets_of_books
2263: WHERE set_of_books_id = l_primary_sob_id;
2264:
2265: -- Get flexfield qualifier segment number
2266: IF (l_Liability_Post_Lookup_Code = 'ACCOUNT_SEGMENT_VALUE') THEN

Line 2406: l_chart_of_accts_id GL_SETS_OF_BOOKS.chart_of_accounts_id%TYPE;

2402: l_curr_calling_sequence VARCHAR2(2000);
2403: G_flex_qualifier_name VARCHAR2(100);
2404: l_primary_sob_id AP_SYSTEM_PARAMETERS.set_of_books_id%TYPE;
2405: l_liability_post_lookup_code AP_SYSTEM_PARAMETERS.liability_post_lookup_code%TYPE;
2406: l_chart_of_accts_id GL_SETS_OF_BOOKS.chart_of_accounts_id%TYPE;
2407: G_flex_segment_num NUMBER;
2408: l_return_segments varchar2(200) := null;
2409:
2410:

Line 2427: FROM gl_sets_of_books

2423: -- Get Chart of Accounts Information
2424:
2425: SELECT chart_of_accounts_id
2426: INTO l_chart_of_accts_id
2427: FROM gl_sets_of_books
2428: WHERE set_of_books_id = l_primary_sob_id;
2429:
2430: -----------------------------------------------------------------------------------------
2431: -- Get flexfield qualifier segment number

Line 2519: P_chart_of_accts_id IN GL_SETS_OF_BOOKS.chart_of_accounts_id%TYPE

2515: FUNCTION get_auto_offsets_segments
2516: (P_base_ccid IN NUMBER,
2517: P_flex_qualifier_name IN VARCHAR2,
2518: P_flex_segment_num IN NUMBER,
2519: P_chart_of_accts_id IN GL_SETS_OF_BOOKS.chart_of_accounts_id%TYPE
2520: ) return varchar2 is
2521:
2522:
2523: l_base_segments FND_FLEX_EXT.SEGMENTARRAY ;

Line 3785: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%type,

3781:
3782: -- bug 7531219
3783: -- Function to validate balancing segment to the ledger
3784: FUNCTION is_balancing_segment_valid (
3785: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%type,
3786: p_balancing_segment_value IN gl_ledger_segment_values.segment_value%type,
3787: p_date IN DATE,
3788: p_calling_sequence IN VARCHAR2)
3789: RETURN BOOLEAN IS