APPS.AMV_USER_PVT SQL Statements

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

Line: 50

PROCEDURE Update_Access_Helper
(
    p_access_obj          IN  AMV_ACCESS_OBJ_TYPE,
    x_return_status       OUT NOCOPY VARCHAR2
);

Line: 62

Select
    role_id
From jtf_rs_roles_vl
Where role_code = p_role_code
And   role_type_code = G_MES_ROLE_TYPE_NAME
;

Line: 82

Select
     rol.role_id
From jtf_rs_roles_vl rol, jtf_rs_role_relations_vl rel
Where rol.role_id = rel.role_id
And rel.role_resource_id = p_resource_id
And rel.role_resource_type = p_resource_type
And rol.role_type_code = G_MES_ROLE_TYPE_NAME
And rol.role_code = p_role_code;

Line: 241

Select amv_u_access_s.nextval, sysdate
From   Dual;

Line: 264

    Insert into amv_u_access
    (
       ACCESS_ID,
       OBJECT_VERSION_NUMBER,
       CREATION_DATE,
       CREATED_BY,
       LAST_UPDATE_DATE,
       LAST_UPDATED_BY,
       LAST_UPDATE_LOGIN,
       ACCESS_TO_TABLE_CODE,
       ACCESS_TO_TABLE_RECORD_ID,
       USER_OR_GROUP_ID,
       USER_OR_GROUP_TYPE,
       EFFECTIVE_START_DATE,
       EXPIRATION_DATE,
       CAN_VIEW_FLAG,
       CAN_CREATE_FLAG,
       CAN_DELETE_FLAG,
       CAN_UPDATE_FLAG,
       CAN_CREATE_DIST_RULE_FLAG,
       CHL_APPROVER_FLAG,
       CHL_REQUIRED_FLAG,
       CHL_REQUIRED_NEED_NOTIF_FLAG
    )
    values
    (
       l_access_id,
       1, --OBJECT_VERSION_NUMBER
       l_date,
       l_current_user_id,
       l_date,
       l_current_user_id,
       l_current_login_id,
       l_access_obj.ACCESS_TO_TABLE_CODE,
       l_access_obj.ACCESS_TO_TABLE_RECORD_ID,
       l_access_obj.USER_OR_GROUP_ID,
       l_access_obj.USER_OR_GROUP_TYPE,
       l_access_obj.EFFECTIVE_START_DATE,
       l_access_obj.EXPIRATION_DATE,
       l_access_obj.CAN_VIEW_FLAG,
       l_access_obj.CAN_CREATE_FLAG,
       l_access_obj.CAN_DELETE_FLAG,
       l_access_obj.CAN_UPDATE_FLAG,
       l_access_obj.CAN_CREATE_DIST_RULE_FLAG,
       l_access_obj.CHL_APPROVER_FLAG,
       l_access_obj.CHL_REQUIRED_FLAG,
       l_access_obj.CHL_REQUIRED_NEED_NOTIF_FLAG
    );

Line: 323

PROCEDURE Update_Access_helper
(
    p_access_obj          IN  AMV_ACCESS_OBJ_TYPE,
    x_return_status       OUT NOCOPY VARCHAR2
) AS
--
l_api_name             CONSTANT VARCHAR2(30) := 'Update_Access_helper';

Line: 339

    SAVEPOINT  Update_Access_helper_PVT;

Line: 355

    Update amv_u_access
    Set LAST_UPDATE_DATE  = sysdate,
        LAST_UPDATED_BY   = l_current_user_id,
        LAST_UPDATE_LOGIN = l_current_login_id,
        OBJECT_VERSION_NUMBER = object_version_number + 1,
        EFFECTIVE_START_DATE = decode(l_access_obj.effective_start_date,
                                  FND_API.G_MISS_DATE, EFFECTIVE_START_DATE,
                                  l_access_obj.effective_start_date),
        EXPIRATION_DATE = decode(l_access_obj.expiration_date,
                                FND_API.G_MISS_DATE, EXPIRATION_DATE,
                                l_access_obj.expiration_date),
        CAN_VIEW_FLAG = decode(l_access_obj.can_view_flag,
                               FND_API.G_MISS_CHAR, CAN_VIEW_FLAG,
                               l_access_obj.can_view_flag),
        CAN_CREATE_FLAG = decode(l_access_obj.can_create_flag,
                               FND_API.G_MISS_CHAR, CAN_CREATE_FLAG,
                               l_access_obj.can_create_flag),
        CAN_DELETE_FLAG = decode(l_access_obj.can_delete_flag,
                               FND_API.G_MISS_CHAR, CAN_DELETE_FLAG,
                               l_access_obj.can_delete_flag),
        CAN_UPDATE_FLAG = decode(l_access_obj.can_update_flag,
                               FND_API.G_MISS_CHAR, CAN_UPDATE_FLAG,
                               l_access_obj.can_update_flag),
        CAN_CREATE_DIST_RULE_FLAG  =
                           decode(l_access_obj.can_create_dist_rule_flag,
                           FND_API.G_MISS_CHAR, CAN_CREATE_DIST_RULE_FLAG,
                           l_access_obj.can_create_dist_rule_flag),
        CHL_APPROVER_FLAG = decode(l_access_obj.chl_approver_flag,
                               FND_API.G_MISS_CHAR, CHL_APPROVER_FLAG,
                               l_access_obj.chl_approver_flag),
        CHL_REQUIRED_FLAG = decode(l_access_obj.chl_required_flag,
                               FND_API.G_MISS_CHAR, CHL_REQUIRED_FLAG,
                               l_access_obj.chl_required_flag),
        CHL_REQUIRED_NEED_NOTIF_FLAG =
                          decode(l_access_obj.chl_required_need_notif_flag,
                          FND_API.G_MISS_CHAR, CHL_REQUIRED_NEED_NOTIF_FLAG,
                          l_access_obj.chl_required_need_notif_flag)
    where access_id = l_access_obj.access_id
    ;--and object_version_number = l_access_obj.access_id.object_version_number;

Line: 405

        ROLLBACK TO  Update_Access_helper_PVT;

Line: 410

END Update_Access_helper;

Line: 594

          'Select ' ||
              'r.source_id, ' ||
              'r.resource_id, ' ||
              's.user_name, ' ||
	      'r.resource_name, ' ||
              'r.first_name, ' ||
              'r.last_name ' ||
              'From  amv_rs_all_res_extns_vl r,  jtf_rs_resource_extns s ';

Line: 603

          'Select count(*) ' ||
              'From  amv_rs_all_res_extns_vl r, jtf_rs_resource_extns s ';

Line: 608

          'Select ' ||
              'r.source_id, ' ||
              'r.resource_id, ' ||
              's.user_name, ' ||
	      'r.resource_name, ' ||
              'r.first_name, ' ||
              'r.last_name ' ||
              'From  amv_rs_all_res_extns_vl r, jtf_rs_group_members m, jtf_rs_resource_extns s  ';

Line: 617

          'Select count(*) ' ||
              'From  amv_rs_all_res_extns_vl r, jtf_rs_group_members m, jtf_rs_resource_extns s  ';

