DBA Data[Home] [Help]

APPS.OTA_EL_TRAINING_SS dependencies on FND_FLEX_EXT

Line 2179: l_delimiter := FND_FLEX_EXT.GET_DELIMITER('SQLGL', 'GL#', l_chart_of_accounts_id);

2175: OPEN sob(from_rec.gl_set_of_books_id);
2176: FETCH sob into l_chart_of_accounts_id;
2177:
2178: CLOSE sob;
2179: l_delimiter := FND_FLEX_EXT.GET_DELIMITER('SQLGL', 'GL#', l_chart_of_accounts_id);
2180:
2181: l_from_set_of_books_id := from_rec.gl_set_of_books_id;
2182:
2183: for i in 1..30

Line 2385: l_from_cc_id :=FND_FLEX_EXT.GET_CCID('SQLGL', 'GL#', l_chart_of_accounts_id, fnd_date.date_to_displaydate(sysdate),

2381: END LOOP;
2382: if p_result = 'S' then
2383: if l_paying_cost_center is not null then
2384: l_length := length (l_paying_cost_center);
2385: l_from_cc_id :=FND_FLEX_EXT.GET_CCID('SQLGL', 'GL#', l_chart_of_accounts_id, fnd_date.date_to_displaydate(sysdate),
2386: l_paying_cost_center);
2387:
2388: if l_from_cc_id =0 then
2389: p_from_result := 'C';

Line 2415: l_delimiter := FND_FLEX_EXT.GET_DELIMITER('SQLGL', 'GL#', l_chart_of_accounts_id);

2411:
2412: OPEN sob(to_rec.gl_set_of_books_id);
2413: FETCH sob into l_chart_of_accounts_id;
2414: CLOSE sob;
2415: l_delimiter := FND_FLEX_EXT.GET_DELIMITER('SQLGL', 'GL#', l_chart_of_accounts_id);
2416:
2417: l_to_set_of_books_id := to_rec.gl_set_of_books_id;
2418: for l in 1..30
2419: loop

Line 2624: l_to_cc_id :=FND_FLEX_EXT.GET_CCID('SQLGL', 'GL#', l_chart_of_accounts_id, fnd_date.date_to_displaydate(sysdate),

2620: END LOOP;
2621: if p_result = 'S' then
2622: if l_receiving_cost_center is not null then
2623: l_length := length (l_receiving_cost_center);
2624: l_to_cc_id :=FND_FLEX_EXT.GET_CCID('SQLGL', 'GL#', l_chart_of_accounts_id, fnd_date.date_to_displaydate(sysdate),
2625: l_receiving_cost_center);
2626:
2627: if l_to_cc_id = 0 then
2628: p_result := 'E';