DBA Data[Home] [Help]

APPS.JTF_NOTES_PUB dependencies on FND_API

Line 46: -- p_parent_note_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

42: -- Type : Public
43: -- Description : Insert a Note into JTF_NOTES table
44: -- Pre-reqs :
45: -- Parameters :
46: -- p_parent_note_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
47: -- p_jtf_note_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
48: -- p_api_version IN NUMBER Required
49: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
50: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

Line 47: -- p_jtf_note_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

43: -- Description : Insert a Note into JTF_NOTES table
44: -- Pre-reqs :
45: -- Parameters :
46: -- p_parent_note_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
47: -- p_jtf_note_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
48: -- p_api_version IN NUMBER Required
49: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
50: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
51: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

Line 49: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE

45: -- Parameters :
46: -- p_parent_note_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
47: -- p_jtf_note_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
48: -- p_api_version IN NUMBER Required
49: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
50: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
51: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
52: -- This parameter should always be
53: -- FND_API.G_VALID_LEVEL_FULL if the api is called from external apis

Line 50: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

46: -- p_parent_note_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
47: -- p_jtf_note_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
48: -- p_api_version IN NUMBER Required
49: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
50: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
51: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
52: -- This parameter should always be
53: -- FND_API.G_VALID_LEVEL_FULL if the api is called from external apis
54: -- p_return_status OUT VARCHAR2 Required Length = 1

Line 51: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

47: -- p_jtf_note_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
48: -- p_api_version IN NUMBER Required
49: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
50: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
51: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
52: -- This parameter should always be
53: -- FND_API.G_VALID_LEVEL_FULL if the api is called from external apis
54: -- p_return_status OUT VARCHAR2 Required Length = 1
55: -- p_msg_count OUT NUMBER Required

Line 53: -- FND_API.G_VALID_LEVEL_FULL if the api is called from external apis

49: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
50: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
51: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
52: -- This parameter should always be
53: -- FND_API.G_VALID_LEVEL_FULL if the api is called from external apis
54: -- p_return_status OUT VARCHAR2 Required Length = 1
55: -- p_msg_count OUT NUMBER Required
56: -- p_msg_data OUT VARCHAR2 Required Length = 2000
57: -- p_source_object_id IN NUMBER (eg request_id for Service Request)

Line 156: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE

152: -- Usage : Updates a note record in the table JTF_NOTES
153: -- Pre-reqs : None
154: -- Parameters :
155: -- p_api_version IN NUMBER Required
156: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
157: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
158: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
159: -- x_return_status OUT VARCHAR2 Required
160: -- x_msg_count OUT NUMBER Required

Line 157: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

153: -- Pre-reqs : None
154: -- Parameters :
155: -- p_api_version IN NUMBER Required
156: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
157: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
158: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
159: -- x_return_status OUT VARCHAR2 Required
160: -- x_msg_count OUT NUMBER Required
161: -- x_msg_data OUT VARCHAR2 Required

Line 158: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

154: -- Parameters :
155: -- p_api_version IN NUMBER Required
156: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
157: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
158: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
159: -- x_return_status OUT VARCHAR2 Required
160: -- x_msg_count OUT NUMBER Required
161: -- x_msg_data OUT VARCHAR2 Required
162: -- p_jtf_note_id IN NUMBER Required Primary key of the note record