Line: 622

         'And m.delete_flag <> ''Y'' ' ||
         'And m.group_id = ' || p_group_id || ' ';

Line: 827

        'Select ' ||
          'r.source_id, ' ||
          'r.resource_id, ' ||
          'r.email user_name, ' ||
          'r.resource_name, ' ||
	  'r.first_name, ' ||
          'r.last_name ' ||
          'From  amv_rs_all_res_extns_vl r ';

Line: 836

      'Select count(*) ' ||fnd_global.local_chr(10)||
         'From  amv_rs_all_res_extns_vl r ';

Line: 996

Select role_relate_id
From  jtf_rs_role_relations_vl
Where role_id = l_role_id
And   role_resource_id = p_resource_id
And   role_resource_type = p_resource_type
;

Line: 1168

Select
      role_relate_id,
      object_version_number
From  jtf_rs_role_relations
Where role_id = p_role_id
And   role_resource_id = p_resource_id
And   role_resource_type = p_resource_type
And   delete_flag <> 'Y'
--And   role_type_code = G_MES_ROLE_TYPE_NAME
;

Line: 1258

    jtf_rs_role_relate_pub.delete_resource_role_relate
    (
         p_api_version        => p_api_version,
         p_commit             => p_commit,
         p_role_relate_id     => l_role_relate_id,
         p_object_version_num => l_version,
         x_return_status      => x_return_status,
         x_msg_count          => x_msg_count,
         x_msg_data           => x_msg_data
    );

Line: 1867

Select
     rol.role_code,
     rol.role_id
From  jtf_rs_role_relations_vl rel, jtf_rs_roles_vl rol
Where rel.role_resource_id = p_resource_id
And   rel.role_resource_type = G_RESOURCE_ROLE_CODE
And   rel.role_id = rol.role_id
And   rol.role_type_code = G_MES_ROLE_TYPE_NAME
Order by rol.role_code;

Line: 1996

Select
     role_relate_id
From  jtf_rs_role_relations_vl
Where role_id = p_role_id
And   role_resource_id = p_res_id
And   role_resource_type = G_RESOURCE_ROLE_CODE
;

Line: 2005

Select rel.role_relate_id
From  jtf_rs_role_relations_vl rel
,     jtf_rs_resource_extns res
Where rel.role_id = p_role_id
And   rel.role_resource_id = p_res_id
And   rel.role_resource_type = G_RESOURCE_ROLE_CODE
And   res.resource_id = rel.role_resource_id
And   rel.start_date_active < sysdate
And   nvl(rel.end_date_active, sysdate+1) > sysdate
And   res.start_date_active < sysdate
And   nvl(res.end_date_active, sysdate+1) > sysdate
;

Line: 2019

Select
     1
From  dual
Where exists
   (
     select r.role_id
     from jtf_rs_group_members m, jtf_rs_role_relations_vl r,
          jtf_rs_group_usages usg
     where m.resource_id = p_res_id
     and   m.delete_flag <> 'Y'
     and   m.group_id = r.role_resource_id
     and   r.role_resource_type = G_GROUP_ROLE_CODE
     and   r.role_id = p_role_id
     and   m.group_id = usg.group_id
     and   usg.usage = p_group_usage
   );

Line: 2037

Select
     1
From  dual
Where exists
   (
     select r.role_id
     from  jtf_rs_group_members m, jtf_rs_role_relations_vl r,
           jtf_rs_groups_vl g, jtf_rs_group_usages usg
     where m.resource_id = p_res_id
     and   m.delete_flag <> 'Y'
     and   m.group_id = r.role_resource_id
     and   r.role_id = p_role_id
     and   r.role_resource_type = G_GROUP_ROLE_CODE
     --and   r.role_type_code = G_MES_ROLE_TYPE_NAME
     and   r.start_date_active < sysdate
     and   nvl(r.end_date_active, sysdate+1) > sysdate
     and   g.group_id = m.group_id
     and   g.start_date_active < sysdate
     and   nvl(g.end_date_active, sysdate+1) > sysdate
     and   usg.group_id = g.group_id
     and   usg.usage = p_group_usage
   )
;

Line: 3023

Select
     rol.role_code,
     rol.role_id
From  jtf_rs_role_relations_vl rel, jtf_rs_roles_vl rol
Where rol.role_id = rel.role_id
And   rel.role_resource_id = p_group_id
And   rel.role_resource_type = G_GROUP_ROLE_CODE
And   rol.role_type_code = G_MES_ROLE_TYPE_NAME
Order by rol.role_code;

Line: 3150

Select
     role_relate_id
From  jtf_rs_role_relations_vl
Where role_id = p_role_id
And   role_resource_id = p_group_id
And   role_resource_type = G_GROUP_ROLE_CODE
;

Line: 3159

Select
     r.role_relate_id
From  jtf_rs_role_relations_vl r, jtf_rs_groups_vl g
Where r.role_id = p_role_id
And   r.role_resource_id = p_group_id
And   r.role_resource_type = G_GROUP_ROLE_CODE
And   r.start_date_active < sysdate
And   nvl(r.end_date_active, sysdate-1) < sysdate
And   g.group_id = p_group_id
And   g.start_date_active < sysdate
And   nvl(g.end_date_active, sysdate-1) < sysdate;

Line: 3308

Select g.group_id
From  jtf_rs_groups_vl g, jtf_rs_group_usages usg
Where g.group_name = p_group_name
And   g.start_date_active < sysdate
And   nvl(g.end_date_active, sysdate+1) > sysdate
And   usg.group_id = g.group_id
And   usg.usage = p_group_usage
;

Line: 3598

PROCEDURE Update_Group
(
    p_api_version         IN  NUMBER,
    p_init_msg_list       IN  VARCHAR2 := FND_API.G_FALSE,
    p_commit              IN  VARCHAR2 := FND_API.G_FALSE,
    p_validation_level    IN  NUMBER   := FND_API.G_VALID_LEVEL_FULL,
    x_return_status       OUT NOCOPY VARCHAR2,
    x_msg_count           OUT NOCOPY NUMBER,
    x_msg_data            OUT NOCOPY VARCHAR2,
    p_check_login_user    IN  VARCHAR2 := FND_API.G_TRUE,
    p_group_id            IN  NUMBER,
    p_new_group_name      IN  VARCHAR2 := FND_API.G_MISS_CHAR,
    p_new_group_desc      IN  VARCHAR2 := FND_API.G_MISS_CHAR,
    p_group_usage         IN  VARCHAR2 := G_MES_GROUP_USAGE,
    p_email_address       IN  VARCHAR2 := FND_API.G_MISS_CHAR,
    p_new_start_date      IN  DATE     := FND_API.G_MISS_DATE,
    p_new_end_date        IN  DATE     := FND_API.G_MISS_DATE
)  AS
l_api_name             CONSTANT VARCHAR2(30) := 'Update_Group';

Line: 3630

Select object_version_number
From  jtf_rs_groups_vl
Where group_id = p_group_id
;

Line: 3635

Select g.group_id
From  jtf_rs_groups_vl g, jtf_rs_group_usages usg
Where g.group_name = p_name
And   usg.group_id = g.group_id
And   usg.usage = p_group_usage
;

