[Home] [Help]
PACKAGE: APPS.PA_RESOURCE_LIST_TBL_PKG
Source
1 PACKAGE PA_Resource_List_tbl_Pkg AS
2 /* $Header: PARELSTS.pls 120.1 2005/08/19 16:50:26 mwasowic noship $ */
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 x_resource_list_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
23 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
24 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
25 );
26
27
28 PROCEDURE Insert_row (X_ROW_ID IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
29 X_RESOURCE_LIST_ID NUMBER,
30 X_NAME VARCHAR2,
31 X_DESCRIPTION VARCHAR2,
32 X_PUBLIC_FLAG VARCHAR2,
33 X_GROUP_RESOURCE_TYPE_ID NUMBER,
34 X_START_DATE_ACTIVE DATE,
35 X_END_DATE_ACTIVE DATE,
36 X_UNCATEGORIZED_FLAG VARCHAR2,
37 X_BUSINESS_GROUP_ID NUMBER,
38 -- X_ADW_NOTIFY_FLAG VARCHAR2,
39 X_JOB_GROUP_ID NUMBER,
40 X_RESOURCE_LIST_TYPE VARCHAR2 DEFAULT 'U',
41 X_LAST_UPDATED_BY NUMBER,
42 X_LAST_UPDATE_DATE DATE,
43 X_CREATION_DATE DATE,
44 X_CREATED_BY NUMBER,
45 X_LAST_UPDATE_LOGIN NUMBER );
46
47 PROCEDURE Update_Row (X_ROW_ID IN VARCHAR2,
48 X_RESOURCE_LIST_ID NUMBER,
49 X_NAME VARCHAR2,
50 X_DESCRIPTION VARCHAR2,
51 X_PUBLIC_FLAG VARCHAR2,
52 X_GROUP_RESOURCE_TYPE_ID NUMBER,
53 X_START_DATE_ACTIVE DATE,
54 X_END_DATE_ACTIVE DATE,
55 X_UNCATEGORIZED_FLAG VARCHAR2,
56 X_BUSINESS_GROUP_ID NUMBER,
57 -- X_ADW_NOTIFY_FLAG VARCHAR2,
58 X_JOB_GROUP_ID NUMBER,
59 X_RESOURCE_LIST_TYPE VARCHAR2 DEFAULT 'U',
60 X_LAST_UPDATED_BY NUMBER,
61 X_LAST_UPDATE_DATE DATE,
62 X_LAST_UPDATE_LOGIN NUMBER );
63
64 Procedure Lock_Row (X_ROW_ID IN VARCHAR2,
65 X_RESOURCE_LIST_ID NUMBER,
66 X_NAME VARCHAR2,
67 X_DESCRIPTION VARCHAR2,
68 X_PUBLIC_FLAG VARCHAR2,
69 X_GROUP_RESOURCE_TYPE_ID NUMBER,
70 X_START_DATE_ACTIVE DATE,
71 X_END_DATE_ACTIVE DATE,
72 X_UNCATEGORIZED_FLAG VARCHAR2,
73 X_BUSINESS_GROUP_ID NUMBER,
74 X_JOB_GROUP_ID NUMBER,
75 -- X_ADW_NOTIFY_FLAG VARCHAR2,
76 X_LAST_UPDATED_BY NUMBER);
77
78
79 Procedure Delete_Row (X_ROW_ID IN VARCHAR2);
80
81 END PA_Resource_List_tbl_Pkg;