[Home] [Help]
PACKAGE: APPS.PA_RESOURCE_LIST_PKG
Source
1 PACKAGE PA_Resource_List_Pkg AS
2 /* $Header: PARELITS.pls 120.1 2005/08/19 16:50:18 mwasowic noship $ */
3 -- Standard Table Handler procedures for PA_RESOURCE_LISTS table
4 PROCEDURE Insert_parent_row (X_ROW_ID IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
5 X_RESOURCE_LIST_MEMBER_ID NUMBER,
6 X_RESOURCE_LIST_ID NUMBER,
7 X_RESOURCE_ID NUMBER,
8 X_ALIAS VARCHAR2,
9 X_SORT_ORDER NUMBER,
10 X_MEMBER_LEVEL NUMBER,
11 X_DISPLAY_FLAG VARCHAR2,
12 X_ENABLED_FLAG VARCHAR2,
13 X_TRACK_AS_LABOR_FLAG VARCHAR2,
14 X_LAST_UPDATED_BY NUMBER,
15 X_LAST_UPDATE_DATE DATE,
16 X_CREATION_DATE DATE,
17 X_CREATED_BY NUMBER,
18 X_LAST_UPDATE_LOGIN NUMBER,
19 X_Funds_Control_Level_Code VARCHAR2,
20 p_migration_code VARCHAR2);
21
22 PROCEDURE Update_Parent_Row (X_ROW_ID IN VARCHAR2,
23 X_RESOURCE_LIST_MEMBER_ID NUMBER,
24 X_ALIAS VARCHAR2,
25 X_SORT_ORDER NUMBER,
26 X_MEMBER_LEVEL NUMBER,
27 X_DISPLAY_FLAG VARCHAR2,
28 X_ENABLED_FLAG VARCHAR2,
29 X_TRACK_AS_LABOR_FLAG VARCHAR2,
30 X_LAST_UPDATED_BY NUMBER,
31 X_LAST_UPDATE_DATE DATE,
32 X_LAST_UPDATE_LOGIN NUMBER,
33 X_Funds_Control_Level_Code VARCHAR2,
34 p_migration_code VARCHAR2);
35
36 Procedure Lock_Parent_Row (X_ROW_ID IN VARCHAR2,
37 X_RESOURCE_LIST_MEMBER_ID NUMBER,
38 X_RESOURCE_ID NUMBER,
39 X_ALIAS VARCHAR2,
40 X_SORT_ORDER NUMBER,
41 X_DISPLAY_FLAG VARCHAR2,
42 X_ENABLED_FLAG VARCHAR2,
43 X_Funds_Control_Level_Code VARCHAR2,
44 p_migration_code VARCHAR2);
45
46 Procedure Delete_Parent_Row (X_ROW_ID IN VARCHAR2);
47
48 PROCEDURE Insert_child_row (X_ROW_ID IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
49 X_RESOURCE_LIST_MEMBER_ID NUMBER,
50 X_RESOURCE_LIST_ID NUMBER,
51 X_RESOURCE_ID NUMBER,
52 X_ALIAS VARCHAR2,
53 X_PARENT_MEMBER_ID NUMBER,
54 X_SORT_ORDER NUMBER,
55 X_MEMBER_LEVEL NUMBER,
56 X_DISPLAY_FLAG VARCHAR2,
57 X_ENABLED_FLAG VARCHAR2,
58 X_TRACK_AS_LABOR_FLAG VARCHAR2,
59 X_LAST_UPDATED_BY NUMBER,
60 X_LAST_UPDATE_DATE DATE,
61 X_CREATION_DATE DATE,
62 X_CREATED_BY NUMBER,
63 X_LAST_UPDATE_LOGIN NUMBER,
64 X_Funds_Control_Level_Code VARCHAR2);
65
66 PROCEDURE Update_Child_Row (X_ROW_ID IN VARCHAR2,
67 X_RESOURCE_LIST_MEMBER_ID NUMBER,
68 X_ALIAS VARCHAR2,
69 X_SORT_ORDER NUMBER,
70 X_MEMBER_LEVEL NUMBER,
71 X_DISPLAY_FLAG VARCHAR2,
72 X_ENABLED_FLAG VARCHAR2,
73 X_TRACK_AS_LABOR_FLAG VARCHAR2,
74 X_LAST_UPDATED_BY NUMBER,
75 X_LAST_UPDATE_DATE DATE,
76 X_LAST_UPDATE_LOGIN NUMBER,
77 X_Funds_Control_Level_Code VARCHAR2 );
78
79 Procedure Lock_Child_Row (X_ROW_ID IN VARCHAR2,
80 X_RESOURCE_LIST_MEMBER_ID NUMBER,
81 X_RESOURCE_ID NUMBER,
82 X_ALIAS VARCHAR2,
83 X_SORT_ORDER NUMBER,
84 X_DISPLAY_FLAG VARCHAR2,
85 X_ENABLED_FLAG VARCHAR2,
86 X_Funds_Control_Level_Code VARCHAR2 );
87
88 Procedure Delete_Child_Row (X_ROW_ID IN VARCHAR2);
89
90
91 Procedure Delete_Unclassified_Child (x_resource_list_id IN
92 PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_ID%TYPE,
93 x_parent_member_id IN
94 PA_RESOURCE_LIST_MEMBERS.Parent_Member_ID%TYPE,
95 X_msg_Count OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
96 X_msg_Data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
97 X_return_Status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
98 );
99 END PA_Resource_List_Pkg;