APPS.WSH_CONT_PKG dependencies on WSH_PACKED_CONTAINERS

Line 20: FROM wsh_packed_containers

16: CURSOR get_master_container(
17: P_container_id NUMBER)
18: IS
19: SELECT container_id, master_serial_number
20: FROM wsh_packed_containers
21: WHERE parent_container_id IS NULL
22: START WITH container_id = P_container_id
23: CONNECT BY PRIOR parent_container_id = container_id;
24:

Line 55: FROM wsh_packed_containers

51: CURSOR get_child_cont(
52: P_container_id NUMBER)
53: IS
54: SELECT container_id
55: FROM wsh_packed_containers
56: START WITH parent_container_id = P_container_id
57: CONNECT BY PRIOR container_id = parent_container_id;
58:
59: L_container_id NUMBER;

Line 69: UPDATE wsh_packed_containers

65: LOOP
66: FETCH get_child_cont INTO L_container_id;
67: EXIT WHEN get_child_cont%NOTFOUND;
68:
69: UPDATE wsh_packed_containers
70: SET master_container_id = X_master_container_id,
71: master_serial_number = X_master_serial_number
72: WHERE container_id = L_container_id
73: AND delivery_id = X_delivery_id;

Line 124: FROM wsh_packed_containers

120: CURSOR get_child_cont(
121: P_container_id NUMBER)
122: IS
123: SELECT container_id
124: FROM wsh_packed_containers
125: START WITH parent_container_id = P_container_id
126: CONNECT BY PRIOR container_id = parent_container_id;
127:
128: L_container_id NUMBER;

Line 136: UPDATE wsh_packed_containers

132: LOOP
133: FETCH get_child_cont INTO L_container_id;
134: EXIT WHEN get_child_cont%NOTFOUND;
135:
136: UPDATE wsh_packed_containers
137: SET master_serial_number = X_master_serial_number
138: WHERE container_id = L_container_id
139: AND delivery_id = X_delivery_id;
140:

Line 162: FROM wsh_packed_containers

158: P_sequence_number NUMBER,
159: P_delivery_id NUMBER)
160: IS
161: SELECT master_serial_number
162: FROM wsh_packed_containers
163: WHERE parent_sequence_number IS NULL
164: START WITH sequence_number = p_sequence_number
165: AND delivery_id = p_delivery_id
166: CONNECT BY PRIOR parent_sequence_number = sequence_number