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.WMS_DOCK_APPOINTMENTS_PUB dependencies on WMS_DOCK_APPOINTMENTS_B

Line 48: FROM wms_dock_appointments_b

44: l_trip_stop NUMBER := -1;
45: BEGIN
46: SELECT trip_stop
47: INTO l_trip_stop
48: FROM wms_dock_appointments_b
49: WHERE dock_id = p_dock_locator_id
50: AND appointment_status = 2 -- occupied
51: AND start_time <= Sysdate
52: AND end_time >= Sysdate;

Line 91: UPDATE wms_dock_appointments_b

87: SAVEPOINT update_dock_sp;
88: -- Initialize API return status to success
89: x_return_status := FND_API.G_RET_STS_SUCCESS;
90:
91: UPDATE wms_dock_appointments_b
92: SET
93: APPOINTMENT_TYPE = p_dock_appointments_v_rec.APPOINTMENT_TYPE,
94: DOCK_ID = p_dock_appointments_v_rec.DOCK_ID,
95: ORGANIZATION_ID = p_dock_appointments_v_rec.ORGANIZATION_ID,

Line 156: UPDATE wms_dock_appointments_b

152: SAVEPOINT update_rep_dock_sp;
153: -- Initialize API return status to success
154: x_return_status := FND_API.G_RET_STS_SUCCESS;
155:
156: UPDATE wms_dock_appointments_b
157: SET
158: APPOINTMENT_TYPE = p_dock_appointments_v_rec.APPOINTMENT_TYPE,
159: DOCK_ID = p_dock_appointments_v_rec.DOCK_ID,
160: ORGANIZATION_ID = p_dock_appointments_v_rec.ORGANIZATION_ID,

Line 190: FROM wms_dock_appointments_b

186: LAST_UPDATE_LOGIN = p_dock_appointments_v_rec.LAST_UPDATE_LOGIN
187: WHERE
188: DOCK_APPOINTMENT_ID IN
189: (SELECT dock_appointment_id
190: FROM wms_dock_appointments_b
191: WHERE REP_ORIGIN = p_orig_id)
192: AND userenv('LANG') in (LANGUAGE, SOURCE_LANG);
193:
194: EXCEPTION

Line 223: INSERT INTO wms_dock_appointments_b

219: SAVEPOINT insert_dock_sp;
220: -- Initialize API return status to success
221: x_return_status := FND_API.G_RET_STS_SUCCESS;
222:
223: INSERT INTO wms_dock_appointments_b
224: (DOCK_APPOINTMENT_ID,
225: APPOINTMENT_TYPE,
226: DOCK_ID,
227: ORGANIZATION_ID,

Line 327: INSERT INTO wms_dock_appointments_b

323: SAVEPOINT insert_rep_dock_sp;
324: -- Initialize API return status to success
325: x_return_status := FND_API.G_RET_STS_SUCCESS;
326:
327: INSERT INTO wms_dock_appointments_b
328: (DOCK_APPOINTMENT_ID,
329: APPOINTMENT_TYPE,
330: DOCK_ID,
331: ORGANIZATION_ID,

Line 431: DELETE wms_dock_appointments_b

427: SAVEPOINT delete_dock_sp;
428: -- Initialize API return status to success
429: x_return_status := FND_API.G_RET_STS_SUCCESS;
430:
431: DELETE wms_dock_appointments_b
432: WHERE DOCK_APPOINTMENT_ID = p_dock_appointment_id;
433:
434: DELETE wms_dock_appointments_tl
435: WHERE DOCK_APPOINTMENT_ID = p_dock_appointment_id;

Line 468: FROM wms_dock_appointments_b

464:
465: DELETE wms_dock_appointments_tl
466: WHERE dock_appointment_id IN
467: (SELECT dock_appointment_id
468: FROM wms_dock_appointments_b
469: WHERE REP_ORIGIN = p_rep_orig_id);
470:
471: DELETE wms_dock_appointments_b
472: WHERE REP_ORIGIN = p_rep_orig_id;

Line 471: DELETE wms_dock_appointments_b

467: (SELECT dock_appointment_id
468: FROM wms_dock_appointments_b
469: WHERE REP_ORIGIN = p_rep_orig_id);
470:
471: DELETE wms_dock_appointments_b
472: WHERE REP_ORIGIN = p_rep_orig_id;
473:
474: EXCEPTION
475: WHEN OTHERS THEN

Line 494: FROM WMS_DOCK_APPOINTMENTS_B B

490: BEGIN
491: DELETE FROM WMS_DOCK_APPOINTMENTS_TL T
492: WHERE NOT exists
493: (SELECT NULL
494: FROM WMS_DOCK_APPOINTMENTS_B B
495: WHERE B.DOCK_APPOINTMENT_ID = T.DOCK_APPOINTMENT_ID
496: );
497:
498: UPDATE WMS_DOCK_APPOINTMENTS_TL T

Line 596: from WMS_DOCK_APPOINTMENTS_B

592: END_TIME,
593: SOURCE_TYPE,
594: SOURCE_HEADER_ID,
595: SOURCE_LINE_ID
596: from WMS_DOCK_APPOINTMENTS_B
597: where DOCK_APPOINTMENT_ID = X_DOCK_APPOINTMENT_ID
598: for update of DOCK_APPOINTMENT_ID nowait;
599: recinfo c%rowtype;
600:

Line 832: FROM wms_dock_appointments_b

828: SELECT dock_appointment_id
829: , start_time
830: , end_time
831: INTO x_dock_appt_list(1)
832: FROM wms_dock_appointments_b
833: WHERE
834: start_time=(SELECT min(start_time)
835: FROM wms_dock_appointments_b
836: WHERE organization_id = p_organization_id

Line 835: FROM wms_dock_appointments_b

831: INTO x_dock_appt_list(1)
832: FROM wms_dock_appointments_b
833: WHERE
834: start_time=(SELECT min(start_time)
835: FROM wms_dock_appointments_b
836: WHERE organization_id = p_organization_id
837: AND appointment_type = NVL(p_appointment_type, appointment_type)
838: AND start_time >= p_start_date
839: AND trip_stop = p_trip_stop_id

Line 874: FROM wms_dock_appointments_b

870: , start_time
871: , end_time
872: BULK COLLECT
873: INTO x_dock_appt_list
874: FROM wms_dock_appointments_b
875: WHERE organization_id = p_organization_id
876: AND appointment_type = NVL(p_appointment_type, appointment_type)
877: AND carrier_code = l_carrier_code
878: AND start_time >= p_start_date

Line 941: FROM wms_dock_appointments_b

937: l_msg_data VARCHAR2(4000);
938:
939: CURSOR Get_Appt_Info(v_trip_stop_id number, v_organization_id NUMBER) IS
940: SELECT dock_appointment_id
941: FROM wms_dock_appointments_b
942: WHERE trip_stop = v_trip_stop_id
943: AND organization_id = v_organization_id;
944:
945: CURSOR Check_Valid_Locator(v_locator_id NUMBER, v_organization_id NUMBER) IS