APPS.CSF_TRIPS_PUB dependencies on FND_NEW_MESSAGES

Line 32: message_name fnd_new_messages.message_name%TYPE

28: g_blocked_assigned_status_id NUMBER;
29: g_closed_status_id NUMBER;
30:
31: TYPE message_rec_type IS RECORD(
32: message_name fnd_new_messages.message_name%TYPE
33: , message_type VARCHAR2(1)
34: , resource_id NUMBER
35: , resource_type jtf_objects_b.object_code%TYPE
36: , start_datetime DATE

Line 39: , error_reason fnd_new_messages.message_text%TYPE

35: , resource_type jtf_objects_b.object_code%TYPE
36: , start_datetime DATE
37: , end_datetime DATE
38: , trip_id NUMBER
39: , error_reason fnd_new_messages.message_text%TYPE
40: );
41:
42: TYPE message_tbl_type IS TABLE OF message_rec_type
43: INDEX BY BINARY_INTEGER;

Line 1598: l_msg_name fnd_new_messages.message_name%TYPE;

1594: l_temp_trip_tbl number_tbl_type;
1595: l_del_trip_tbl jtf_number_table;
1596: l_old_new_trip_map number_tbl_type;
1597:
1598: l_msg_name fnd_new_messages.message_name%TYPE;
1599: l_reason fnd_new_messages.message_text%TYPE;
1600:
1601: -- Query to check for the existence of Stray Shift Tasks
1602: CURSOR c_shift_tasks_exist (p_res_id NUMBER, p_res_type VARCHAR2, p_start DATE, p_end DATE) IS

Line 1599: l_reason fnd_new_messages.message_text%TYPE;

1595: l_del_trip_tbl jtf_number_table;
1596: l_old_new_trip_map number_tbl_type;
1597:
1598: l_msg_name fnd_new_messages.message_name%TYPE;
1599: l_reason fnd_new_messages.message_text%TYPE;
1600:
1601: -- Query to check for the existence of Stray Shift Tasks
1602: CURSOR c_shift_tasks_exist (p_res_id NUMBER, p_res_type VARCHAR2, p_start DATE, p_end DATE) IS
1603: SELECT 'Y'