FND_API.G_RET_STS_SUCCESS
33: * @param p_reference_code the reference code eg. esc for escalations
34: * @param p_usage the usage for reference creation
35: * @param x_return_status the parameter that returns the result of all the operations performed.
36: * by the API and must have one of the following values:
37: * FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
FND_API.G_RET_STS_ERROR
34: * @param p_usage the usage for reference creation
35: * @param x_return_status the parameter that returns the result of all the operations performed.
36: * by the API and must have one of the following values:
37: *
FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
35: * @param x_return_status the parameter that returns the result of all the operations performed.
36: * by the API and must have one of the following values:
37: *
FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
62: * @rep:compatibility S
63: */
64: PROCEDURE create_references (
65: p_api_version IN NUMBER,
66: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
67: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
68: p_escalation_id IN NUMBER DEFAULT NULL,
69: p_escalation_number IN VARCHAR2 DEFAULT NULL,
70: p_object_type_code IN VARCHAR2,
63: */
64: PROCEDURE create_references (
65: p_api_version IN NUMBER,
66: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
67: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
68: p_escalation_id IN NUMBER DEFAULT NULL,
69: p_escalation_number IN VARCHAR2 DEFAULT NULL,
70: p_object_type_code IN VARCHAR2,
71: p_object_name IN VARCHAR2,
FND_API.G_RET_STS_SUCCESS
116: * @param p_reference_code the reference code eg. esc for escalations
117: * @param p_usage the usage for reference creation
118: * @param x_return_status the parameter that returns the result of all the operations performed.
119: * by the API and must have one of the following values:
120: * FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
FND_API.G_RET_STS_ERROR
117: * @param p_usage the usage for reference creation
118: * @param x_return_status the parameter that returns the result of all the operations performed.
119: * by the API and must have one of the following values:
120: *
FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
118: * @param x_return_status the parameter that returns the result of all the operations performed.
119: * by the API and must have one of the following values:
120: *
FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
145: * @rep:compatibility S
146: */
147: PROCEDURE update_references (
148: p_api_version IN NUMBER,
149: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
150: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
151: p_object_version_number IN OUT NOCOPY NUMBER,
152: p_escalation_reference_id IN NUMBER,
153: p_object_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
146: */
147: PROCEDURE update_references (
148: p_api_version IN NUMBER,
149: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
150: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
151: p_object_version_number IN OUT NOCOPY NUMBER,
152: p_escalation_reference_id IN NUMBER,
153: p_object_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
154: p_object_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
149: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
150: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
151: p_object_version_number IN OUT NOCOPY NUMBER,
152: p_escalation_reference_id IN NUMBER,
153: p_object_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
154: p_object_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
155: p_object_id IN NUMBER DEFAULT fnd_api.g_miss_num,
156: p_object_details IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
157: p_reference_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
150: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
151: p_object_version_number IN OUT NOCOPY NUMBER,
152: p_escalation_reference_id IN NUMBER,
153: p_object_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
154: p_object_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
155: p_object_id IN NUMBER DEFAULT fnd_api.g_miss_num,
156: p_object_details IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
157: p_reference_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
158: p_usage IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
151: p_object_version_number IN OUT NOCOPY NUMBER,
152: p_escalation_reference_id IN NUMBER,
153: p_object_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
154: p_object_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
155: p_object_id IN NUMBER DEFAULT fnd_api.g_miss_num,
156: p_object_details IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
157: p_reference_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
158: p_usage IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
159: x_return_status OUT NOCOPY VARCHAR2,
152: p_escalation_reference_id IN NUMBER,
153: p_object_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
154: p_object_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
155: p_object_id IN NUMBER DEFAULT fnd_api.g_miss_num,
156: p_object_details IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
157: p_reference_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
158: p_usage IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
159: x_return_status OUT NOCOPY VARCHAR2,
160: x_msg_data OUT NOCOPY VARCHAR2,
153: p_object_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
154: p_object_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
155: p_object_id IN NUMBER DEFAULT fnd_api.g_miss_num,
156: p_object_details IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
157: p_reference_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
158: p_usage IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
159: x_return_status OUT NOCOPY VARCHAR2,
160: x_msg_data OUT NOCOPY VARCHAR2,
161: x_msg_count OUT NOCOPY NUMBER,
154: p_object_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
155: p_object_id IN NUMBER DEFAULT fnd_api.g_miss_num,
156: p_object_details IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
157: p_reference_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
158: p_usage IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
159: x_return_status OUT NOCOPY VARCHAR2,
160: x_msg_data OUT NOCOPY VARCHAR2,
161: x_msg_count OUT NOCOPY NUMBER,
162: p_attribute1 IN VARCHAR2 DEFAULT null ,
174: p_attribute13 IN VARCHAR2 DEFAULT null ,
175: p_attribute14 IN VARCHAR2 DEFAULT null ,
176: p_attribute15 IN VARCHAR2 DEFAULT null ,
177: p_attribute_category IN VARCHAR2 DEFAULT null ,
178: p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num
179: );
180:
181:
182: /*#
FND_API.G_RET_STS_SUCCESS
193: * @param p_object_version_number the object version number of the escalation reference record
194: * @param p_escalation_reference_id the escalation reference id
195: * @param x_return_status the parameter that returns the result of all the operations performed.
196: * by the API and must have one of the following values:
197: * FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
FND_API.G_RET_STS_ERROR
194: * @param p_escalation_reference_id the escalation reference id
195: * @param x_return_status the parameter that returns the result of all the operations performed.
196: * by the API and must have one of the following values:
197: *
FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
195: * @param x_return_status the parameter that returns the result of all the operations performed.
196: * by the API and must have one of the following values:
197: *
FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
205: * @rep:compatibility S
206: */
207: PROCEDURE delete_references (
208: p_api_version IN NUMBER,
209: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
210: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
211: p_object_version_number IN NUMBER,
212: p_escalation_reference_id IN NUMBER,
213: x_return_status OUT NOCOPY VARCHAR2,
206: */
207: PROCEDURE delete_references (
208: p_api_version IN NUMBER,
209: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
210: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
211: p_object_version_number IN NUMBER,
212: p_escalation_reference_id IN NUMBER,
213: x_return_status OUT NOCOPY VARCHAR2,
214: x_msg_data OUT NOCOPY VARCHAR2,
217:
218: --Created for BES enh 2660883
219:
220: TYPE Esc_Ref_rec IS RECORD (
221: TASK_REFERENCE_ID JTF_TASK_REFERENCES_B.TASK_REFERENCE_ID%TYPE := FND_API.G_MISS_NUM,
222: OBJECT_TYPE_CODE JTF_TASK_REFERENCES_B.OBJECT_TYPE_CODE%TYPE := FND_API.G_MISS_CHAR,
223: REFERENCE_CODE JTF_TASK_REFERENCES_B.REFERENCE_CODE%TYPE := FND_API.G_MISS_CHAR,
224: OBJECT_ID JTF_TASK_REFERENCES_B.OBJECT_ID%TYPE := FND_API.G_MISS_NUM,
225: TASK_ID JTF_TASK_REFERENCES_B.TASK_ID%TYPE := FND_API.G_MISS_NUM
218: --Created for BES enh 2660883
219:
220: TYPE Esc_Ref_rec IS RECORD (
221: TASK_REFERENCE_ID JTF_TASK_REFERENCES_B.TASK_REFERENCE_ID%TYPE := FND_API.G_MISS_NUM,
222: OBJECT_TYPE_CODE JTF_TASK_REFERENCES_B.OBJECT_TYPE_CODE%TYPE := FND_API.G_MISS_CHAR,
223: REFERENCE_CODE JTF_TASK_REFERENCES_B.REFERENCE_CODE%TYPE := FND_API.G_MISS_CHAR,
224: OBJECT_ID JTF_TASK_REFERENCES_B.OBJECT_ID%TYPE := FND_API.G_MISS_NUM,
225: TASK_ID JTF_TASK_REFERENCES_B.TASK_ID%TYPE := FND_API.G_MISS_NUM
226: );
219:
220: TYPE Esc_Ref_rec IS RECORD (
221: TASK_REFERENCE_ID JTF_TASK_REFERENCES_B.TASK_REFERENCE_ID%TYPE := FND_API.G_MISS_NUM,
222: OBJECT_TYPE_CODE JTF_TASK_REFERENCES_B.OBJECT_TYPE_CODE%TYPE := FND_API.G_MISS_CHAR,
223: REFERENCE_CODE JTF_TASK_REFERENCES_B.REFERENCE_CODE%TYPE := FND_API.G_MISS_CHAR,
224: OBJECT_ID JTF_TASK_REFERENCES_B.OBJECT_ID%TYPE := FND_API.G_MISS_NUM,
225: TASK_ID JTF_TASK_REFERENCES_B.TASK_ID%TYPE := FND_API.G_MISS_NUM
226: );
227:
220: TYPE Esc_Ref_rec IS RECORD (
221: TASK_REFERENCE_ID JTF_TASK_REFERENCES_B.TASK_REFERENCE_ID%TYPE := FND_API.G_MISS_NUM,
222: OBJECT_TYPE_CODE JTF_TASK_REFERENCES_B.OBJECT_TYPE_CODE%TYPE := FND_API.G_MISS_CHAR,
223: REFERENCE_CODE JTF_TASK_REFERENCES_B.REFERENCE_CODE%TYPE := FND_API.G_MISS_CHAR,
224: OBJECT_ID JTF_TASK_REFERENCES_B.OBJECT_ID%TYPE := FND_API.G_MISS_NUM,
225: TASK_ID JTF_TASK_REFERENCES_B.TASK_ID%TYPE := FND_API.G_MISS_NUM
226: );
227:
228: END;
221: TASK_REFERENCE_ID JTF_TASK_REFERENCES_B.TASK_REFERENCE_ID%TYPE := FND_API.G_MISS_NUM,
222: OBJECT_TYPE_CODE JTF_TASK_REFERENCES_B.OBJECT_TYPE_CODE%TYPE := FND_API.G_MISS_CHAR,
223: REFERENCE_CODE JTF_TASK_REFERENCES_B.REFERENCE_CODE%TYPE := FND_API.G_MISS_CHAR,
224: OBJECT_ID JTF_TASK_REFERENCES_B.OBJECT_ID%TYPE := FND_API.G_MISS_NUM,
225: TASK_ID JTF_TASK_REFERENCES_B.TASK_ID%TYPE := FND_API.G_MISS_NUM
226: );
227:
228: END;