APPS.AK_CUSTOM_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 60

    select ac.customization_application_id, ac.customization_code,
	   ac.region_application_id, ac.region_code
    from   AK_CUSTOMIZATIONS ac, AK_REGIONS ar
    where  ac.REGION_APPLICATION_ID = application_id
    and    ac.REGION_CODE = p_region_code
    and     ac.region_application_id = ar.region_application_id
    and     ac.region_code = ar.region_code;

Line: 68

    select ac.customization_application_id, ac.customization_code,
           ac.region_application_id, ac.region_code
    from   AK_CUSTOMIZATIONS ac, AK_REGIONS ar
    where  ac.REGION_APPLICATION_ID = application_id
    and    ac.REGION_CODE = p_region_code
    and     ac.region_application_id = ar.region_application_id
    and     ac.region_code = ar.region_code
    and     ac.responsibility_id = levelpk;

Line: 77

    select ac.customization_application_id, ac.customization_code,
           ac.region_application_id, ac.region_code
    from   AK_CUSTOMIZATIONS ac, AK_REGIONS ar
    where  ac.REGION_APPLICATION_ID = application_id
    and    ac.REGION_CODE = p_region_code
    and     ac.region_application_id = ar.region_application_id
    and     ac.region_code = ar.region_code
    and     ac.responsibility_id is not null;

Line: 86

    select ac.customization_application_id, ac.customization_code,
           ac.region_application_id, ac.region_code
    from   AK_CUSTOMIZATIONS ac, AK_REGIONS ar
    where  ac.REGION_APPLICATION_ID = application_id
    and    ac.REGION_CODE = p_region_code
    and     ac.region_application_id = ar.region_application_id
    and     ac.region_code = ar.region_code
    and     ac.org_id = levelpk;

Line: 95

    select ac.customization_application_id, ac.customization_code,
           ac.region_application_id, ac.region_code
    from   AK_CUSTOMIZATIONS ac, AK_REGIONS ar
    where  ac.REGION_APPLICATION_ID = application_id
    and    ac.REGION_CODE = p_region_code
    and     ac.region_application_id = ar.region_application_id
    and     ac.region_code = ar.region_code
    and     ac.org_id is not null;

Line: 104

    select ac.customization_application_id, ac.customization_code,
           ac.region_application_id, ac.region_code
    from   AK_CUSTOMIZATIONS ac, AK_REGIONS ar
    where  ac.REGION_APPLICATION_ID = application_id
    and    ac.REGION_CODE = p_region_code
    and     ac.region_application_id = ar.region_application_id
    and     ac.region_code = ar.region_code
    and     ac.site_id = levelpk;

Line: 113

    select ac.customization_application_id, ac.customization_code,
           ac.region_application_id, ac.region_code
    from   AK_CUSTOMIZATIONS ac, AK_REGIONS ar
    where  ac.REGION_APPLICATION_ID = application_id
    and    ac.REGION_CODE = p_region_code
    and     ac.region_application_id = ar.region_application_id
    and     ac.region_code = ar.region_code
    and     ac.site_id is not null;

Line: 122

    select ac.customization_application_id, ac.customization_code,
           ac.region_application_id, ac.region_code
    from   AK_CUSTOMIZATIONS ac, AK_REGIONS ar
    where  ac.REGION_APPLICATION_ID = application_id
    and    ac.REGION_CODE = p_region_code
    and     ac.region_application_id = ar.region_application_id
    and     ac.region_code = ar.region_code
    and     ac.function_name = levelpk;

Line: 131

    select ac.customization_application_id, ac.customization_code,
           ac.region_application_id, ac.region_code
    from   AK_CUSTOMIZATIONS ac, AK_REGIONS ar
    where  ac.REGION_APPLICATION_ID = application_id
    and    ac.REGION_CODE = p_region_code
    and     ac.region_application_id = ar.region_application_id
    and     ac.region_code = ar.region_code
    and     ac.function_name is not null;

Line: 140

    select ac.customization_application_id, ac.customization_code,
           ac.region_application_id, ac.region_code
    from   AK_CUSTOMIZATIONS ac, AK_REGIONS ar
    where  ac.REGION_APPLICATION_ID = application_id
    and    ac.REGION_CODE = p_region_code
    and     ac.region_application_id = ar.region_application_id
    and     ac.region_code = ar.region_code
    and     ac.localization_code = levelpk;

Line: 149

    select ac.customization_application_id, ac.customization_code,
           ac.region_application_id, ac.region_code
    from   AK_CUSTOMIZATIONS ac, AK_REGIONS ar
    where  ac.REGION_APPLICATION_ID = application_id
    and    ac.REGION_CODE = p_region_code
    and     ac.region_application_id = ar.region_application_id
    and     ac.region_code = ar.region_code
    and     ac.localization_code is not null;

Line: 159

    select region_application_id, region_code
    from  AK_REGIONS
    where region_application_id = region_appl_id_param
    and   region_code = region_code_param;

Line: 164

    select region_application_id, region_code
    from   AK_REGIONS
    where  region_application_id = application_id;

Line: 168

    select organization_id
    from   MTL_PARAMETERS
    where  organization_code = levelpk;

Line: 172

    select 'X'
    from   ak_customizations
    where  org_id is not null
    and    rownum = 1;

Line: 177

    select responsibility_id
    from   FND_RESPONSIBILITY
    where  responsibility_key = levelpk;

Line: 181

    select 'X'
    from   ak_customizations
    where  responsibility_id is not null
    and    rownum = 1;

Line: 186

    select function_name
    from   fnd_form_functions
    where  function_name = levelpk;

Line: 190

    select 'X'
    from   ak_customizations
    where  function_name is not null
    and    rownum = 1;

Line: 195

    select territory_code
    from   fnd_territories
    where  territory_code = levelpk;

Line: 199

    select 'X'
    from   ak_customizations
    where  localization_code is not null
    and    rownum = 1;

Line: 316

        FND_MESSAGE.SET_NAME('AK','AK_NO_SELECTION');

Line: 368

      AK_REGION_PVT.INSERT_REGION_PK_TABLE (
              p_return_status => l_return_status,
              p_region_application_id =>									l_region_rec.region_application_id,
	      p_region_code => l_region_rec.region_code,
              p_region_pk_tbl => l_region_pk_tbl);

Line: 399

  l_custom_pk_tbl.DELETE;

Line: 410

        AK_CUSTOM_PVT.INSERT_CUSTOM_PK_TABLE(
           p_return_status => l_return_status,
           p_region_application_id => l_custom_rec.region_application_id,
           p_region_code => l_custom_rec.region_code,
	   p_custom_appl_id => l_custom_rec.customization_application_id,
	   p_custom_code => l_custom_rec.customization_code,
           p_custom_pk_tbl => l_custom_pk_tbl);

Line: 423

        AK_CUSTOM_PVT.INSERT_CUSTOM_PK_TABLE(
           p_return_status => l_return_status,
           p_region_application_id => l_custom_rec.region_application_id,
           p_region_code => l_custom_rec.region_code,
           p_custom_appl_id => l_custom_rec.customization_application_id,
           p_custom_code => l_custom_rec.customization_code,
           p_custom_pk_tbl => l_custom_pk_tbl);

Line: 435

        AK_CUSTOM_PVT.INSERT_CUSTOM_PK_TABLE(
           p_return_status => l_return_status,
           p_region_application_id => l_custom_rec.region_application_id,
           p_region_code => l_custom_rec.region_code,
           p_custom_appl_id => l_custom_rec.customization_application_id,
           p_custom_code => l_custom_rec.customization_code,
           p_custom_pk_tbl => l_custom_pk_tbl);

