[Home] [Help]
PACKAGE: APPS.PA_RESOURCE_LIST_TBL_PKG
Source
1 PACKAGE PA_Resource_List_tbl_Pkg AUTHID CURRENT_USER AS
2 /* $Header: PARELSTS.pls 120.2 2012/01/03 13:25:55 djambhek ship $ */
3 -- Standard Table Handler procedures for PA_RESOURCE_LISTS table
4
5
6
7 PROCEDURE Insert_Row(
8 p_name PA_RESOURCE_LISTS_ALL_BG.name%TYPE,
9 p_description PA_RESOURCE_LISTS_ALL_BG.description%TYPE,
10 p_public_flag PA_RESOURCE_LISTS_ALL_BG.public_flag%TYPE,
11 p_group_resource_type_id NUMBER,
12 p_start_date_active DATE,
13 p_end_date_active DATE,
14 p_uncategorized_flag PA_RESOURCE_LISTS_ALL_BG.uncategorized_flag%TYPE,
15 p_business_group_id NUMBER,
16 p_adw_notify_flag PA_RESOURCE_LISTS_ALL_BG.adw_notify_flag%TYPE,
17 p_job_group_id NUMBER,
18 p_resource_list_type PA_RESOURCE_LISTS_ALL_BG.resource_list_type%TYPE,
19 p_control_flag PA_RESOURCE_LISTS_ALL_BG.control_flag%TYPE,
20 p_use_for_wp_flag PA_RESOURCE_LISTS_ALL_BG.use_for_wp_flag%TYPE,
21 p_migration_code PA_RESOURCE_LISTS_ALL_BG.migration_code%TYPE,
22 p_Enable_Resource_Classes IN VARCHAR2 DEFAULT 'Y', -- Added for CBS Bug13535688
23 x_resource_list_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
24 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
25 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
26 );
27
28
29 PROCEDURE Insert_row (X_ROW_ID IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
30 X_RESOURCE_LIST_ID NUMBER,
31 X_NAME VARCHAR2,
32 X_DESCRIPTION VARCHAR2,
33 X_PUBLIC_FLAG VARCHAR2,
34 X_GROUP_RESOURCE_TYPE_ID NUMBER,
35 X_START_DATE_ACTIVE DATE,
36 X_END_DATE_ACTIVE DATE,
37 X_UNCATEGORIZED_FLAG VARCHAR2,
38 X_BUSINESS_GROUP_ID NUMBER,
39 -- X_ADW_NOTIFY_FLAG VARCHAR2,
40 X_JOB_GROUP_ID NUMBER,
41 X_RESOURCE_LIST_TYPE VARCHAR2 DEFAULT 'U',
42 X_LAST_UPDATED_BY NUMBER,
43 X_LAST_UPDATE_DATE DATE,
44 X_CREATION_DATE DATE,
45 X_CREATED_BY NUMBER,
46 X_LAST_UPDATE_LOGIN NUMBER );
47
48 PROCEDURE Update_Row (X_ROW_ID IN VARCHAR2,
49 X_RESOURCE_LIST_ID NUMBER,
50 X_NAME VARCHAR2,
51 X_DESCRIPTION VARCHAR2,
52 X_PUBLIC_FLAG VARCHAR2,
53 X_GROUP_RESOURCE_TYPE_ID NUMBER,
54 X_START_DATE_ACTIVE DATE,
55 X_END_DATE_ACTIVE DATE,
56 X_UNCATEGORIZED_FLAG VARCHAR2,
57 X_BUSINESS_GROUP_ID NUMBER,
58 -- X_ADW_NOTIFY_FLAG VARCHAR2,
59 X_JOB_GROUP_ID NUMBER,
60 X_RESOURCE_LIST_TYPE VARCHAR2 DEFAULT 'U',
61 X_LAST_UPDATED_BY NUMBER,
62 X_LAST_UPDATE_DATE DATE,
63 X_LAST_UPDATE_LOGIN NUMBER );
64
65 Procedure Lock_Row (X_ROW_ID IN VARCHAR2,
66 X_RESOURCE_LIST_ID NUMBER,
67 X_NAME VARCHAR2,
68 X_DESCRIPTION VARCHAR2,
69 X_PUBLIC_FLAG VARCHAR2,
70 X_GROUP_RESOURCE_TYPE_ID NUMBER,
71 X_START_DATE_ACTIVE DATE,
72 X_END_DATE_ACTIVE DATE,
73 X_UNCATEGORIZED_FLAG VARCHAR2,
74 X_BUSINESS_GROUP_ID NUMBER,
75 X_JOB_GROUP_ID NUMBER,
76 -- X_ADW_NOTIFY_FLAG VARCHAR2,
77 X_LAST_UPDATED_BY NUMBER);
78
79
80 Procedure Delete_Row (X_ROW_ID IN VARCHAR2);
81
82 END PA_Resource_List_tbl_Pkg;