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 1533: IS SELECT wsh_delivery_assignments_s.nextval

1529: ) IS
1530:
1531:
1532: CURSOR C_Del_Assign_ID
1533: IS SELECT wsh_delivery_assignments_s.nextval
1534: FROM sys.dual;
1535:
1536: l_row_count NUMBER;
1537: l_temp_id NUMBER;

Line 1579: INSERT INTO wsh_delivery_assignments

1575: END IF;
1576: x_da_id_tab := l_da_id_tab;
1577:
1578: FORALL i in 1..p_num_of_rec
1579: INSERT INTO wsh_delivery_assignments
1580: (delivery_id,
1581: parent_delivery_id,
1582: delivery_detail_id,
1583: parent_delivery_detail_id,

Line 1761: FROM wsh_delivery_details wdd, wsh_delivery_assignments wda

1757: wdd.transaction_temp_id,
1758: wda.delivery_id,
1759: nvl(wdd.ignore_for_planning, 'N'), -- OTM R12
1760: nvl(wdd.gross_weight, 0) -- OTM R12 : packing ECO
1761: FROM wsh_delivery_details wdd, wsh_delivery_assignments wda
1762: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
1763: and wdd.rowid = v_rowid;
1764:
1765: CURSOR get_del_detail_by_id(v_delivery_detail_id NUMBER) IS

Line 1776: FROM wsh_delivery_details wdd, wsh_delivery_assignments wda

1772: wdd.transaction_temp_id,
1773: wda.delivery_id,
1774: nvl(wdd.ignore_for_planning, 'N'), -- OTM R12
1775: nvl(wdd.gross_weight, 0) -- OTM R12 : packing ECO
1776: FROM wsh_delivery_details wdd, wsh_delivery_assignments wda
1777: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
1778: and wdd.delivery_detail_id = v_delivery_detail_id;
1779:
1780: l_delivery_detail_id NUMBER := NULL;

Line 1977: DELETE FROM wsh_delivery_assignments

1973: WSH_DEBUG_SV.log(l_module_name,'Rows deleted from wsh_delivery_details',SQL%ROWCOUNT);
1974: END IF;
1975: l_dbi_dml_type := 'DELETE';
1976:
1977: DELETE FROM wsh_delivery_assignments
1978: WHERE delivery_detail_id = l_delivery_detail_id;
1979: IF l_debug_on THEN
1980: WSH_DEBUG_SV.log(l_module_name,'Rows deleted from wsh_delivery_assignments',SQL%ROWCOUNT);
1981: END IF;

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

1976:
1977: DELETE FROM wsh_delivery_assignments
1978: WHERE delivery_detail_id = l_delivery_detail_id;
1979: IF l_debug_on THEN
1980: WSH_DEBUG_SV.log(l_module_name,'Rows deleted from wsh_delivery_assignments',SQL%ROWCOUNT);
1981: END IF;
1982:
1983: -- OTM R12
1984: -- packing ECO : l_container_flag = 'N' is removed from the if condition

Line 3185: FROM wsh_delivery_assignments wda,

3181:
3182: -- OTM R12 : packing ECO
3183: CURSOR c_get_delivery_info(p_delivery_detail_id IN NUMBER) IS
3184: SELECT wda.delivery_id
3185: FROM wsh_delivery_assignments wda,
3186: wsh_new_deliveries wnd
3187: WHERE wda.delivery_detail_id = p_delivery_detail_id
3188: AND wda.delivery_id = wnd.delivery_id
3189: AND wnd.tms_interface_flag IN

Line 3203: wsh_delivery_assignments wda

3199: wdd.requested_quantity,
3200: wdd.requested_quantity2,
3201: wda.delivery_id
3202: FROM wsh_delivery_details wdd,
3203: wsh_delivery_assignments wda
3204: WHERE wdd.delivery_detail_id = p_delivery_details_info.delivery_detail_id
3205: AND wdd.delivery_detail_id = wda.delivery_detail_id;
3206:
3207: l_cons_source_line_rec_tab WSH_DELIVERY_DETAILS_ACTIONS.Cons_Source_Line_Rec_Tab;

Line 4284: FROM wsh_delivery_assignments

4280:
4281:
4282: CURSOR C_Del_Assign_Rowid
4283: IS SELECT rowid
4284: FROM wsh_delivery_assignments
4285: WHERE delivery_assignment_id = x_delivery_assignment_id;
4286:
4287: CURSOR C_Del_Assign_ID
4288: IS SELECT wsh_delivery_assignments_s.nextval

Line 4288: IS SELECT wsh_delivery_assignments_s.nextval

4284: FROM wsh_delivery_assignments
4285: WHERE delivery_assignment_id = x_delivery_assignment_id;
4286:
4287: CURSOR C_Del_Assign_ID
4288: IS SELECT wsh_delivery_assignments_s.nextval
4289: FROM sys.dual;
4290:
4291: CURSOR C_Check_Assignment_ID
4292: IS

Line 4294: FROM wsh_delivery_assignments

4290:
4291: CURSOR C_Check_Assignment_ID
4292: IS
4293: SELECT rowid
4294: FROM wsh_delivery_assignments
4295: WHERE delivery_assignment_id = x_delivery_assignment_id;
4296:
4297: l_row_count NUMBER;
4298: l_temp_id NUMBER;

Line 4398: FROM wsh_delivery_assignments

4394: IS
4395:
4396: CURSOR get_del_assignment_id_rowid (v_rowid VARCHAR2) IS
4397: SELECT delivery_assignment_id
4398: FROM wsh_delivery_assignments
4399: WHERE rowid = v_rowid;
4400:
4401: l_delivery_assignment_id NUMBER;
4402: others exception;

Line 4439: DELETE FROM wsh_delivery_assignments

4435: l_delivery_assignment_id := p_delivery_assignment_id;
4436: END IF;
4437:
4438: IF p_delivery_assignment_id IS NOT NULL THEN
4439: DELETE FROM wsh_delivery_assignments
4440: WHERE delivery_assignment_id = l_delivery_assignment_id;
4441: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4442: ELSE
4443: raise others;

Line 4482: FROM wsh_delivery_assignments

4478: x_return_status OUT NOCOPY VARCHAR2
4479: ) IS
4480: CURSOR get_rowid IS
4481: SELECT rowid
4482: FROM wsh_delivery_assignments
4483: WHERE delivery_assignment_id = p_delivery_assignments_info.delivery_assignment_id;
4484:
4485: l_rowid VARCHAR2(30);
4486: others exception;

