DBA Data[Home] [Help]

APPS.CS_EA_AUTOGEN_TASKS_PVT dependencies on JTF_NOTES_B

Line 688: l_login_id jtf_notes_b.last_update_login % type;

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

Line 689: l_user_id jtf_notes_b.last_updated_by % type;

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

Line 1136: l_note_type jtf_notes_b.note_type % type;

1132: l_err varchar2(4000);
1133: l_msg_index_out number;
1134: l_msg_data varchar2(2000);
1135: l_note_id number;
1136: l_note_type jtf_notes_b.note_type % type;
1137: l_login_id jtf_notes_b.last_update_login % type;
1138: l_user_id jtf_notes_b.last_updated_by % type;
1139: l_sr_rec CS_ServiceRequest_pub.service_request_rec_type;
1140: l_incident_number cs_incidents_all_b.incident_number % type;

Line 1137: l_login_id jtf_notes_b.last_update_login % type;

1133: l_msg_index_out number;
1134: l_msg_data varchar2(2000);
1135: l_note_id number;
1136: l_note_type jtf_notes_b.note_type % type;
1137: l_login_id jtf_notes_b.last_update_login % type;
1138: l_user_id jtf_notes_b.last_updated_by % type;
1139: l_sr_rec CS_ServiceRequest_pub.service_request_rec_type;
1140: l_incident_number cs_incidents_all_b.incident_number % type;
1141: cursor c_sr is

Line 1138: l_user_id jtf_notes_b.last_updated_by % type;

1134: l_msg_data varchar2(2000);
1135: l_note_id number;
1136: l_note_type jtf_notes_b.note_type % type;
1137: l_login_id jtf_notes_b.last_update_login % type;
1138: l_user_id jtf_notes_b.last_updated_by % type;
1139: l_sr_rec CS_ServiceRequest_pub.service_request_rec_type;
1140: l_incident_number cs_incidents_all_b.incident_number % type;
1141: cursor c_sr is
1142: select * from cs_incidents_all_b