Line: 448

        AK_CUSTOM_PVT.INSERT_CUSTOM_PK_TABLE(
           p_return_status => l_return_status,
           p_region_application_id => l_custom_rec.region_application_id,
           p_region_code => l_custom_rec.region_code,
           p_custom_appl_id => l_custom_rec.customization_application_id,
           p_custom_code => l_custom_rec.customization_code,
           p_custom_pk_tbl => l_custom_pk_tbl);

Line: 460

        AK_CUSTOM_PVT.INSERT_CUSTOM_PK_TABLE(
           p_return_status => l_return_status,
           p_region_application_id => l_custom_rec.region_application_id,
           p_region_code => l_custom_rec.region_code,
           p_custom_appl_id => l_custom_rec.customization_application_id,
           p_custom_code => l_custom_rec.customization_code,
           p_custom_pk_tbl => l_custom_pk_tbl);

Line: 473

        AK_CUSTOM_PVT.INSERT_CUSTOM_PK_TABLE(
           p_return_status => l_return_status,
           p_region_application_id => l_custom_rec.region_application_id,
           p_region_code => l_custom_rec.region_code,
           p_custom_appl_id => l_custom_rec.customization_application_id,
           p_custom_code => l_custom_rec.customization_code,
           p_custom_pk_tbl => l_custom_pk_tbl);

Line: 485

        AK_CUSTOM_PVT.INSERT_CUSTOM_PK_TABLE(
           p_return_status => l_return_status,
           p_region_application_id => l_custom_rec.region_application_id,
           p_region_code => l_custom_rec.region_code,
           p_custom_appl_id => l_custom_rec.customization_application_id,
           p_custom_code => l_custom_rec.customization_code,
           p_custom_pk_tbl => l_custom_pk_tbl);

Line: 499

        AK_CUSTOM_PVT.INSERT_CUSTOM_PK_TABLE(
           p_return_status => l_return_status,
           p_region_application_id => l_custom_rec.region_application_id,
           p_region_code => l_custom_rec.region_code,
           p_custom_appl_id => l_custom_rec.customization_application_id,
           p_custom_code => l_custom_rec.customization_code,
           p_custom_pk_tbl => l_custom_pk_tbl);

Line: 512

        AK_CUSTOM_PVT.INSERT_CUSTOM_PK_TABLE(
           p_return_status => l_return_status,
           p_region_application_id => l_custom_rec.region_application_id,
           p_region_code => l_custom_rec.region_code,
           p_custom_appl_id => l_custom_rec.customization_application_id,
           p_custom_code => l_custom_rec.customization_code,
           p_custom_pk_tbl => l_custom_pk_tbl);

Line: 526

        AK_CUSTOM_PVT.INSERT_CUSTOM_PK_TABLE(
           p_return_status => l_return_status,
           p_region_application_id => l_custom_rec.region_application_id,
           p_region_code => l_custom_rec.region_code,
           p_custom_appl_id => l_custom_rec.customization_application_id,
           p_custom_code => l_custom_rec.customization_code,
           p_custom_pk_tbl => l_custom_pk_tbl);

Line: 539

        AK_CUSTOM_PVT.INSERT_CUSTOM_PK_TABLE(
           p_return_status => l_return_status,
           p_region_application_id => l_custom_rec.region_application_id,
           p_region_code => l_custom_rec.region_code,
           p_custom_appl_id => l_custom_rec.customization_application_id,
           p_custom_code => l_custom_rec.customization_code,
           p_custom_pk_tbl => l_custom_pk_tbl);

Line: 645

procedure INSERT_CUSTOM_PK_TABLE (
  p_return_status            OUT NOCOPY     VARCHAR2,
  p_region_application_id    IN      NUMBER,
  p_region_code              IN      VARCHAR2,
  p_custom_appl_id	     IN	     NUMBER,
  p_custom_code		     IN      VARCHAR2,
  p_custom_pk_tbl            IN OUT NOCOPY  AK_CUSTOM_PUB.Custom_PK_Tbl_Type
) is
  cursor l_get_custom_list_csr (application_id number, application_code varchar2, custom_appl_id number, custom_code varchar2) is
    select ac.customization_application_id, ac.customization_code,
           ac.region_application_id, ac.region_code
    from   AK_CUSTOMIZATIONS ac, AK_REGIONS ar
    where  ac.REGION_APPLICATION_ID = application_id
    and    ac.region_code = application_code
    and	   ac.customization_application_id = custom_appl_id
    and    ac.customization_code = custom_code
    and     ac.region_application_id = ar.region_application_id
    and     ac.region_code = ar.region_code;

Line: 665

  l_api_name           CONSTANT varchar2(30) := 'Insert_Custom_PK_Table';

Line: 724

end INSERT_CUSTOM_PK_TABLE;

Line: 762

    select *
    from  AK_CUSTOMIZATIONS
    where REGION_APPLICATION_ID = p_region_application_id
    and   REGION_CODE = p_region_code
    and   CUSTOMIZATION_APPLICATION_ID = p_custom_application_id
    and   CUSTOMIZATION_CODE = p_custom_code;

Line: 769

    select *
    from  AK_CUSTOMIZATIONS_TL
    where REGION_APPLICATION_ID = p_region_application_id
    and   REGION_CODE = p_region_code
    and   CUSTOMIZATION_APPLICATION_ID = p_custom_application_id
    and   CUSTOMIZATION_CODE = p_custom_code
    and   LANGUAGE = p_nls_language;

Line: 964

                FND_LOAD_UTIL.OWNER_NAME(l_custom_rec.last_updated_by) || '"';

