eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_EC_PUB dependencies on JTF_TASK_CONTACTS

Line 159: -- JTF_TASK_CONTACTS table.

155: --------------------------------------------------------------------------------------------
156: -- Start of comments
157: -- Record Type : Esc_Contacts_Rec_Type
158: -- Description : Holds the escalation contacts attributes for creating a record in
159: -- JTF_TASK_CONTACTS table.
160: -- Creating records in JTF_NOTES_B
161: -- Fields :
162: -- name type required? description
163: -- ---- ---- --------- --------------

Line 168: -- jtf_task_contacts

164: -- contact_id NUMBER required Valid values are employee_id from per_employees_current_x
165: -- when the contact_type = 'EMP' or subject_party_id from jtf_party_all_contacts_v
166: -- where object_party_id = customer_id
167: -- task_contact_id NUMBER required for update/delete_escalation. task_contact_id from
168: -- jtf_task_contacts
169: -- object_version_number NUMBER required for update/delete_escalation. object_version_number from
170: -- jtf_task_contacts of the updated/deleted record.
171: -- contact_type_code VARCHAR2 required for create_escalation. Valid values are 'EMP', 'CUST'
172: -- escalation_notify_flag VARCHAR2 optional Specify whether notifications will be sent to the contact.

Line 170: -- jtf_task_contacts of the updated/deleted record.

166: -- where object_party_id = customer_id
167: -- task_contact_id NUMBER required for update/delete_escalation. task_contact_id from
168: -- jtf_task_contacts
169: -- object_version_number NUMBER required for update/delete_escalation. object_version_number from
170: -- jtf_task_contacts of the updated/deleted record.
171: -- contact_type_code VARCHAR2 required for create_escalation. Valid values are 'EMP', 'CUST'
172: -- escalation_notify_flag VARCHAR2 optional Specify whether notifications will be sent to the contact.
173: -- Valid values are 'Y' or 'N'.
174: -- escalation_requester_flag VARCHAR2 required There must be one and only one contact per escalation

Line 184: contact_id jtf_task_contacts.contact_id%TYPE :=FND_API.G_MISS_NUM,

