PACKAGE: APPS.CS_CF_UPG_PKG

Source

1 PACKAGE CS_CF_UPG_PKG AUTHID CURRENT_USER as
2 /* $Header: cscfupgs.pls 120.0 2005/06/01 12:27:10 appldev noship $ */
3 
4 
5 PROCEDURE Upgrade_Main;
6 
7 
8 FUNCTION Is_Region_Upgrade_Required(p_respTable OUT NOCOPY CS_CF_UPG_UTL_PKG.RespTable ,
9                                     p_applTable OUT NOCOPY CS_CF_UPG_UTL_PKG.ApplTable,
10                                     p_siteProfilesTable OUT NOCOPY CS_CF_UPG_UTL_PKG.ProfileTable) RETURN BOOLEAN;
11 
12 FUNCTION Is_Flow_Upgrade_Required(p_respTable OUT NOCOPY CS_CF_UPG_UTL_PKG.RespTable ,
13                                   p_applTable OUT NOCOPY CS_CF_UPG_UTL_PKG.ApplTable,
14                                   p_siteProfilesTable OUT NOCOPY CS_CF_UPG_UTL_PKG.ProfileTable)
15                                   RETURN BOOLEAN;
16 
17 PROCEDURE Do_Region_Upgrade (p_respTable IN CS_CF_UPG_UTL_PKG.RespTable, p_applTable IN CS_CF_UPG_UTL_PKG.ApplTable, p_siteProfilesTable IN CS_CF_UPG_UTL_PKG.ProfileTable);
18 
19 PROCEDURE Do_Region_Upgrades_For_Resp(p_respTable IN CS_CF_UPG_UTL_PKG.RespTable);
20 
21 PROCEDURE Clone_Regions_For_Resp(p_ProfileTable IN CS_CF_UPG_UTL_PKG.ProfileTable,
22                                  p_respId IN FND_PROFILE_OPTION_VALUES.level_value%TYPE,
23                                  p_respApplId IN FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE);
24 
25 
26 PROCEDURE Do_Region_Upgrades_For_Appl(p_applTable IN CS_CF_UPG_UTL_PKG.ApplTable);
27 
28 PROCEDURE Do_Region_Upgrades_For_Global(p_siteProfilesTable IN CS_CF_UPG_UTL_PKG.ProfileTable);
29 
30 /*
31  * Perform the actually cloning
32  * of ak regions, based on the list of
33  * profiles that are customized at the appl level
34  */
35 PROCEDURE Clone_Regions_For_Appl(p_ProfileTable IN CS_CF_UPG_UTL_PKG.ProfileTable, p_ApplId IN NUMBER);
36 
37 /*
38  * Perform the actually cloning
39  * of ak regions, based on the list of
40  * profiles that are customized at the global level
41  */
42 PROCEDURE Clone_Regions_For_Global(p_ProfileTable IN CS_CF_UPG_UTL_PKG.ProfileTable);
43 
44 
45 /*
46  * Top level procedure for performing flow
47  * upgrades; Internally this will call
48  * flow upgrades for each profile level, ie resp, application, etc
49  */
50 PROCEDURE Do_Flow_Upgrade(p_respTable IN CS_CF_UPG_UTL_PKG.RespTable,
51                           p_applTable IN CS_CF_UPG_UTL_PKG.ApplTable,
52                           p_siteProfilesTable IN CS_CF_UPG_UTL_PKG.ProfileTable);
53 
54 
55 /*
56  * Procedure to performing flow upgrades for responsibility level
57  * For each resp
58  */
59 PROCEDURE Do_Flow_Upgrades_For_Resp(p_respTable IN CS_CF_UPG_UTL_PKG.RespTable);
60 
61 /*
62  * Perform the actually cloning
63  * of flows, based on the list of
64  * profiles that are customized at the resp level
65  */
66 PROCEDURE Clone_Flows_For_Resp(p_ProfileTable IN CS_CF_UPG_UTL_PKG.ProfileTable,
67                             p_respId IN FND_PROFILE_OPTION_VALUES.level_value%TYPE,
68                             p_respApplId IN FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE);
69 
70 /*
71  * Procedure to performing flow upgrades for application level
72  */
73 PROCEDURE Do_Flow_Upgrades_For_Appl(p_applTable IN CS_CF_UPG_UTL_PKG.ApplTable);
74 
75 /*
76  * Perform the actually cloning
77  * of flows, based on the list of
78  * profiles that are customized at the application level
79  */
80 
81 PROCEDURE Clone_Flows_For_Appl(p_ProfileTable IN CS_CF_UPG_UTL_PKG.ProfileTable,
82 					   p_applId IN NUMBER);
83 
84 
85 /*
86  * Procedure to performing flow upgrades for site level
87  */
88 PROCEDURE Do_Flow_Upgrades_For_Global(p_siteProfilesTable IN CS_CF_UPG_UTL_PKG.ProfileTable);
89 
90 End CS_CF_UPG_PKG;