Line: 966

    l_databuffer_tbl(l_index) := '  LAST_UPDATE_DATE = "' ||
                to_char(l_custom_rec.last_update_date,
                        AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

Line: 970

    l_databuffer_tbl(l_index) := '  LAST_UPDATE_LOGIN = "' ||
                nvl(to_char(l_custom_rec.last_update_login),'') || '"';

Line: 1000

  l_databuffer_tbl.delete;

Line: 1136

    select *
    from  AK_CUSTOM_REGIONS
    where REGION_APPLICATION_ID = p_region_application_id
    and   REGION_CODE = p_region_code
    and   CUSTOMIZATION_APPLICATION_ID = p_custom_application_id
    and   CUSTOMIZATION_CODE = p_custom_code;

Line: 1143

    select *
    from  AK_CUSTOM_REGIONS_TL
    where REGION_APPLICATION_ID = p_region_application_id
    and   REGION_CODE = p_region_code
    and   CUSTOMIZATION_APPLICATION_ID = p_custom_application_id
    and   CUSTOMIZATION_CODE = p_custom_code
    and   PROPERTY_NAME = property_name_param
    and   LANGUAGE = p_nls_language;

Line: 1244

                FND_LOAD_UTIL.OWNER_NAME(l_cust_region_rec.last_updated_by) || '"';

Line: 1246

    l_databuffer_tbl(l_index) := '  LAST_UPDATE_DATE = "' ||
                to_char(l_cust_region_rec.last_update_date,
                        AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

Line: 1250

    l_databuffer_tbl(l_index) := '  LAST_UPDATE_LOGIN = "' ||
                nvl(to_char(l_cust_region_rec.last_update_login),'') || '"';

Line: 1281

  l_databuffer_tbl.delete;

Line: 1348

    select *
    from  AK_CUSTOM_REGION_ITEMS
    where REGION_APPLICATION_ID = p_region_application_id
    and   REGION_CODE = p_region_code
    and   CUSTOMIZATION_APPLICATION_ID = p_custom_application_id
    and   CUSTOMIZATION_CODE = p_custom_code;

Line: 1357

    select *
    from  AK_CUSTOM_REGION_ITEMS_TL
    where REGION_APPLICATION_ID = p_region_application_id
    and   REGION_CODE = p_region_code
    and   CUSTOMIZATION_APPLICATION_ID = p_custom_application_id
    and   CUSTOMIZATION_CODE = p_custom_code
    and   ATTRIBUTE_APPLICATION_ID = param_attr_appl_id
    and   ATTRIBUTE_CODE = param_attr_code
    and   PROPERTY_NAME = param_property_name
    and   LANGUAGE = p_nls_language;

Line: 1466

                FND_LOAD_UTIL.OWNER_NAME(l_cust_region_item_rec.last_updated_by) || '"';

Line: 1468

    l_databuffer_tbl(l_index) := '  LAST_UPDATE_DATE = "' ||
                to_char(l_cust_region_item_rec.last_update_date,
                        AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

Line: 1472

    l_databuffer_tbl(l_index) := '  LAST_UPDATE_LOGIN = "' ||
                nvl(to_char(l_cust_region_item_rec.last_update_login),'') || '"';

Line: 1504

  l_databuffer_tbl.delete;

Line: 1571

    select *
    from  AK_CRITERIA
    where REGION_APPLICATION_ID = p_region_application_id
    and   REGION_CODE = p_region_code
    and   CUSTOMIZATION_APPLICATION_ID = p_custom_application_id
    and   CUSTOMIZATION_CODE = p_custom_code;

Line: 1676

                FND_LOAD_UTIL.OWNER_NAME(l_criteria_rec.last_updated_by) || '"';

Line: 1678

    l_databuffer_tbl(l_index) := '  LAST_UPDATE_DATE = "' ||
                to_char(l_criteria_rec.last_update_date,
                        AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

Line: 1682

    l_databuffer_tbl(l_index) := '  LAST_UPDATE_LOGIN = "' ||
                nvl(to_char(l_criteria_rec.last_update_login),'') || '"';

Line: 1856

       p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
    l_error := TRUE;

Line: 1867

       p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
    l_error := TRUE;

Line: 1878

       p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
    l_error := TRUE;

Line: 1969

    select  1
    from    AK_CUSTOMIZATIONS
    where   region_application_id = p_region_application_id
    and     region_code = p_region_code
    and     customization_application_id = p_custom_application_id
    and     customization_code = p_custom_code;

Line: 2133

    select  1
    from    AK_CUSTOMIZATIONS
    where   region_application_id = p_region_application_id
    and     region_code = p_region_code
    and     customization_application_id = p_custom_application_id
    and     customization_code = p_custom_code;

Line: 2318

    select  1
    from    AK_CUSTOMIZATIONS
    where   region_application_id = p_region_application_id
    and     region_code = p_region_code
    and     customization_application_id = p_custom_application_id
    and     customization_code = p_custom_code;

Line: 2414

       p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
    l_error := TRUE;

Line: 2443

       p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
    l_error := TRUE;

Line: 2522

  p_last_updated_by          IN      NUMBER := FND_API.G_MISS_NUM,
  p_last_update_date         IN      DATE := FND_API.G_MISS_DATE,
  p_last_update_login        IN      NUMBER := FND_API.G_MISS_NUM,
  p_loader_timestamp         IN      DATE := FND_API.G_MISS_DATE,
  p_pass                     IN      NUMBER,
  p_copy_redo_flag           IN OUT NOCOPY  BOOLEAN
) is
  l_api_version_number      CONSTANT number := 1.0;

Line: 2533

  l_last_update_date            DATE;

Line: 2534

  l_last_update_login           NUMBER;

Line: 2535

  l_last_updated_by             NUMBER;

Line: 2673

  if (p_last_updated_by <> FND_API.G_MISS_NUM) then
    l_last_updated_by := p_last_updated_by;

Line: 2676

  if (p_last_update_date <> FND_API.G_MISS_DATE) then
    l_last_update_date := p_last_update_date;

Line: 2679

  if (p_last_update_login <> FND_API.G_MISS_NUM) then
    l_last_update_login := p_last_update_login;

Line: 2689

  if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
       p_loader_timestamp => p_loader_timestamp,
       p_created_by => l_created_by,
       p_creation_date => l_creation_date,
       p_last_updated_by => l_last_updated_by,
       p_db_last_updated_by => null,
       p_last_update_date => l_last_update_date,
       p_db_last_update_date => null,
       p_last_update_login => l_last_update_login,
       p_create_or_update => 'CREATE') then
     null;

Line: 2702

  select userenv('LANG') into l_lang
  from dual;

Line: 2705

  insert into AK_CUSTOMIZATIONS (
    CUSTOMIZATION_APPLICATION_ID,
    CUSTOMIZATION_CODE,
    REGION_APPLICATION_ID,
    REGION_CODE,
    VERTICALIZATION_ID,
    LOCALIZATION_CODE,
    ORG_ID,
    SITE_ID,
    RESPONSIBILITY_ID,
    WEB_USER_ID,
    DEFAULT_CUSTOMIZATION_FLAG,
    CUSTOMIZATION_LEVEL_ID,
    DEVELOPER_MODE,
    REFERENCE_PATH,
    FUNCTION_NAME,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    START_DATE_ACTIVE,
    END_DATE_ACTIVE
  ) values (
    p_custom_appl_id,
    p_custom_code,
    p_region_appl_id,
    p_region_code,
    l_verticalization_id,
    l_localization_code,
    l_org_id,
    l_site_id,
    l_responsibility_id,
    l_web_user_id,
    l_default_customization_flag,
    p_customization_level_id,
    p_developer_mode,
    l_reference_path,
    l_function_name,
    l_created_by,
    l_creation_date,
    l_last_update_date,
    l_last_updated_by,
    l_last_update_login,
    p_start_date_active,
    l_end_date_active);

Line: 2762

        FND_MESSAGE.SET_NAME('AK','AK_INSERT_CUSTOM_FAILED');

Line: 2769

  insert into AK_CUSTOMIZATIONS_TL (
    CUSTOMIZATION_APPLICATION_ID,
    CUSTOMIZATION_CODE,
    REGION_APPLICATION_ID,
    REGION_CODE,
    NAME,
    DESCRIPTION,
    LANGUAGE,
    SOURCE_LANG,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN
  ) select
    p_custom_appl_id,
    p_custom_code,
    p_region_appl_id,
    p_region_code,
    p_name,
    l_description,
    L.LANGUAGE_CODE,
    decode(L.LANGUAGE_CODE, l_lang, L.LANGUAGE_CODE, l_lang),
    l_created_by,
    l_creation_date,
    l_last_updated_by,
    l_last_update_date,
    l_last_update_login
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from AK_CUSTOMIZATIONS_TL T
    where T.CUSTOMIZATION_APPLICATION_ID = p_custom_appl_id
    and T.CUSTOMIZATION_CODE = p_custom_code
    and T.REGION_APPLICATION_ID = p_region_appl_id
    and T.REGION_CODE = p_region_code
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 2910

  p_last_updated_by          IN      NUMBER := FND_API.G_MISS_NUM,
  p_last_update_date         IN      DATE := FND_API.G_MISS_DATE,
  p_last_update_login        IN      NUMBER := FND_API.G_MISS_NUM,
  p_loader_timestamp         IN      DATE := FND_API.G_MISS_DATE,
  p_pass                     IN      NUMBER,
  p_copy_redo_flag           IN OUT NOCOPY  BOOLEAN
) is
  l_api_version_number      CONSTANT number := 1.0;

Line: 2921

  l_last_update_date            DATE;

Line: 2922

  l_last_update_login           NUMBER;

Line: 2923

  l_last_updated_by             NUMBER;

Line: 3013

  if (p_last_updated_by <> FND_API.G_MISS_NUM) then
    l_last_updated_by := p_last_updated_by;

Line: 3016

  if (p_last_update_date <> FND_API.G_MISS_DATE) then
    l_last_update_date := p_last_update_date;

Line: 3019

  if (p_last_update_login <> FND_API.G_MISS_NUM) then
    l_last_update_login := p_last_update_login;

Line: 3029

  if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
       p_loader_timestamp => p_loader_timestamp,
       p_created_by => l_created_by,
       p_creation_date => l_creation_date,
       p_last_updated_by => l_last_updated_by,
       p_db_last_updated_by => null,
       p_last_update_date => l_last_update_date,
       p_db_last_update_date => null,
       p_last_update_login => l_last_update_login,
       p_create_or_update => 'CREATE') then
     null;

