PACKAGE: APPS.AD_OBSOLETE_PRODUCTS

Source

1 package AD_OBSOLETE_PRODUCTS  as
2 /* $Header: adobsprs.pls 120.2 2005/11/24 03:43:14 vpalakur noship $*/
3    -- Star of Comments
4    --
5    -- Name
6    --
7    --   Package name:   AD_OBSOLETE_PRODUCTS
8    --
9    -- History
10    --                Aug-10-05           hxue    Creation Date
11    --
12    --
13 procedure drop_synonym_list (x_appl_id in number,
14                              x_app_short_name in varchar2);
15    --
16    -- Purpose
17    --
18    --   drop correspondence synonyms (in APPS) which points to the
19    --   base schema objects
20    --
21    -- Arguments
22    --
23    -- Out Parameters
24    --
25    --   x_appl_id
26    --
27    -- Example
28    --
29    --   none
30    --
31    -- Notes
32    --
33    --   none
34    --
35 
36 procedure drop_synonym_all (x_appl_id in number,
37                             x_app_short_name in varchar2);
38    --
39    -- Purpose
40    --
41    --   drop all synonyms(in APPS) which points to objects in base schema
42    --
43    -- Arguments
44    --
45    -- Out Parameters
46    --
47    --   x_appl_id
48    --   x_app_short_name
49    --
50    -- Example
51    --
52    --   none
53    --
54    -- Notes
55    --
56    --   none
57    --
58 procedure drop_apps_objects (x_appl_id in number);
59    --
60    -- Purpose
61    --
62    --   Drop objects based on application_id from .
63    --   table AD_OBSOLETE_OBJECTS
64    --
65    -- Arguments
66    --
67    -- Out Parameters
68    --
69    --   x_appl_id
70    --
71    -- Example
72    --
73    --   none
74    --
75    -- Notes
76    --
77    --   none
78    --
79 
80 procedure drop_schema_objects
81      (aSqlcode      IN OUT NOCOPY  NUMBER,
82       aSqlerrm      IN OUT NOCOPY  VARCHAR2,
83       x_appl_id     IN             NUMBER,
84       x_flag        IN             VARCHAR2);
85 
86    --
87    -- Purpose
88    --
89    --   Drop schema objects based on application_id.
90    --
91    -- Arguments
92    --
93    -- In Parameters
94    --
95    --   aSqlcode
96    --   aSqlerrm
97    --   x_appl_id
98    --   x_flag
99    --
100    -- Example
101    --
102    --   none
103    --
104    -- Notes
105    --
106    --   none
107    --
108 
109 end AD_OBSOLETE_PRODUCTS;