1 PACKAGE PA_RBS_ASGMT_PVT AS
2 /* $Header: PARASGVS.pls 120.0 2005/05/29 21:19:01 appldev 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.LOG_ID;
10
11 /**********************************************************
12 * Function : Check_Primary_rep_flag
13 * Parameter: p_project_id,p_rbs_header_id
14 * Return : Varchar2
15 * Desc : The purpose of this Function is to determine if
16 * The Value of the Primary reporting RBS flag can be set to
17 * 'Y' or not. It checks to see if any other RBS asso.
18 * to the project have the flag set to 'Y' already.
19 * If yes then we shouldn't allow the user to create/Update
20 * the value for the flag to 'Y'.
21 *******************************************************************/
22 FUNCTION Check_Primary_rep_flag
23 (p_project_id IN NUMBER,
24 p_rbs_header_id IN NUMBER)
25 RETURN VARCHAR2;
26
27 /**************************************************************
28 * Procedure : Create_RBS_Assignment
29 * Description : The purpose of this procedure is to associate
30 * an RBS to a project for any of the 4 uasges:-
31 * Reporting, Financial Plan, Workplan and
32 * Program Reporting.
33 * Reporting is the Default Usage type for all the
34 * associations.
35 ****************************************************************/
36 PROCEDURE Create_RBS_Assignment(
37 p_rbs_header_id IN NUMBER,
38 p_rbs_version_id IN NUMBER DEFAULT NULL,
39 p_project_id IN NUMBER,
40 p_wp_usage_flag IN VARCHAR2 DEFAULT NULL,
41 p_fp_usage_flag IN VARCHAR2 DEFAULT NULL,
42 p_prog_rep_usage_flag IN VARCHAR2 DEFAULT NULL,
43 p_primary_rep_flag IN VARCHAR2 DEFAULT 'N',
44 x_return_status OUT NOCOPY VARCHAR2 ,
45 x_msg_count OUT NOCOPY NUMBER ,
46 x_error_msg_data OUT NOCOPY VARCHAR2 );
47
48 PROCEDURE Update_RBS_Assignment(
49 p_rbs_prj_assignment_id IN NUMBER,
50 p_wp_usage_flag IN VARCHAR2 DEFAULT 'N',
51 p_fp_usage_flag IN VARCHAR2 DEFAULT 'N',
52 p_prog_rep_usage_flag IN VARCHAR2 DEFAULT 'N',
53 p_primary_rep_flag IN VARCHAR2 DEFAULT 'N',
54 p_record_version_number IN Number,
55 p_set_as_primary IN Varchar2 DEFAULT 'N',
56 x_return_status OUT NOCOPY VARCHAR2,
57 x_msg_count OUT NOCOPY NUMBER,
58 x_error_msg_data OUT NOCOPY VARCHAR2 );
59
60 PROCEDURE Delete_RBS_Assignment(
61 p_rbs_prj_assignment_id IN NUMBER,
62 x_return_status OUT NOCOPY VARCHAR2,
63 x_msg_count OUT NOCOPY NUMBER,
64 x_error_msg_data OUT NOCOPY VARCHAR2 );
65
66 PROCEDURE Associate_Rbs_To_Program(
67 p_rbs_header_id IN NUMBER,
68 p_rbs_version_id IN NUMBER DEFAULT NULL,
69 p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
70 x_return_status OUT NOCOPY VARCHAR2);
71
72 PROCEDURE Assign_New_Version(
73 p_rbs_new_version_id IN Number,
74 p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
75 x_return_status OUT NOCOPY Varchar2);
76
77 PROCEDURE Copy_Project_Assignment(
78 p_rbs_src_project_id IN NUMBER,
79 p_rbs_dest_project_id IN NUMBER,
80 x_return_status OUT NOCOPY Varchar2);
81
82
83 END PA_RBS_ASGMT_PVT;