[Home] [Help]
PACKAGE: APPS.PSB_ELEMENT_POS_SET_GROUPS_PVT
Source
1 PACKAGE PSB_ELEMENT_POS_SET_GROUPS_PVT AS
2 /* $Header: PSBVPSGS.pls 120.2 2005/07/13 11:29:19 shtripat ship $ */
3
4
5 PROCEDURE INSERT_ROW
6 ( p_api_version IN NUMBER,
7 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
8 p_commit IN VARCHAR2 := FND_API.G_FALSE,
9 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
10 p_return_status OUT NOCOPY VARCHAR2,
11 p_msg_count OUT NOCOPY NUMBER,
12 p_msg_data OUT NOCOPY VARCHAR2,
13 --
14 P_POSITION_SET_GROUP_ID in NUMBER,
15 P_PAY_ELEMENT_ID in NUMBER,
16 P_NAME in VARCHAR2,
17 P_LAST_UPDATE_DATE in DATE,
18 P_LAST_UPDATED_BY in NUMBER,
19 P_LAST_UPDATE_LOGIN in NUMBER,
20 P_CREATED_BY in NUMBER,
21 P_CREATION_DATE in DATE
22 );
23
24 PROCEDURE UPDATE_ROW
25 ( p_api_version IN NUMBER,
26 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
27 p_commit IN VARCHAR2 := FND_API.G_FALSE,
28 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
29 p_return_status OUT NOCOPY VARCHAR2,
30 p_msg_count OUT NOCOPY NUMBER,
31 p_msg_data OUT NOCOPY VARCHAR2,
32 --
33 P_POSITION_SET_GROUP_ID in NUMBER,
34 P_PAY_ELEMENT_ID in NUMBER,
35 P_NAME in VARCHAR2,
36 P_LAST_UPDATE_DATE in DATE,
37 P_LAST_UPDATED_BY in NUMBER,
38 P_LAST_UPDATE_LOGIN in NUMBER
39 );
40
41 PROCEDURE DELETE_ROW
42 ( p_api_version IN NUMBER,
43 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
44 p_commit IN VARCHAR2 := FND_API.G_FALSE,
45 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
46 p_return_status OUT NOCOPY VARCHAR2,
47 p_msg_count OUT NOCOPY NUMBER,
48 p_msg_data OUT NOCOPY VARCHAR2,
49 --
50 P_POSITION_SET_GROUP_ID in NUMBER,
51 P_PAY_ELEMENT_ID in NUMBER
52 );
53
54 PROCEDURE LOCK_ROW
55 ( p_api_version IN NUMBER,
56 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
57 p_commit IN VARCHAR2 := FND_API.G_FALSE,
58 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
59 p_return_status OUT NOCOPY VARCHAR2,
60 p_msg_count OUT NOCOPY NUMBER,
61 p_msg_data OUT NOCOPY VARCHAR2,
62 --
63 p_row_locked OUT NOCOPY VARCHAR2,
64 --
65 P_POSITION_SET_GROUP_ID in NUMBER,
66 P_PAY_ELEMENT_ID in NUMBER,
67 P_NAME in VARCHAR2
68 );
69
70 PROCEDURE Check_Unique
71 (
72 p_api_version IN NUMBER,
73 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
74 p_commit IN VARCHAR2 := FND_API.G_FALSE,
75 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
76 p_return_status OUT NOCOPY VARCHAR2,
77 p_msg_count OUT NOCOPY NUMBER,
78 p_msg_data OUT NOCOPY VARCHAR2,
79 --
80 P_POSITION_SET_GROUP_ID in NUMBER,
81 P_PAY_ELEMENT_ID in NUMBER,
82 P_Name IN VARCHAR2,
83 P_Return_Value IN OUT NOCOPY VARCHAR2
84 );
85
86
87 PROCEDURE Check_References
88 (
89 p_api_version IN NUMBER,
90 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
91 p_commit IN VARCHAR2 := FND_API.G_FALSE,
92 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
93 p_return_status OUT NOCOPY VARCHAR2,
94 p_msg_count OUT NOCOPY NUMBER,
95 p_msg_data OUT NOCOPY VARCHAR2,
96 --
97 P_POSITION_SET_GROUP_ID in NUMBER,
98 P_Return_Value IN OUT NOCOPY VARCHAR2
99 );
100
101
102 END PSB_ELEMENT_POS_SET_GROUPS_PVT;