APPS.OTA_TRAINING_SS dependencies on FND_FLEX_EXT

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

2585: OPEN sob(from_rec.gl_set_of_books_id);
2586: FETCH sob into l_chart_of_accounts_id;
2587:
2588: CLOSE sob;
2589: l_delimiter := FND_FLEX_EXT.GET_DELIMITER('SQLGL', 'GL#', l_chart_of_accounts_id);
2590:
2591: l_from_set_of_books_id := from_rec.gl_set_of_books_id;
2592:
2593: for i in 1..30

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

2791: END LOOP;
2792: if p_result = 'S' then
2793: if l_paying_cost_center is not null then
2794: l_length := length (l_paying_cost_center);
2795: l_from_cc_id :=FND_FLEX_EXT.GET_CCID('SQLGL', 'GL#', l_chart_of_accounts_id, fnd_date.date_to_displaydate(sysdate),
2796: l_paying_cost_center);
2797:
2798: if l_from_cc_id =0 then
2799: p_from_result := 'C';

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

2821:
2822: OPEN sob(to_rec.gl_set_of_books_id);
2823: FETCH sob into l_chart_of_accounts_id;
2824: CLOSE sob;
2825: l_delimiter := FND_FLEX_EXT.GET_DELIMITER('SQLGL', 'GL#', l_chart_of_accounts_id);
2826:
2827: l_to_set_of_books_id := to_rec.gl_set_of_books_id;
2828: for l in 1..30
2829: loop

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

3030: END LOOP;
3031: if p_result = 'S' then
3032: if l_receiving_cost_center is not null then
3033: l_length := length (l_receiving_cost_center);
3034: l_to_cc_id :=FND_FLEX_EXT.GET_CCID('SQLGL', 'GL#', l_chart_of_accounts_id, fnd_date.date_to_displaydate(sysdate),
3035: l_receiving_cost_center);
3036:
3037: if l_to_cc_id = 0 then
3038: p_result := 'E';