DBA Data[Home] [Help]

APPS.WMS_DOCK_APPOINTMENTS_PUB dependencies on WMS_DOCK_APPOINTMENTS_V

Line 83: p_dock_appointments_v_rec IN wms_dock_appointments_v%ROWTYPE

79: (
80: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
81: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
82: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
83: p_dock_appointments_v_rec IN wms_dock_appointments_v%ROWTYPE
84: )
85: IS
86: BEGIN
87: SAVEPOINT update_dock_sp;

Line 148: p_dock_appointments_v_rec IN wms_dock_appointments_v%ROWTYPE

144: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
145: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
146: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
147: p_orig_id IN NUMBER,
148: p_dock_appointments_v_rec IN wms_dock_appointments_v%ROWTYPE
149: )
150: IS
151: BEGIN
152: SAVEPOINT update_rep_dock_sp;

Line 215: , p_dock_appointments_v_rec IN wms_dock_appointments_v%ROWTYPE

211: (
212: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
213: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
214: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
215: , p_dock_appointments_v_rec IN wms_dock_appointments_v%ROWTYPE
216: )
217: IS
218: BEGIN
219: SAVEPOINT insert_dock_sp;

Line 319: , p_dock_appointments_v_rec IN wms_dock_appointments_v%ROWTYPE

315: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
316: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
317: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
318: , p_rep_orig_id IN NUMBER
319: , p_dock_appointments_v_rec IN wms_dock_appointments_v%ROWTYPE
320: )
321: IS
322: BEGIN
323: SAVEPOINT insert_rep_dock_sp;

Line 930: l_dock_appointments_v_rec wms_dock_appointments_v%ROWTYPE;

926: x_msg_count OUT NOCOPY NUMBER,
927: x_msg_data OUT NOCOPY VARCHAR2
928: ) IS
929:
930: l_dock_appointments_v_rec wms_dock_appointments_v%ROWTYPE;
931: l_dock_appointment_id NUMBER;
932: l_locator_id NUMBER;
933: l_disable_date DATE;
934: l_msg VARCHAR2(100);