Line 251: ( p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

247: -- Type : Private
248: -- Usage : This procedure will update a record in the jtf_note_contexts
249: -- table.
250: -- --------------------------------------------------------------------------
251: ( p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
252: , x_return_status OUT NOCOPY VARCHAR2
253: , p_note_context_id IN NUMBER
254: , p_jtf_note_id IN NUMBER
255: , p_note_context_type_id IN NUMBER

Line 367: * @param p_validation_level This value determines whether validation should occur or not. This variable is checked against FND_API.G_VALID_LEVEL_NONE and if it is greater than the latter, validation occurs.

363: * @param p_jtf_note_id Unique note identifier, identifies which note record is to be deleted.
364: * @param p_api_version Standard API version number.
365: * @param p_init_msg_list Standard API flag allows API callers to request that the API does the initialization of the message list on their behalf. By default, the message list will not be initialized.
366: * @param p_commit Optional Standard API flag is used by API callers to ask the API to commit on their behalf after performing its function. By default, the commit will not be performed.
367: * @param p_validation_level This value determines whether validation should occur or not. This variable is checked against FND_API.G_VALID_LEVEL_NONE and if it is greater than the latter, validation occurs.
368: * @param x_return_status Result of all the operations performed by the API. This will have one of the following values:
369: *

  • FND_API.G_RET_STS_SUCCESS - If the API processed the data successfully.
    370: *
  • FND_API.G_RET_STS_ERROR - If there was an expected error in API processing.
    371: *
  • FND_API.G_RET_STS_UNEXP_ERROR If there was an unexpected error in API processing.

    Line 369: *
  • FND_API.G_RET_STS_SUCCESS - If the API processed the data successfully.

    • 365: * @param p_init_msg_list Standard API flag allows API callers to request that the API does the initialization of the message list on their behalf. By default, the message list will not be initialized.
    366: * @param p_commit Optional Standard API flag is used by API callers to ask the API to commit on their behalf after performing its function. By default, the commit will not be performed.
    367: * @param p_validation_level This value determines whether validation should occur or not. This variable is checked against FND_API.G_VALID_LEVEL_NONE and if it is greater than the latter, validation occurs.
    368: * @param x_return_status Result of all the operations performed by the API. This will have one of the following values:
    369: *

  • FND_API.G_RET_STS_SUCCESS - If the API processed the data successfully.
    370: *
  • FND_API.G_RET_STS_ERROR - If there was an expected error in API processing.
    371: *
  • FND_API.G_RET_STS_UNEXP_ERROR If there was an unexpected error in API processing.
    372: * @param x_msg_count Number of messages returned in the API message list.
    373: * @param x_msg_data Returned message data in an encoded format if x_msg_count returns non-zero value.

    Line 370: *
  • FND_API.G_RET_STS_ERROR - If there was an expected error in API processing.

    • 366: * @param p_commit Optional Standard API flag is used by API callers to ask the API to commit on their behalf after performing its function. By default, the commit will not be performed.
    367: * @param p_validation_level This value determines whether validation should occur or not. This variable is checked against FND_API.G_VALID_LEVEL_NONE and if it is greater than the latter, validation occurs.
    368: * @param x_return_status Result of all the operations performed by the API. This will have one of the following values:
    369: *

  • FND_API.G_RET_STS_SUCCESS - If the API processed the data successfully.
    370: *
  • FND_API.G_RET_STS_ERROR - If there was an expected error in API processing.
    371: *
  • FND_API.G_RET_STS_UNEXP_ERROR If there was an unexpected error in API processing.
    372: * @param x_msg_count Number of messages returned in the API message list.
    373: * @param x_msg_data Returned message data in an encoded format if x_msg_count returns non-zero value.
    374: * @param p_use_AOL_security AOL Security Flag, Optional Default FND_API.G_TRUE.

    Line 371: *
  • FND_API.G_RET_STS_UNEXP_ERROR If there was an unexpected error in API processing.

    • 367: * @param p_validation_level This value determines whether validation should occur or not. This variable is checked against FND_API.G_VALID_LEVEL_NONE and if it is greater than the latter, validation occurs.
    368: * @param x_return_status Result of all the operations performed by the API. This will have one of the following values:
    369: *

  • FND_API.G_RET_STS_SUCCESS - If the API processed the data successfully.
    370: *
  • FND_API.G_RET_STS_ERROR - If there was an expected error in API processing.
    371: *
  • FND_API.G_RET_STS_UNEXP_ERROR If there was an unexpected error in API processing.
    372: * @param x_msg_count Number of messages returned in the API message list.
    373: * @param x_msg_data Returned message data in an encoded format if x_msg_count returns non-zero value.
    374: * @param p_use_AOL_security AOL Security Flag, Optional Default FND_API.G_TRUE.
    375: * @rep:scope public

    Line 374: * @param p_use_AOL_security AOL Security Flag, Optional Default FND_API.G_TRUE.

    370: *

  • FND_API.G_RET_STS_ERROR - If there was an expected error in API processing.
    371: *
  • FND_API.G_RET_STS_UNEXP_ERROR If there was an unexpected error in API processing.
    372: * @param x_msg_count Number of messages returned in the API message list.
    373: * @param x_msg_data Returned message data in an encoded format if x_msg_count returns non-zero value.
    374: * @param p_use_AOL_security AOL Security Flag, Optional Default FND_API.G_TRUE.
    375: * @rep:scope public
    376: * @rep:lifecycle active
    377: * @rep:displayname Delete Note
    378: * @rep:metalink 249665.1 Oracle Common Application Calendar - API Reference Guide

    Line 394: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE

    390: -- Usage : Deletes a note record in the table JTF_NOTES_B/JTF_NOTES_TL and JTF_NOTE_CONTEXTS
    391: -- Pre-reqs : None
    392: -- Parameters :
    393: -- p_api_version IN NUMBER Required
    394: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
    395: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
    396: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
    397: -- x_return_status OUT VARCHAR2 Required
    398: -- x_msg_count OUT NUMBER Required

    Line 395: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

    391: -- Pre-reqs : None
    392: -- Parameters :
    393: -- p_api_version IN NUMBER Required
    394: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
    395: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
    396: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
    397: -- x_return_status OUT VARCHAR2 Required
    398: -- x_msg_count OUT NUMBER Required
    399: -- x_msg_data OUT VARCHAR2 Required

    Line 396: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

    392: -- Parameters :
    393: -- p_api_version IN NUMBER Required
    394: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
    395: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
    396: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
    397: -- x_return_status OUT VARCHAR2 Required
    398: -- x_msg_count OUT NUMBER Required
    399: -- x_msg_data OUT VARCHAR2 Required
    400: -- p_jtf_note_id IN NUMBER Required Primary key of the note record

    Line 401: -- p_use_AOL_security IN VARCHAR2 Optional Default FND_API.G_TRUE

    397: -- x_return_status OUT VARCHAR2 Required
    398: -- x_msg_count OUT NUMBER Required
    399: -- x_msg_data OUT VARCHAR2 Required
    400: -- p_jtf_note_id IN NUMBER Required Primary key of the note record
    401: -- p_use_AOL_security IN VARCHAR2 Optional Default FND_API.G_TRUE
    402: --
    403: -- Version : Initial version 1.0
    404: --
    405: --

    Line 428: *
  • FND_API.G_RET_STS_SUCCESS - If the API processed the data successfully.

    • 424: * @param p_api_version Standard API version number.
    425: * @param p_init_msg_list Standard API flag allows API callers to request that the API does the initialization of the message list on their behalf. By default, the message list will not be initialized.
    426: * @param p_commit Optional Standard API flag is used by API callers to ask the API to commit on their behalf after performing its function. By default, the commit will not be performed.
    427: * @param x_return_status Result of all the operations performed by the API. This will have one of the following values:
    428: *

  • FND_API.G_RET_STS_SUCCESS - If the API processed the data successfully.
    429: *
  • FND_API.G_RET_STS_ERROR - If there was an expected error in API processing.
    430: *
  • FND_API.G_RET_STS_UNEXP_ERROR If there was an unexpected error in API processing.
    431: * @param p_validation_level This value determines whether validation should occur or not. This variable is checked against FND_API.G_VALID_LEVEL_NONE and if it is greater than the latter, validation occurs.
    432: * @param x_msg_count Number of messages returned in the API message list.

    Line 429: *
  • FND_API.G_RET_STS_ERROR - If there was an expected error in API processing.

    • 425: * @param p_init_msg_list Standard API flag allows API callers to request that the API does the initialization of the message list on their behalf. By default, the message list will not be initialized.
    426: * @param p_commit Optional Standard API flag is used by API callers to ask the API to commit on their behalf after performing its function. By default, the commit will not be performed.
    427: * @param x_return_status Result of all the operations performed by the API. This will have one of the following values:
    428: *

  • FND_API.G_RET_STS_SUCCESS - If the API processed the data successfully.
    429: *
  • FND_API.G_RET_STS_ERROR - If there was an expected error in API processing.
    430: *
  • FND_API.G_RET_STS_UNEXP_ERROR If there was an unexpected error in API processing.
    431: * @param p_validation_level This value determines whether validation should occur or not. This variable is checked against FND_API.G_VALID_LEVEL_NONE and if it is greater than the latter, validation occurs.
    432: * @param x_msg_count Number of messages returned in the API message list.
    433: * @param x_msg_data Returned message data in an encoded format if x_msg_count returns non-zero value.

    Line 430: *
  • FND_API.G_RET_STS_UNEXP_ERROR If there was an unexpected error in API processing.

    • 426: * @param p_commit Optional Standard API flag is used by API callers to ask the API to commit on their behalf after performing its function. By default, the commit will not be performed.
    427: * @param x_return_status Result of all the operations performed by the API. This will have one of the following values:
    428: *

  • FND_API.G_RET_STS_SUCCESS - If the API processed the data successfully.
    429: *
  • FND_API.G_RET_STS_ERROR - If there was an expected error in API processing.
    430: *
  • FND_API.G_RET_STS_UNEXP_ERROR If there was an unexpected error in API processing.
    431: * @param p_validation_level This value determines whether validation should occur or not. This variable is checked against FND_API.G_VALID_LEVEL_NONE and if it is greater than the latter, validation occurs.
    432: * @param x_msg_count Number of messages returned in the API message list.
    433: * @param x_msg_data Returned message data in an encoded format if x_msg_count returns non-zero value.
    434: * @param p_org_id An identifier for the organization.

    Line 431: * @param p_validation_level This value determines whether validation should occur or not. This variable is checked against FND_API.G_VALID_LEVEL_NONE and if it is greater than the latter, validation occurs.

    427: * @param x_return_status Result of all the operations performed by the API. This will have one of the following values:
    428: *

  • FND_API.G_RET_STS_SUCCESS - If the API processed the data successfully.
    429: *
  • FND_API.G_RET_STS_ERROR - If there was an expected error in API processing.
    430: *
  • FND_API.G_RET_STS_UNEXP_ERROR If there was an unexpected error in API processing.
    431: * @param p_validation_level This value determines whether validation should occur or not. This variable is checked against FND_API.G_VALID_LEVEL_NONE and if it is greater than the latter, validation occurs.
    432: * @param x_msg_count Number of messages returned in the API message list.
    433: * @param x_msg_data Returned message data in an encoded format if x_msg_count returns non-zero value.
    434: * @param p_org_id An identifier for the organization.
    435: * @param p_source_object_id Dependent on parameter p_source_object_code; for example, if the source business object is a service request, this is the service request number.

    Line 470: * @param p_use_AOL_security AOL Security Flag, Optional Default FND_API.G_TRUE.

    466: * @param p_attribute15 Descriptive Flexfield Segment.
    467: * @param p_context This is a short description field.
    468: * @param p_note_type The type of note, based on the source business object; for example, this could be SR_PROBLEM, if the note concerns a service request problem. If this value is not valid, an error is raised.
    469: * @param p_jtf_note_contexts_tab Table of PL/SQL records used to specify the note context. For details see: Oracle Common Application Calendar - API Reference Guide.
    470: * @param p_use_AOL_security AOL Security Flag, Optional Default FND_API.G_TRUE.
    471: * @rep:scope public
    472: * @rep:lifecycle active
    473: * @rep:displayname Create Note
    474: * @rep:metalink 249665.1 Oracle Common Application Calendar - API Reference Guide

    Line 488: -- p_parent_note_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

    484: -- Type : Public
    485: -- Description : Insert a Note into JTF_NOTES table
    486: -- Pre-reqs :
    487: -- Parameters :
    488: -- p_parent_note_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
    489: -- p_jtf_note_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
    490: -- p_api_version IN NUMBER Required
    491: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
    492: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

    Line 489: -- p_jtf_note_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

    485: -- Description : Insert a Note into JTF_NOTES table
    486: -- Pre-reqs :
    487: -- Parameters :
    488: -- p_parent_note_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
    489: -- p_jtf_note_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
    490: -- p_api_version IN NUMBER Required
    491: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
    492: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
    493: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

    Line 491: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE

    487: -- Parameters :
    488: -- p_parent_note_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
    489: -- p_jtf_note_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
    490: -- p_api_version IN NUMBER Required
    491: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
    492: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
    493: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
    494: -- This parameter should always be
    495: -- FND_API.G_VALID_LEVEL_FULL if the api is called from external apis

    Line 492: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

    488: -- p_parent_note_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
    489: -- p_jtf_note_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
    490: -- p_api_version IN NUMBER Required
    491: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
    492: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
    493: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
    494: -- This parameter should always be
    495: -- FND_API.G_VALID_LEVEL_FULL if the api is called from external apis
    496: -- p_return_status OUT VARCHAR2 Required Length = 1

    Line 493: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

    489: -- p_jtf_note_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
    490: -- p_api_version IN NUMBER Required
    491: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
    492: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
    493: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
    494: -- This parameter should always be
    495: -- FND_API.G_VALID_LEVEL_FULL if the api is called from external apis
    496: -- p_return_status OUT VARCHAR2 Required Length = 1
    497: -- p_msg_count OUT NUMBER Required

    Line 495: -- FND_API.G_VALID_LEVEL_FULL if the api is called from external apis

    491: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
    492: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
    493: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
    494: -- This parameter should always be
    495: -- FND_API.G_VALID_LEVEL_FULL if the api is called from external apis
    496: -- p_return_status OUT VARCHAR2 Required Length = 1
    497: -- p_msg_count OUT NUMBER Required
    498: -- p_msg_data OUT VARCHAR2 Required Length = 2000
    499: -- p_source_object_id IN NUMBER (eg request_id for Service Request)

    Line 528: -- p_use_AOL_security IN VARCHAR2 Optional Default FND_API.G_TRUE

    524: -- p_attribute13 IN VARCHAR2 Optional Default NULL
    525: -- p_attribute14 IN VARCHAR2 Optional Default NULL
    526: -- p_attribute15 IN VARCHAR2 Optional Default NULL
    527: -- p_context IN VARCHAR2 Optional Default NULL
    528: -- p_use_AOL_security IN VARCHAR2 Optional Default FND_API.G_TRUE
    529: --
    530: -- Version : Initial Version 1.0
    531: --
    532: -- Notes :

    Line 595: * @param p_validation_level This value determines whether validation should occur or not. This variable is checked against FND_API.G_VALID_LEVEL_NONE and if it is greater than the latter, validation occurs.

    591: * @param p_jtf_note_id Unique note identifier, identifies which note record is to be updated.
    592: * @param p_api_version Standard API version number.
    593: * @param p_init_msg_list Standard API flag allows API callers to request that the API does the initialization of the message list on their behalf. By default, the message list will not be initialized.
    594: * @param p_commit Optional Standard API flag is used by API callers to ask the API to commit on their behalf after performing its function. By default, the commit will not be performed.
    595: * @param p_validation_level This value determines whether validation should occur or not. This variable is checked against FND_API.G_VALID_LEVEL_NONE and if it is greater than the latter, validation occurs.
    596: * @param x_return_status Result of all the operations performed by the API. This will have one of the following values:
    597: *

  • FND_API.G_RET_STS_SUCCESS - If the API processed the data successfully.
    598: *
  • FND_API.G_RET_STS_ERROR - If there was an expected error in API processing.
    599: *
  • FND_API.G_RET_STS_UNEXP_ERROR If there was an unexpected error in API processing.

    Line 597: *
  • FND_API.G_RET_STS_SUCCESS - If the API processed the data successfully.

    • 593: * @param p_init_msg_list Standard API flag allows API callers to request that the API does the initialization of the message list on their behalf. By default, the message list will not be initialized.
    594: * @param p_commit Optional Standard API flag is used by API callers to ask the API to commit on their behalf after performing its function. By default, the commit will not be performed.
    595: * @param p_validation_level This value determines whether validation should occur or not. This variable is checked against FND_API.G_VALID_LEVEL_NONE and if it is greater than the latter, validation occurs.
    596: * @param x_return_status Result of all the operations performed by the API. This will have one of the following values:
    597: *

  • FND_API.G_RET_STS_SUCCESS - If the API processed the data successfully.
    598: *
  • FND_API.G_RET_STS_ERROR - If there was an expected error in API processing.
    599: *
  • FND_API.G_RET_STS_UNEXP_ERROR If there was an unexpected error in API processing.
    600: * @param x_msg_count Number of messages returned in the API message list.
    601: * @param x_msg_data Returned message data in an encoded format if x_msg_count returns non-zero value.

    Line 598: *
  • FND_API.G_RET_STS_ERROR - If there was an expected error in API processing.

    • 594: * @param p_commit Optional Standard API flag is used by API callers to ask the API to commit on their behalf after performing its function. By default, the commit will not be performed.
    595: * @param p_validation_level This value determines whether validation should occur or not. This variable is checked against FND_API.G_VALID_LEVEL_NONE and if it is greater than the latter, validation occurs.
    596: * @param x_return_status Result of all the operations performed by the API. This will have one of the following values:
    597: *

  • FND_API.G_RET_STS_SUCCESS - If the API processed the data successfully.
    598: *
  • FND_API.G_RET_STS_ERROR - If there was an expected error in API processing.
    599: *
  • FND_API.G_RET_STS_UNEXP_ERROR If there was an unexpected error in API processing.
    600: * @param x_msg_count Number of messages returned in the API message list.
    601: * @param x_msg_data Returned message data in an encoded format if x_msg_count returns non-zero value.
    602: * @param p_notes The updated note text.

    Line 599: *
  • FND_API.G_RET_STS_UNEXP_ERROR If there was an unexpected error in API processing.

    • 595: * @param p_validation_level This value determines whether validation should occur or not. This variable is checked against FND_API.G_VALID_LEVEL_NONE and if it is greater than the latter, validation occurs.
    596: * @param x_return_status Result of all the operations performed by the API. This will have one of the following values:
    597: *

  • FND_API.G_RET_STS_SUCCESS - If the API processed the data successfully.
    598: *
  • FND_API.G_RET_STS_ERROR - If there was an expected error in API processing.
    599: *
  • FND_API.G_RET_STS_UNEXP_ERROR If there was an unexpected error in API processing.
    600: * @param x_msg_count Number of messages returned in the API message list.
    601: * @param x_msg_data Returned message data in an encoded format if x_msg_count returns non-zero value.
    602: * @param p_notes The updated note text.
    603: * @param p_notes_detail Used to create larger notes of up to 32K. If p_append_flag is set to Yes, then p_notes_detail is appended to p_notes.

    Line 653: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE

    649: -- Usage : Updates a note record in the table JTF_NOTES
    650: -- Pre-reqs : None
    651: -- Parameters :
    652: -- p_api_version IN NUMBER Required
    653: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
    654: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
    655: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
    656: -- x_return_status OUT VARCHAR2 Required
    657: -- x_msg_count OUT NUMBER Required

    Line 654: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

    650: -- Pre-reqs : None
    651: -- Parameters :
    652: -- p_api_version IN NUMBER Required
    653: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
    654: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
    655: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
    656: -- x_return_status OUT VARCHAR2 Required
    657: -- x_msg_count OUT NUMBER Required
    658: -- x_msg_data OUT VARCHAR2 Required

    Line 655: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

    651: -- Parameters :
    652: -- p_api_version IN NUMBER Required
    653: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
    654: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
    655: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
    656: -- x_return_status OUT VARCHAR2 Required
    657: -- x_msg_count OUT NUMBER Required
    658: -- x_msg_data OUT VARCHAR2 Required
    659: -- p_jtf_note_id IN NUMBER Required Primary key of the note record

    Line 690: -- p_use_AOL_security IN VARCHAR2 Optional Default FND_API.G_TRUE

    686: -- p_context IN VARCHAR2 DEFAULT CHR(0)
    687: -- p_note_type IN VARCHAR2 Optional Type of the Note
    688: -- p_jtf_note_contexts_tab IN jtf_note_contexts_tbl_type
    689: -- Optional Default jtf_note_contexts_tab_dflt
    690: -- p_use_AOL_security IN VARCHAR2 Optional Default FND_API.G_TRUE
    691: --
    692: -- Version : Initial version 1.0
    693: --
    694: -- Notes :