180: -- attribute_category VARCHAR2 optional Category column for descriptive flexfield support
181: --------------------------------------------------------------------------------------------
182:
183: TYPE Esc_Contacts_Rec_Type IS RECORD (
184: contact_id jtf_task_contacts.contact_id%TYPE :=FND_API.G_MISS_NUM,
185: task_contact_id jtf_task_contacts.task_contact_id%TYPE :=FND_API.G_MISS_NUM,
186: object_version_number jtf_task_contacts.object_version_number%TYPE :=FND_API.G_MISS_NUM,
187: contact_type_code jtf_task_contacts.contact_type_code%TYPE :=FND_API.G_MISS_CHAR,
188: escalation_notify_flag jtf_task_contacts.escalation_notify_flag%TYPE :=FND_API.G_MISS_CHAR,

Line 185: task_contact_id jtf_task_contacts.task_contact_id%TYPE :=FND_API.G_MISS_NUM,

181: --------------------------------------------------------------------------------------------
182:
183: TYPE Esc_Contacts_Rec_Type IS RECORD (
184: contact_id jtf_task_contacts.contact_id%TYPE :=FND_API.G_MISS_NUM,
185: task_contact_id jtf_task_contacts.task_contact_id%TYPE :=FND_API.G_MISS_NUM,
186: object_version_number jtf_task_contacts.object_version_number%TYPE :=FND_API.G_MISS_NUM,
187: contact_type_code jtf_task_contacts.contact_type_code%TYPE :=FND_API.G_MISS_CHAR,
188: escalation_notify_flag jtf_task_contacts.escalation_notify_flag%TYPE :=FND_API.G_MISS_CHAR,
189: escalation_requester_flag jtf_task_contacts.escalation_requester_flag%TYPE :=FND_API.G_MISS_CHAR,

Line 186: object_version_number jtf_task_contacts.object_version_number%TYPE :=FND_API.G_MISS_NUM,

182:
183: TYPE Esc_Contacts_Rec_Type IS RECORD (
184: contact_id jtf_task_contacts.contact_id%TYPE :=FND_API.G_MISS_NUM,
185: task_contact_id jtf_task_contacts.task_contact_id%TYPE :=FND_API.G_MISS_NUM,
186: object_version_number jtf_task_contacts.object_version_number%TYPE :=FND_API.G_MISS_NUM,
187: contact_type_code jtf_task_contacts.contact_type_code%TYPE :=FND_API.G_MISS_CHAR,
188: escalation_notify_flag jtf_task_contacts.escalation_notify_flag%TYPE :=FND_API.G_MISS_CHAR,
189: escalation_requester_flag jtf_task_contacts.escalation_requester_flag%TYPE :=FND_API.G_MISS_CHAR,
190: action_code varchar2(1),

Line 187: contact_type_code jtf_task_contacts.contact_type_code%TYPE :=FND_API.G_MISS_CHAR,

183: TYPE Esc_Contacts_Rec_Type IS RECORD (
184: contact_id jtf_task_contacts.contact_id%TYPE :=FND_API.G_MISS_NUM,
185: task_contact_id jtf_task_contacts.task_contact_id%TYPE :=FND_API.G_MISS_NUM,
186: object_version_number jtf_task_contacts.object_version_number%TYPE :=FND_API.G_MISS_NUM,
187: contact_type_code jtf_task_contacts.contact_type_code%TYPE :=FND_API.G_MISS_CHAR,
188: escalation_notify_flag jtf_task_contacts.escalation_notify_flag%TYPE :=FND_API.G_MISS_CHAR,
189: escalation_requester_flag jtf_task_contacts.escalation_requester_flag%TYPE :=FND_API.G_MISS_CHAR,
190: action_code varchar2(1),
191: attribute1 jtf_tasks_b.attribute1%TYPE := FND_API.G_MISS_CHAR,

Line 188: escalation_notify_flag jtf_task_contacts.escalation_notify_flag%TYPE :=FND_API.G_MISS_CHAR,

184: contact_id jtf_task_contacts.contact_id%TYPE :=FND_API.G_MISS_NUM,
185: task_contact_id jtf_task_contacts.task_contact_id%TYPE :=FND_API.G_MISS_NUM,
186: object_version_number jtf_task_contacts.object_version_number%TYPE :=FND_API.G_MISS_NUM,
187: contact_type_code jtf_task_contacts.contact_type_code%TYPE :=FND_API.G_MISS_CHAR,
188: escalation_notify_flag jtf_task_contacts.escalation_notify_flag%TYPE :=FND_API.G_MISS_CHAR,
189: escalation_requester_flag jtf_task_contacts.escalation_requester_flag%TYPE :=FND_API.G_MISS_CHAR,
190: action_code varchar2(1),
191: attribute1 jtf_tasks_b.attribute1%TYPE := FND_API.G_MISS_CHAR,
192: attribute2 jtf_tasks_b.attribute2%TYPE := FND_API.G_MISS_CHAR,

Line 189: escalation_requester_flag jtf_task_contacts.escalation_requester_flag%TYPE :=FND_API.G_MISS_CHAR,

185: task_contact_id jtf_task_contacts.task_contact_id%TYPE :=FND_API.G_MISS_NUM,
186: object_version_number jtf_task_contacts.object_version_number%TYPE :=FND_API.G_MISS_NUM,
187: contact_type_code jtf_task_contacts.contact_type_code%TYPE :=FND_API.G_MISS_CHAR,
188: escalation_notify_flag jtf_task_contacts.escalation_notify_flag%TYPE :=FND_API.G_MISS_CHAR,
189: escalation_requester_flag jtf_task_contacts.escalation_requester_flag%TYPE :=FND_API.G_MISS_CHAR,
190: action_code varchar2(1),
191: attribute1 jtf_tasks_b.attribute1%TYPE := FND_API.G_MISS_CHAR,
192: attribute2 jtf_tasks_b.attribute2%TYPE := FND_API.G_MISS_CHAR,
193: attribute3 jtf_tasks_b.attribute3%TYPE := FND_API.G_MISS_CHAR,

Line 236: contact_id jtf_task_contacts.contact_id%TYPE := FND_API.G_MISS_NUM,

232: -- attribute_category VARCHAR2 optional Category column for descriptive flexfield support
233: --------------------------------------------------------------------------------------------
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,

Line 237: contact_type_code jtf_task_contacts.contact_type_code%TYPE := FND_API.G_MISS_CHAR,

233: --------------------------------------------------------------------------------------------
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),