APPS.JTF_EC_PUB dependencies on JTF_TASK_PHONES

Line 215: -- JTF_TASK_PHONES table.

211: --------------------------------------------------------------------------------------------
212: -- Start of comments
213: -- Record Type : Esc_Cont_Points_Rec_Type
214: -- Description : Holds the escalation header attributes for creating record in
215: -- JTF_TASK_PHONES table.
216: -- Fields :
217: -- name type required? description
218: -- ---- ---- --------- --------------
219: -- contact_id NUMBER required Valid values are employee_id from per_employees_current_x

Line 225: -- from jtf_task_phones

221: -- where object_party_id = customer_id
222: -- contact_type_code VARCHAR2 required for create_escalation. Valid values are 'EMP', 'CUST'
223: -- contact_point_id NUMBER required Valid values are contact_point_id from hz_contact_points
224: -- task_phone_id NUMBER required for update/delete_escalation. Valid values are task_phone_id
225: -- from jtf_task_phones
226: -- object_version_number NUMBER required for update/delete_escalation. object_version_number from
227: -- jtf_task_phones of the updated/deleted record.
228: -- action_code VARCHAR2 required Valid values are 'I' insert contact,
229: -- 'U' - update contact, 'D' - delete contact

Line 227: -- jtf_task_phones of the updated/deleted record.

223: -- contact_point_id NUMBER required Valid values are contact_point_id from hz_contact_points
224: -- task_phone_id NUMBER required for update/delete_escalation. Valid values are task_phone_id
225: -- from jtf_task_phones
226: -- object_version_number NUMBER required for update/delete_escalation. object_version_number from
227: -- jtf_task_phones of the updated/deleted record.
228: -- action_code VARCHAR2 required Valid values are 'I' insert contact,
229: -- 'U' - update contact, 'D' - delete contact
230: -- attribute1..attribute15 VARCHAR2 optional Flex field attribute columns
231: -- for descriptive flexfield support.

Line 238: contact_point_id jtf_task_phones.phone_id%TYPE := FND_API.G_MISS_NUM,

234:
235: TYPE Esc_Cont_Points_Rec_Type IS RECORD (
236: contact_id jtf_task_contacts.contact_id%TYPE := FND_API.G_MISS_NUM,
237: contact_type_code jtf_task_contacts.contact_type_code%TYPE := FND_API.G_MISS_CHAR,
238: contact_point_id jtf_task_phones.phone_id%TYPE := FND_API.G_MISS_NUM,
239: task_phone_id jtf_task_phones.task_phone_id%TYPE := FND_API.G_MISS_NUM,
240: object_version_number jtf_task_phones.object_version_number%TYPE := FND_API.G_MISS_NUM,
241: action_code varchar2(1),
242: attribute1 jtf_tasks_b.attribute1%TYPE := FND_API.G_MISS_CHAR,

Line 239: task_phone_id jtf_task_phones.task_phone_id%TYPE := FND_API.G_MISS_NUM,

235: TYPE Esc_Cont_Points_Rec_Type IS RECORD (
236: contact_id jtf_task_contacts.contact_id%TYPE := FND_API.G_MISS_NUM,
237: contact_type_code jtf_task_contacts.contact_type_code%TYPE := FND_API.G_MISS_CHAR,
238: contact_point_id jtf_task_phones.phone_id%TYPE := FND_API.G_MISS_NUM,
239: task_phone_id jtf_task_phones.task_phone_id%TYPE := FND_API.G_MISS_NUM,
240: object_version_number jtf_task_phones.object_version_number%TYPE := FND_API.G_MISS_NUM,
241: action_code varchar2(1),
242: attribute1 jtf_tasks_b.attribute1%TYPE := FND_API.G_MISS_CHAR,
243: attribute2 jtf_tasks_b.attribute2%TYPE := FND_API.G_MISS_CHAR,

Line 240: object_version_number jtf_task_phones.object_version_number%TYPE := FND_API.G_MISS_NUM,

236: contact_id jtf_task_contacts.contact_id%TYPE := FND_API.G_MISS_NUM,
237: contact_type_code jtf_task_contacts.contact_type_code%TYPE := FND_API.G_MISS_CHAR,
238: contact_point_id jtf_task_phones.phone_id%TYPE := FND_API.G_MISS_NUM,
239: task_phone_id jtf_task_phones.task_phone_id%TYPE := FND_API.G_MISS_NUM,
240: object_version_number jtf_task_phones.object_version_number%TYPE := FND_API.G_MISS_NUM,
241: action_code varchar2(1),
242: attribute1 jtf_tasks_b.attribute1%TYPE := FND_API.G_MISS_CHAR,
243: attribute2 jtf_tasks_b.attribute2%TYPE := FND_API.G_MISS_CHAR,
244: attribute3 jtf_tasks_b.attribute3%TYPE := FND_API.G_MISS_CHAR,