3:
4: PROCEDURE Insert_Row
5: (
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: PROCEDURE Insert_Row
5: (
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: (
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: --
36:
37: PROCEDURE Lock_Row
38: (
39: p_api_version IN NUMBER,
40: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
41: p_commit IN VARCHAR2 := FND_API.G_FALSE,
42: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
43: p_return_status OUT NOCOPY VARCHAR2,
44: p_msg_count OUT NOCOPY NUMBER,
37: PROCEDURE Lock_Row
38: (
39: p_api_version IN NUMBER,
40: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
41: p_commit IN VARCHAR2 := FND_API.G_FALSE,
42: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
43: p_return_status OUT NOCOPY VARCHAR2,
44: p_msg_count OUT NOCOPY NUMBER,
45: p_msg_data OUT NOCOPY VARCHAR2,
38: (
39: p_api_version IN NUMBER,
40: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
41: p_commit IN VARCHAR2 := FND_API.G_FALSE,
42: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
43: p_return_status OUT NOCOPY VARCHAR2,
44: p_msg_count OUT NOCOPY NUMBER,
45: p_msg_data OUT NOCOPY VARCHAR2,
46: --
66:
67: PROCEDURE Update_Row
68: (
69: p_api_version IN NUMBER,
70: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
71: p_commit IN VARCHAR2 := FND_API.G_FALSE,
72: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
73: p_return_status OUT NOCOPY VARCHAR2,
74: p_msg_count OUT NOCOPY NUMBER,
67: PROCEDURE Update_Row
68: (
69: p_api_version IN NUMBER,
70: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
71: p_commit IN VARCHAR2 := FND_API.G_FALSE,
72: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
73: p_return_status OUT NOCOPY VARCHAR2,
74: p_msg_count OUT NOCOPY NUMBER,
75: p_msg_data OUT NOCOPY VARCHAR2,
68: (
69: p_api_version IN NUMBER,
70: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
71: p_commit IN VARCHAR2 := FND_API.G_FALSE,
72: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
73: p_return_status OUT NOCOPY VARCHAR2,
74: p_msg_count OUT NOCOPY NUMBER,
75: p_msg_data OUT NOCOPY VARCHAR2,
76: --
96:
97: PROCEDURE Delete_Row
98: (
99: p_api_version IN NUMBER,
100: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
101: p_commit IN VARCHAR2 := FND_API.G_FALSE,
102: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
103: p_return_status OUT NOCOPY VARCHAR2,
104: p_msg_count OUT NOCOPY NUMBER,
97: PROCEDURE Delete_Row
98: (
99: p_api_version IN NUMBER,
100: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
101: p_commit IN VARCHAR2 := FND_API.G_FALSE,
102: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
103: p_return_status OUT NOCOPY VARCHAR2,
104: p_msg_count OUT NOCOPY NUMBER,
105: p_msg_data OUT NOCOPY VARCHAR2,
98: (
99: p_api_version IN NUMBER,
100: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
101: p_commit IN VARCHAR2 := FND_API.G_FALSE,
102: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
103: p_return_status OUT NOCOPY VARCHAR2,
104: p_msg_count OUT NOCOPY NUMBER,
105: p_msg_data OUT NOCOPY VARCHAR2,
106: --
110:
111: PROCEDURE Check_Unique
112: (
113: p_api_version IN NUMBER,
114: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
115: p_commit IN VARCHAR2 := FND_API.G_FALSE,
116: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
117: p_return_status OUT NOCOPY VARCHAR2,
118: p_msg_count OUT NOCOPY NUMBER,
111: PROCEDURE Check_Unique
112: (
113: p_api_version IN NUMBER,
114: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
115: p_commit IN VARCHAR2 := FND_API.G_FALSE,
116: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
117: p_return_status OUT NOCOPY VARCHAR2,
118: p_msg_count OUT NOCOPY NUMBER,
119: p_msg_data OUT NOCOPY VARCHAR2,
112: (
113: p_api_version IN NUMBER,
114: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
115: p_commit IN VARCHAR2 := FND_API.G_FALSE,
116: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
117: p_return_status OUT NOCOPY VARCHAR2,
118: p_msg_count OUT NOCOPY NUMBER,
119: p_msg_data OUT NOCOPY VARCHAR2,
120: --
127:
128: PROCEDURE Validate_Account_Overlap
129: (
130: p_api_version IN NUMBER,
131: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
132: p_commit IN VARCHAR2 := FND_API.G_FALSE,
133: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
134: p_return_status OUT NOCOPY VARCHAR2,
135: p_msg_count OUT NOCOPY NUMBER,
128: PROCEDURE Validate_Account_Overlap
129: (
130: p_api_version IN NUMBER,
131: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
132: p_commit IN VARCHAR2 := FND_API.G_FALSE,
133: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
134: p_return_status OUT NOCOPY VARCHAR2,
135: p_msg_count OUT NOCOPY NUMBER,
136: p_msg_data OUT NOCOPY VARCHAR2,
129: (
130: p_api_version IN NUMBER,
131: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
132: p_commit IN VARCHAR2 := FND_API.G_FALSE,
133: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
134: p_return_status OUT NOCOPY VARCHAR2,
135: p_msg_count OUT NOCOPY NUMBER,
136: p_msg_data OUT NOCOPY VARCHAR2,
137: --