1486: * *
1487: * HISTORY *
1488: * 27-Apr-2005 Created Anand Thiyagarajan *
1489: * 05-Jul-2006 rseshadr bug 5374823 - date has to be formatted *
1490: * appropriate in the call to fnd_flex_ext. *
1491: **********************************************************************/
1492: FUNCTION Get_Account_Id
1493: (
1494: p_account_code IN VARCHAR2,
1602: END IF;
1603: END LOOP;
1604:
1605: /**
1606: * rseshadr bug 5374823 - format date in call to fnd_flex_ext otherwise
1607: * raises an error
1608: **/
1609: L_Account_id := fnd_flex_ext.get_ccid(
1610: application_short_name => 'SQLGL',
1605: /**
1606: * rseshadr bug 5374823 - format date in call to fnd_flex_ext otherwise
1607: * raises an error
1608: **/
1609: L_Account_id := fnd_flex_ext.get_ccid(
1610: application_short_name => 'SQLGL',
1611: key_flex_code => 'GL#',
1612: structure_number => L_Chart_of_Accounts_id,
1613: validation_date => TO_CHAR(SYSDATE, FND_FLEX_EXT.DATE_FORMAT),
1609: L_Account_id := fnd_flex_ext.get_ccid(
1610: application_short_name => 'SQLGL',
1611: key_flex_code => 'GL#',
1612: structure_number => L_Chart_of_Accounts_id,
1613: validation_date => TO_CHAR(SYSDATE, FND_FLEX_EXT.DATE_FORMAT),
1614: concatenated_segments => L_Result);
1615:
1616: IF L_Account_id IS NULL OR L_Account_id <= 0 THEN
1617: RAISE NO_DATA_FOUND;