1 PACKAGE PSB_DEFAULT_ASSIGNMENTS_PVT AS
2 /* $Header: PSBVPDAS.pls 120.2 2005/07/13 11:28:02 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_ROW_ID IN OUT NOCOPY VARCHAR2,
15 P_DEFAULT_ASSIGNMENT_ID IN NUMBER,
16 P_DEFAULT_RULE_ID in NUMBER,
17 P_ASSIGNMENT_TYPE IN VARCHAR2,
18 P_ATTRIBUTE_ID IN NUMBER,
19 P_ATTRIBUTE_VALUE_ID IN NUMBER,
20 P_ATTRIBUTE_VALUE IN VARCHAR2,
21 P_PAY_ELEMENT_ID IN NUMBER,
22 P_PAY_ELEMENT_OPTION_ID IN NUMBER,
23 P_PAY_BASIS IN VARCHAR2,
24 P_ELEMENT_VALUE_TYPE IN VARCHAR2,
25 P_ELEMENT_VALUE IN NUMBER,
26 P_CURRENCY_CODE IN VARCHAR2,
27 P_LAST_UPDATE_DATE in DATE,
28 P_LAST_UPDATED_BY in NUMBER,
29 P_LAST_UPDATE_LOGIN in NUMBER,
30 P_CREATED_BY in NUMBER,
31 P_CREATION_DATE in DATE
32 );
33
34 PROCEDURE UPDATE_ROW
35 ( p_api_version IN NUMBER,
36 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
37 p_commit IN VARCHAR2 := FND_API.G_FALSE,
38 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
39 p_return_status OUT NOCOPY VARCHAR2,
40 p_msg_count OUT NOCOPY NUMBER,
41 p_msg_data OUT NOCOPY VARCHAR2,
42 --
43 P_ROW_ID IN VARCHAR2,
44 P_DEFAULT_ASSIGNMENT_ID IN NUMBER,
45 P_DEFAULT_RULE_ID in NUMBER,
46 P_ASSIGNMENT_TYPE IN VARCHAR2,
47 P_ATTRIBUTE_ID IN NUMBER,
48 P_ATTRIBUTE_VALUE_ID IN NUMBER,
49 P_ATTRIBUTE_VALUE IN VARCHAR2,
50 P_PAY_ELEMENT_ID IN NUMBER,
51 P_PAY_ELEMENT_OPTION_ID IN NUMBER,
52 P_PAY_BASIS IN VARCHAR2,
53 P_ELEMENT_VALUE_TYPE IN VARCHAR2,
54 P_ELEMENT_VALUE IN NUMBER,
55 P_CURRENCY_CODE IN VARCHAR2,
56 P_LAST_UPDATE_DATE in DATE,
57 P_LAST_UPDATED_BY in NUMBER,
58 P_LAST_UPDATE_LOGIN in NUMBER
59 );
60
61
62 PROCEDURE DELETE_ROW
63 ( p_api_version IN NUMBER,
64 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
65 p_commit IN VARCHAR2 := FND_API.G_FALSE,
66 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
67 p_return_status OUT NOCOPY VARCHAR2,
68 p_msg_count OUT NOCOPY NUMBER,
69 p_msg_data OUT NOCOPY VARCHAR2,
70 --
71 P_ROW_ID IN VARCHAR2
72 );
73
74 PROCEDURE LOCK_ROW
75 ( p_api_version IN NUMBER,
76 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
77 p_commit IN VARCHAR2 := FND_API.G_FALSE,
78 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
79 p_return_status OUT NOCOPY VARCHAR2,
80 p_msg_count OUT NOCOPY NUMBER,
81 p_msg_data OUT NOCOPY VARCHAR2,
82 --
83 p_row_locked OUT NOCOPY VARCHAR2,
84 --
85 P_ROW_ID IN VARCHAR2,
86 P_DEFAULT_ASSIGNMENT_ID IN NUMBER,
87 P_DEFAULT_RULE_ID in NUMBER,
88 P_ASSIGNMENT_TYPE IN VARCHAR2,
89 P_ATTRIBUTE_ID IN NUMBER,
90 P_ATTRIBUTE_VALUE_ID IN NUMBER,
91 P_ATTRIBUTE_VALUE IN VARCHAR2,
92 P_PAY_ELEMENT_ID IN NUMBER,
93 P_PAY_ELEMENT_OPTION_ID IN NUMBER,
94 P_PAY_BASIS IN VARCHAR2,
95 P_ELEMENT_VALUE_TYPE IN VARCHAR2,
96 P_ELEMENT_VALUE IN NUMBER,
97 P_CURRENCY_CODE IN VARCHAR2
98 );
99
100 PROCEDURE CHECK_UNIQUE
101 ( p_api_version IN NUMBER,
102 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
103 p_commit IN VARCHAR2 := FND_API.G_FALSE,
104 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
105 p_return_status OUT NOCOPY VARCHAR2,
106 p_msg_count OUT NOCOPY NUMBER,
107 p_msg_data OUT NOCOPY VARCHAR2,
108 --
109 p_return_value IN OUT NOCOPY VARCHAR2,
110 --
111 P_DEFAULT_RULE_ID IN NUMBER,
112 P_DEFAULT_ASSIGNMENT_ID IN NUMBER,
113 P_ATTRIBUTE_ID IN NUMBER,
114 P_PAY_ELEMENT_ID IN NUMBER,
115 P_PAY_ELEMENT_OPTION_ID IN NUMBER
116 );
117
118
119 END PSB_DEFAULT_ASSIGNMENTS_PVT;