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.WSH_DELIVERY_DETAILS_PKG dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 1670: IS SELECT wsh_delivery_assignments_s.nextval

1666: ) IS
1667:
1668:
1669: CURSOR C_Del_Assign_ID
1670: IS SELECT wsh_delivery_assignments_s.nextval
1671: FROM sys.dual;
1672:
1673: l_row_count NUMBER;
1674: l_temp_id NUMBER;

Line 1716: INSERT INTO wsh_delivery_assignments

1712: END IF;
1713: x_da_id_tab := l_da_id_tab;
1714:
1715: FORALL i in 1..p_num_of_rec
1716: INSERT INTO wsh_delivery_assignments
1717: (delivery_id,
1718: parent_delivery_id,
1719: delivery_detail_id,
1720: parent_delivery_detail_id,

Line 1898: FROM wsh_delivery_details wdd, wsh_delivery_assignments wda

1894: wdd.transaction_temp_id,
1895: wda.delivery_id,
1896: nvl(wdd.ignore_for_planning, 'N'), -- OTM R12
1897: nvl(wdd.gross_weight, 0) -- OTM R12 : packing ECO
1898: FROM wsh_delivery_details wdd, wsh_delivery_assignments wda
1899: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
1900: and wdd.rowid = v_rowid;
1901:
1902: CURSOR get_del_detail_by_id(v_delivery_detail_id NUMBER) IS

Line 1913: FROM wsh_delivery_details wdd, wsh_delivery_assignments wda

1909: wdd.transaction_temp_id,
1910: wda.delivery_id,
1911: nvl(wdd.ignore_for_planning, 'N'), -- OTM R12
1912: nvl(wdd.gross_weight, 0) -- OTM R12 : packing ECO
1913: FROM wsh_delivery_details wdd, wsh_delivery_assignments wda
1914: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
1915: and wdd.delivery_detail_id = v_delivery_detail_id;
1916:
1917: l_delivery_detail_id NUMBER := NULL;

Line 2116: DELETE FROM wsh_delivery_assignments

2112: WSH_DEBUG_SV.log(l_module_name,'Rows deleted from wsh_delivery_details',SQL%ROWCOUNT);
2113: END IF;
2114: l_dbi_dml_type := 'DELETE';
2115:
2116: DELETE FROM wsh_delivery_assignments
2117: WHERE delivery_detail_id = l_delivery_detail_id;
2118: IF l_debug_on THEN
2119: WSH_DEBUG_SV.log(l_module_name,'Rows deleted from wsh_delivery_assignments',SQL%ROWCOUNT);
2120: END IF;

Line 2119: WSH_DEBUG_SV.log(l_module_name,'Rows deleted from wsh_delivery_assignments',SQL%ROWCOUNT);

2115:
2116: DELETE FROM wsh_delivery_assignments
2117: WHERE delivery_detail_id = l_delivery_detail_id;
2118: IF l_debug_on THEN
2119: WSH_DEBUG_SV.log(l_module_name,'Rows deleted from wsh_delivery_assignments',SQL%ROWCOUNT);
2120: END IF;
2121:
2122: -- OTM R12
2123: -- packing ECO : l_container_flag = 'N' is removed from the if condition

Line 3320: FROM wsh_delivery_assignments wda,

3316:
3317: -- OTM R12 : packing ECO
3318: CURSOR c_get_delivery_info(p_delivery_detail_id IN NUMBER) IS
3319: SELECT wda.delivery_id
3320: FROM wsh_delivery_assignments wda,
3321: wsh_new_deliveries wnd
3322: WHERE wda.delivery_detail_id = p_delivery_detail_id
3323: AND wda.delivery_id = wnd.delivery_id
3324: AND wnd.tms_interface_flag IN

Line 3338: wsh_delivery_assignments wda

3334: wdd.requested_quantity,
3335: wdd.requested_quantity2,
3336: wda.delivery_id
3337: FROM wsh_delivery_details wdd,
3338: wsh_delivery_assignments wda
3339: WHERE wdd.delivery_detail_id = p_delivery_details_info.delivery_detail_id
3340: AND wdd.delivery_detail_id = wda.delivery_detail_id;
3341:
3342: l_cons_source_line_rec_tab WSH_DELIVERY_DETAILS_ACTIONS.Cons_Source_Line_Rec_Tab;

Line 4419: FROM wsh_delivery_assignments

4415:
4416:
4417: CURSOR C_Del_Assign_Rowid
4418: IS SELECT rowid
4419: FROM wsh_delivery_assignments
4420: WHERE delivery_assignment_id = x_delivery_assignment_id;
4421:
4422: CURSOR C_Del_Assign_ID
4423: IS SELECT wsh_delivery_assignments_s.nextval

Line 4423: IS SELECT wsh_delivery_assignments_s.nextval

4419: FROM wsh_delivery_assignments
4420: WHERE delivery_assignment_id = x_delivery_assignment_id;
4421:
4422: CURSOR C_Del_Assign_ID
4423: IS SELECT wsh_delivery_assignments_s.nextval
4424: FROM sys.dual;
4425:
4426: CURSOR C_Check_Assignment_ID
4427: IS

Line 4429: FROM wsh_delivery_assignments

4425:
4426: CURSOR C_Check_Assignment_ID
4427: IS
4428: SELECT rowid
4429: FROM wsh_delivery_assignments
4430: WHERE delivery_assignment_id = x_delivery_assignment_id;
4431:
4432: l_row_count NUMBER;
4433: l_temp_id NUMBER;

Line 4533: FROM wsh_delivery_assignments

4529: IS
4530:
4531: CURSOR get_del_assignment_id_rowid (v_rowid VARCHAR2) IS
4532: SELECT delivery_assignment_id
4533: FROM wsh_delivery_assignments
4534: WHERE rowid = v_rowid;
4535:
4536: l_delivery_assignment_id NUMBER;
4537: others exception;

Line 4574: DELETE FROM wsh_delivery_assignments

4570: l_delivery_assignment_id := p_delivery_assignment_id;
4571: END IF;
4572:
4573: IF p_delivery_assignment_id IS NOT NULL THEN
4574: DELETE FROM wsh_delivery_assignments
4575: WHERE delivery_assignment_id = l_delivery_assignment_id;
4576: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4577: ELSE
4578: raise others;

Line 4617: FROM wsh_delivery_assignments

4613: x_return_status OUT NOCOPY VARCHAR2
4614: ) IS
4615: CURSOR get_rowid IS
4616: SELECT rowid
4617: FROM wsh_delivery_assignments
4618: WHERE delivery_assignment_id = p_delivery_assignments_info.delivery_assignment_id;
4619:
4620: l_rowid VARCHAR2(30);
4621: others exception;

