DBA Data[Home] [Help]

APPS.JTF_EC_REFERENCES_PVT dependencies on FND_API

Line 37: *
  • 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
    38: *
  • FND_API.G_RET_STS_ERROR
    39: *
  • FND_API.G_RET_STS_UNEXP_ERROR
    40: * @param x_msg_data the parameter that returns the FND Message in encoded format.
    41: * @param x_msg_count the parameter that returns the number of messages in the FND message list.

    Line 38: *
  • 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
    38: *
  • FND_API.G_RET_STS_ERROR
    39: *
  • FND_API.G_RET_STS_UNEXP_ERROR
    40: * @param x_msg_data the parameter that returns the FND Message in encoded format.
    41: * @param x_msg_count the parameter that returns the number of messages in the FND message list.
    42: * @param x_escalation_reference_id the parameter that returns the Escalation reference ID

    Line 39: *
  • 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
    38: *
  • FND_API.G_RET_STS_ERROR
    39: *
  • FND_API.G_RET_STS_UNEXP_ERROR
    40: * @param x_msg_data the parameter that returns the FND Message in encoded format.
    41: * @param x_msg_count the parameter that returns the number of messages in the FND message list.
    42: * @param x_escalation_reference_id the parameter that returns the Escalation reference ID
    43: * @param p_attribute1 the value of the flex field attribute1

    Line 66: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

    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,

    Line 67: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

    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,

    Line 120: *
  • 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
    121: *
  • FND_API.G_RET_STS_ERROR
    122: *
  • FND_API.G_RET_STS_UNEXP_ERROR
    123: * @param x_msg_data the parameter that returns the FND Message in encoded format.
    124: * @param x_msg_count the parameter that returns the number of messages in the FND message list.

    Line 121: *
  • 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
    121: *
  • FND_API.G_RET_STS_ERROR
    122: *
  • FND_API.G_RET_STS_UNEXP_ERROR
    123: * @param x_msg_data the parameter that returns the FND Message in encoded format.
    124: * @param x_msg_count the parameter that returns the number of messages in the FND message list.
    125: * @param p_attribute1 the value of the flex field attribute1

    Line 122: *
  • 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
    121: *
  • FND_API.G_RET_STS_ERROR
    122: *
  • FND_API.G_RET_STS_UNEXP_ERROR
    123: * @param x_msg_data the parameter that returns the FND Message in encoded format.
    124: * @param x_msg_count the parameter that returns the number of messages in the FND message list.
    125: * @param p_attribute1 the value of the flex field attribute1
    126: * @param p_attribute2 the value of the flex field attribute2

    Line 149: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

    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,

    Line 150: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

    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,

    Line 153: p_object_type_code 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,

    Line 154: p_object_name 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,

    Line 155: p_object_id IN NUMBER DEFAULT fnd_api.g_miss_num,

    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,

    Line 156: p_object_details IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

    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,

    Line 157: p_reference_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

    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,

    Line 158: p_usage 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,
    162: p_attribute1 IN VARCHAR2 DEFAULT null ,

    Line 178: p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num

    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: /*#

    Line 197: *
  • 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
    198: *
  • FND_API.G_RET_STS_ERROR
    199: *
  • FND_API.G_RET_STS_UNEXP_ERROR
    200: * @param x_msg_data the parameter that returns the FND Message in encoded format.
    201: * @param x_msg_count the parameter that returns the number of messages in the FND message list.

    Line 198: *
  • 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
    198: *
  • FND_API.G_RET_STS_ERROR
    199: *
  • FND_API.G_RET_STS_UNEXP_ERROR
    200: * @param x_msg_data the parameter that returns the FND Message in encoded format.
    201: * @param x_msg_count the parameter that returns the number of messages in the FND message list.
    202: * @rep:scope private

    Line 199: *
  • 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
    198: *
  • FND_API.G_RET_STS_ERROR
    199: *
  • FND_API.G_RET_STS_UNEXP_ERROR
    200: * @param x_msg_data the parameter that returns the FND Message in encoded format.
    201: * @param x_msg_count the parameter that returns the number of messages in the FND message list.
    202: * @rep:scope private
    203: * @rep:lifecycle active

    Line 209: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

    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,

    Line 210: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

    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,

    Line 221: TASK_REFERENCE_ID JTF_TASK_REFERENCES_B.TASK_REFERENCE_ID%TYPE := FND_API.G_MISS_NUM,

    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

    Line 222: OBJECT_TYPE_CODE JTF_TASK_REFERENCES_B.OBJECT_TYPE_CODE%TYPE := FND_API.G_MISS_CHAR,

    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: );

    Line 223: REFERENCE_CODE JTF_TASK_REFERENCES_B.REFERENCE_CODE%TYPE := FND_API.G_MISS_CHAR,

    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:

    Line 224: OBJECT_ID JTF_TASK_REFERENCES_B.OBJECT_ID%TYPE := FND_API.G_MISS_NUM,

    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;

    Line 225: TASK_ID JTF_TASK_REFERENCES_B.TASK_ID%TYPE := FND_API.G_MISS_NUM

    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;