[Home] [Help]
PACKAGE: APPS.PA_RBS_ASGMT_PUB
Source
1 PACKAGE PA_RBS_ASGMT_PUB AUTHID CURRENT_USER AS
2 /* $Header: PARASGPS.pls 120.0 2005/05/30 18:40:59 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 * Procedure : Create_RBS_Assignment
13 * Description : The purpose of this procedure is to associate
14 * an RBS to a project for any of the 4 uasges:-
15 * Reporting, Financial Plan, Workplan and
16 * Program Reporting.
17 * Reporting is the Default Usage type for all the
18 * associations.
19 ****************************************************************/
20 PROCEDURE Create_RBS_Assignment(
21 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
22 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
23 p_rbs_header_id IN NUMBER,
24 p_rbs_version_id IN NUMBER DEFAULT NULL,
25 p_project_id IN NUMBER,
26 p_wp_usage_flag IN VARCHAR2 DEFAULT NULL,
27 p_fp_usage_flag IN VARCHAR2 DEFAULT NULL,
28 p_prog_rep_usage_flag IN VARCHAR2 DEFAULT NULL,
29 p_primary_rep_flag IN VARCHAR2 DEFAULT 'N',
30 x_return_status OUT NOCOPY VARCHAR2 ,
31 x_msg_count OUT NOCOPY NUMBER ,
32 x_error_msg_data OUT NOCOPY VARCHAR2 );
33
34 PROCEDURE Update_RBS_Assignment(
35 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
36 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
37 p_rbs_prj_assignment_id IN NUMBER,
38 p_wp_usage_flag IN VARCHAR2 DEFAULT 'N',
39 p_fp_usage_flag IN VARCHAR2 DEFAULT 'N',
40 p_prog_rep_usage_flag IN VARCHAR2 DEFAULT 'N',
41 p_primary_rep_flag IN VARCHAR2 DEFAULT 'N',
42 p_record_version_number IN Number,
43 p_set_as_primary 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
49 PROCEDURE Delete_RBS_Assignment(
50 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
51 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
52 p_rbs_prj_assignment_id IN NUMBER,
53 x_return_status OUT NOCOPY VARCHAR2,
54 x_msg_count OUT NOCOPY NUMBER,
55 x_error_msg_data OUT NOCOPY VARCHAR2 );
56
57
58 PROCEDURE Copy_rbs_assignments(
59 p_source_project_id IN Number,
60 p_destination_project_id IN Number,
61 x_return_status OUT NOCOPY Varchar2);
62
63
64 END PA_RBS_ASGMT_PUB;