Line: 3042

  select userenv('LANG') into l_lang
  from dual;

Line: 3045

  insert into AK_CUSTOM_REGIONS (
    CUSTOMIZATION_APPLICATION_ID,
    CUSTOMIZATION_CODE,
    REGION_APPLICATION_ID,
    REGION_CODE,
    PROPERTY_NAME,
    PROPERTY_VARCHAR2_VALUE,
    PROPERTY_NUMBER_VALUE,
    CRITERIA_JOIN_CONDITION,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN
  ) values (
    p_custom_appl_id,
    p_custom_code,
    p_region_appl_id,
    p_region_code,
    p_property_name,
    l_property_varchar2_value,
    l_property_number_value,
    l_criteria_join_condition,
    l_created_by,
    l_creation_date,
    l_last_updated_by,
    l_last_update_date,
    l_last_update_login);

Line: 3085

        FND_MESSAGE.SET_NAME('AK','AK_INSERT_CUST_REGION_FAILED');

Line: 3092

  insert into AK_CUSTOM_REGIONS_TL (
    CUSTOMIZATION_APPLICATION_ID,
    CUSTOMIZATION_CODE,
    REGION_APPLICATION_ID,
    REGION_CODE,
    PROPERTY_NAME,
    PROPERTY_VARCHAR2_VALUE,
    LANGUAGE,
    SOURCE_LANG,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN
  ) select
    p_custom_appl_id,
    p_custom_code,
    p_region_appl_id,
    p_region_code,
    p_property_name,
    l_property_varchar2_value,
    L.LANGUAGE_CODE,
    decode(L.LANGUAGE_CODE, l_lang, L.LANGUAGE_CODE, l_lang),
    l.created_by,
    l_creation_date,
    l_last_updated_by,
    l_last_update_date,
    l_last_update_login
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from AK_CUSTOM_REGIONS_TL T
    where T.CUSTOMIZATION_APPLICATION_ID = p_custom_appl_id
    and T.CUSTOMIZATION_CODE = p_custom_code
    and T.REGION_APPLICATION_ID = p_region_appl_id
    and T.REGION_CODE = p_region_code
    and T.PROPERTY_NAME = p_property_name
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 3238

  p_last_updated_by          IN      NUMBER := FND_API.G_MISS_NUM,
  p_last_update_date         IN      DATE := FND_API.G_MISS_DATE,
  p_last_update_login        IN      NUMBER := FND_API.G_MISS_NUM,
  p_loader_timestamp         IN      DATE := FND_API.G_MISS_DATE,
  p_pass                     IN      NUMBER,
  p_copy_redo_flag           IN OUT NOCOPY  BOOLEAN
) is
  l_api_version_number      CONSTANT number := 1.0;

Line: 3249

  l_last_update_date            DATE;

Line: 3250

  l_last_update_login           NUMBER;

Line: 3251

  l_last_updated_by             NUMBER;

Line: 3345

  if (p_last_updated_by <> FND_API.G_MISS_NUM) then
    l_last_updated_by := p_last_updated_by;

Line: 3348

  if (p_last_update_date <> FND_API.G_MISS_DATE) then
    l_last_update_date := p_last_update_date;

Line: 3351

  if (p_last_update_login <> FND_API.G_MISS_NUM) then
    l_last_update_login := p_last_update_login;

Line: 3361

  if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
       p_loader_timestamp => p_loader_timestamp,
       p_created_by => l_created_by,
       p_creation_date => l_creation_date,
       p_last_updated_by => l_last_updated_by,
       p_db_last_updated_by => null,
       p_last_update_date => l_last_update_date,
       p_db_last_update_date => null,
       p_last_update_login => l_last_update_login,
       p_create_or_update => 'CREATE') then
     null;

Line: 3374

  select userenv('LANG') into l_lang
  from dual;

Line: 3377

  insert into AK_CUSTOM_REGION_ITEMS (
    CUSTOMIZATION_APPLICATION_ID,
    CUSTOMIZATION_CODE,
    REGION_APPLICATION_ID,
    REGION_CODE,
    ATTRIBUTE_APPLICATION_ID,
    ATTRIBUTE_CODE,
    PROPERTY_NAME,
    PROPERTY_VARCHAR2_VALUE,
    PROPERTY_NUMBER_VALUE,
    PROPERTY_DATE_VALUE,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN
  ) values (
    p_custom_appl_id,
    p_custom_code,
    p_region_appl_id,
    p_region_code,
    p_attr_appl_id,
    p_attr_code,
    p_property_name,
    l_property_varchar2_value,
    l_property_number_value,
    l_property_date_value,
    l_created_by,
    l_creation_date,
    l_last_updated_by,
    l_last_update_date,
    l_last_update_login);

Line: 3423

        FND_MESSAGE.SET_NAME('AK','AK_INSERT_CUST_REG_ITEM_FAILED');

Line: 3430

  insert into AK_CUSTOM_REGION_ITEMS_TL (
    CUSTOMIZATION_APPLICATION_ID,
    CUSTOMIZATION_CODE,
    REGION_APPLICATION_ID,
    REGION_CODE,
    ATTRIBUTE_APPLICATION_ID,
    ATTRIBUTE_CODE,
    PROPERTY_NAME,
    PROPERTY_VARCHAR2_VALUE,
    LANGUAGE,
    SOURCE_LANG,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN
  ) select
    p_custom_appl_id,
    p_custom_code,
    p_region_appl_id,
    p_region_code,
    p_attr_appl_id,
    p_attr_code,
    p_property_name,
    l_property_varchar2_value_tl,
    L.LANGUAGE_CODE,
    decode(L.LANGUAGE_CODE, l_lang, L.LANGUAGE_CODE, l_lang),
    l.created_by,
    l_creation_date,
    l_last_updated_by,
    l_last_update_date,
    l_last_update_login
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from AK_CUSTOM_REGION_ITEMS_TL T
    where T.CUSTOMIZATION_APPLICATION_ID = p_custom_appl_id
    and T.CUSTOMIZATION_CODE = p_custom_code
    and T.REGION_APPLICATION_ID = p_region_appl_id
    and T.REGION_CODE = p_region_code
    and T.ATTRIBUTE_APPLICATION_ID = p_attr_appl_id
    and T.ATTRIBUTE_CODE = p_attr_code
    and T.PROPERTY_NAME = p_property_name
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 3588

  p_last_updated_by          IN      NUMBER := FND_API.G_MISS_NUM,
  p_last_update_date         IN      DATE := FND_API.G_MISS_DATE,
  p_last_update_login        IN      NUMBER := FND_API.G_MISS_NUM,
  p_loader_timestamp         IN      DATE := FND_API.G_MISS_DATE,
  p_pass                     IN      NUMBER,
  p_copy_redo_flag           IN OUT NOCOPY  BOOLEAN
) is
  l_api_version_number      CONSTANT number := 1.0;

