80: l_cost_center VARCHAR2(200);
81: l_account_id gl_sets_of_books.chart_of_accounts_id%TYPE;
82: cost_center_1 VARCHAR2(200);
83: cc_Id po_req_distributions_all.code_combination_id%TYPE;
84: l_segments fnd_flex_ext.SegmentArray;
85: nsegments NUMBER;
86: multiple_cost_center VARCHAR2(100):= '';
87: dist_num NUMBER;
88:
130: LOOP
131: FETCH ccId_csr INTO cc_Id;
132: EXIT WHEN ccid_csr%NOTFOUND;
133:
134: IF fnd_flex_ext.get_segments( 'SQLGL','GL#', l_account_id,cc_id,nsegments,l_segments) THEN
135: l_cost_center := l_segments(l_segment_num);
136: ELSE
137: l_cost_center := '';
138: END IF;
148: END IF;
149: END LOOP;
150: CLOSE ccId_csr;
151: IF l_cost_center <> multiple_cost_center THEN
152: IF fnd_flex_ext.get_segments( 'SQLGL','GL#', l_account_id,cc_id,nsegments,l_segments) THEN
153: l_cost_center := l_segments(l_segment_num);
154: ELSE
155: l_cost_center := '';
156: END IF;