109: p_staging_tbl was modified to IN OUT NOCOPY
110: */
111: PROCEDURE Validate_Process_Rules(
112: p_api_version_number IN NUMBER,
113: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
114: p_simulate 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: x_return_status OUT NOCOPY VARCHAR2,
110: */
111: PROCEDURE Validate_Process_Rules(
112: p_api_version_number IN NUMBER,
113: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
114: p_simulate 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: x_return_status OUT NOCOPY VARCHAR2,
118: x_msg_count OUT NOCOPY NUMBER,
111: PROCEDURE Validate_Process_Rules(
112: p_api_version_number IN NUMBER,
113: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
114: p_simulate 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: x_return_status OUT NOCOPY VARCHAR2,
118: x_msg_count OUT NOCOPY NUMBER,
119: x_msg_data OUT NOCOPY VARCHAR2,
112: p_api_version_number IN NUMBER,
113: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
114: p_simulate 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: x_return_status OUT NOCOPY VARCHAR2,
118: x_msg_count OUT NOCOPY NUMBER,
119: x_msg_data OUT NOCOPY VARCHAR2,
120: p_transaction_type IN VARCHAR2,
160: p_staging_tbl was modified to IN OUT NOCOPY
161: */
162: PROCEDURE Validate_Column_Rules(
163: p_api_version_number IN NUMBER,
164: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
165: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
166: p_commit IN VARCHAR2 := FND_API.G_FALSE,
167: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
168: x_return_status OUT NOCOPY VARCHAR2,
161: */
162: PROCEDURE Validate_Column_Rules(
163: p_api_version_number IN NUMBER,
164: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
165: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
166: p_commit IN VARCHAR2 := FND_API.G_FALSE,
167: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
168: x_return_status OUT NOCOPY VARCHAR2,
169: x_msg_count OUT NOCOPY NUMBER,
162: PROCEDURE Validate_Column_Rules(
163: p_api_version_number IN NUMBER,
164: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
165: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
166: p_commit IN VARCHAR2 := FND_API.G_FALSE,
167: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
168: x_return_status OUT NOCOPY VARCHAR2,
169: x_msg_count OUT NOCOPY NUMBER,
170: x_msg_data OUT NOCOPY VARCHAR2,
163: p_api_version_number IN NUMBER,
164: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
165: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
166: p_commit IN VARCHAR2 := FND_API.G_FALSE,
167: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
168: x_return_status OUT NOCOPY VARCHAR2,
169: x_msg_count OUT NOCOPY NUMBER,
170: x_msg_data OUT NOCOPY VARCHAR2,
171: p_transaction_type IN VARCHAR2,