1 PACKAGE PA_RBS_UTILS AUTHID CURRENT_USER AS
2 /* $Header: PARRBSUS.pls 120.2 2005/09/28 18:09:54 ramurthy noship $*/
3
4 -- Standard who
5 g_last_updated_by NUMBER(15) := FND_GLOBAL.USER_ID;
6 g_last_update_date DATE := SYSDATE;
7 g_creation_date DATE := SYSDATE;
8 g_created_by NUMBER(15) := FND_GLOBAL.USER_ID;
9 g_last_update_login NUMBER(15) := FND_GLOBAL.LOGIN_ID;
10 /********************************************************
11 * Function : get_max_rbs_frozen_version
12 * Description : Get the latest frozen version of an RBS.
13 ********************************************************/
14 FUNCTION get_max_rbs_frozen_version(p_rbs_header_id IN NUMBER) return NUMBER;
15
16 /*****************************************************
17 * Function : Get_element_Name
18 * Description : This Function is used to return the
19 * Element_Name for a given
20 * resource_source_id and resource_type_code
21 * passed in.
22 * Further details are specified in the Body.
23 ***************************************************/
24 Function Get_element_Name
25 (p_resource_source_id IN Number,
26 p_resource_type_code IN Varchar2)
27 RETURN Varchar2;
28
29 /********************************************************
30 * Procedure : Insert_elements
31 * Description : This Procedure is used to insert into
32 * the pa_rbs_element_names_b table
33 * This API is called passing the call_flag
34 * of 'A' or 'B'.
35 * Details are specified in the Body.
36 ******************************************************/
37 Procedure Insert_elements(p_resource_type_id IN NUMBER,
38 x_return_status OUT NOCOPY Varchar2);
39 /******************************************************
40 * Procedure : Insert_non_tl_names
41 * Description : This API is used to insert into the
42 * pa_rbs_element_names_tl table.
43 * For those res_type_codes for which there
44 * is no Multi lang support.
45 * Details are specified in the Body.
46 ***************************************************/
47 PROCEDURE Insert_non_tl_names
48 (p_resource_type_id IN Number,
49 p_resource_type_code IN Varchar2,
50 x_return_status OUT NOCOPY Varchar2);
51
52 /******************************************************
53 * Procedure : Insert_tl_names
54 * Description : This API is used to insert into the
55 * pa_rbs_element_names_tl table.
56 * For those res_type_codes for which there
57 * are corr TL tables
58 * Details are specified in the Body.
59 ***************************************************/
60 PROCEDURE Insert_tl_names
61 (p_resource_type_id IN Number,
62 p_resource_type_code IN Varchar2,
63 x_return_status OUT NOCOPY Varchar2);
64 /*******************************************************
65 * Procedure : Populate_RBS_Element_Name
66 * Description : Used to populate the pa_rbs_element_names_b
67 * and pa_rbs_element_names_tl tables
68 * and return back the element_name_id.
69 * Further details in the Body.
70 ******************************************************/
71 PROCEDURE Populate_RBS_Element_Name
72 ( p_resource_source_id IN Number Default Null,
73 p_resource_type_id IN Number Default Null,
74 x_rbs_element_name_id OUT NOCOPY Number,
75 x_return_status OUT NOCOPY Varchar2);
76
77 /* ----------------------------------------------------------------
78 Wrapper API for handling RBS version changes. This API is called
79 by the RBS summarization program. This API includes calls to all
80 API's that handle RBS version changes in other PA modules. This
81 API is called in the beginning of PJI concurrent program that
82 handles RBS version changes
83 ----------------------------------------------------------------*/
84 PROCEDURE PROCESS_RBS_CHANGES (
85 p_rbs_header_id IN NUMBER,
86 p_new_rbs_version_id IN NUMBER,
87 p_old_rbs_version_id IN NUMBER,
88 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
89 x_msg_count OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
90 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
91
92 /* ----------------------------------------------------------------
93 * API for upgrading a resource list to an RBS. This API is called
94 * by the resource list upgrade concurrent program.
95 ----------------------------------------------------------------*/
96 PROCEDURE UPGRADE_LIST_TO_RBS (
97 p_resource_list_id IN NUMBER,
98 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
99 x_msg_count OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
100 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
101
102
103 /*==============================================================================
104 This api is used to Refresh Resource names
105 =============================================================================*/
106
107 -- Procedure : Refresh_Resource_Names
108 -- Type : Public Procedure
109 -- Purpose : This API will be used to refresh Resource names associated with RBS.
110 -- : This API will be called from :
111 -- : 1.Concurrent program: Refresh RBS Element Names
112
113 -- Parameters : None
114 --
115
116 PROCEDURE Refresh_Resource_Names(errbuf OUT NOCOPY VARCHAR2,
117 retcode OUT NOCOPY VARCHAR2);
118
119 /*****************************************************
120 * Function : Get_Concatenated_Name
121 * Description : This Function is used to return the
122 * Concatenated Name given a rbs_element_id.
123 * Further details are specified in the Body.
124 ***************************************************/
125 Function Get_Concatenated_name
126 (p_rbs_element_id IN Number)
127 RETURN Varchar2;
128
129 /*******************************************************************
130 * Procedure : Delete_proj_specific_RBS
131 * Desc : This API is used to delete the project specific RBS assignment
132 * once the project is deleted.
133 ********************************************************************/
134 PROCEDURE Delete_Proj_Specific_RBS(
135 p_project_id IN NUMBER,
136 x_return_status OUT NOCOPY VARCHAR2,
137 x_msg_count OUT NOCOPY NUMBER);
138
139 Procedure Add_language;
140
141 END PA_RBS_UTILS;
[Home] [Help]