APPS.WSH_VENDOR_PARTY_MERGE_PKG dependencies on WSH_TMP

Line 2931: -- deliveries(from wsh_tmp table) which are to be updated with new

2927: -- PROCEDURE : GET_DELIVERY_HASH
2928: --
2929: -- DESCRIPTION :
2930: -- Get_Delivery_Hash generates new hash value and hash string for
2931: -- deliveries(from wsh_tmp table) which are to be updated with new
2932: -- Customer/Location ids
2933: --
2934: -- PARAMETERS :
2935: -- x_hash_string_tab => Contains array of Hash String for deliveries

Line 2950: FROM Wsh_Tmp;

2946: IS
2947: CURSOR Get_Tmp_Deliveries
2948: IS
2949: SELECT to_number(Column1) delivery_id, Column3
2950: FROM Wsh_Tmp;
2951:
2952: l_grp_attr_tab_type WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;
2953: l_action_code VARCHAR2(30);
2954: l_return_status VARCHAR2(1);

Line 3441: wsh_tmp tmp

3437: wdd.weight_uom_code,wdd.volume_uom_code
3438: FROM wsh_delivery_assignments wda,
3439: wsh_delivery_details wdd,
3440: wsh_new_deliveries wnd,
3441: wsh_tmp tmp
3442: WHERE wdd.container_flag = 'N'
3443: AND wdd.source_code = 'RTV'
3444: AND wdd.released_status = 'X'
3445: AND nvl(wdd.consignee_flag, 'C') = 'V'

Line 3468: wsh_tmp tmp

3464: CURSOR get_delivery_containers IS
3465: SELECT wdd.rowid
3466: FROM wsh_delivery_details wdd,
3467: wsh_delivery_assignments wda,
3468: wsh_tmp tmp
3469: WHERE wdd.container_flag = 'Y'
3470: AND wdd.delivery_detail_id = wda.parent_delivery_detail_id
3471: AND wda.parent_delivery_detail_id IS NOT NULL
3472: AND wda.delivery_id = tmp.column1

Line 3481: wsh_tmp tmp

3477: wts.stop_id, wnd.gross_weight, wnd.net_weight, wnd.volume
3478: FROM wsh_delivery_legs wdl,
3479: wsh_new_deliveries wnd,
3480: Wsh_trip_stops wts,
3481: wsh_tmp tmp
3482: WHERE wnd.ultimate_dropoff_location_id = c_to_location_id
3483: AND wts.stop_id = wdl.drop_off_stop_id
3484: AND wdl.delivery_id = wnd.delivery_id
3485: AND wnd.delivery_id = tmp.column1

Line 3891: INSERT INTO wsh_tmp ( column1, column2, column3 )

3887: WSH_DEBUG_SV.log(l_module_name, 'l_delivery_id.count', l_delivery_id.count);
3888: END IF;
3889:
3890: FORALL I IN l_delivery_id.first..l_delivery_id.last
3891: INSERT INTO wsh_tmp ( column1, column2, column3 )
3892: SELECT l_delivery_id(i), l_stop_id(i), l_delivery_detail_id(i)
3893: FROM dual
3894: WHERE l_delivery_id(i) IS NOT NULL
3895: AND NOT EXISTS

Line 3897: FROM wsh_tmp

3893: FROM dual
3894: WHERE l_delivery_id(i) IS NOT NULL
3895: AND NOT EXISTS
3896: ( SELECT 'x'
3897: FROM wsh_tmp
3898: WHERE column1 = l_delivery_id(i)
3899: AND ( column2 = l_stop_id(i) OR l_stop_id(i) IS NULL ) );
3900:
3901: l_sql_count := SQL%rowcount;

Line 3903: WSH_DEBUG_SV.logmsg(l_module_name,'inserted into wsh_tmp. Number of Rows inserted is ' || l_sql_count, WSH_DEBUG_SV.C_STMT_LEVEL);

3899: AND ( column2 = l_stop_id(i) OR l_stop_id(i) IS NULL ) );
3900:
3901: l_sql_count := SQL%rowcount;
3902: IF l_debug_on THEN
3903: WSH_DEBUG_SV.logmsg(l_module_name,'inserted into wsh_tmp. Number of Rows inserted is ' || l_sql_count, WSH_DEBUG_SV.C_STMT_LEVEL);
3904: END IF;
3905:
3906: -- To Process deliveries and Stops, inserting into temp table
3907: -- END

