[Home] [Help]
1074:
1075: ) RETURN NUMBER IS
1076: l_ccid NUMBER := 0;
1077: l_flex_code NUMBER := 0;
1078: l_seg_val FND_FLEX_EXT.SegmentArray;
1079: l_return_status VARCHAR2(1);
1080: l_cy_budget_year_type_id NUMBER ;
1081: l_py_budget_year_type_id NUMBER ;
1082: l_cy_id NUMBER ;
1213: -- +++++++++++++++++
1214: -- Explode p_ccid into individual segments to l_seg_val array
1215: -- +++++++++++++++++
1216:
1217: if not FND_FLEX_EXT.Get_Segments
1218: (application_short_name => 'SQLGL',
1219: key_flex_code => 'GL#',
1220: structure_number => g_flex_code,
1221: combination_id => p_ccid,
1338: -- If the composed Code Combination does not already exist in GL, it is
1339: -- dynamically created
1340: --+++++++++++++++++++
1341:
1342: if not FND_FLEX_EXT.Get_Combination_ID
1343: (application_short_name => 'SQLGL',
1344: key_flex_code => 'GL#',
1345: structure_number => g_flex_code,
1346: validation_date => sysdate,
1411: ) RETURN VARCHAR2 IS
1412:
1413: l_concat_segments VARCHAR2(2000) := null;
1414: l_flex_code NUMBER := 0;
1415: l_seg_val FND_FLEX_EXT.SegmentArray;
1416: l_return_status VARCHAR2(1);
1417: l_cy_budget_year_type_id NUMBER ;
1418: l_cy_id NUMBER ;
1419: l_index NUMBER;
1534: -- +++++++++++++++++
1535: -- Explode p_ccid into individual segments to l_seg_val array
1536: -- +++++++++++++++++
1537:
1538: if not FND_FLEX_EXT.Get_Segments
1539: (application_short_name => 'SQLGL',
1540: key_flex_code => 'GL#',
1541: structure_number => g_flex_code,
1542: combination_id => p_ccid,
1625:
1626: --+++++++++++++++++++
1627: -- Concatenate the segments of the account combination
1628: --+++++++++++++++++++
1629: l_concat_segments := FND_FLEX_EXT.Concatenate_Segments
1630: (n_segments => g_num_segs,
1631: segments => l_seg_val,
1632: delimiter => l_segment_delimiter);
1633: