49: -- Parameters :
50: -- IN :
51: -- p_api_version_number: For 11i Oracle Sales application, this is 2.0.
52: -- p_init_msg_list : Initialize message stack or not. It's
53: -- FND_API.G_FALSE by default.
54: -- p_validation_level : Validation level for pass-in values.
55: -- It's FND_API.G_VALID_LEVEL_FULL by default.
56: -- p_commit : Whether commit the whole API at the end of API.
57: -- It's FND_API.G_FALSE by default.
51: -- p_api_version_number: For 11i Oracle Sales application, this is 2.0.
52: -- p_init_msg_list : Initialize message stack or not. It's
53: -- FND_API.G_FALSE by default.
54: -- p_validation_level : Validation level for pass-in values.
55: -- It's FND_API.G_VALID_LEVEL_FULL by default.
56: -- p_commit : Whether commit the whole API at the end of API.
57: -- It's FND_API.G_FALSE by default.
58: --
59: -- The above four parameters are standard input.
53: -- FND_API.G_FALSE by default.
54: -- p_validation_level : Validation level for pass-in values.
55: -- It's FND_API.G_VALID_LEVEL_FULL by default.
56: -- p_commit : Whether commit the whole API at the end of API.
57: -- It's FND_API.G_FALSE by default.
58: --
59: -- The above four parameters are standard input.
60: --
61: -- IN :
65: --
66: -- OUT :
67: -- x_return_status :
68: -- The return status. If your code completes
69: -- successfully, then FND_API.G_RET_STS_SUCCESS
70: -- should be returned; if you get an expected error,
71: -- then return FND_API.G_RET_STS_ERROR; otherwise
72: -- return FND_API.G_RET_STS_UNEXP_ERROR.
73: -- x_msg_count :
67: -- x_return_status :
68: -- The return status. If your code completes
69: -- successfully, then FND_API.G_RET_STS_SUCCESS
70: -- should be returned; if you get an expected error,
71: -- then return FND_API.G_RET_STS_ERROR; otherwise
72: -- return FND_API.G_RET_STS_UNEXP_ERROR.
73: -- x_msg_count :
74: -- The message count.
75: -- Call FND_MSG_PUB.Count_And_Get to get the message
68: -- The return status. If your code completes
69: -- successfully, then FND_API.G_RET_STS_SUCCESS
70: -- should be returned; if you get an expected error,
71: -- then return FND_API.G_RET_STS_ERROR; otherwise
72: -- return FND_API.G_RET_STS_UNEXP_ERROR.
73: -- x_msg_count :
74: -- The message count.
75: -- Call FND_MSG_PUB.Count_And_Get to get the message
76: -- count and messages.
83: -- parameters.
84: --
85: PROCEDURE ATA_Pre(
86: p_api_version_number IN NUMBER,
87: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
88: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
89: p_commit IN VARCHAR2 := FND_API.G_FALSE,
90: p_param1 IN VARCHAR2,
91: p_param2 IN VARCHAR2,
84: --
85: PROCEDURE ATA_Pre(
86: p_api_version_number IN NUMBER,
87: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
88: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
89: p_commit IN VARCHAR2 := FND_API.G_FALSE,
90: p_param1 IN VARCHAR2,
91: p_param2 IN VARCHAR2,
92: p_param3 IN VARCHAR2,
85: PROCEDURE ATA_Pre(
86: p_api_version_number IN NUMBER,
87: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
88: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
89: p_commit IN VARCHAR2 := FND_API.G_FALSE,
90: p_param1 IN VARCHAR2,
91: p_param2 IN VARCHAR2,
92: p_param3 IN VARCHAR2,
93: x_return_status OUT NOCOPY VARCHAR2,
101: -- Parameters :
102: -- IN :
103: -- p_api_version_number: For 11i Oracle Sales application, this is 2.0.
104: -- p_init_msg_list : Initialize message stack or not. It's
105: -- FND_API.G_FALSE by default.
106: -- p_validation_level : Validation level for pass-in values.
107: -- It's FND_API.G_VALID_LEVEL_FULL by default.
108: -- p_commit : Whether commit the whole API at the end of API.
109: -- It's FND_API.G_FALSE by default.
103: -- p_api_version_number: For 11i Oracle Sales application, this is 2.0.
104: -- p_init_msg_list : Initialize message stack or not. It's
105: -- FND_API.G_FALSE by default.
106: -- p_validation_level : Validation level for pass-in values.
107: -- It's FND_API.G_VALID_LEVEL_FULL by default.
108: -- p_commit : Whether commit the whole API at the end of API.
109: -- It's FND_API.G_FALSE by default.
110: --
111: -- The above four parameters are standard input.
105: -- FND_API.G_FALSE by default.
106: -- p_validation_level : Validation level for pass-in values.
107: -- It's FND_API.G_VALID_LEVEL_FULL by default.
108: -- p_commit : Whether commit the whole API at the end of API.
109: -- It's FND_API.G_FALSE by default.
110: --
111: -- The above four parameters are standard input.
112: --
113: -- IN :
117: --
118: -- OUT :
119: -- x_return_status :
120: -- The return status. If your code completes
121: -- successfully, then FND_API.G_RET_STS_SUCCESS
122: -- should be returned; if you get an expected error,
123: -- then return FND_API.G_RET_STS_ERROR; otherwise
124: -- return FND_API.G_RET_STS_UNEXP_ERROR.
125: -- x_msg_count :
119: -- x_return_status :
120: -- The return status. If your code completes
121: -- successfully, then FND_API.G_RET_STS_SUCCESS
122: -- should be returned; if you get an expected error,
123: -- then return FND_API.G_RET_STS_ERROR; otherwise
124: -- return FND_API.G_RET_STS_UNEXP_ERROR.
125: -- x_msg_count :
126: -- The message count.
127: -- Call FND_MSG_PUB.Count_And_Get to get the message
120: -- The return status. If your code completes
121: -- successfully, then FND_API.G_RET_STS_SUCCESS
122: -- should be returned; if you get an expected error,
123: -- then return FND_API.G_RET_STS_ERROR; otherwise
124: -- return FND_API.G_RET_STS_UNEXP_ERROR.
125: -- x_msg_count :
126: -- The message count.
127: -- Call FND_MSG_PUB.Count_And_Get to get the message
128: -- count and messages.
135: -- parameters.
136: --
137: PROCEDURE ATA_Post(
138: p_api_version_number IN NUMBER,
139: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
140: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
141: p_commit IN VARCHAR2 := FND_API.G_FALSE,
142: p_param1 IN VARCHAR2,
143: p_param2 IN VARCHAR2,
136: --
137: PROCEDURE ATA_Post(
138: p_api_version_number IN NUMBER,
139: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
140: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
141: p_commit IN VARCHAR2 := FND_API.G_FALSE,
142: p_param1 IN VARCHAR2,
143: p_param2 IN VARCHAR2,
144: p_param3 IN VARCHAR2,
137: PROCEDURE ATA_Post(
138: p_api_version_number IN NUMBER,
139: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
140: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
141: p_commit IN VARCHAR2 := FND_API.G_FALSE,
142: p_param1 IN VARCHAR2,
143: p_param2 IN VARCHAR2,
144: p_param3 IN VARCHAR2,
145: p_request_id IN NUMBER,