PACKAGE: APPS.PA_ALLOC_RESOURCES_PKG

Source

1 package  PA_ALLOC_RESOURCES_PKG AS
2  /* $Header: PAXATRSS.pls 120.1 2005/08/18 14:53:32 dlanka noship $   */
3 procedure INSERT_ROW (
4   X_ROWID 			in out NOCOPY VARCHAR2,
5   X_RULE_ID 			in NUMBER,
6   X_MEMBER_TYPE 		in VARCHAR2,
7   X_RESOURCE_LIST_MEMBER_ID 	in NUMBER,
8   X_EXCLUDE_FLAG 		in VARCHAR2,
9   X_TARGET_EXPND_TYPE 		in VARCHAR2,
10   X_OFFSET_EXPND_TYPE 		in VARCHAR2,
11   X_RESOURCE_PERCENTAGE 	in NUMBER,
12   X_CREATED_BY			in NUMBER,
13   X_CREATION_DATE		in DATE,
14   X_LAST_UPDATE_DATE		in DATE,
15   X_LAST_UPDATED_BY		in NUMBER,
16   X_LAST_UPDATE_LOGIN		in NUMBER
17 
18   );
19 procedure LOCK_ROW (
20   X_RULE_ID 			in NUMBER,
21   X_MEMBER_TYPE 		in VARCHAR2,
22   X_RESOURCE_LIST_MEMBER_ID 	in NUMBER,
23   X_EXCLUDE_FLAG 		in VARCHAR2,
24   X_TARGET_EXPND_TYPE 		in VARCHAR2,
25   X_OFFSET_EXPND_TYPE 		in VARCHAR2,
26   X_RESOURCE_PERCENTAGE 	in NUMBER
27 );
28 procedure UPDATE_ROW (
29   X_ROWID   			in varchar2,
30   X_RULE_ID 			in NUMBER,
31   X_MEMBER_TYPE 		in VARCHAR2,
32   X_RESOURCE_LIST_MEMBER_ID 	in NUMBER,
33   X_EXCLUDE_FLAG 		in VARCHAR2,
34   X_TARGET_EXPND_TYPE 		in VARCHAR2,
35   X_OFFSET_EXPND_TYPE 		in VARCHAR2,
36   X_RESOURCE_PERCENTAGE 	in NUMBER,
37   X_LAST_UPDATE_DATE		in DATE,
38   X_LAST_UPDATED_BY		in NUMBER,
39   X_LAST_UPDATE_LOGIN		in NUMBER
40   );
41 
42 procedure DELETE_ROW (X_ROWID in varchar2 );
43 
44 end PA_ALLOC_RESOURCES_PKG;