DBA Data[Home] [Help]

APPS.OTA_ENROLL_REVIEW_SS dependencies on FND_FLEX_EXT

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

2106: OPEN sob(from_rec.gl_set_of_books_id);
2107: FETCH sob into l_chart_of_accounts_id;
2108:
2109: CLOSE sob;
2110: l_delimiter := FND_FLEX_EXT.GET_DELIMITER('SQLGL', 'GL#', l_chart_of_accounts_id);
2111:
2112: l_from_set_of_books_id := from_rec.gl_set_of_books_id;
2113:
2114: for i in 1..30

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

2312: END LOOP;
2313: if p_result = 'S' then
2314: if l_paying_cost_center is not null then
2315: l_length := length (l_paying_cost_center);
2316: l_from_cc_id :=FND_FLEX_EXT.GET_CCID('SQLGL', 'GL#', l_chart_of_accounts_id, fnd_date.date_to_displaydate(sysdate),
2317: l_paying_cost_center);
2318:
2319: if l_from_cc_id =0 then
2320: p_from_result := 'C';

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

2342:
2343: OPEN sob(to_rec.gl_set_of_books_id);
2344: FETCH sob into l_chart_of_accounts_id;
2345: CLOSE sob;
2346: l_delimiter := FND_FLEX_EXT.GET_DELIMITER('SQLGL', 'GL#', l_chart_of_accounts_id);
2347:
2348: l_to_set_of_books_id := to_rec.gl_set_of_books_id;
2349: for l in 1..30
2350: loop

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

2542: END LOOP;
2543: if p_result = 'S' then
2544: if l_receiving_cost_center is not null then
2545: l_length := length (l_receiving_cost_center);
2546: l_to_cc_id :=FND_FLEX_EXT.GET_CCID('SQLGL', 'GL#', l_chart_of_accounts_id, fnd_date.date_to_displaydate(sysdate),
2547: l_receiving_cost_center);
2548:
2549: if l_to_cc_id = 0 then
2550: p_result := 'E';