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 ,
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,
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)
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:
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);
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:
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,
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);
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:
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: /*
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
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
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
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:
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: /*
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
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
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: /*
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
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: /*
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;