1 PACKAGE PA_RBS_ASGMT_PKG AUTHID CURRENT_USER AS
2 /* $Header: PARASGTS.pls 120.0 2005/05/30 00:51:34 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 Insert_Row(
21 p_rbs_assignment_id IN NUMBER,
22 p_rbs_header_id IN NUMBER,
23 p_rbs_version_id IN NUMBER DEFAULT NULL,
24 p_project_id IN NUMBER,
25 p_wp_usage_flag IN VARCHAR2 DEFAULT 'N',
26 p_fp_usage_flag IN VARCHAR2 DEFAULT 'N',
27 p_prog_rep_usage_flag IN VARCHAR2 DEFAULT 'N',
28 p_primary_rep_flag IN VARCHAR2 DEFAULT 'N',
29 x_return_status OUT NOCOPY VARCHAR2 );
30
31 PROCEDURE Update_Row(
32 p_rbs_prj_assignment_id IN NUMBER,
33 p_wp_usage_flag IN VARCHAR2 DEFAULT 'N',
34 p_fp_usage_flag IN VARCHAR2 DEFAULT 'N',
35 p_prog_rep_usage_flag IN VARCHAR2 DEFAULT 'N',
36 p_primary_rep_flag IN VARCHAR2 DEFAULT 'N',
37 p_record_version_number IN Number,
38 x_return_status OUT NOCOPY VARCHAR2 );
39
40 PROCEDURE Delete_Row(
41 p_rbs_prj_assignment_id IN NUMBER,
42 x_return_status OUT NOCOPY VARCHAR2);
43
44
45 END PA_RBS_ASGMT_PKG;