Line: 3642

Select subscribing_to_id channel_id
From amv_u_my_channels
Where user_or_group_id = p_g_id
And user_or_group_type = G_GROUP_ARC_TYPE
And subscribing_to_type = G_CHAN_ARC_TYPE
And subscription_reason_type = 'ENFORCED'
;

Line: 3652

    SAVEPOINT  Update_Group_Pvt;

Line: 3735

    jtf_rs_groups_pub.update_resource_group
    (
       p_api_version        => p_api_version,
       p_group_id           => p_group_id,
       p_group_number       => null,
       p_group_name         => p_new_group_name,
       p_group_desc         => p_new_group_desc,
       p_email_address      => p_email_address,
       p_start_date_active  => p_new_start_date,
       p_end_date_active    => p_new_end_date,
       p_object_version_num => l_object_version_num,
       x_return_status      => x_return_status,
       x_msg_count          => x_msg_count,
       x_msg_data           => x_msg_data
    );

Line: 3764

               update amv_c_channels_b set
                   EFFECTIVE_START_DATE = DECODE(p_new_start_date,
                                                 FND_API.G_MISS_DATE,
                                                 EFFECTIVE_START_DATE,
                                                 p_new_start_date),
                   EXPIRATION_DATE = DECODE(p_new_start_date,
                                            FND_API.G_MISS_DATE,
                                            EXPIRATION_DATE,
                                            p_new_start_date),
                   LAST_UPDATE_DATE = sysdate,
                   LAST_UPDATED_BY = l_current_user_id,
                   LAST_UPDATE_LOGIN = l_current_login_id,
                   OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
               where CHANNEL_ID = l_channel_id;

Line: 3780

               update amv_c_channels_tl set
                   CHANNEL_NAME = p_new_group_name,
                   LAST_UPDATE_DATE = sysdate,
                   LAST_UPDATED_BY = l_current_user_id,
                   LAST_UPDATE_LOGIN = l_current_login_id,
                   SOURCE_LANG = userenv('LANG')
               where CHANNEL_ID = l_channel_id
               and  userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 3804

       ROLLBACK TO  Update_Group_Pvt;

Line: 3813

       ROLLBACK TO  Update_Group_Pvt;

Line: 3822

       ROLLBACK TO  Update_Group_Pvt;

Line: 3833

END Update_Group;

Line: 3835

PROCEDURE Delete_Group
(
    p_api_version         IN  NUMBER,
    p_init_msg_list       IN  VARCHAR2 := FND_API.G_FALSE,
    p_commit              IN  VARCHAR2 := FND_API.G_FALSE,
    p_validation_level    IN  NUMBER   := FND_API.G_VALID_LEVEL_FULL,
    x_return_status       OUT NOCOPY VARCHAR2,
    x_msg_count           OUT NOCOPY NUMBER,
    x_msg_data            OUT NOCOPY VARCHAR2,
    p_check_login_user    IN  VARCHAR2 := FND_API.G_TRUE,
    p_group_id            IN  NUMBER   := FND_API.G_MISS_NUM,
    p_group_name          IN  VARCHAR2 := FND_API.G_MISS_CHAR
)  AS
l_api_name             CONSTANT VARCHAR2(30) := 'Delete_Group';

Line: 3860

Select group_id
From jtf_rs_groups_vl
Where group_name = p_name
;

Line: 3865

 SELECT CHANNEL_ID
 FROM AMV_C_CHANNELS_TL
 WHERE LANGUAGE = userenv('LANG') and
	  CHANNEL_NAME = (select group_name from
 jtf_rs_groups_tl where group_id = p_grp_id and language = userenv('LANG'));

Line: 3873

    SAVEPOINT Delete_Group_Pvt;

Line: 3924

    Delete from amv_u_access
    Where user_or_group_id = l_group_id
    And   User_OR_group_type = G_GROUP_ARC_TYPE;

Line: 3928

    Delete from amv_u_my_channels
    Where user_or_group_id = l_group_id
    And   User_OR_group_type = G_GROUP_ARC_TYPE;

Line: 3940

           AMV_C_CHANNELS_PKG.DELETE_ROW(l_channel_id);

Line: 3944

    Update_Group
      (
         p_api_version         => p_api_version,
         p_init_msg_list       => p_init_msg_list,
         p_commit              => p_commit,
         p_validation_level    => p_validation_level,
         x_return_status       => x_return_status,
         x_msg_count           => x_msg_count,
         x_msg_data            => x_msg_data,
         p_check_login_user    => p_check_login_user,
         p_group_id            => l_group_id,
         p_new_group_name      => FND_API.G_MISS_CHAR,
         p_new_group_desc      => FND_API.G_MISS_CHAR,
         p_email_address       => FND_API.G_MISS_CHAR,
         p_new_start_date      => sysdate -2,
         p_new_end_date        => sysdate -1
      );

Line: 3969

       ROLLBACK TO  Delete_Group_Pvt;

Line: 3978

       ROLLBACK TO  Delete_Group_Pvt;

Line: 3987

       ROLLBACK TO  Delete_Group_Pvt;

Line: 3998

END Delete_Group;

Line: 4020

Select
    group_id,
    group_name,
    object_version_number,
    email_address,
    group_desc,
    start_date_active,
    end_date_active
From  jtf_rs_groups_vl
Where group_id = p_group_id
;

Line: 4221

           'Select ' ||
               'g.group_id, ' ||
               'g.group_name, ' ||
               'g.object_version_number, ' ||
               'g.email_address, ' ||
               'g.group_desc, ' ||
               'g.start_date_active, ' ||
               'g.end_date_active ' ||
               'From  jtf_rs_groups_vl g, jtf_rs_group_usages usg ';

Line: 4231

           'Select count(*) ' ||
               'From  jtf_rs_groups_vl g, jtf_rs_group_usages usg ';

Line: 4239

           'Select ' ||
               'g.group_id, ' ||
               'g.group_name, ' ||
               'g.object_version_number, ' ||
               'g.email_address, ' ||
               'g.group_desc, ' ||
               'g.start_date_active, ' ||
               'g.end_date_active ' ||
               'From  jtf_rs_groups_vl g, jtf_rs_group_members m, ' ||
               '      jtf_rs_group_usages usg ';

Line: 4250

           'Select count(*) ' ||
               'From  jtf_rs_groups_vl g, jtf_rs_group_members m, ' ||
               '      jtf_rs_group_usages usg ';

