APPS.HZ_CUST_ACCT_CONTACT_BO_PVT SQL Statements

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

Line: 347

        HZ_CUST_ACCOUNT_ROLE_V2PUB.update_role_responsibility (
          p_role_responsibility_rec   => l_rr_rec,
          p_object_version_number     => l_ovn,
          x_return_status             => x_return_status,
          x_msg_count                 => x_msg_count,
          x_msg_data                  => x_msg_data
        );

Line: 494

    p_create_update_flag      IN            VARCHAR2,
    p_obj_source              IN            VARCHAR2 := null,
    x_return_status           OUT NOCOPY    VARCHAR2,
    x_msg_count               OUT NOCOPY    NUMBER,
    x_msg_data                OUT NOCOPY    VARCHAR2,
    p_parent_id               IN            NUMBER,
    p_parent_os               IN            VARCHAR2,
    p_parent_osr              IN            VARCHAR2,
    p_parent_obj_type         IN            VARCHAR2
  ) IS
    l_debug_prefix            VARCHAR2(30) := '';

Line: 531

    IF(p_create_update_flag = 'C') THEN
      -- Create cust account contact
      FOR i IN 1..p_cac_objs.COUNT LOOP
        HZ_CUST_ACCT_CONTACT_BO_PUB.do_create_cac_bo(
          p_init_msg_list           => fnd_api.g_false,
          p_validate_bo_flag        => fnd_api.g_false,
          p_cust_acct_contact_obj   => p_cac_objs(i),
          p_created_by_module       => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,
          p_obj_source              => p_obj_source,
          x_return_status           => x_return_status,
          x_msg_count               => x_msg_count,
          x_msg_data                => x_msg_data,
          x_cust_acct_contact_id    => l_cac_id,
          x_cust_acct_contact_os    => l_cac_os,
          x_cust_acct_contact_osr   => l_cac_osr,
          px_parent_id              => l_parent_id,
          px_parent_os              => l_parent_os,
          px_parent_osr             => l_parent_osr,
          px_parent_obj_type        => l_parent_obj_type
        );