DBA Data[Home] [Help]

APPS.OTA_LEARNER_ENROLL_REVIEW_SS dependencies on FND_FLEX_EXT

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

2196: OPEN sob(from_rec.gl_set_of_books_id);
2197: FETCH sob into l_chart_of_accounts_id;
2198:
2199: CLOSE sob;
2200: l_delimiter := FND_FLEX_EXT.GET_DELIMITER('SQLGL', 'GL#', l_chart_of_accounts_id);
2201:
2202: l_from_set_of_books_id := from_rec.gl_set_of_books_id;
2203:
2204: for i in 1..30

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

2402: END LOOP;
2403: if p_result = 'S' then
2404: if l_paying_cost_center is not null then
2405: l_length := length (l_paying_cost_center);
2406: l_from_cc_id :=FND_FLEX_EXT.GET_CCID('SQLGL', 'GL#', l_chart_of_accounts_id, fnd_date.date_to_displaydate(sysdate),
2407: l_paying_cost_center);
2408:
2409: if l_from_cc_id =0 then
2410: p_from_result := 'C';

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

2432:
2433: OPEN sob(to_rec.gl_set_of_books_id);
2434: FETCH sob into l_chart_of_accounts_id;
2435: CLOSE sob;
2436: l_delimiter := FND_FLEX_EXT.GET_DELIMITER('SQLGL', 'GL#', l_chart_of_accounts_id);
2437:
2438: l_to_set_of_books_id := to_rec.gl_set_of_books_id;
2439: for l in 1..30
2440: loop

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

2632: END LOOP;
2633: if p_result = 'S' then
2634: if l_receiving_cost_center is not null then
2635: l_length := length (l_receiving_cost_center);
2636: l_to_cc_id :=FND_FLEX_EXT.GET_CCID('SQLGL', 'GL#', l_chart_of_accounts_id, fnd_date.date_to_displaydate(sysdate),
2637: l_receiving_cost_center);
2638:
2639: if l_to_cc_id = 0 then
2640: p_result := 'E';