PACKAGE: APPS.AD_FILE_SYS_SNAPSHOTS_PKG

Source

1 package ad_file_sys_snapshots_pkg as
2 /* $Header: adfssnps.pls 120.0.12010000.1 2008/07/25 08:03:18 appldev ship $ */
3 
4 -- ACTION code to use when inserting into the temp table for use with
5 -- update_current_view() with p_patch_runs_spec = 'IN_TEMP_TAB'
6 
7 G_PR_ID_ACT_CD constant number := 20;
8 
9 
10 -- return codes when instantiating a current-view snapshot
11 
12 G_SNAPSHOT_MAINT_DISALLOWED  constant varchar2(2) := 'NA';
13 G_ALREADY_INSTANTIATED       constant varchar2(2) := 'AI';
14 G_NO_PRESEEDED_BASELINE      constant varchar2(3) := 'NPB';
15 G_INSTANTIATED_SNAPSHOT      constant varchar2(2) := 'IS';
16 G_INSTANTIATED_SNAPSHOT_BUGS constant varchar2(3) := 'ISB';
17 
18 
19 -- Returns TRUE if we are allowed to maintain snapshots (using a temporary
20 -- strategy)
21 function snapshot_maint_allowed return boolean;
22 
23 -- Update curr-vw snapshot using info from a single patch run
24 --   Pre-req: Temp table AD_PTCH_HST_EXE_COP_TMP must be empty
25 procedure update_current_view
26            (p_patch_run_id number,
27             p_appl_top_id  number default null);
28 
29 -- Update curr-vw snapshot using info from a set of patch runs
30 --   Pre-req: Temp table AD_PTCH_HST_EXE_COP_TMP must be populated with
31 --            (only) the patch-run-id's (if called in IN_TEMP_TAB mode)
32 
33 
34 -- patch-runs specifier: 'IN_TEMP_TAB' or 'ALL'
35 procedure update_current_view
36            (p_patch_runs_spec          varchar2,
37             p_appl_top_id              number,
38             p_caller_is_managing_locks boolean);
39 
40 -- Instantiate a current-view
41 -- Note: See return-code "constants" above.
42 -- Note2: This procedure ALWAYS commits.
43 procedure instantiate_current_view
44            (p_release_id                           number,
45             p_appl_top_id                          number,
46             p_fail_if_no_preseeded_rows            boolean default TRUE,
47             p_caller_is_managing_locks             boolean default FALSE,
48             p_return_code               out nocopy varchar2);
49 
50 -- BUG 3402506  - sallamse , 02-03-04
51 -- Backfill the current-view snapshot if necessary.
52 -- Note: See return-code "constants" above.
53 -- Note2: This procedure ALWAYS commits.
54 procedure backfill_bugs_from_patch_hist
55            (p_snapshot_id number);
56 
57 procedure update_rel_name(rel_name varchar2);
58 
59 end ad_file_sys_snapshots_pkg;