Line: 3599

  l_last_update_date            DATE;

Line: 3600

  l_last_update_login           NUMBER;

Line: 3601

  l_last_updated_by             NUMBER;

Line: 3700

  if (p_last_updated_by <> FND_API.G_MISS_NUM) then
    l_last_updated_by := p_last_updated_by;

Line: 3704

  if (p_last_update_date <> FND_API.G_MISS_DATE) then
    l_last_update_date := p_last_update_date;

Line: 3708

  if (p_last_update_login <> FND_API.G_MISS_NUM) then
    l_last_update_login := p_last_update_login;

Line: 3718

  if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
       p_loader_timestamp => p_loader_timestamp,
       p_created_by => l_created_by,
       p_creation_date => l_creation_date,
       p_last_updated_by => l_last_updated_by,
       p_db_last_updated_by => null,
       p_last_update_date => l_last_update_date,
       p_db_last_update_date => null,
       p_last_update_login => l_last_update_login,
       p_create_or_update => 'CREATE') then
     null;

Line: 3731

  select userenv('LANG') into l_lang
  from dual;

Line: 3734

  insert into AK_CRITERIA (
    CUSTOMIZATION_APPLICATION_ID,
    CUSTOMIZATION_CODE,
    REGION_APPLICATION_ID,
    REGION_CODE,
    ATTRIBUTE_APPLICATION_ID,
    ATTRIBUTE_CODE,
    SEQUENCE_NUMBER,
    OPERATION,
    VALUE_VARCHAR2,
    VALUE_NUMBER,
    VALUE_DATE,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    START_DATE_ACTIVE,
    END_DATE_ACTIVE
  ) values (
    p_custom_appl_id,
    p_custom_code,
    p_region_appl_id,
    p_region_code,
    p_attr_appl_id,
    p_attr_code,
    p_sequence_number,
    p_operation,
    l_value_varchar2,
    l_value_number,
    l_value_date,
    l_created_by,
    l_creation_date,
    l_last_updated_by,
    l_last_update_date,
    l_last_update_login,
    p_start_date_active,
    l_end_date_active);

Line: 3870

    select 1
    from  AK_CUSTOMIZATIONS
    where region_application_id = p_region_application_id
    and   region_code = p_region_code
    and   customization_application_id = p_custom_appl_id
    and   customization_code = p_custom_code;

Line: 3945

    select 1
    from  AK_CUSTOM_REGIONS
    where region_application_id = p_region_application_id
    and   region_code = p_region_code
    and   customization_application_id = p_custom_appl_id
    and   customization_code = p_custom_code
    and   property_name = p_property_name;

Line: 4023

    select 1
    from  AK_CUSTOM_REGION_ITEMS
    where region_application_id = p_region_application_id
    and   region_code = p_region_code
    and   customization_application_id = p_custom_appl_id
    and   customization_code = p_custom_code
    and   attribute_application_id = p_attribute_appl_id
    and   attribute_code = p_attribute_code
    and   property_name = p_property_name;

Line: 4103

    select 1
    from  AK_CRITERIA
    where region_application_id = p_region_application_id
    and   region_code = p_region_code
    and   customization_application_id = p_custom_appl_id
    and   customization_code = p_custom_code
    and   attribute_application_id = p_attribute_appl_id
    and   attribute_code = p_attribute_code
    and   sequence_number = p_sequence_number;

Line: 4171

procedure UPDATE_CUSTOM (
  p_validation_level         IN      NUMBER := FND_API.G_VALID_LEVEL_FULL,
  p_api_version_number       IN      NUMBER,
  p_init_msg_tbl             IN      BOOLEAN := FALSE,
  p_msg_count                OUT NOCOPY     NUMBER,
  p_msg_data                 OUT NOCOPY     VARCHAR2,
  p_return_status            OUT NOCOPY     VARCHAR2,
  p_custom_appl_id 	     IN      NUMBER,
  p_custom_code		     IN      VARCHAR2,
  p_region_application_id    IN      NUMBER,
  p_region_code              IN      VARCHAR2,
  p_verticalization_id	     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
  p_localization_code	     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
  p_org_id		     IN      NUMBER := FND_API.G_MISS_NUM,
  p_site_id		     IN      NUMBER := FND_API.G_MISS_NUM,
  p_responsibility_id	     IN      NUMBER := FND_API.G_MISS_NUM,
  p_web_user_id		     IN      NUMBER := FND_API.G_MISS_NUM,
  p_default_customization_flag   IN  VARCHAR2 := FND_API.G_MISS_CHAR,
  p_customization_level_id   IN      NUMBER := FND_API.G_MISS_NUM,
  p_developer_mode	     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
  p_reference_path	     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
  p_function_name 	     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
  p_start_date_active	     IN      DATE := FND_API.G_MISS_DATE,
  p_end_date_active	     IN      DATE := FND_API.G_MISS_DATE,
  p_name		     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
  p_description		     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
  p_created_by		     IN      NUMBER := FND_API.G_MISS_NUM,
  p_creation_date	     IN      DATE := FND_API.G_MISS_DATE,
  p_last_updated_by	     IN      NUMBER := FND_API.G_MISS_NUM,
  p_last_update_date	     IN      DATE := FND_API.G_MISS_DATE,
  p_last_update_login	     IN      NUMBER := FND_API.G_MISS_NUM,
  p_loader_timestamp         IN      DATE := FND_API.G_MISS_DATE,
  p_pass                     IN      NUMBER,
  p_copy_redo_flag           IN OUT NOCOPY  BOOLEAN
) is
  cursor l_get_row_csr is
    select *
    from  AK_CUSTOMIZATIONS
    where CUSTOMIZATION_APPLICATION_ID = p_custom_appl_id
    and   CUSTOMIZATION_CODE = p_custom_code
    and   REGION_APPLICATION_ID = p_region_application_id
    and   REGION_CODE = p_region_code
    for update of VERTICALIZATION_ID;

Line: 4215

    select *
    from  AK_CUSTOMIZATIONS_TL
    where CUSTOMIZATION_APPLICATION_ID = p_custom_appl_id
    and   CUSTOMIZATION_CODE = p_custom_code
    and   REGION_APPLICATION_ID = p_region_application_id
    and   REGION_CODE = p_region_code
    and   LANGUAGE = lang_parm
    for update of name;

Line: 4224

  l_api_name               CONSTANT varchar2(30) := 'Update_Custom';

Line: 4231

  l_last_update_date       date;

Line: 4232

  l_last_update_login      number;

Line: 4233

  l_last_updated_by        number;

Line: 4251

  savepoint start_update_custom;

Line: 4253

  select userenv('LANG') into l_lang
  from dual;

Line: 4311

            p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,
                        p_pass => p_pass
          ) then
      --dbms_output.put_line(l_api_name || ' validation failed');

Line: 4399

  if (p_last_updated_by <> FND_API.G_MISS_NUM) then
    l_last_updated_by := p_last_updated_by;

Line: 4403

  if (p_last_update_date <> FND_API.G_MISS_DATE) then
    l_last_update_date := p_last_update_date;

Line: 4407

  if (p_last_update_login <> FND_API.G_MISS_NUM) then
    l_last_update_login := p_last_update_login;