Line 4525: UPDATE wsh_delivery_assignments

4521: ELSE
4522: l_rowid := p_rowid;
4523: END IF;
4524:
4525: UPDATE wsh_delivery_assignments
4526: SET
4527: delivery_id = p_delivery_assignments_info.delivery_id,
4528: parent_delivery_id = p_delivery_assignments_info.parent_delivery_id,
4529: delivery_detail_id = p_delivery_assignments_info.delivery_detail_id,

Line 4582: FROM wsh_delivery_assignments

4578: ) IS
4579:
4580: CURSOR lock_row IS
4581: SELECT *
4582: FROM wsh_delivery_assignments
4583: WHERE rowid = p_rowid
4584: FOR UPDATE OF delivery_assignment_id NOWAIT;
4585:
4586: Recinfo lock_row%ROWTYPE;

Line 4858: FROM wsh_delivery_details wdd, wsh_delivery_assignments wda

4854: IS
4855:
4856: CURSOR c_lock_details_of_dlvy(p_dlvy_id NUMBER) IS
4857: SELECT wdd.delivery_detail_id
4858: FROM wsh_delivery_details wdd, wsh_delivery_assignments wda
4859: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
4860: AND wda.delivery_id = p_dlvy_id
4861: FOR UPDATE OF wdd.delivery_detail_id NOWAIT;
4862:

Line 5217: FROM wsh_delivery_assignments

5213: IS
5214:
5215: CURSOR c_lock_wda_of_dlvy(p_dlvy_id NUMBER) IS
5216: SELECT delivery_detail_id
5217: FROM wsh_delivery_assignments
5218: WHERE delivery_id = p_dlvy_id
5219: FOR UPDATE NOWAIT;
5220:
5221: CURSOR c_lock_wda_of_detail(p_detail_id NUMBER) IS

Line 5223: FROM wsh_delivery_assignments

5219: FOR UPDATE NOWAIT;
5220:
5221: CURSOR c_lock_wda_of_detail(p_detail_id NUMBER) IS
5222: SELECT delivery_detail_id
5223: FROM wsh_delivery_assignments
5224: WHERE delivery_detail_id = p_delivery_detail_id
5225: FOR UPDATE NOWAIT;
5226:
5227: l_dummy_detail_id NUMBER;