1138: )
1139:
1140: LOOP
1141:
1142: IF FND_FLEX_KEYVAL.validate_ccid('SQLGL', 'GL#', g_coa_id, wal_rec.CODE_COMBINATION_ID) THEN
1143: l_account_segments := substr(FND_FLEX_KEYVAL.concatenated_values,1,1000);
1144: l_account_desc := substr(FND_FLEX_KEYVAL.concatenated_descriptions,1,1000);
1145: END IF;
1146:
1139:
1140: LOOP
1141:
1142: IF FND_FLEX_KEYVAL.validate_ccid('SQLGL', 'GL#', g_coa_id, wal_rec.CODE_COMBINATION_ID) THEN
1143: l_account_segments := substr(FND_FLEX_KEYVAL.concatenated_values,1,1000);
1144: l_account_desc := substr(FND_FLEX_KEYVAL.concatenated_descriptions,1,1000);
1145: END IF;
1146:
1147: l_position_account_flag := NULL;
1140: LOOP
1141:
1142: IF FND_FLEX_KEYVAL.validate_ccid('SQLGL', 'GL#', g_coa_id, wal_rec.CODE_COMBINATION_ID) THEN
1143: l_account_segments := substr(FND_FLEX_KEYVAL.concatenated_values,1,1000);
1144: l_account_desc := substr(FND_FLEX_KEYVAL.concatenated_descriptions,1,1000);
1145: END IF;
1146:
1147: l_position_account_flag := NULL;
1148:
2082: l_wlbi_start_index := l_wlbi_end_index + 1;
2083:
2084: END LOOP; -- For each Budget Year Balance
2085:
2086: IF FND_FLEX_KEYVAL.validate_ccid('SQLGL', 'GL#', g_coa_id, l_code_combination_id) THEN
2087: l_account_segments := substr(FND_FLEX_KEYVAL.concatenated_values,1,1000);
2088: l_account_desc := substr(FND_FLEX_KEYVAL.concatenated_descriptions,1,1000);
2089: END IF;
2090:
2083:
2084: END LOOP; -- For each Budget Year Balance
2085:
2086: IF FND_FLEX_KEYVAL.validate_ccid('SQLGL', 'GL#', g_coa_id, l_code_combination_id) THEN
2087: l_account_segments := substr(FND_FLEX_KEYVAL.concatenated_values,1,1000);
2088: l_account_desc := substr(FND_FLEX_KEYVAL.concatenated_descriptions,1,1000);
2089: END IF;
2090:
2091: -- Maximum columns used = 168
2084: END LOOP; -- For each Budget Year Balance
2085:
2086: IF FND_FLEX_KEYVAL.validate_ccid('SQLGL', 'GL#', g_coa_id, l_code_combination_id) THEN
2087: l_account_segments := substr(FND_FLEX_KEYVAL.concatenated_values,1,1000);
2088: l_account_desc := substr(FND_FLEX_KEYVAL.concatenated_descriptions,1,1000);
2089: END IF;
2090:
2091: -- Maximum columns used = 168
2092: -- (12 years * 12 periods ) + 12 years * 2 misc columns = 168