Line: 4413

  if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
       p_loader_timestamp => p_loader_timestamp,
       p_created_by => l_created_by,
       p_creation_date => l_creation_date,
       p_last_updated_by => l_last_updated_by,
       p_db_last_updated_by => l_custom_rec.last_updated_by,
       p_last_update_date => l_last_update_date,
       p_db_last_update_date => l_custom_rec.last_update_date,
       p_last_update_login => l_last_update_login,
       p_create_or_update => 'UPDATE') then
     null;

Line: 4427

  delete AK_CUSTOM_REGIONS
  where REGION_APPLICATION_ID = p_region_application_id
  and   REGION_CODE = p_region_code
  and   CUSTOMIZATION_APPLICATION_ID = p_custom_appl_id
  and   CUSTOMIZATION_CODE = p_custom_code;

Line: 4433

  delete AK_CUSTOM_REGION_ITEMS
  where REGION_APPLICATION_ID = p_region_application_id
  and   REGION_CODE = p_region_code
  and   CUSTOMIZATION_APPLICATION_ID = p_custom_appl_id
  and   CUSTOMIZATION_CODE = p_custom_code;

Line: 4439

  update AK_CUSTOMIZATIONS set
	VERTICALIZATION_ID = l_custom_rec.verticalization_id,
	LOCALIZATION_CODE = l_custom_rec.localization_code,
	ORG_ID = l_custom_rec.org_id,
	SITE_ID = l_custom_rec.site_id,
	RESPONSIBILITY_ID = l_custom_rec.responsibility_id,
	WEB_USER_ID = l_custom_rec.web_user_id,
	DEFAULT_CUSTOMIZATION_FLAG = l_custom_rec.default_customization_flag,
	CUSTOMIZATION_LEVEL_ID = l_custom_rec.customization_level_id,
	DEVELOPER_MODE = l_custom_rec.developer_mode,
        START_DATE_ACTIVE = l_custom_Rec.start_date_active,
        END_DATE_ACTIVE = l_custom_rec.end_date_active,
        LAST_UPDATE_DATE = l_last_update_date,
        LAST_UPDATED_BY = l_last_updated_by,
        LAST_UPDATE_LOGIN = l_last_update_login
  where REGION_APPLICATION_ID = p_region_application_id
  and   REGION_CODE = p_region_code
  and   CUSTOMIZATION_APPLICATION_ID = p_custom_appl_id
  and   CUSTOMIZATION_CODE = p_custom_code;

Line: 4460

      FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_UPDATE_FAILED');

Line: 4467

  delete AK_CUSTOM_REGIONS_TL
  where REGION_APPLICATION_ID = p_region_application_id
  and   REGION_CODE = p_region_code
  and   CUSTOMIZATION_APPLICATION_ID = p_custom_appl_id
  and   CUSTOMIZATION_CODE = p_custom_code;

Line: 4473

  delete AK_CUSTOM_REGION_ITEMS_TL
  where REGION_APPLICATION_ID = p_region_application_id
  and   REGION_CODE = p_region_code
  and   CUSTOMIZATION_APPLICATION_ID = p_custom_appl_id
  and   CUSTOMIZATION_CODE = p_custom_code;

Line: 4479

  update AK_CUSTOMIZATIONS_TL set
	NAME = l_custom_tl_rec.name,
	DESCRIPTION = l_custom_tl_rec.description,
      LAST_UPDATED_BY = l_last_updated_by,
      LAST_UPDATE_DATE = l_last_update_date,
      LAST_UPDATE_LOGIN = l_last_update_login,
          SOURCE_LANG = l_lang
  where REGION_APPLICATION_ID = p_region_application_id
  and   REGION_CODE = p_region_code
  and   CUSTOMIZATION_APPLICATION_ID = p_custom_appl_id
  and   CUSTOMIZATION_CODE = p_custom_code
  and   l_lang in (LANGUAGE, SOURCE_LANG);

Line: 4493

      FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_UPDATE_FAILED');

Line: 4504

    FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_UPDATED');

Line: 4528

    rollback to start_update_custom;

Line: 4535

      FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_NOT_UPDATED');

Line: 4543

    rollback to start_update_custom;

Line: 4550

end UPDATE_CUSTOM;

Line: 4575

procedure UPDATE_CUST_REGION (
  p_validation_level         IN      NUMBER := FND_API.G_VALID_LEVEL_FULL,
  p_api_version_number       IN      NUMBER,
  p_init_msg_tbl             IN      BOOLEAN := FALSE,
  p_msg_count                OUT NOCOPY     NUMBER,
  p_msg_data                 OUT NOCOPY     VARCHAR2,
  p_return_status            OUT NOCOPY     VARCHAR2,
  p_custom_appl_id           IN      NUMBER,
  p_custom_code              IN      VARCHAR2,
  p_region_application_id    IN      NUMBER,
  p_region_code              IN      VARCHAR2,
  p_property_name	     IN      VARCHAR2,
  p_property_varchar2_value  IN	     VARCHAR2 := FND_API.G_MISS_CHAR,
  p_property_number_value    IN      NUMBER := FND_API.G_MISS_NUM,
  p_criteria_join_condition  IN      VARCHAR2 := FND_API.G_MISS_CHAR,
  p_property_varchar2_value_tl  IN   VARCHAR2 := FND_API.G_MISS_CHAR,
  p_created_by			IN      NUMBER := FND_API.G_MISS_NUM,
  p_creation_date		IN      DATE := FND_API.G_MISS_DATE,
  p_last_updated_by		IN      NUMBER := FND_API.G_MISS_NUM,
  p_last_update_date		IN      DATE := FND_API.G_MISS_DATE,
  p_last_update_login		IN      NUMBER := FND_API.G_MISS_NUM,
  p_loader_timestamp         IN      DATE := FND_API.G_MISS_DATE,
  p_pass                     IN      NUMBER,
  p_copy_redo_flag           IN OUT NOCOPY  BOOLEAN
) is
  cursor l_get_row_csr is
    select *
    from  AK_CUSTOM_REGIONS
    where CUSTOMIZATION_APPLICATION_ID = p_custom_appl_id
    and   CUSTOMIZATION_CODE = p_custom_code
    and   REGION_APPLICATION_ID = p_region_application_id
    and   REGION_CODE = p_region_code
    and   PROPERTY_NAME = p_property_name
    for update of PROPERTY_VARCHAR2_VALUE;

Line: 4610

    select *
    from  AK_CUSTOM_REGIONS_TL
    where CUSTOMIZATION_APPLICATION_ID = p_custom_appl_id
    and   CUSTOMIZATION_CODE = p_custom_code
    and   REGION_APPLICATION_ID = p_region_application_id
    and   REGION_CODE = p_region_code
    and   PROPERTY_NAME = p_property_name
    and   LANGUAGE = lang_parm
    for update of PROPERTY_VARCHAR2_VALUE;

Line: 4620

  l_api_name               CONSTANT varchar2(30) := 'Update_Custom';

Line: 4627

  l_last_update_date       date;

Line: 4628

  l_last_update_login      number;

Line: 4629

  l_last_updated_by        number;

Line: 4647

  savepoint start_update_cust_region;

Line: 4649

  select userenv('LANG') into l_lang
  from dual;

Line: 4697

            p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,
                        p_pass => p_pass
          ) then
      --dbms_output.put_line(l_api_name || ' validation failed');

Line: 4741

  if (p_last_updated_by <> FND_API.G_MISS_NUM) then
    l_last_updated_by := p_last_updated_by;

