PACKAGE: APPS.AD_FILE_SYS_SNAPSHOTS_PKG

Source

1 package ad_file_sys_snapshots_pkg AUTHID CURRENT_USER as
2 /* $Header: adfssnps.pls 120.0.12020000.2 2012/07/09 17:54:54 mkumandu 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 function  get_snapshot_type (p_snapshot_name in varchar2)
20                              return varchar2;
21 
22 -- Returns TRUE if we are allowed to maintain snapshots (using a temporary
23 -- strategy)
24 function snapshot_maint_allowed return boolean;
25 
26 -- Update curr-vw snapshot using info from a single patch run
27 --   Pre-req: Temp table AD_PTCH_HST_EXE_COP_TMP must be empty
28 procedure update_current_view
29            (p_patch_run_id number,
30             p_appl_top_id  number default null);
31 
32 -- Update curr-vw snapshot using info from a set of patch runs
33 --   Pre-req: Temp table AD_PTCH_HST_EXE_COP_TMP must be populated with
34 --            (only) the patch-run-id's (if called in IN_TEMP_TAB mode)
35 
36 
37 -- patch-runs specifier: 'IN_TEMP_TAB' or 'ALL'
38 procedure update_current_view
39            (p_patch_runs_spec          varchar2,
40             p_appl_top_id              number,
41             p_caller_is_managing_locks boolean);
42 
43 -- Instantiate a current-view
44 -- Note: See return-code "constants" above.
45 -- Note2: This procedure ALWAYS commits.
46 procedure instantiate_current_view
47            (p_release_id                           number,
48             p_appl_top_id                          number,
49             p_fail_if_no_preseeded_rows            boolean default TRUE,
50             p_caller_is_managing_locks             boolean default FALSE,
51             p_return_code               out nocopy varchar2);
52 
53 -- BUG 3402506  - sallamse , 02-03-04
54 -- Backfill the current-view snapshot if necessary.
55 -- Note: See return-code "constants" above.
56 -- Note2: This procedure ALWAYS commits.
57 procedure backfill_bugs_from_patch_hist
58            (p_snapshot_id number);
59 
60 procedure update_rel_name(rel_name varchar2);
61 
62 end ad_file_sys_snapshots_pkg;