DBA Data[Home] [Help]

APPS.CS_EA_AUTOGEN_TASKS_PVT dependencies on JTF_NOTES_B

Line 689: l_login_id jtf_notes_b.last_update_login % type;

685: l_task_rec_tbl ea_task_table_type;
686: l_task_attr_rec cs_sr_task_autoassign_pkg.Sr_Task_rec_type;
687: l_indx number;
688: l_task_id jtf_tasks_b.task_id % type;
689: l_login_id jtf_notes_b.last_update_login % type;
690: l_user_id jtf_notes_b.last_updated_by % type;
691: l_obj_version cs_incidents_all_b.object_version_number % type;
692: l_owner_type cs_incidents_all_b.resource_type % type;
693: l_owner_id cs_incidents_all_b.incident_owner_id % type;

Line 690: l_user_id jtf_notes_b.last_updated_by % type;

686: l_task_attr_rec cs_sr_task_autoassign_pkg.Sr_Task_rec_type;
687: l_indx number;
688: l_task_id jtf_tasks_b.task_id % type;
689: l_login_id jtf_notes_b.last_update_login % type;
690: l_user_id jtf_notes_b.last_updated_by % type;
691: l_obj_version cs_incidents_all_b.object_version_number % type;
692: l_owner_type cs_incidents_all_b.resource_type % type;
693: l_owner_id cs_incidents_all_b.incident_owner_id % type;
694: l_owner_group_id cs_incidents_all_b.owner_group_id % type;

Line 1168: l_note_type jtf_notes_b.note_type % type;

1164: l_err varchar2(4000);
1165: l_msg_index_out number;
1166: l_msg_data varchar2(2000);
1167: l_note_id number;
1168: l_note_type jtf_notes_b.note_type % type;
1169: l_login_id jtf_notes_b.last_update_login % type;
1170: l_user_id jtf_notes_b.last_updated_by % type;
1171: l_sr_rec CS_ServiceRequest_pub.service_request_rec_type;
1172: l_incident_number cs_incidents_all_b.incident_number % type;

Line 1169: l_login_id jtf_notes_b.last_update_login % type;

1165: l_msg_index_out number;
1166: l_msg_data varchar2(2000);
1167: l_note_id number;
1168: l_note_type jtf_notes_b.note_type % type;
1169: l_login_id jtf_notes_b.last_update_login % type;
1170: l_user_id jtf_notes_b.last_updated_by % type;
1171: l_sr_rec CS_ServiceRequest_pub.service_request_rec_type;
1172: l_incident_number cs_incidents_all_b.incident_number % type;
1173: cursor c_sr is

Line 1170: l_user_id jtf_notes_b.last_updated_by % type;

1166: l_msg_data varchar2(2000);
1167: l_note_id number;
1168: l_note_type jtf_notes_b.note_type % type;
1169: l_login_id jtf_notes_b.last_update_login % type;
1170: l_user_id jtf_notes_b.last_updated_by % type;
1171: l_sr_rec CS_ServiceRequest_pub.service_request_rec_type;
1172: l_incident_number cs_incidents_all_b.incident_number % type;
1173: cursor c_sr is
1174: select * from cs_incidents_all_b