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,
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,
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: --
39: );
40:
41: PROCEDURE UPDATE_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,
40:
41: PROCEDURE UPDATE_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,
41: PROCEDURE UPDATE_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: --
72: );
73:
74: PROCEDURE DELETE_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,
73:
74: PROCEDURE DELETE_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,
74: PROCEDURE DELETE_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: --
84: );
85:
86: PROCEDURE LOCK_ROW
87: ( p_api_version IN NUMBER,
88: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
89: p_commit IN VARCHAR2 := FND_API.G_FALSE,
90: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
91: p_return_status OUT NOCOPY VARCHAR2,
92: p_msg_count OUT NOCOPY NUMBER,
85:
86: PROCEDURE LOCK_ROW
87: ( p_api_version IN NUMBER,
88: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
89: p_commit IN VARCHAR2 := FND_API.G_FALSE,
90: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
91: p_return_status OUT NOCOPY VARCHAR2,
92: p_msg_count OUT NOCOPY NUMBER,
93: p_msg_data OUT NOCOPY VARCHAR2,
86: PROCEDURE LOCK_ROW
87: ( p_api_version IN NUMBER,
88: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
89: p_commit IN VARCHAR2 := FND_API.G_FALSE,
90: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
91: p_return_status OUT NOCOPY VARCHAR2,
92: p_msg_count OUT NOCOPY NUMBER,
93: p_msg_data OUT NOCOPY VARCHAR2,
94: --
118:
119: PROCEDURE Check_Unique
120: (
121: p_api_version IN NUMBER,
122: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
123: p_commit IN VARCHAR2 := FND_API.G_FALSE,
124: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
125: p_return_status OUT NOCOPY VARCHAR2,
126: p_msg_count OUT NOCOPY NUMBER,
119: PROCEDURE Check_Unique
120: (
121: p_api_version IN NUMBER,
122: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
123: p_commit IN VARCHAR2 := FND_API.G_FALSE,
124: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
125: p_return_status OUT NOCOPY VARCHAR2,
126: p_msg_count OUT NOCOPY NUMBER,
127: p_msg_data OUT NOCOPY VARCHAR2,
120: (
121: p_api_version IN NUMBER,
122: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
123: p_commit IN VARCHAR2 := FND_API.G_FALSE,
124: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
125: p_return_status OUT NOCOPY VARCHAR2,
126: p_msg_count OUT NOCOPY NUMBER,
127: p_msg_data OUT NOCOPY VARCHAR2,
128: --
134:
135: PROCEDURE Check_References1
136: (
137: p_api_version IN NUMBER,
138: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
139: p_commit IN VARCHAR2 := FND_API.G_FALSE,
140: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
141: p_return_status OUT NOCOPY VARCHAR2,
142: p_msg_count OUT NOCOPY NUMBER,
135: PROCEDURE Check_References1
136: (
137: p_api_version IN NUMBER,
138: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
139: p_commit IN VARCHAR2 := FND_API.G_FALSE,
140: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
141: p_return_status OUT NOCOPY VARCHAR2,
142: p_msg_count OUT NOCOPY NUMBER,
143: p_msg_data OUT NOCOPY VARCHAR2,
136: (
137: p_api_version IN NUMBER,
138: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
139: p_commit IN VARCHAR2 := FND_API.G_FALSE,
140: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
141: p_return_status OUT NOCOPY VARCHAR2,
142: p_msg_count OUT NOCOPY NUMBER,
143: p_msg_data OUT NOCOPY VARCHAR2,
144: --
150:
151: PROCEDURE Check_References2
152: (
153: p_api_version IN NUMBER,
154: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
155: p_commit IN VARCHAR2 := FND_API.G_FALSE,
156: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
157: p_return_status OUT NOCOPY VARCHAR2,
158: p_msg_count OUT NOCOPY NUMBER,
151: PROCEDURE Check_References2
152: (
153: p_api_version IN NUMBER,
154: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
155: p_commit IN VARCHAR2 := FND_API.G_FALSE,
156: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
157: p_return_status OUT NOCOPY VARCHAR2,
158: p_msg_count OUT NOCOPY NUMBER,
159: p_msg_data OUT NOCOPY VARCHAR2,
152: (
153: p_api_version IN NUMBER,
154: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
155: p_commit IN VARCHAR2 := FND_API.G_FALSE,
156: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
157: p_return_status OUT NOCOPY VARCHAR2,
158: p_msg_count OUT NOCOPY NUMBER,
159: p_msg_data OUT NOCOPY VARCHAR2,
160: --
165: PROCEDURE Insert_System_Attributes
166: (
167:
168: p_api_version IN NUMBER,
169: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
170: p_commit IN VARCHAR2 := FND_API.G_FALSE,
171: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
172: p_return_status OUT NOCOPY VARCHAR2,
173: p_msg_count OUT NOCOPY NUMBER,
166: (
167:
168: p_api_version IN NUMBER,
169: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
170: p_commit IN VARCHAR2 := FND_API.G_FALSE,
171: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
172: p_return_status OUT NOCOPY VARCHAR2,
173: p_msg_count OUT NOCOPY NUMBER,
174: p_msg_data OUT NOCOPY VARCHAR2,
167:
168: p_api_version IN NUMBER,
169: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
170: p_commit IN VARCHAR2 := FND_API.G_FALSE,
171: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
172: p_return_status OUT NOCOPY VARCHAR2,
173: p_msg_count OUT NOCOPY NUMBER,
174: p_msg_data OUT NOCOPY VARCHAR2,
175: --