APPS.FEM_INTG_PL_PKG SQL Statements

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

Line: 30

  FUNCTION Can_Delete_Object_Def(p_object_definition_id NUMBER)
  RETURN VARCHAR2 IS
    can_delete	VARCHAR2(1);

Line: 36

    FEM_PL_PKG.can_delete_object_def(
	p_object_definition_id	=> p_object_definition_id,
	x_can_delete_obj_def	=> can_delete,
	x_msg_count		=> msg_count,
	x_msg_data		=> msg_data,
	p_calling_program	=> 'can_delete_object');

Line: 43

    return can_delete;

Line: 44

  END Can_Delete_Object_Def;

Line: 54

    SELECT dim_rule_obj_id
    FROM   fem_intg_dim_rules
    WHERE  chart_of_accounts_id = p_chart_of_accounts_id;

Line: 63

    SELECT exec_status_code
    FROM   fem_pl_object_executions
    WHERE  object_id = c_object_id
    ORDER BY event_order desc;

Line: 163

      p_last_update_login      => p_login_id,
      p_program_id             => p_pgm_id,
      p_program_login_id       => p_login_id,
      p_program_application_id => p_pgm_app_id,
      p_exec_mode_code         => 'S',
      p_dimension_id           => NULL,
      p_table_name             => NULL,
      p_hierarchy_name         => p_hierarchy_name,
      x_msg_count              => v_msg_count,
      x_msg_data               => v_msg_data,
      x_return_status          => v_return_status
    );

Line: 197

      p_last_update_login         => p_login_id,
      p_exec_mode_code            => 'S',
      x_exec_state                => v_exec_state,
      x_prev_request_id           => v_prev_request_id,
      x_msg_count                 => v_msg_count,
      x_msg_data                  => v_msg_data,
      x_return_status             => v_return_status
    );

Line: 231

      p_last_update_login    => p_login_id,
      x_msg_count            => v_msg_count,
      x_msg_data             => v_msg_data,
      x_return_status        => v_return_status
    );

Line: 448

    FEM_PL_PKG.Update_Obj_Exec_Errors(
      p_api_version       => pc_api_version,
      p_commit            => 'T',
      p_request_id        => p_req_id,
      p_object_id         => p_obj_id,
      p_errors_reported	  => p_err_num_count,
      p_errors_reprocessed => 0,
      p_user_id           => p_user_id,
      p_last_update_login => p_login_id,
      x_msg_count         => v_msg_count,
      x_msg_data          => v_msg_data,
      x_return_status     => v_return_status
    );

Line: 483

    FEM_PL_PKG.Update_Obj_Exec_Status(
      p_api_version       => pc_api_version,
      p_commit            => 'T',
      p_request_id        => p_req_id,
      p_object_id         => p_obj_id,
      p_exec_status_code  => p_exec_status,
      p_user_id           => p_user_id,
      p_last_update_login => p_login_id,
      x_msg_count         => v_msg_count,
      x_msg_data          => v_msg_data,
      x_return_status     => v_return_status
    );

Line: 518

    FEM_PL_PKG.Update_Request_Status(
      p_api_version       => pc_api_version,
      p_commit            => 'T',
      p_request_id        => p_req_id,
      p_exec_status_code  => p_exec_status,
      p_user_id           => p_user_id,
      p_last_update_login => p_login_id,
      x_msg_count         => v_msg_count,
      x_msg_data          => v_msg_data,
      x_return_status     => v_return_status
    );