Line: 4254

                          'And m.delete_flag <> ''Y'' ' ||
                          'And m.resource_id = ' || p_resource_id || ' ' ||
                          'And g.start_date_active < sysdate  ' ||
                          'And nvl(g.end_date_active, sysdate+1) > sysdate ' ||
                          'And usg.group_id = g.group_id ' ||
                          'And usg.usage = ''' || p_group_usage || ''' ';

Line: 4466

       'Select ' ||
           'g.group_id, ' ||
           'g.group_name, ' ||
           'g.object_version_number, ' ||
           'g.email_address, ' ||
           'g.group_desc, ' ||
           'g.start_date_active, ' ||
           'g.end_date_active ' ||
           'From  jtf_rs_groups_vl g, jtf_rs_group_usages usg ';

Line: 4476

       'Select count(*) ' ||
           'From  jtf_rs_groups_vl g, jtf_rs_group_usages usg ';

Line: 4628

Select group_member_id
From jtf_rs_group_members
Where resource_id = p_resource_id
And   group_id = p_group_id
And   delete_flag <> 'Y';

Line: 4945

Select object_version_number
From jtf_rs_group_members
Where resource_id = p_resource_id
And   group_id = p_group_id
And   delete_flag <> 'Y';

Line: 5012

       jtf_rs_group_members_pub.delete_resource_group_members
       (
          p_api_version        => 1.0,
          p_commit             => p_commit,
          p_group_id           => p_group_id,
          p_group_number       => null,
          p_resource_id        => p_resource_id,
          p_resource_number    => null,
          p_object_version_num => l_version,
          x_return_status      => x_return_status,
          x_msg_count          => x_msg_count,
          x_msg_data           => x_msg_data
       );

Line: 5247

Select m.group_member_id
From jtf_rs_group_members m, jtf_rs_groups_vl g
Where m.resource_id = p_resource_id
And   m.group_id = p_group_id
And   m.delete_flag <> 'Y'
And   g.group_id = p_group_id
And   g.start_date_active < sysdate
And   nvl(g.end_date_active, sysdate+1) > sysdate
;

Line: 5336

PROCEDURE Update_Access
(
    p_api_version         IN  NUMBER,
    p_init_msg_list       IN  VARCHAR2 := FND_API.G_FALSE,
    p_commit              IN  VARCHAR2 := FND_API.G_FALSE,
    p_validation_level    IN  NUMBER   := FND_API.G_VALID_LEVEL_FULL,
    x_return_status       OUT NOCOPY VARCHAR2,
    x_msg_count           OUT NOCOPY NUMBER,
    x_msg_data            OUT NOCOPY VARCHAR2,
    p_check_login_user    IN  VARCHAR2 := FND_API.G_TRUE,
    p_access_obj          IN  AMV_ACCESS_OBJ_TYPE
) AS
l_api_name             CONSTANT VARCHAR2(30) := 'Update_Access';

Line: 5360

Select access_id
From  amv_u_access
Where user_or_group_id = l_access_obj.user_or_group_id
And   user_or_group_type = l_access_obj.user_or_group_type
And   access_to_table_record_id = l_access_obj.access_to_table_record_id
And   access_to_table_code = l_access_obj.access_to_table_code;

Line: 5369

    SAVEPOINT  Update_Access_Pvt;

Line: 5544

        IF (l_access_obj.can_delete_flag IS NULL OR
            l_access_obj.can_delete_flag <> FND_API.G_TRUE) THEN
            l_access_obj.can_delete_flag := FND_API.G_FALSE;

Line: 5548

        IF (l_access_obj.can_update_flag IS NULL OR
            l_access_obj.can_update_flag <> FND_API.G_TRUE) THEN
            l_access_obj.can_update_flag := FND_API.G_FALSE;

Line: 5585

        IF (l_access_obj.can_delete_flag IS NULL) THEN
            l_access_obj.can_delete_flag := FND_API.G_MISS_CHAR;

Line: 5588

        IF (l_access_obj.can_update_flag IS NULL) THEN
            l_access_obj.can_update_flag := FND_API.G_MISS_CHAR;

Line: 5604

        Update_Access_helper
        (
            p_access_obj     => l_access_obj,
            x_return_status  => x_return_status
        );

Line: 5621

       ROLLBACK TO  Update_Access_Pvt;

Line: 5630

       ROLLBACK TO  Update_Access_Pvt;

Line: 5639

       ROLLBACK TO  Update_Access_Pvt;

Line: 5650

END Update_Access;

Line: 5652

PROCEDURE Update_Access
(
    p_api_version         IN  NUMBER,
    p_init_msg_list       IN  VARCHAR2 := FND_API.G_FALSE,
    p_commit              IN  VARCHAR2 := FND_API.G_FALSE,
    p_validation_level    IN  NUMBER   := FND_API.G_VALID_LEVEL_FULL,
    x_return_status       OUT NOCOPY VARCHAR2,
    x_msg_count           OUT NOCOPY NUMBER,
    x_msg_data            OUT NOCOPY VARCHAR2,
    p_check_login_user    IN  VARCHAR2 := FND_API.G_TRUE,
    p_access_obj_array    IN  AMV_ACCESS_OBJ_VARRAY
) AS
l_api_name             CONSTANT VARCHAR2(30) := 'Update_Access';

Line: 5677

    SAVEPOINT  Update_Access_Pvt;

Line: 5739

       Update_Access
       (
           p_api_version         => p_api_version,
           p_commit              => p_commit,
           p_validation_level    => p_validation_level,
           x_return_status       => l_return_status,
           x_msg_count           => x_msg_count,
           x_msg_data            => x_msg_data,
           p_check_login_user    => FND_API.G_FALSE,
           p_access_obj          => p_access_obj_array(i)
       );

Line: 5765

       ROLLBACK TO  Update_Access_Pvt;

Line: 5774

       ROLLBACK TO  Update_Access_Pvt;

Line: 5783

       ROLLBACK TO  Update_Access_Pvt;

Line: 5794

END Update_Access;

Line: 5796

PROCEDURE Update_ResourceApplAccess
(
    p_api_version         IN  NUMBER,
    p_init_msg_list       IN  VARCHAR2 := FND_API.G_FALSE,
    p_commit              IN  VARCHAR2 := FND_API.G_FALSE,
    p_validation_level    IN  NUMBER   := FND_API.G_VALID_LEVEL_FULL,
    x_return_status       OUT NOCOPY VARCHAR2,
    x_msg_count           OUT NOCOPY NUMBER,
    x_msg_data            OUT NOCOPY VARCHAR2,
    p_check_login_user    IN  VARCHAR2 := FND_API.G_TRUE,
    p_resource_id         IN  NUMBER,
    p_application_id      IN  NUMBER,
    p_access_flag_obj     IN  AMV_ACCESS_FLAG_OBJ_TYPE
) AS
l_access_obj      AMV_ACCESS_OBJ_TYPE;

Line: 5823

   l_access_obj.CAN_DELETE_FLAG := p_access_flag_obj.can_delete_flag;

Line: 5824

   l_access_obj.CAN_UPDATE_FLAG := p_access_flag_obj.can_update_flag;

Line: 5842

                     p_access_flag_obj.can_delete_flag,
                     p_access_flag_obj.can_update_flag,
                     p_access_flag_obj.can_create_dist_rule_flag,
                     p_access_flag_obj.chl_approver_flag,
                     p_access_flag_obj.chl_required_flag,
                     p_access_flag_obj.chl_required_need_notif_flag
                   );

Line: 5850

    Update_Access
    (
        p_api_version         => p_api_version,
        p_init_msg_list       => p_init_msg_list,
        p_commit              => p_commit,
        p_validation_level    => p_validation_level,
        x_return_status       => x_return_status,
        x_msg_count           => x_msg_count,
        x_msg_data            => x_msg_data,
        p_check_login_user    => p_check_login_user,
        p_access_obj          => l_access_obj
    );

Line: 5862

END Update_ResourceApplAccess;

Line: 5864

PROCEDURE Update_ResourceChanAccess
(
    p_api_version         IN  NUMBER,
    p_init_msg_list       IN  VARCHAR2 := FND_API.G_FALSE,
    p_commit              IN  VARCHAR2 := FND_API.G_FALSE,
    p_validation_level    IN  NUMBER   := FND_API.G_VALID_LEVEL_FULL,
    x_return_status       OUT NOCOPY VARCHAR2,
    x_msg_count           OUT NOCOPY NUMBER,
    x_msg_data            OUT NOCOPY VARCHAR2,
    p_check_login_user    IN  VARCHAR2 := FND_API.G_TRUE,
    p_resource_id         IN  NUMBER,
    p_channel_id          IN  NUMBER,
    p_access_flag_obj     IN  AMV_ACCESS_FLAG_OBJ_TYPE
) AS
l_access_obj      AMV_ACCESS_OBJ_TYPE;

Line: 5890

   l_access_obj.CAN_DELETE_FLAG := p_access_flag_obj.can_delete_flag;

Line: 5891

   l_access_obj.CAN_UPDATE_FLAG := p_access_flag_obj.can_update_flag;

Line: 5910

                     p_access_flag_obj.can_delete_flag,
                     p_access_flag_obj.can_update_flag,
                     p_access_flag_obj.can_create_dist_rule_flag,
                     p_access_flag_obj.chl_approver_flag,
                     p_access_flag_obj.chl_required_flag,
                     p_access_flag_obj.chl_required_need_notif_flag
                   );

Line: 5918

    Update_Access
    (
        p_api_version         => p_api_version,
        p_init_msg_list       => p_init_msg_list,
        p_commit              => p_commit,
        p_validation_level    => p_validation_level,
        x_return_status       => x_return_status,
        x_msg_count           => x_msg_count,
        x_msg_data            => x_msg_data,
        p_check_login_user    => p_check_login_user,
        p_access_obj          => l_access_obj
    );

Line: 5930

END Update_ResourceChanAccess;

Line: 5932

PROCEDURE Update_ResourceCateAccess
(
    p_api_version         IN  NUMBER,
    p_init_msg_list       IN  VARCHAR2 := FND_API.G_FALSE,
    p_commit              IN  VARCHAR2 := FND_API.G_FALSE,
    p_validation_level    IN  NUMBER   := FND_API.G_VALID_LEVEL_FULL,
    x_return_status       OUT NOCOPY VARCHAR2,
    x_msg_count           OUT NOCOPY NUMBER,
    x_msg_data            OUT NOCOPY VARCHAR2,
    p_check_login_user    IN  VARCHAR2 := FND_API.G_TRUE,
    p_resource_id         IN  NUMBER,
    p_category_id         IN  NUMBER,
    p_access_flag_obj     IN  AMV_ACCESS_FLAG_OBJ_TYPE
) AS
l_access_obj      AMV_ACCESS_OBJ_TYPE;

Line: 5958

   l_access_obj.CAN_DELETE_FLAG := p_access_flag_obj.can_delete_flag;

Line: 5959

   l_access_obj.CAN_UPDATE_FLAG := p_access_flag_obj.can_update_flag;

Line: 5978

                     p_access_flag_obj.can_delete_flag,
                     p_access_flag_obj.can_update_flag,
                     p_access_flag_obj.can_create_dist_rule_flag,
                     p_access_flag_obj.chl_approver_flag,
                     p_access_flag_obj.chl_required_flag,
                     p_access_flag_obj.chl_required_need_notif_flag
                   );

Line: 5986

    Update_Access
    (
        p_api_version         => p_api_version,
        p_init_msg_list       => p_init_msg_list,
        p_commit              => p_commit,
        p_validation_level    => p_validation_level,
        x_return_status       => x_return_status,
        x_msg_count           => x_msg_count,
        x_msg_data            => x_msg_data,
        p_check_login_user    => p_check_login_user,
        p_access_obj          => l_access_obj
    );

Line: 5998

END Update_ResourceCateAccess;

Line: 6000

PROCEDURE Update_ResourceItemAccess
(
    p_api_version         IN  NUMBER,
    p_init_msg_list       IN  VARCHAR2 := FND_API.G_FALSE,
    p_commit              IN  VARCHAR2 := FND_API.G_FALSE,
    p_validation_level    IN  NUMBER   := FND_API.G_VALID_LEVEL_FULL,
    x_return_status       OUT NOCOPY VARCHAR2,
    x_msg_count           OUT NOCOPY NUMBER,
    x_msg_data            OUT NOCOPY VARCHAR2,
    p_check_login_user    IN  VARCHAR2 := FND_API.G_TRUE,
    p_resource_id         IN  NUMBER,
    p_item_id             IN  NUMBER,
    p_access_flag_obj     IN  AMV_ACCESS_FLAG_OBJ_TYPE
) AS
l_access_obj      AMV_ACCESS_OBJ_TYPE;

Line: 6026

   l_access_obj.CAN_DELETE_FLAG := p_access_flag_obj.can_delete_flag;

Line: 6027

   l_access_obj.CAN_UPDATE_FLAG := p_access_flag_obj.can_update_flag;

Line: 6046

                     p_access_flag_obj.can_delete_flag,
                     p_access_flag_obj.can_update_flag,
                     p_access_flag_obj.can_create_dist_rule_flag,
                     p_access_flag_obj.chl_approver_flag,
                     p_access_flag_obj.chl_required_flag,
                     p_access_flag_obj.chl_required_need_notif_flag
                   );

Line: 6054

    Update_Access
    (
        p_api_version         => p_api_version,
        p_init_msg_list       => p_init_msg_list,
        p_commit              => p_commit,
        p_validation_level    => p_validation_level,
        x_return_status       => x_return_status,
        x_msg_count           => x_msg_count,
        x_msg_data            => x_msg_data,
        p_check_login_user    => p_check_login_user,
        p_access_obj          => l_access_obj
    );

Line: 6066

END Update_ResourceItemAccess;

Line: 6068

PROCEDURE Update_GroupApplAccess
(
    p_api_version         IN  NUMBER,
    p_init_msg_list       IN  VARCHAR2 := FND_API.G_FALSE,
    p_commit              IN  VARCHAR2 := FND_API.G_FALSE,
    p_validation_level    IN  NUMBER   := FND_API.G_VALID_LEVEL_FULL,
    x_return_status       OUT NOCOPY VARCHAR2,
    x_msg_count           OUT NOCOPY NUMBER,
    x_msg_data            OUT NOCOPY VARCHAR2,
    p_check_login_user    IN  VARCHAR2 := FND_API.G_TRUE,
    p_resource_id         IN  NUMBER,
    p_group_id            IN  NUMBER,
    p_application_id      IN  NUMBER,
    p_access_flag_obj     IN  AMV_ACCESS_FLAG_OBJ_TYPE
) AS
l_access_obj      AMV_ACCESS_OBJ_TYPE;

Line: 6095

   l_access_obj.CAN_DELETE_FLAG := p_access_flag_obj.can_delete_flag;

Line: 6096

   l_access_obj.CAN_UPDATE_FLAG := p_access_flag_obj.can_update_flag;

Line: 6115

                     p_access_flag_obj.can_delete_flag,
                     p_access_flag_obj.can_update_flag,
                     p_access_flag_obj.can_create_dist_rule_flag,
                     p_access_flag_obj.chl_approver_flag,
                     p_access_flag_obj.chl_required_flag,
                     p_access_flag_obj.chl_required_need_notif_flag
                   );

Line: 6123

    Update_Access
    (
        p_api_version         => p_api_version,
        p_init_msg_list       => p_init_msg_list,
        p_commit              => p_commit,
        p_validation_level    => p_validation_level,
        x_return_status       => x_return_status,
        x_msg_count           => x_msg_count,
        x_msg_data            => x_msg_data,
        p_check_login_user    => p_check_login_user,
        p_access_obj          => l_access_obj
    );

Line: 6135

END Update_GroupApplAccess;

Line: 6137

PROCEDURE Update_GroupChanAccess
(
    p_api_version         IN  NUMBER,
    p_init_msg_list       IN  VARCHAR2 := FND_API.G_FALSE,
    p_commit              IN  VARCHAR2 := FND_API.G_FALSE,
    p_validation_level    IN  NUMBER   := FND_API.G_VALID_LEVEL_FULL,
    x_return_status       OUT NOCOPY VARCHAR2,
    x_msg_count           OUT NOCOPY NUMBER,
    x_msg_data            OUT NOCOPY VARCHAR2,
    p_check_login_user    IN  VARCHAR2 := FND_API.G_TRUE,
    p_group_id            IN  NUMBER,
    p_channel_id          IN  NUMBER,
    p_access_flag_obj     IN  AMV_ACCESS_FLAG_OBJ_TYPE
) AS
l_access_obj      AMV_ACCESS_OBJ_TYPE;

Line: 6163

   l_access_obj.CAN_DELETE_FLAG := p_access_flag_obj.can_delete_flag;

Line: 6164

   l_access_obj.CAN_UPDATE_FLAG := p_access_flag_obj.can_update_flag;

Line: 6183

                     p_access_flag_obj.can_delete_flag,
                     p_access_flag_obj.can_update_flag,
                     p_access_flag_obj.can_create_dist_rule_flag,
                     p_access_flag_obj.chl_approver_flag,
                     p_access_flag_obj.chl_required_flag,
                     p_access_flag_obj.chl_required_need_notif_flag
                   );

Line: 6191

    Update_Access
    (
        p_api_version         => p_api_version,
        p_init_msg_list       => p_init_msg_list,
        p_commit              => p_commit,
        p_validation_level    => p_validation_level,
        x_return_status       => x_return_status,
        x_msg_count           => x_msg_count,
        x_msg_data            => x_msg_data,
        p_check_login_user    => p_check_login_user,
        p_access_obj          => l_access_obj
    );

Line: 6203

END Update_GroupChanAccess;

Line: 6205

PROCEDURE Update_GroupCateAccess
(
    p_api_version         IN  NUMBER,
    p_init_msg_list       IN  VARCHAR2 := FND_API.G_FALSE,
    p_commit              IN  VARCHAR2 := FND_API.G_FALSE,
    p_validation_level    IN  NUMBER   := FND_API.G_VALID_LEVEL_FULL,
    x_return_status       OUT NOCOPY VARCHAR2,
    x_msg_count           OUT NOCOPY NUMBER,
    x_msg_data            OUT NOCOPY VARCHAR2,
    p_check_login_user    IN  VARCHAR2 := FND_API.G_TRUE,
    p_group_id            IN  NUMBER,
    p_category_id         IN  NUMBER,
    p_access_flag_obj     IN  AMV_ACCESS_FLAG_OBJ_TYPE
) AS
l_access_obj      AMV_ACCESS_OBJ_TYPE;

Line: 6231

   l_access_obj.CAN_DELETE_FLAG := p_access_flag_obj.can_delete_flag;

Line: 6232

   l_access_obj.CAN_UPDATE_FLAG := p_access_flag_obj.can_update_flag;

Line: 6251

                     p_access_flag_obj.can_delete_flag,
                     p_access_flag_obj.can_update_flag,
                     p_access_flag_obj.can_create_dist_rule_flag,
                     p_access_flag_obj.chl_approver_flag,
                     p_access_flag_obj.chl_required_flag,
                     p_access_flag_obj.chl_required_need_notif_flag
                   );

Line: 6259

    Update_Access
    (
        p_api_version         => p_api_version,
        p_init_msg_list       => p_init_msg_list,
        p_commit              => p_commit,
        p_validation_level    => p_validation_level,
        x_return_status       => x_return_status,
        x_msg_count           => x_msg_count,
        x_msg_data            => x_msg_data,
        p_check_login_user    => p_check_login_user,
        p_access_obj          => l_access_obj
    );

Line: 6271

END Update_GroupCateAccess;

Line: 6273

PROCEDURE Update_GroupItemAccess
(
    p_api_version         IN  NUMBER,
    p_init_msg_list       IN  VARCHAR2 := FND_API.G_FALSE,
    p_commit              IN  VARCHAR2 := FND_API.G_FALSE,
    p_validation_level    IN  NUMBER   := FND_API.G_VALID_LEVEL_FULL,
    x_return_status       OUT NOCOPY VARCHAR2,
    x_msg_count           OUT NOCOPY NUMBER,
    x_msg_data            OUT NOCOPY VARCHAR2,
    p_check_login_user    IN  VARCHAR2 := FND_API.G_TRUE,
    p_group_id            IN  NUMBER,
    p_item_id             IN  NUMBER,
    p_access_flag_obj     IN  AMV_ACCESS_FLAG_OBJ_TYPE
) AS
l_access_obj      AMV_ACCESS_OBJ_TYPE;

Line: 6299

   l_access_obj.CAN_DELETE_FLAG := p_access_flag_obj.can_delete_flag;

Line: 6300

   l_access_obj.CAN_UPDATE_FLAG := p_access_flag_obj.can_update_flag;

Line: 6319

                     p_access_flag_obj.can_delete_flag,
                     p_access_flag_obj.can_update_flag,
                     p_access_flag_obj.can_create_dist_rule_flag,
                     p_access_flag_obj.chl_approver_flag,
                     p_access_flag_obj.chl_required_flag,
                     p_access_flag_obj.chl_required_need_notif_flag
                   );

Line: 6327

    Update_Access
    (
        p_api_version         => p_api_version,
        p_init_msg_list       => p_init_msg_list,
        p_commit              => p_commit,
        p_validation_level    => p_validation_level,
        x_return_status       => x_return_status,
        x_msg_count           => x_msg_count,
        x_msg_data            => x_msg_data,
        p_check_login_user    => p_check_login_user,
        p_access_obj          => l_access_obj
    );

Line: 6339

END Update_GroupItemAccess;

Line: 6365

Select
   C.CHANNEL_NAME,
   U.ACCESS_TO_TABLE_RECORD_ID,
   U.ACCESS_ID,
   U.OBJECT_VERSION_NUMBER,
   U.EFFECTIVE_START_DATE,
   U.EXPIRATION_DATE,
   U.CAN_VIEW_FLAG,
   U.CAN_CREATE_FLAG,
   U.CAN_DELETE_FLAG,
   U.CAN_UPDATE_FLAG,
   U.CAN_CREATE_DIST_RULE_FLAG,
   U.CHL_APPROVER_FLAG,
   U.CHL_REQUIRED_FLAG,
   U.CHL_REQUIRED_NEED_NOTIF_FLAG
From  amv_u_access u, amv_c_channels_vl c
Where u.user_or_group_id = p_user_or_group_id
And   u.user_or_group_type = p_user_or_group_type
And   access_to_table_code = G_CHAN_ARC_TYPE
And   u.access_to_table_record_id = c.channel_id;

Line: 6438

        x_access_obj_varray(l_count).CAN_DELETE_FLAG := cur.CAN_DELETE_FLAG;

Line: 6439

        x_access_obj_varray(l_count).CAN_UPDATE_FLAG := cur.CAN_UPDATE_FLAG;

Line: 6456

          cur.CAN_DELETE_FLAG,
          cur.CAN_UPDATE_FLAG,
          cur.CAN_CREATE_DIST_RULE_FLAG,
          cur.CHL_APPROVER_FLAG,
          cur.CHL_REQUIRED_FLAG,
          cur.CHL_REQUIRED_NEED_NOTIF_FLAG
          );

Line: 6524

Select
   G.GROUP_NAME NAME,
   U.USER_OR_GROUP_ID,
   U.USER_OR_GROUP_TYPE,
   U.ACCESS_TO_TABLE_RECORD_ID,
   U.ACCESS_TO_TABLE_CODE,
   U.ACCESS_ID,
   U.OBJECT_VERSION_NUMBER,
   U.EFFECTIVE_START_DATE,
   U.EXPIRATION_DATE,
   U.CAN_VIEW_FLAG,
   U.CAN_CREATE_FLAG,
   U.CAN_DELETE_FLAG,
   U.CAN_UPDATE_FLAG,
   U.CAN_CREATE_DIST_RULE_FLAG,
   U.CHL_APPROVER_FLAG,
   U.CHL_REQUIRED_FLAG,
   U.CHL_REQUIRED_NEED_NOTIF_FLAG
From  amv_u_access u, jtf_rs_groups_vl g
Where u.user_or_group_id = g.group_id
And   u.user_or_group_type = G_GROUP_ARC_TYPE
And   access_to_table_code = G_CHAN_ARC_TYPE
And   u.access_to_table_record_id = p_channel_id;

Line: 6549

Select
   R.LAST_NAME || ', ' || R.FIRST_NAME NAME,
   U.USER_OR_GROUP_ID,
   U.USER_OR_GROUP_TYPE,
   U.ACCESS_TO_TABLE_RECORD_ID,
   U.ACCESS_TO_TABLE_CODE,
   U.ACCESS_ID,
   U.OBJECT_VERSION_NUMBER,
   U.EFFECTIVE_START_DATE,
   U.EXPIRATION_DATE,
   U.CAN_VIEW_FLAG,
   U.CAN_CREATE_FLAG,
   U.CAN_DELETE_FLAG,
   U.CAN_UPDATE_FLAG,
   U.CAN_CREATE_DIST_RULE_FLAG,
   U.CHL_APPROVER_FLAG,
   U.CHL_REQUIRED_FLAG,
   U.CHL_REQUIRED_NEED_NOTIF_FLAG
From  amv_u_access u, amv_rs_all_res_extns_vl r
Where u.user_or_group_id = r.resource_id
And   u.user_or_group_type = G_USER_ARC_TYPE
And   access_to_table_code = G_CHAN_ARC_TYPE
And   u.access_to_table_record_id = p_channel_id;

Line: 6626

            x_access_obj_varray(l_count).CAN_DELETE_FLAG := cur.CAN_DELETE_FLAG;

Line: 6627

            x_access_obj_varray(l_count).CAN_UPDATE_FLAG := cur.CAN_UPDATE_FLAG;

Line: 6645

              cur.CAN_DELETE_FLAG,
              cur.CAN_UPDATE_FLAG,
              cur.CAN_CREATE_DIST_RULE_FLAG,
              cur.CHL_APPROVER_FLAG,
              cur.CHL_REQUIRED_FLAG,
              cur.CHL_REQUIRED_NEED_NOTIF_FLAG
              );

Line: 6671

            x_access_obj_varray(l_count).CAN_DELETE_FLAG := cur.CAN_DELETE_FLAG;

Line: 6672

            x_access_obj_varray(l_count).CAN_UPDATE_FLAG := cur.CAN_UPDATE_FLAG;

Line: 6689

              cur.CAN_DELETE_FLAG,
              cur.CAN_UPDATE_FLAG,
              cur.CAN_CREATE_DIST_RULE_FLAG,
              cur.CHL_APPROVER_FLAG,
              cur.CHL_REQUIRED_FLAG,
              cur.CHL_REQUIRED_NEED_NOTIF_FLAG
              );

Line: 6759

Select
   ACCESS_ID,
   OBJECT_VERSION_NUMBER,
   EFFECTIVE_START_DATE,
   EXPIRATION_DATE,
   CAN_VIEW_FLAG,
   CAN_CREATE_FLAG,
   CAN_DELETE_FLAG,
   CAN_UPDATE_FLAG,
   CAN_CREATE_DIST_RULE_FLAG,
   CHL_APPROVER_FLAG,
   CHL_REQUIRED_FLAG,
   CHL_REQUIRED_NEED_NOTIF_FLAG
From  amv_u_access
Where user_or_group_id = p_user_or_group_id
And   user_or_group_type = p_user_or_group_type
And   access_to_table_record_id = p_business_object_id
And   access_to_table_code = p_business_object_type;

Line: 6804

    x_access_obj.CAN_DELETE_FLAG := FND_API.G_FALSE;

Line: 6805

    x_access_obj.CAN_UPDATE_FLAG := FND_API.G_FALSE;

Line: 6858

          x_access_obj.CAN_DELETE_FLAG,
          x_access_obj.CAN_UPDATE_FLAG,
          x_access_obj.CAN_CREATE_DIST_RULE_FLAG,
          x_access_obj.CHL_APPROVER_FLAG,
          x_access_obj.CHL_REQUIRED_FLAG,
          x_access_obj.CHL_REQUIRED_NEED_NOTIF_FLAG;

Line: 6929

Select
   effective_start_date,
   expiration_date
From  amv_c_channels_b
Where channel_id = p_id;

Line: 6936

Select
   actual_avail_from_date effective_start_date,
   actual_avail_to_date   expiration_date
From  ams_deliverables_all_b
Where deliverable_id = p_id;

Line: 6943

Select
   CAN_VIEW_FLAG,
   CAN_CREATE_FLAG,
   CAN_DELETE_FLAG,
   CAN_UPDATE_FLAG,
   CAN_CREATE_DIST_RULE_FLAG,
   CHL_APPROVER_FLAG,
   CHL_REQUIRED_FLAG,
   CHL_REQUIRED_NEED_NOTIF_FLAG
From  amv_u_access
Where user_or_group_id = p_user_or_group_id
And   user_or_group_type = p_user_or_group_type
And   access_to_table_record_id = p_business_object_id
And   access_to_table_code = p_business_object_type;

Line: 6959

Select A.CAN_VIEW_FLAG,
   	  A.CAN_CREATE_FLAG,
   	  A.CAN_DELETE_FLAG,
   	  A.CAN_UPDATE_FLAG,
   	  A.CAN_CREATE_DIST_RULE_FLAG,
   	  A.CHL_APPROVER_FLAG,
   	  A.CHL_REQUIRED_FLAG,
   	  A.CHL_REQUIRED_NEED_NOTIF_FLAG
From  amv_u_access a
,     jtf_rs_resource_extns r
Where a.user_or_group_id = p_user_or_group_id
And   a.user_or_group_type = G_USER_ARC_TYPE
And   a.access_to_table_record_id = p_business_object_id
And   a.access_to_table_code = p_business_object_type
And   nvl(a.effective_start_date, sysdate-1) < sysdate
And   nvl(a.expiration_date, sysdate+1) > sysdate
And   r.resource_id = a.user_or_group_id
--And   r.active_flag = 'Y'
;

Line: 6980

Select
   A.CAN_VIEW_FLAG,
   A.CAN_CREATE_FLAG,
   A.CAN_DELETE_FLAG,
   A.CAN_UPDATE_FLAG,
   A.CAN_CREATE_DIST_RULE_FLAG,
   A.CHL_APPROVER_FLAG,
   A.CHL_REQUIRED_FLAG,
   A.CHL_REQUIRED_NEED_NOTIF_FLAG
From  amv_u_access a,  jtf_rs_groups_vl g
Where a.user_or_group_id = p_user_or_group_id
And   a.user_or_group_type = G_GROUP_ARC_TYPE
And   a.access_to_table_record_id = p_business_object_id
And   a.access_to_table_code = p_business_object_type
And   nvl(a.effective_start_date, sysdate-1) < sysdate
And   nvl(a.expiration_date, sysdate+1) > sysdate
And   g.group_id = a.user_or_group_id
And   nvl(g.start_date_active, sysdate-1) < sysdate
And   nvl(g.end_date_active, sysdate+1) > sysdate;

Line: 7001

Select
   A.CAN_VIEW_FLAG,
   A.CAN_CREATE_FLAG,
   A.CAN_DELETE_FLAG,
   A.CAN_UPDATE_FLAG,
   A.CAN_CREATE_DIST_RULE_FLAG,
   A.CHL_APPROVER_FLAG,
   A.CHL_REQUIRED_FLAG,
   A.CHL_REQUIRED_NEED_NOTIF_FLAG
From  amv_u_access a, jtf_rs_group_members m
Where a.access_to_table_record_id = p_business_object_id
And   a.access_to_table_code = p_business_object_type
And   a.user_or_group_type = G_GROUP_ARC_TYPE
And   a.user_or_group_id = m.group_id
And   m.resource_id = p_user_or_group_id;

Line: 7018

Select
   A.CAN_VIEW_FLAG,
   A.CAN_CREATE_FLAG,
   A.CAN_DELETE_FLAG,
   A.CAN_UPDATE_FLAG,
   A.CAN_CREATE_DIST_RULE_FLAG,
   A.CHL_APPROVER_FLAG,
   A.CHL_REQUIRED_FLAG,
   A.CHL_REQUIRED_NEED_NOTIF_FLAG
From  amv_u_access a, jtf_rs_group_members m, jtf_rs_groups_vl g
Where a.access_to_table_record_id = p_business_object_id
And   a.access_to_table_code =p_business_object_type
And   nvl(a.effective_start_date, sysdate-1) < sysdate
And   nvl(a.expiration_date, sysdate+1) > sysdate
And   a.user_or_group_type = G_GROUP_ARC_TYPE
And   a.user_or_group_id = m.group_id
And   m.resource_id = p_user_or_group_id
--And   nvl(m.start_date_active, sysdate-1) < sysdate
--And   nvl(m.end_date_active, sysdate+1) > sysdate
And   g.group_id = m.group_id
And   nvl(g.start_date_active, sysdate-1) < sysdate
And   nvl(g.end_date_active, sysdate+1) > sysdate;

Line: 7059

    x_access_flag_obj.CAN_DELETE_FLAG := FND_API.G_FALSE;

Line: 7060

    x_access_flag_obj.CAN_UPDATE_FLAG := FND_API.G_FALSE;

Line: 7143

                x_access_flag_obj.CAN_DELETE_FLAG,
                x_access_flag_obj.CAN_UPDATE_FLAG,
                x_access_flag_obj.CAN_CREATE_DIST_RULE_FLAG,
                x_access_flag_obj.CHL_APPROVER_FLAG,
                x_access_flag_obj.CHL_REQUIRED_FLAG,
                x_access_flag_obj.CHL_REQUIRED_NEED_NOTIF_FLAG;

Line: 7155

                x_access_flag_obj.CAN_DELETE_FLAG,
                x_access_flag_obj.CAN_UPDATE_FLAG,
                x_access_flag_obj.CAN_CREATE_DIST_RULE_FLAG,
                x_access_flag_obj.CHL_APPROVER_FLAG,
                x_access_flag_obj.CHL_REQUIRED_FLAG,
                x_access_flag_obj.CHL_REQUIRED_NEED_NOTIF_FLAG;

Line: 7170

                IF (csr1.CAN_DELETE_FLAG = FND_API.G_TRUE) THEN
                    x_access_flag_obj.CAN_DELETE_FLAG := FND_API.G_TRUE;

Line: 7173

                IF (csr1.CAN_UPDATE_FLAG = FND_API.G_TRUE) THEN
                    x_access_flag_obj.CAN_UPDATE_FLAG := FND_API.G_TRUE;

Line: 7198

             x_access_flag_obj.CAN_DELETE_FLAG,
             x_access_flag_obj.CAN_UPDATE_FLAG,
             x_access_flag_obj.CAN_CREATE_DIST_RULE_FLAG,
             x_access_flag_obj.CHL_APPROVER_FLAG,
             x_access_flag_obj.CHL_REQUIRED_FLAG,
             x_access_flag_obj.CHL_REQUIRED_NEED_NOTIF_FLAG;

Line: 7215

             IF (csr1.CAN_DELETE_FLAG = FND_API.G_TRUE) THEN
                 x_access_flag_obj.CAN_DELETE_FLAG := FND_API.G_TRUE;

Line: 7218

             IF (csr1.CAN_UPDATE_FLAG = FND_API.G_TRUE) THEN
                 x_access_flag_obj.CAN_UPDATE_FLAG := FND_API.G_TRUE;