DBA Data[Home] [Help]

APPS.OTA_CRT_FINANCE_SEGMENT dependencies on FND_FLEX_EXT

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

195: OPEN sob(from_rec.gl_set_of_books_id);
196: FETCH sob into l_chart_of_accounts_id;
197:
198: CLOSE sob;
199: l_delimiter := FND_FLEX_EXT.GET_DELIMITER('SQLGL', 'GL#', l_chart_of_accounts_id);
200:
201: l_from_set_of_books_id := from_rec.gl_set_of_books_id;
202:
203: for i in 1..30

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

402: END LOOP;
403: if p_result = 'S' then
404: if l_paying_cost_center is not null then
405: l_length := length (l_paying_cost_center);
406: l_from_cc_id :=FND_FLEX_EXT.GET_CCID('SQLGL', 'GL#', l_chart_of_accounts_id, fnd_date.date_to_canonical(sysdate),
407: l_paying_cost_center);
408:
409: if l_from_cc_id =0 then
410: p_from_result := 'C';

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

432:
433: OPEN sob(to_rec.gl_set_of_books_id);
434: FETCH sob into l_chart_of_accounts_id;
435: CLOSE sob;
436: l_delimiter := FND_FLEX_EXT.GET_DELIMITER('SQLGL', 'GL#', l_chart_of_accounts_id);
437:
438: l_to_set_of_books_id := to_rec.gl_set_of_books_id;
439: for l in 1..30
440: loop

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

642: END LOOP;
643: if p_result = 'S' then
644: if l_receiving_cost_center is not null then
645: l_length := length (l_receiving_cost_center);
646: l_to_cc_id :=FND_FLEX_EXT.GET_CCID('SQLGL', 'GL#', l_chart_of_accounts_id, fnd_date.date_to_canonical(sysdate),
647: l_receiving_cost_center);
648:
649: if l_to_cc_id = 0 then
650: p_result := 'E';