Line 4016: --from wsh_tmp table

4012: IF l_debug_on THEN
4013: WSH_DEBUG_SV.log(l_module_name, 'Clearing the deliveries from temp table');
4014: END IF;
4015: --Delivery for which delivery lines are unassigned needs to be deleted
4016: --from wsh_tmp table
4017: FORALL I IN l_delivery_id.FIRST..l_delivery_id.LAST
4018: DELETE FROM wsh_tmp
4019: WHERE column1 = l_delivery_id(i);
4020:

Line 4018: DELETE FROM wsh_tmp

4014: END IF;
4015: --Delivery for which delivery lines are unassigned needs to be deleted
4016: --from wsh_tmp table
4017: FORALL I IN l_delivery_id.FIRST..l_delivery_id.LAST
4018: DELETE FROM wsh_tmp
4019: WHERE column1 = l_delivery_id(i);
4020:
4021: l_sql_count := SQL%rowcount;
4022: IF l_debug_on THEN

Line 4023: WSH_DEBUG_SV.logmsg(l_module_name,'deleted from wsh_tmp. Number of Rows deleted is ' || l_sql_count, WSH_DEBUG_SV.C_STMT_LEVEL);

4019: WHERE column1 = l_delivery_id(i);
4020:
4021: l_sql_count := SQL%rowcount;
4022: IF l_debug_on THEN
4023: WSH_DEBUG_SV.logmsg(l_module_name,'deleted from wsh_tmp. Number of Rows deleted is ' || l_sql_count, WSH_DEBUG_SV.C_STMT_LEVEL);
4024: END IF;
4025: --Log Exceptions 'WSH_VENDOR_MERGE_CHANGE' with message
4026: --'WSH_VMRG_UNASSIGN_DELIVERY' against delivery from which delivery lines
4027: --are un-assigned.

Line 4280: DELETE FROM wsh_tmp

4276: WSH_DEBUG_SV.logmsg(l_module_name,'deleted from wsh_delivery_legs. Number of Rows deleted is ' || l_sql_count, WSH_DEBUG_SV.C_STMT_LEVEL);
4277: END IF;
4278:
4279: FORALL I IN l_tmp_rowid.FIRST..l_tmp_rowid.LAST
4280: DELETE FROM wsh_tmp
4281: WHERE ROWID = l_tmp_rowid(i);
4282:
4283: l_sql_count := SQL%rowcount;
4284: IF l_debug_on THEN

Line 4285: WSH_DEBUG_SV.logmsg(l_module_name,'deleted from wsh_tmp. Number of Rows deleted is ' || l_sql_count, WSH_DEBUG_SV.C_STMT_LEVEL);

4281: WHERE ROWID = l_tmp_rowid(i);
4282:
4283: l_sql_count := SQL%rowcount;
4284: IF l_debug_on THEN
4285: WSH_DEBUG_SV.logmsg(l_module_name,'deleted from wsh_tmp. Number of Rows deleted is ' || l_sql_count, WSH_DEBUG_SV.C_STMT_LEVEL);
4286: END IF;
4287:
4288: -- Log Exceptions 'WSH_VENDOR_MERGE_CHANGE' with message
4289: -- 'WSH_VMRG_UNASSIGN_STOP' against stop from which delivery

Line 4359: FROM WSH_TMP

4355: program_id = fnd_global.conc_program_id,
4356: program_update_date = SYSDATE
4357: WHERE Stop_Id in (
4358: SELECT Column2
4359: FROM WSH_TMP
4360: WHERE Column2 IS NOT NULL );
4361:
4362: --Delete from Wsh_Tmp Table
4363: DELETE FROM Wsh_Tmp;

Line 4362: --Delete from Wsh_Tmp Table

4358: SELECT Column2
4359: FROM WSH_TMP
4360: WHERE Column2 IS NOT NULL );
4361:
4362: --Delete from Wsh_Tmp Table
4363: DELETE FROM Wsh_Tmp;
4364:
4365: -- Updating Empty Deliveries
4366:

Line 4363: DELETE FROM Wsh_Tmp;

4359: FROM WSH_TMP
4360: WHERE Column2 IS NOT NULL );
4361:
4362: --Delete from Wsh_Tmp Table
4363: DELETE FROM Wsh_Tmp;
4364:
4365: -- Updating Empty Deliveries
4366:
4367: OPEN get_empty_deliveries(p_from_vendor_id, l_from_location_id);