[Home] [Help]
PACKAGE: APPS.PSB_DEFAULTS_PVT
Source
1 PACKAGE PSB_DEFAULTS_PVT AS
2 /* $Header: PSBVPDFS.pls 120.3 2004/11/30 14:16:25 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_RULE_ID in NUMBER,
16 P_NAME in VARCHAR2,
17 P_GLOBAL_DEFAULT_FLAG IN VARCHAR2,
18 P_DATA_EXTRACT_ID IN NUMBER,
19 P_BUSINESS_GROUP_ID IN NUMBER,
20 P_ENTITY_ID IN NUMBER,
21 P_PRIORITY IN NUMBER,
22 P_CREATION_DATE in DATE,
23 P_CREATED_BY in NUMBER,
24 P_LAST_UPDATE_DATE in DATE,
25 P_LAST_UPDATED_BY in NUMBER,
26 P_LAST_UPDATE_LOGIN in NUMBER,
27 /* Bug 1308558 Start */
28 P_OVERWRITE IN VARCHAR2 DEFAULT NULL
29 /* Bug 1308558 End */
30 );
31
32 PROCEDURE UPDATE_ROW
33 ( p_api_version IN NUMBER,
34 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
35 p_commit IN VARCHAR2 := FND_API.G_FALSE,
36 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
37 p_return_status OUT NOCOPY VARCHAR2,
38 p_msg_count OUT NOCOPY NUMBER,
39 p_msg_data OUT NOCOPY VARCHAR2,
40 --
41 P_ROW_ID IN VARCHAR2,
42 P_DEFAULT_RULE_ID in NUMBER,
43 P_NAME in VARCHAR2,
44 P_GLOBAL_DEFAULT_FLAG IN VARCHAR2,
45 P_DATA_EXTRACT_ID IN NUMBER,
46 P_BUSINESS_GROUP_ID IN NUMBER,
47 P_ENTITY_ID IN NUMBER,
48 P_PRIORITY IN NUMBER,
49 P_LAST_UPDATE_DATE in DATE,
50 P_LAST_UPDATED_BY in NUMBER,
51 P_LAST_UPDATE_LOGIN in NUMBER,
52 /* Bug 1308558 Start */
53 P_OVERWRITE IN VARCHAR2 DEFAULT NULL
54 /* Bug 1308558 End */
55 );
56
57 PROCEDURE DELETE_ROW
58 ( p_api_version IN NUMBER,
59 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
60 p_commit IN VARCHAR2 := FND_API.G_FALSE,
61 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
62 p_return_status OUT NOCOPY VARCHAR2,
63 p_msg_count OUT NOCOPY NUMBER,
64 p_msg_data OUT NOCOPY VARCHAR2,
65 --
66 P_DEFAULT_RULE_ID IN NUMBER,
67 P_ENTITY_ID IN NUMBER,
68 /* Bug 1308558 Start */
69 P_SOURCE_FORM IN VARCHAR2 DEFAULT NULL
70 /* Bug 1308558 End */
71 );
72
73 PROCEDURE LOCK_ROW
74 ( p_api_version IN NUMBER,
75 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
76 p_commit IN VARCHAR2 := FND_API.G_FALSE,
77 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
78 p_return_status OUT NOCOPY VARCHAR2,
79 p_msg_count OUT NOCOPY NUMBER,
80 p_msg_data OUT NOCOPY VARCHAR2,
81 --
82 p_row_locked OUT NOCOPY VARCHAR2,
83 --
84 P_ROW_ID IN VARCHAR2,
85 P_DEFAULT_RULE_ID in NUMBER,
86 P_NAME in VARCHAR2,
87 P_GLOBAL_DEFAULT_FLAG IN VARCHAR2,
88 P_DATA_EXTRACT_ID IN NUMBER,
89 P_BUSINESS_GROUP_ID IN NUMBER,
90 P_ENTITY_ID IN NUMBER,
91 P_PRIORITY IN NUMBER,
92 /* Bug 1308558 Start */
93 P_OVERWRITE IN VARCHAR2 DEFAULT NULL,
94 P_SOURCE_FORM IN VARCHAR2 DEFAULT 'F'
95 /* Bug 1308558 End */
96 );
97
98 PROCEDURE Check_Unique
99 (
100 p_api_version IN NUMBER,
101 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
102 p_commit IN VARCHAR2 := FND_API.G_FALSE,
103 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
104 p_return_status OUT NOCOPY VARCHAR2,
105 p_msg_count OUT NOCOPY NUMBER,
106 p_msg_data OUT NOCOPY VARCHAR2,
107 --
108 P_DEFAULT_RULE_ID in NUMBER,
109 P_NAME in VARCHAR2,
110 P_DATA_EXTRACT_ID IN NUMBER,
111 P_RETURN_VALUE IN OUT NOCOPY VARCHAR2
112 );
113
114 PROCEDURE Check_Global_Default
115 (
116 p_api_version IN NUMBER,
117 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
118 p_commit IN VARCHAR2 := FND_API.G_FALSE,
119 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
120 p_return_status OUT NOCOPY VARCHAR2,
121 p_msg_count OUT NOCOPY NUMBER,
122 p_msg_data OUT NOCOPY VARCHAR2,
123 --
124 P_ROW_ID IN VARCHAR2,
125 P_DATA_EXTRACT_ID IN NUMBER,
126 P_GLOBAL_DEFAULT_FLAG IN VARCHAR2,
127 P_RETURN_VALUE IN OUT NOCOPY VARCHAR2
128 );
129
130 PROCEDURE Check_References
131 (
132 p_api_version IN NUMBER,
133 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
134 p_commit IN VARCHAR2 := FND_API.G_FALSE,
135 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
136 p_return_status OUT NOCOPY VARCHAR2,
137 p_msg_count OUT NOCOPY NUMBER,
138 p_msg_data OUT NOCOPY VARCHAR2,
139 --
140 P_DEFAULT_RULE_ID in NUMBER,
141 P_NAME in VARCHAR2,
142 P_RETURN_VALUE IN OUT NOCOPY VARCHAR2
143 );
144
145
146 END PSB_DEFAULTS_PVT;