Line: 4745

  if (p_last_update_date <> FND_API.G_MISS_DATE) then
    l_last_update_date := p_last_update_date;

Line: 4749

  if (p_last_update_login <> FND_API.G_MISS_NUM) then
    l_last_update_login := p_last_update_login;

Line: 4757

  if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
       p_loader_timestamp => p_loader_timestamp,
       p_created_by => l_created_by,
       p_creation_date => l_creation_date,
       p_last_updated_by => l_last_updated_by,
       p_db_last_updated_by => l_cust_region_rec.last_updated_by,
       p_last_update_date => l_last_update_date,
       p_db_last_update_date => l_cust_region_rec.last_update_date,
       p_last_update_login => l_last_update_login,
       p_create_or_update => 'UPDATE') then
     null;

Line: 4770

  update AK_CUSTOM_REGIONS set
	PROPERTY_VARCHAR2_VALUE = l_cust_region_rec.property_varchar2_value,
	PROPERTY_NUMBER_VALUE = l_cust_region_rec.property_number_value,
 	CRITERIA_JOIN_CONDITION = l_cust_region_rec.criteria_join_condition,
        LAST_UPDATE_DATE = l_last_update_date,
        LAST_UPDATED_BY = l_last_updated_by,
        LAST_UPDATE_LOGIN = l_last_update_login
  where REGION_APPLICATION_ID = p_region_application_id
  and   REGION_CODE = p_region_code
  and   CUSTOMIZATION_APPLICATION_ID = p_custom_appl_id
  and   CUSTOMIZATION_CODE = p_custom_code
  and   PROPERTY_NAME = p_property_name;

Line: 4784

      FND_MESSAGE.SET_NAME('AK','AK_CUST_REGION_UPDATE_FAILED');

Line: 4791

  update AK_CUSTOM_REGIONS_TL set
	PROPERTY_VARCHAR2_VALUE = l_cust_region_tl_rec.property_varchar2_value,
        LAST_UPDATE_DATE = l_last_update_date,
        LAST_UPDATED_BY = l_last_updated_by,
        LAST_UPDATE_LOGIN = l_last_update_login,
          SOURCE_LANG = l_lang
  where REGION_APPLICATION_ID = p_region_application_id
  and   REGION_CODE = p_region_code
  and   CUSTOMIZATION_APPLICATION_ID = p_custom_appl_id
  and   CUSTOMIZATION_CODE = p_custom_code
  and   PROPERTY_NAME = p_property_name
  and   l_lang in (LANGUAGE, SOURCE_LANG);

Line: 4805

      FND_MESSAGE.SET_NAME('AK','AK_CUST_REGION_UPDATE_FAILED');

Line: 4816

    FND_MESSAGE.SET_NAME('AK','AK_CUST_REGION_UPDATED');

Line: 4842

    rollback to start_update_cust_region;

Line: 4849

      FND_MESSAGE.SET_NAME('AK','AK_CUST_REGION_NOT_UPDATED');

Line: 4858

    rollback to start_update_cust_region;

Line: 4865

end UPDATE_CUST_REGION;

Line: 4890

procedure UPDATE_CUST_REG_ITEM (
  p_validation_level         IN      NUMBER := FND_API.G_VALID_LEVEL_FULL,
  p_api_version_number       IN      NUMBER,
  p_init_msg_tbl             IN      BOOLEAN := FALSE,
  p_msg_count                OUT NOCOPY     NUMBER,
  p_msg_data                 OUT NOCOPY     VARCHAR2,
  p_return_status            OUT NOCOPY     VARCHAR2,
  p_custom_appl_id           IN      NUMBER,
  p_custom_code              IN      VARCHAR2,
  p_region_application_id    IN      NUMBER,
  p_region_code              IN      VARCHAR2,
  p_attribute_appl_id	     IN      NUMBER,
  p_attribute_code	     IN      VARCHAR2,
  p_property_name            IN      VARCHAR2,
  p_property_varchar2_value  IN      VARCHAR2 := FND_API.G_MISS_CHAR,
  p_property_number_value    IN      NUMBER := FND_API.G_MISS_NUM,
  p_property_date_value      IN      VARCHAR2 := FND_API.G_MISS_CHAR,
  p_property_varchar2_value_tl  IN   VARCHAR2 := FND_API.G_MISS_CHAR,
  p_created_by               IN      NUMBER := FND_API.G_MISS_NUM,
  p_creation_date            IN      DATE := FND_API.G_MISS_DATE,
  p_last_updated_by          IN      NUMBER := FND_API.G_MISS_NUM,
  p_last_update_date         IN      DATE := FND_API.G_MISS_DATE,
  p_last_update_login        IN      NUMBER := FND_API.G_MISS_NUM,
  p_loader_timestamp         IN      DATE := FND_API.G_MISS_DATE,
  p_pass                     IN      NUMBER,
  p_copy_redo_flag           IN OUT NOCOPY  BOOLEAN
) is
  cursor l_get_row_csr is
    select *
    from  AK_CUSTOM_REGION_ITEMS
    where CUSTOMIZATION_APPLICATION_ID = p_custom_appl_id
    and   CUSTOMIZATION_CODE = p_custom_code
    and   REGION_APPLICATION_ID = p_region_application_id
    and   REGION_CODE = p_region_code
    and   ATTRIBUTE_APPLICATION_ID = p_attribute_appl_id
    and   ATTRIBUTE_CODE = p_attribute_code
    and   PROPERTY_NAME = p_property_name
    for update of PROPERTY_VARCHAR2_VALUE;

Line: 4929

    select *
    from  AK_CUSTOM_REGION_ITEMS_TL
    where CUSTOMIZATION_APPLICATION_ID = p_custom_appl_id
    and   CUSTOMIZATION_CODE = p_custom_code
    and   REGION_APPLICATION_ID = p_region_application_id
    and   REGION_CODE = p_region_code
    and   ATTRIBUTE_APPLICATION_ID = p_attribute_appl_id
    and   ATTRIBUTE_CODE = p_attribute_code
    and   PROPERTY_NAME = p_property_name
    and   LANGUAGE = lang_parm
    for update of PROPERTY_VARCHAR2_VALUE;

Line: 4941

  l_api_name               CONSTANT varchar2(30) := 'Update_Cust_Reg_Item';

Line: 4948

  l_last_update_date       date;

Line: 4949

  l_last_update_login      number;

Line: 4950

  l_last_updated_by        number;

Line: 4968

  savepoint start_update_cust_reg_item;

Line: 4970

  select userenv('LANG') into l_lang
  from dual;

Line: 5020

            p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,
                        p_pass => p_pass
          ) then
      --dbms_output.put_line(l_api_name || ' validation failed');

Line: 5064

  if (p_last_updated_by <> FND_API.G_MISS_NUM) then
    l_last_updated_by := p_last_updated_by;

Line: 5068

  if (p_last_update_date <> FND_API.G_MISS_DATE) then
    l_last_update_date := p_last_update_date;

Line: 5072

  if (p_last_update_login <> FND_API.G_MISS_NUM) then
    l_last_update_login := p_last_update_login;

Line: 5080

  if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
       p_loader_timestamp => p_loader_timestamp,
       p_created_by => l_created_by,
       p_creation_date => l_creation_date,
       p_last_updated_by => l_last_updated_by,
       p_db_last_updated_by => l_cust_reg_item_rec.last_updated_by,
       p_last_update_date => l_last_update_date,
       p_db_last_update_date => l_cust_reg_item_rec.last_update_date,
       p_last_update_login => l_last_update_login,
       p_create_or_update => 'UPDATE') then
     null;

