APPS.AS_ACCESS_PUB_W2 SQL Statements

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

Line: 22

  procedure has_updatepersonaccess(p_api_version_number  NUMBER
    , p_init_msg_list  VARCHAR2
    , p_validation_level  NUMBER
    , p_admin_flag  VARCHAR2
    , p_admin_group_id  NUMBER
    , p_person_id  NUMBER
    , p_security_id  NUMBER
    , p_security_type  VARCHAR2
    , p_person_party_id  NUMBER
    , p_check_access_flag  VARCHAR2
    , p_identity_salesforce_id  NUMBER
    , p_partner_cont_party_id  NUMBER
    , x_return_status out  VARCHAR2
    , x_msg_count out  NUMBER
    , x_msg_data out  VARCHAR2
    , x_update_access_flag out  VARCHAR2
    , p3_a0  VARCHAR2 := fnd_api.g_miss_char
    , p3_a1  VARCHAR2 := fnd_api.g_miss_char
    , p3_a2  VARCHAR2 := fnd_api.g_miss_char
    , p3_a3  VARCHAR2 := fnd_api.g_miss_char
    , p3_a4  VARCHAR2 := fnd_api.g_miss_char
  )

  as
    ddp_access_profile_rec as_access_pub.access_profile_rec_type;

Line: 57

    ddp_access_profile_rec.mgr_update_profile_value := p3_a3;

Line: 58

    ddp_access_profile_rec.admin_update_profile_value := p3_a4;

Line: 74

    as_access_pub.has_updatepersonaccess(p_api_version_number,
      p_init_msg_list,
      p_validation_level,
      ddp_access_profile_rec,
      p_admin_flag,
      p_admin_group_id,
      p_person_id,
      p_security_id,
      p_security_type,
      p_person_party_id,
      p_check_access_flag,
      p_identity_salesforce_id,
      p_partner_cont_party_id,
      x_return_status,
      x_msg_count,
      x_msg_data,
      x_update_access_flag);

Line: 146

    ddp_access_profile_rec.mgr_update_profile_value := p3_a3;

Line: 147

    ddp_access_profile_rec.admin_update_profile_value := p3_a4;

Line: 233

    ddp_access_profile_rec.mgr_update_profile_value := p3_a3;

Line: 234

    ddp_access_profile_rec.admin_update_profile_value := p3_a4;

Line: 314

    ddp_access_profile_rec.mgr_update_profile_value := p3_a3;

Line: 315

    ddp_access_profile_rec.admin_update_profile_value := p3_a4;

Line: 395

    ddp_access_profile_rec.mgr_update_profile_value := p3_a3;

Line: 396

    ddp_access_profile_rec.admin_update_profile_value := p3_a4;

Line: 478

    ddp_access_profile_rec.mgr_update_profile_value := p3_a3;

Line: 479

    ddp_access_profile_rec.admin_update_profile_value := p3_a4;

Line: 565

    ddp_access_profile_rec.mgr_update_profile_value := p3_a3;

Line: 566

    ddp_access_profile_rec.admin_update_profile_value := p3_a4;

Line: 646

    ddp_access_profile_rec.mgr_update_profile_value := p3_a3;

Line: 647

    ddp_access_profile_rec.admin_update_profile_value := p3_a4;