Line 4660: UPDATE wsh_delivery_assignments

4656: ELSE
4657: l_rowid := p_rowid;
4658: END IF;
4659:
4660: UPDATE wsh_delivery_assignments
4661: SET
4662: delivery_id = p_delivery_assignments_info.delivery_id,
4663: parent_delivery_id = p_delivery_assignments_info.parent_delivery_id,
4664: delivery_detail_id = p_delivery_assignments_info.delivery_detail_id,

Line 4717: FROM wsh_delivery_assignments

4713: ) IS
4714:
4715: CURSOR lock_row IS
4716: SELECT *
4717: FROM wsh_delivery_assignments
4718: WHERE rowid = p_rowid
4719: FOR UPDATE OF delivery_assignment_id NOWAIT;
4720:
4721: Recinfo lock_row%ROWTYPE;

Line 4993: FROM wsh_delivery_details wdd, wsh_delivery_assignments wda

4989: IS
4990:
4991: CURSOR c_lock_details_of_dlvy(p_dlvy_id NUMBER) IS
4992: SELECT wdd.delivery_detail_id
4993: FROM wsh_delivery_details wdd, wsh_delivery_assignments wda
4994: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
4995: AND wda.delivery_id = p_dlvy_id
4996: FOR UPDATE OF wdd.delivery_detail_id NOWAIT;
4997:

Line 5369: FROM wsh_delivery_assignments

5365: IS
5366:
5367: CURSOR c_lock_wda_of_dlvy(p_dlvy_id NUMBER) IS
5368: SELECT delivery_detail_id
5369: FROM wsh_delivery_assignments
5370: WHERE delivery_id = p_dlvy_id
5371: FOR UPDATE NOWAIT;
5372:
5373: CURSOR c_lock_wda_of_detail(p_detail_id NUMBER) IS

Line 5375: FROM wsh_delivery_assignments

5371: FOR UPDATE NOWAIT;
5372:
5373: CURSOR c_lock_wda_of_detail(p_detail_id NUMBER) IS
5374: SELECT delivery_detail_id
5375: FROM wsh_delivery_assignments
5376: WHERE delivery_detail_id = p_delivery_detail_id
5377: FOR UPDATE NOWAIT;
5378:
5379: l_dummy_detail_id NUMBER;