Line: 5093

  update AK_CUSTOM_REGION_ITEMS set
        PROPERTY_VARCHAR2_VALUE = l_cust_reg_item_rec.property_varchar2_value,
        PROPERTY_NUMBER_VALUE = l_cust_reg_item_rec.property_number_value,
        PROPERTY_DATE_VALUE = l_cust_reg_item_rec.property_date_value,
        LAST_UPDATE_DATE = l_last_update_date,
        LAST_UPDATED_BY = l_last_updated_by,
        LAST_UPDATE_LOGIN = l_last_update_login
  where REGION_APPLICATION_ID = p_region_application_id
  and   REGION_CODE = p_region_code
  and   CUSTOMIZATION_APPLICATION_ID = p_custom_appl_id
  and   CUSTOMIZATION_CODE = p_custom_code
  and   ATTRIBUTE_APPLICATION_ID = p_attribute_appl_id
  and   ATTRIBUTE_CODE = p_attribute_code
  and   PROPERTY_NAME = p_property_name;

Line: 5109

      FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_ITEM_UPDATE_FAILED');

Line: 5116

  update AK_CUSTOM_REGION_ITEMS_TL set
        PROPERTY_VARCHAR2_VALUE = l_cust_reg_item_tl_rec.property_varchar2_value,
        LAST_UPDATE_DATE = l_last_update_date,
        LAST_UPDATED_BY = l_last_updated_by,
        LAST_UPDATE_LOGIN = l_last_update_login,
          SOURCE_LANG = l_lang
  where REGION_APPLICATION_ID = p_region_application_id
  and   REGION_CODE = p_region_code
  and   CUSTOMIZATION_APPLICATION_ID = p_custom_appl_id
  and   CUSTOMIZATION_CODE = p_custom_code
  and   ATTRIBUTE_APPLICATION_ID = p_attribute_appl_id
  and   ATTRIBUTE_CODE = p_attribute_code
  and   PROPERTY_NAME = p_property_name
  and   l_lang in (LANGUAGE, SOURCE_LANG);

Line: 5132

      FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_ITEM_UPDATE_FAILED');

Line: 5143

    FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_ITEM_UPDATED');

Line: 5169

    rollback to start_update_cust_reg_item;

Line: 5176

      FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_ITEM_NOT_UPDATED');

Line: 5185

    rollback to start_update_cust_reg_item;

Line: 5192

end UPDATE_CUST_REG_ITEM;

Line: 5217

procedure UPDATE_CRITERIA (
  p_validation_level         IN      NUMBER := FND_API.G_VALID_LEVEL_FULL,
  p_api_version_number       IN      NUMBER,
  p_init_msg_tbl             IN      BOOLEAN := FALSE,
  p_msg_count                OUT NOCOPY     NUMBER,
  p_msg_data                 OUT NOCOPY     VARCHAR2,
  p_return_status            OUT NOCOPY     VARCHAR2,
  p_custom_appl_id           IN      NUMBER,
  p_custom_code              IN      VARCHAR2,
  p_region_application_id    IN      NUMBER,
  p_region_code              IN      VARCHAR2,
  p_attribute_appl_id        IN      NUMBER,
  p_attribute_code           IN      VARCHAR2,
  p_sequence_number	     IN      NUMBER,
  p_operation		     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
  p_value_varchar2	     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
  p_value_number	     IN      NUMBER := FND_API.G_MISS_NUM,
  p_value_date 		     IN      DATE := FND_API.G_MISS_DATE,
  p_start_date_active        IN      DATE := FND_API.G_MISS_DATE,
  p_end_date_active	     IN      DATE := FND_API.G_MISS_DATE,
  p_created_by               IN      NUMBER := FND_API.G_MISS_NUM,
  p_creation_date            IN      DATE := FND_API.G_MISS_DATE,
  p_last_updated_by          IN      NUMBER := FND_API.G_MISS_NUM,
  p_last_update_date         IN      DATE := FND_API.G_MISS_DATE,
  p_last_update_login        IN      NUMBER := FND_API.G_MISS_NUM,
  p_loader_timestamp         IN      DATE := FND_API.G_MISS_DATE,
  p_pass                     IN      NUMBER,
  p_copy_redo_flag           IN OUT NOCOPY  BOOLEAN
) is
  cursor l_get_row_csr is
    select *
    from  AK_CRITERIA
    where CUSTOMIZATION_APPLICATION_ID = p_custom_appl_id
    and   CUSTOMIZATION_CODE = p_custom_code
    and   REGION_APPLICATION_ID = p_region_application_id
    and   REGION_CODE = p_region_code
    and   ATTRIBUTE_APPLICATION_ID = p_attribute_appl_id
    and   ATTRIBUTE_CODE = p_attribute_code
    and   SEQUENCE_NUMBER = p_sequence_number
    for update of OPERATION;

Line: 5258

  l_api_name               CONSTANT varchar2(30) := 'Update_Criteria';

Line: 5263

  l_last_update_date       date;

Line: 5264

  l_last_update_login      number;

Line: 5265

  l_last_updated_by        number;

Line: 5283

  savepoint start_update_criteria;

Line: 5320

	                p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,
                        p_pass => p_pass
          ) then
      --dbms_output.put_line(l_api_name || ' validation failed');

Line: 5374

  if (p_last_updated_by <> FND_API.G_MISS_NUM) then
    l_last_updated_by := p_last_updated_by;

Line: 5378

  if (p_last_update_date <> FND_API.G_MISS_DATE) then
    l_last_update_date := p_last_update_date;

Line: 5382

  if (p_last_update_login <> FND_API.G_MISS_NUM) then
    l_last_update_login := p_last_update_login;

Line: 5388

  if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
       p_loader_timestamp => p_loader_timestamp,
       p_created_by => l_created_by,
       p_creation_date => l_creation_date,
       p_last_updated_by => l_last_updated_by,
       p_db_last_updated_by => l_criteria_rec.last_updated_by,
       p_last_update_date => l_last_update_date,
       p_db_last_update_date => l_criteria_rec.last_update_date,
       p_last_update_login => l_last_update_login,
       p_create_or_update => 'UPDATE') then
     null;

Line: 5401

  update AK_CRITERIA set
	OPERATION = l_criteria_rec.operation,
	VALUE_VARCHAR2 = l_criteria_rec.value_varchar2,
	VALUE_NUMBER = l_criteria_rec.value_number,
        VALUE_DATE = l_criteria_rec.value_date,
	START_DATE_ACTIVE = l_criteria_rec.start_date_active,
  	END_DATE_ACTIVE = l_criteria_rec.end_date_active,
        LAST_UPDATE_DATE = l_last_update_date,
        LAST_UPDATED_BY = l_last_updated_by,
        LAST_UPDATE_LOGIN = l_last_update_login
  where REGION_APPLICATION_ID = p_region_application_id
  and   REGION_CODE = p_region_code
  and   CUSTOMIZATION_APPLICATION_ID = p_custom_appl_id
  and   CUSTOMIZATION_CODE = p_custom_code
  and   ATTRIBUTE_APPLICATION_ID = p_attribute_appl_id
  and   ATTRIBUTE_CODE = p_attribute_code
  and   SEQUENCE_NUMBER = p_sequence_number;

Line: 5420

      FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_UPDATE_FAILED');

Line: 5431

    FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_UPDATED');

Line: 5457

    rollback to start_update_criteria;

Line: 5464

      FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_NOT_UPDATED');

Line: 5473

    rollback to start_update_criteria;

Line: 5480

end UPDATE_CRITERIA;