DBA Data[Home] [Help]

APPS.JTF_EC_PVT dependencies on FND_API

Line 18: g_false CONSTANT VARCHAR2(30) := fnd_api.g_false;

14: */
15:
16: g_pkg_name CONSTANT VARCHAR2(30) := 'JTF_EC_PVT';
17: g_user CONSTANT VARCHAR2(30) := fnd_global.user_id;
18: g_false CONSTANT VARCHAR2(30) := fnd_api.g_false;
19: g_true CONSTANT VARCHAR2(30) := fnd_api.g_true;
20:
21: /*#
22: * Creates an Escalation. After successful creation, triggers the BES for

Line 19: g_true CONSTANT VARCHAR2(30) := fnd_api.g_true;

15:
16: g_pkg_name CONSTANT VARCHAR2(30) := 'JTF_EC_PVT';
17: g_user CONSTANT VARCHAR2(30) := fnd_global.user_id;
18: g_false CONSTANT VARCHAR2(30) := fnd_api.g_false;
19: g_true CONSTANT VARCHAR2(30) := fnd_api.g_true;
20:
21: /*#
22: * Creates an Escalation. After successful creation, triggers the BES for
23: * create event.

Line 60: *
  • FND_API.G_RET_STS_SUCCESS

    • 56: * @param p_workflow_process_id the workflow process id for notifications of the created escalation
    57: * @param p_escalation_level the escalation level
    58: * @param x_return_status the parameter that returns the result of all the operations performed.
    59: * by the API and must have one of the following values:
    60: *

  • FND_API.G_RET_STS_SUCCESS
    61: *
  • FND_API.G_RET_STS_ERROR
    62: *
  • FND_API.G_RET_STS_UNEXP_ERROR
    63: * @param x_msg_count the parameter that returns the number of messages in the FND message list.
    64: * @param x_msg_data the parameter that returns the FND Message in encoded format.

    Line 61: *
  • FND_API.G_RET_STS_ERROR

    • 57: * @param p_escalation_level the escalation level
    58: * @param x_return_status the parameter that returns the result of all the operations performed.
    59: * by the API and must have one of the following values:
    60: *

  • FND_API.G_RET_STS_SUCCESS
    61: *
  • FND_API.G_RET_STS_ERROR
    62: *
  • FND_API.G_RET_STS_UNEXP_ERROR
    63: * @param x_msg_count the parameter that returns the number of messages in the FND message list.
    64: * @param x_msg_data the parameter that returns the FND Message in encoded format.
    65: * @param x_escalation_id the parameter that returns the Escalation ID for the created Escalation

    Line 62: *
  • FND_API.G_RET_STS_UNEXP_ERROR

    • 58: * @param x_return_status the parameter that returns the result of all the operations performed.
    59: * by the API and must have one of the following values:
    60: *

  • FND_API.G_RET_STS_SUCCESS
    61: *
  • FND_API.G_RET_STS_ERROR
    62: *
  • FND_API.G_RET_STS_UNEXP_ERROR
    63: * @param x_msg_count the parameter that returns the number of messages in the FND message list.
    64: * @param x_msg_data the parameter that returns the FND Message in encoded format.
    65: * @param x_escalation_id the parameter that returns the Escalation ID for the created Escalation
    66: * @param p_attribute1 the value of the flex field attribute1

    Line 89: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

    85: * @rep:compatibility S
    86: */
    87: PROCEDURE create_escalation (
    88: p_api_version IN NUMBER,
    89: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
    90: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
    91: p_esc_id IN NUMBER DEFAULT NULL,
    92: p_escalation_name IN VARCHAR2,
    93: p_description IN VARCHAR2 DEFAULT NULL,

    Line 90: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

    86: */
    87: PROCEDURE create_escalation (
    88: p_api_version IN NUMBER,
    89: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
    90: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
    91: p_esc_id IN NUMBER DEFAULT NULL,
    92: p_escalation_name IN VARCHAR2,
    93: p_description IN VARCHAR2 DEFAULT NULL,
    94: p_escalation_status_name IN VARCHAR2 DEFAULT NULL,

    Line 181: *
  • FND_API.G_RET_STS_SUCCESS

    • 177: * @param p_workflow_process_id the workflow process id for notifications of the created escalation
    178: * @param p_escalation_level the escalation level
    179: * @param x_return_status the parameter that returns the result of all the operations performed.
    180: * by the API and must have one of the following values:
    181: *

  • FND_API.G_RET_STS_SUCCESS
    182: *
  • FND_API.G_RET_STS_ERROR
    183: *
  • FND_API.G_RET_STS_UNEXP_ERROR
    184: * @param x_msg_count the parameter that returns the number of messages in the FND message list.
    185: * @param x_msg_data the parameter that returns the FND Message in encoded format.

    Line 182: *
  • FND_API.G_RET_STS_ERROR

    • 178: * @param p_escalation_level the escalation level
    179: * @param x_return_status the parameter that returns the result of all the operations performed.
    180: * by the API and must have one of the following values:
    181: *

  • FND_API.G_RET_STS_SUCCESS
    182: *
  • FND_API.G_RET_STS_ERROR
    183: *
  • FND_API.G_RET_STS_UNEXP_ERROR
    184: * @param x_msg_count the parameter that returns the number of messages in the FND message list.
    185: * @param x_msg_data the parameter that returns the FND Message in encoded format.
    186: * @param p_attribute1 the value of the flex field attribute1

    Line 183: *
  • FND_API.G_RET_STS_UNEXP_ERROR

    • 179: * @param x_return_status the parameter that returns the result of all the operations performed.
    180: * by the API and must have one of the following values:
    181: *

  • FND_API.G_RET_STS_SUCCESS
    182: *
  • FND_API.G_RET_STS_ERROR
    183: *
  • FND_API.G_RET_STS_UNEXP_ERROR
    184: * @param x_msg_count the parameter that returns the number of messages in the FND message list.
    185: * @param x_msg_data the parameter that returns the FND Message in encoded format.
    186: * @param p_attribute1 the value of the flex field attribute1
    187: * @param p_attribute2 the value of the flex field attribute2

    Line 209: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

    205: * @rep:compatibility S
    206: */
    207: PROCEDURE update_escalation (
    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 OUT NOCOPY NUMBER,
    212: p_escalation_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    213: p_escalation_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

    Line 210: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

    206: */
    207: PROCEDURE update_escalation (
    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 OUT NOCOPY NUMBER,
    212: p_escalation_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    213: p_escalation_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    214: p_escalation_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

    Line 212: p_escalation_id IN NUMBER DEFAULT fnd_api.g_miss_num,

    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 OUT NOCOPY NUMBER,
    212: p_escalation_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    213: p_escalation_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    214: p_escalation_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    215: p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    216: p_escalation_status_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

    Line 213: p_escalation_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

    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 OUT NOCOPY NUMBER,
    212: p_escalation_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    213: p_escalation_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    214: p_escalation_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    215: p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    216: p_escalation_status_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    217: p_escalation_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,

    Line 214: p_escalation_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

    210: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
    211: p_object_version_number IN OUT NOCOPY NUMBER,
    212: p_escalation_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    213: p_escalation_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    214: p_escalation_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    215: p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    216: p_escalation_status_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    217: p_escalation_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    218: p_open_date in DATE DEFAULT fnd_api.g_miss_date,

    Line 215: p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

    211: p_object_version_number IN OUT NOCOPY NUMBER,
    212: p_escalation_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    213: p_escalation_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    214: p_escalation_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    215: p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    216: p_escalation_status_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    217: p_escalation_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    218: p_open_date in DATE DEFAULT fnd_api.g_miss_date,
    219: p_close_date in DATE DEFAULT fnd_api.g_miss_date,

    Line 216: p_escalation_status_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

    212: p_escalation_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    213: p_escalation_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    214: p_escalation_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    215: p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    216: p_escalation_status_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    217: p_escalation_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    218: p_open_date in DATE DEFAULT fnd_api.g_miss_date,
    219: p_close_date in DATE DEFAULT fnd_api.g_miss_date,
    220: p_escalation_priority_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

    Line 217: p_escalation_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,

    213: p_escalation_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    214: p_escalation_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    215: p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    216: p_escalation_status_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    217: p_escalation_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    218: p_open_date in DATE DEFAULT fnd_api.g_miss_date,
    219: p_close_date in DATE DEFAULT fnd_api.g_miss_date,
    220: p_escalation_priority_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    221: p_escalation_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,

    Line 218: p_open_date in DATE DEFAULT fnd_api.g_miss_date,

    214: p_escalation_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    215: p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    216: p_escalation_status_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    217: p_escalation_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    218: p_open_date in DATE DEFAULT fnd_api.g_miss_date,
    219: p_close_date in DATE DEFAULT fnd_api.g_miss_date,
    220: p_escalation_priority_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    221: p_escalation_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    222: p_owner_id IN NUMBER DEFAULT fnd_api.g_miss_num,

    Line 219: p_close_date in DATE DEFAULT fnd_api.g_miss_date,

    215: p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    216: p_escalation_status_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    217: p_escalation_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    218: p_open_date in DATE DEFAULT fnd_api.g_miss_date,
    219: p_close_date in DATE DEFAULT fnd_api.g_miss_date,
    220: p_escalation_priority_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    221: p_escalation_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    222: p_owner_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    223: p_escalation_owner_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

    Line 220: p_escalation_priority_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

    216: p_escalation_status_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    217: p_escalation_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    218: p_open_date in DATE DEFAULT fnd_api.g_miss_date,
    219: p_close_date in DATE DEFAULT fnd_api.g_miss_date,
    220: p_escalation_priority_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    221: p_escalation_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    222: p_owner_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    223: p_escalation_owner_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    224: p_owner_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num,

    Line 221: p_escalation_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,

    217: p_escalation_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    218: p_open_date in DATE DEFAULT fnd_api.g_miss_date,
    219: p_close_date in DATE DEFAULT fnd_api.g_miss_date,
    220: p_escalation_priority_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    221: p_escalation_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    222: p_owner_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    223: p_escalation_owner_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    224: p_owner_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    225: p_assigned_by_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

    Line 222: p_owner_id IN NUMBER DEFAULT fnd_api.g_miss_num,

    218: p_open_date in DATE DEFAULT fnd_api.g_miss_date,
    219: p_close_date in DATE DEFAULT fnd_api.g_miss_date,
    220: p_escalation_priority_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    221: p_escalation_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    222: p_owner_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    223: p_escalation_owner_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    224: p_owner_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    225: p_assigned_by_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    226: p_assigned_by_id IN NUMBER DEFAULT fnd_api.g_miss_num,

    Line 223: p_escalation_owner_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

    219: p_close_date in DATE DEFAULT fnd_api.g_miss_date,
    220: p_escalation_priority_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    221: p_escalation_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    222: p_owner_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    223: p_escalation_owner_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    224: p_owner_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    225: p_assigned_by_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    226: p_assigned_by_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    227: p_customer_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

    Line 224: p_owner_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num,

    220: p_escalation_priority_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    221: p_escalation_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    222: p_owner_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    223: p_escalation_owner_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    224: p_owner_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    225: p_assigned_by_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    226: p_assigned_by_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    227: p_customer_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    228: p_customer_id IN NUMBER DEFAULT fnd_api.g_miss_num,

    Line 225: p_assigned_by_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

    221: p_escalation_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    222: p_owner_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    223: p_escalation_owner_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    224: p_owner_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    225: p_assigned_by_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    226: p_assigned_by_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    227: p_customer_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    228: p_customer_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    229: p_cust_account_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

    Line 226: p_assigned_by_id IN NUMBER DEFAULT fnd_api.g_miss_num,

    222: p_owner_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    223: p_escalation_owner_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    224: p_owner_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    225: p_assigned_by_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    226: p_assigned_by_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    227: p_customer_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    228: p_customer_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    229: p_cust_account_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    230: p_cust_account_id IN NUMBER DEFAULT fnd_api.g_miss_num,

    Line 227: p_customer_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

    223: p_escalation_owner_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    224: p_owner_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    225: p_assigned_by_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    226: p_assigned_by_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    227: p_customer_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    228: p_customer_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    229: p_cust_account_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    230: p_cust_account_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    231: p_address_id IN NUMBER DEFAULT fnd_api.g_miss_num,

    Line 228: p_customer_id IN NUMBER DEFAULT fnd_api.g_miss_num,

    224: p_owner_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    225: p_assigned_by_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    226: p_assigned_by_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    227: p_customer_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    228: p_customer_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    229: p_cust_account_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    230: p_cust_account_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    231: p_address_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    232: p_address_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

    Line 229: p_cust_account_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

    225: p_assigned_by_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    226: p_assigned_by_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    227: p_customer_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    228: p_customer_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    229: p_cust_account_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    230: p_cust_account_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    231: p_address_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    232: p_address_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    233: p_target_date IN DATE DEFAULT fnd_api.g_miss_date,

    Line 230: p_cust_account_id IN NUMBER DEFAULT fnd_api.g_miss_num,

    226: p_assigned_by_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    227: p_customer_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    228: p_customer_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    229: p_cust_account_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    230: p_cust_account_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    231: p_address_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    232: p_address_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    233: p_target_date IN DATE DEFAULT fnd_api.g_miss_date,
    234: /* p_timezone_id IN NUMBER DEFAULT fnd_api.g_miss_num,

    Line 231: p_address_id IN NUMBER DEFAULT fnd_api.g_miss_num,

    227: p_customer_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    228: p_customer_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    229: p_cust_account_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    230: p_cust_account_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    231: p_address_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    232: p_address_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    233: p_target_date IN DATE DEFAULT fnd_api.g_miss_date,
    234: /* p_timezone_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    235: p_timezone_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

    Line 232: p_address_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

    228: p_customer_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    229: p_cust_account_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    230: p_cust_account_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    231: p_address_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    232: p_address_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    233: p_target_date IN DATE DEFAULT fnd_api.g_miss_date,
    234: /* p_timezone_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    235: p_timezone_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    236: */ p_reason_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

    Line 233: p_target_date IN DATE DEFAULT fnd_api.g_miss_date,

    229: p_cust_account_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    230: p_cust_account_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    231: p_address_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    232: p_address_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    233: p_target_date IN DATE DEFAULT fnd_api.g_miss_date,
    234: /* p_timezone_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    235: p_timezone_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    236: */ p_reason_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    237: p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

    Line 234: /* p_timezone_id IN NUMBER DEFAULT fnd_api.g_miss_num,

    230: p_cust_account_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    231: p_address_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    232: p_address_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    233: p_target_date IN DATE DEFAULT fnd_api.g_miss_date,
    234: /* p_timezone_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    235: p_timezone_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    236: */ p_reason_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    237: p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    238: p_publish_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

    Line 235: p_timezone_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

    231: p_address_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    232: p_address_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    233: p_target_date IN DATE DEFAULT fnd_api.g_miss_date,
    234: /* p_timezone_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    235: p_timezone_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    236: */ p_reason_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    237: p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    238: p_publish_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    239: p_workflow_process_id IN NUMBER DEFAULT fnd_api.g_miss_num,

    Line 236: */ p_reason_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

    232: p_address_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    233: p_target_date IN DATE DEFAULT fnd_api.g_miss_date,
    234: /* p_timezone_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    235: p_timezone_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    236: */ p_reason_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    237: p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    238: p_publish_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    239: p_workflow_process_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    240: p_escalation_level IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

    Line 237: p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

    233: p_target_date IN DATE DEFAULT fnd_api.g_miss_date,
    234: /* p_timezone_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    235: p_timezone_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    236: */ p_reason_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    237: p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    238: p_publish_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    239: p_workflow_process_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    240: p_escalation_level IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    241: x_return_status OUT NOCOPY VARCHAR2,

    Line 238: p_publish_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

    234: /* p_timezone_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    235: p_timezone_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    236: */ p_reason_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    237: p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    238: p_publish_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    239: p_workflow_process_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    240: p_escalation_level IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    241: x_return_status OUT NOCOPY VARCHAR2,
    242: x_msg_count OUT NOCOPY NUMBER,

    Line 239: p_workflow_process_id IN NUMBER DEFAULT fnd_api.g_miss_num,

    235: p_timezone_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    236: */ p_reason_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    237: p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    238: p_publish_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    239: p_workflow_process_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    240: p_escalation_level IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    241: x_return_status OUT NOCOPY VARCHAR2,
    242: x_msg_count OUT NOCOPY NUMBER,
    243: x_msg_data OUT NOCOPY VARCHAR2,

    Line 240: p_escalation_level IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

    236: */ p_reason_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    237: p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    238: p_publish_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    239: p_workflow_process_id IN NUMBER DEFAULT fnd_api.g_miss_num,
    240: p_escalation_level IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
    241: x_return_status OUT NOCOPY VARCHAR2,
    242: x_msg_count OUT NOCOPY NUMBER,
    243: x_msg_data OUT NOCOPY VARCHAR2,
    244: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

    Line 278: *
  • FND_API.G_RET_STS_SUCCESS

    • 274: * @param p_escalation_id the escalation id
    275: * @param p_escalation_number the escalation number
    276: * @param x_return_status the parameter that returns the result of all the operations performed.
    277: * by the API and must have one of the following values:
    278: *

  • FND_API.G_RET_STS_SUCCESS
    279: *
  • FND_API.G_RET_STS_ERROR
    280: *
  • FND_API.G_RET_STS_UNEXP_ERROR
    281: * @param x_msg_count the parameter that returns the number of messages in the FND message list.
    282: * @param x_msg_data the parameter that returns the FND Message in encoded format.

    Line 279: *
  • FND_API.G_RET_STS_ERROR

    • 275: * @param p_escalation_number the escalation number
    276: * @param x_return_status the parameter that returns the result of all the operations performed.
    277: * by the API and must have one of the following values:
    278: *

  • FND_API.G_RET_STS_SUCCESS
    279: *
  • FND_API.G_RET_STS_ERROR
    280: *
  • FND_API.G_RET_STS_UNEXP_ERROR
    281: * @param x_msg_count the parameter that returns the number of messages in the FND message list.
    282: * @param x_msg_data the parameter that returns the FND Message in encoded format.
    283: * @rep:scope private

    Line 280: *
  • FND_API.G_RET_STS_UNEXP_ERROR

    • 276: * @param x_return_status the parameter that returns the result of all the operations performed.
    277: * by the API and must have one of the following values:
    278: *

  • FND_API.G_RET_STS_SUCCESS
    279: *
  • FND_API.G_RET_STS_ERROR
    280: *
  • FND_API.G_RET_STS_UNEXP_ERROR
    281: * @param x_msg_count the parameter that returns the number of messages in the FND message list.
    282: * @param x_msg_data the parameter that returns the FND Message in encoded format.
    283: * @rep:scope private
    284: * @rep:lifecycle active

    Line 290: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

    286: * @rep:compatibility S
    287: */
    288: PROCEDURE delete_escalation (
    289: p_api_version IN NUMBER,
    290: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
    291: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
    292: p_object_version_number IN NUMBER ,
    293: p_escalation_id IN NUMBER DEFAULT NULL,
    294: p_escalation_number IN VARCHAR2 DEFAULT NULL,

    Line 291: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

    287: */
    288: PROCEDURE delete_escalation (
    289: p_api_version IN NUMBER,
    290: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
    291: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
    292: p_object_version_number IN NUMBER ,
    293: p_escalation_id IN NUMBER DEFAULT NULL,
    294: p_escalation_number IN VARCHAR2 DEFAULT NULL,
    295: x_return_status OUT NOCOPY VARCHAR2,

    Line 303: ESCALATION_ID JTF_TASKS_B.TASK_ID %TYPE := FND_API.G_MISS_NUM,

    299:
    300: --Created for BES enh 2660883
    301:
    302: TYPE Esc_rec_type IS RECORD (
    303: ESCALATION_ID JTF_TASKS_B.TASK_ID %TYPE := FND_API.G_MISS_NUM,
    304: ESCALATION_LEVEL JTF_TASKS_B.ESCALATION_LEVEL%TYPE := FND_API.G_MISS_CHAR,
    305: TASK_AUDIT_ID JTF_TASK_AUDITS_B.TASK_AUDIT_ID%TYPE := FND_API.G_MISS_NUM
    306: );
    307:

    Line 304: ESCALATION_LEVEL JTF_TASKS_B.ESCALATION_LEVEL%TYPE := FND_API.G_MISS_CHAR,

    300: --Created for BES enh 2660883
    301:
    302: TYPE Esc_rec_type IS RECORD (
    303: ESCALATION_ID JTF_TASKS_B.TASK_ID %TYPE := FND_API.G_MISS_NUM,
    304: ESCALATION_LEVEL JTF_TASKS_B.ESCALATION_LEVEL%TYPE := FND_API.G_MISS_CHAR,
    305: TASK_AUDIT_ID JTF_TASK_AUDITS_B.TASK_AUDIT_ID%TYPE := FND_API.G_MISS_NUM
    306: );
    307:
    308: PROCEDURE GET_ASSIGN_ESC_TERR_RESOURCES(

    Line 305: TASK_AUDIT_ID JTF_TASK_AUDITS_B.TASK_AUDIT_ID%TYPE := FND_API.G_MISS_NUM

    301:
    302: TYPE Esc_rec_type IS RECORD (
    303: ESCALATION_ID JTF_TASKS_B.TASK_ID %TYPE := FND_API.G_MISS_NUM,
    304: ESCALATION_LEVEL JTF_TASKS_B.ESCALATION_LEVEL%TYPE := FND_API.G_MISS_CHAR,
    305: TASK_AUDIT_ID JTF_TASK_AUDITS_B.TASK_AUDIT_ID%TYPE := FND_API.G_MISS_NUM
    306: );
    307:
    308: PROCEDURE GET_ASSIGN_ESC_TERR_RESOURCES(
    309: p_api_version IN NUMBER,

    Line 310: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

    306: );
    307:
    308: PROCEDURE GET_ASSIGN_ESC_TERR_RESOURCES(
    309: p_api_version IN NUMBER,
    310: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
    311: p_source_object_id IN NUMBER,
    312: p_source_object_type IN VARCHAR2,
    313: x_owner_type_code OUT NOCOPY VARCHAR2,
    314: x_resource_id OUT NOCOPY NUMBER);