237: ItemCat_EndCust_Hold Hold_Entity_Tbl;
238:
239: --ER# 13331078 end added for 'IC'
240:
241: g_hold_header_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
242: g_hold_line_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
243: g_hold_Source_Id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
244: g_hold_ship_set OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
245: g_hold_arrival_set OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
238:
239: --ER# 13331078 end added for 'IC'
240:
241: g_hold_header_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
242: g_hold_line_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
243: g_hold_Source_Id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
244: g_hold_ship_set OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
245: g_hold_arrival_set OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
246: g_hold_top_model_line_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
239: --ER# 13331078 end added for 'IC'
240:
241: g_hold_header_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
242: g_hold_line_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
243: g_hold_Source_Id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
244: g_hold_ship_set OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
245: g_hold_arrival_set OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
246: g_hold_top_model_line_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
247: g_hold_activity_name OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
240:
241: g_hold_header_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
242: g_hold_line_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
243: g_hold_Source_Id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
244: g_hold_ship_set OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
245: g_hold_arrival_set OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
246: g_hold_top_model_line_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
247: g_hold_activity_name OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
248:
241: g_hold_header_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
242: g_hold_line_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
243: g_hold_Source_Id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
244: g_hold_ship_set OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
245: g_hold_arrival_set OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
246: g_hold_top_model_line_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
247: g_hold_activity_name OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
248:
249: g_header_index NUMBER;
242: g_hold_line_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
243: g_hold_Source_Id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
244: g_hold_ship_set OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
245: g_hold_arrival_set OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
246: g_hold_top_model_line_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
247: g_hold_activity_name OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
248:
249: g_header_index NUMBER;
250:
243: g_hold_Source_Id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
244: g_hold_ship_set OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
245: g_hold_arrival_set OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
246: g_hold_top_model_line_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
247: g_hold_activity_name OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
248:
249: g_header_index NUMBER;
250:
251: TYPE Hold_Source_Rec IS RECORD
249: g_header_index NUMBER;
250:
251: TYPE Hold_Source_Rec IS RECORD
252: (
253: HOLD_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
254: HOLD_SOURCE_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
255: HOLD_ENTITY_CODE OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30(),
256: HOLD_ENTITY_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
257: HOLD_UNTIL_DATE OE_WSH_BULK_GRP.T_DATE := OE_WSH_BULK_GRP.T_DATE(),
250:
251: TYPE Hold_Source_Rec IS RECORD
252: (
253: HOLD_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
254: HOLD_SOURCE_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
255: HOLD_ENTITY_CODE OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30(),
256: HOLD_ENTITY_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
257: HOLD_UNTIL_DATE OE_WSH_BULK_GRP.T_DATE := OE_WSH_BULK_GRP.T_DATE(),
258: RELEASED_FLAG OE_WSH_BULK_GRP.T_V1 := OE_WSH_BULK_GRP.T_V1(),
251: TYPE Hold_Source_Rec IS RECORD
252: (
253: HOLD_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
254: HOLD_SOURCE_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
255: HOLD_ENTITY_CODE OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30(),
256: HOLD_ENTITY_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
257: HOLD_UNTIL_DATE OE_WSH_BULK_GRP.T_DATE := OE_WSH_BULK_GRP.T_DATE(),
258: RELEASED_FLAG OE_WSH_BULK_GRP.T_V1 := OE_WSH_BULK_GRP.T_V1(),
259: HOLD_COMMENT OE_WSH_BULK_GRP.T_V2000 := OE_WSH_BULK_GRP.T_V2000(),
252: (
253: HOLD_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
254: HOLD_SOURCE_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
255: HOLD_ENTITY_CODE OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30(),
256: HOLD_ENTITY_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
257: HOLD_UNTIL_DATE OE_WSH_BULK_GRP.T_DATE := OE_WSH_BULK_GRP.T_DATE(),
258: RELEASED_FLAG OE_WSH_BULK_GRP.T_V1 := OE_WSH_BULK_GRP.T_V1(),
259: HOLD_COMMENT OE_WSH_BULK_GRP.T_V2000 := OE_WSH_BULK_GRP.T_V2000(),
260: ORG_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
253: HOLD_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
254: HOLD_SOURCE_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
255: HOLD_ENTITY_CODE OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30(),
256: HOLD_ENTITY_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
257: HOLD_UNTIL_DATE OE_WSH_BULK_GRP.T_DATE := OE_WSH_BULK_GRP.T_DATE(),
258: RELEASED_FLAG OE_WSH_BULK_GRP.T_V1 := OE_WSH_BULK_GRP.T_V1(),
259: HOLD_COMMENT OE_WSH_BULK_GRP.T_V2000 := OE_WSH_BULK_GRP.T_V2000(),
260: ORG_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
261: HOLD_RELEASE_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
254: HOLD_SOURCE_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
255: HOLD_ENTITY_CODE OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30(),
256: HOLD_ENTITY_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
257: HOLD_UNTIL_DATE OE_WSH_BULK_GRP.T_DATE := OE_WSH_BULK_GRP.T_DATE(),
258: RELEASED_FLAG OE_WSH_BULK_GRP.T_V1 := OE_WSH_BULK_GRP.T_V1(),
259: HOLD_COMMENT OE_WSH_BULK_GRP.T_V2000 := OE_WSH_BULK_GRP.T_V2000(),
260: ORG_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
261: HOLD_RELEASE_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
262: HOLD_ENTITY_CODE2 OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30(),
255: HOLD_ENTITY_CODE OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30(),
256: HOLD_ENTITY_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
257: HOLD_UNTIL_DATE OE_WSH_BULK_GRP.T_DATE := OE_WSH_BULK_GRP.T_DATE(),
258: RELEASED_FLAG OE_WSH_BULK_GRP.T_V1 := OE_WSH_BULK_GRP.T_V1(),
259: HOLD_COMMENT OE_WSH_BULK_GRP.T_V2000 := OE_WSH_BULK_GRP.T_V2000(),
260: ORG_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
261: HOLD_RELEASE_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
262: HOLD_ENTITY_CODE2 OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30(),
263: HOLD_ENTITY_ID2 OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
256: HOLD_ENTITY_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
257: HOLD_UNTIL_DATE OE_WSH_BULK_GRP.T_DATE := OE_WSH_BULK_GRP.T_DATE(),
258: RELEASED_FLAG OE_WSH_BULK_GRP.T_V1 := OE_WSH_BULK_GRP.T_V1(),
259: HOLD_COMMENT OE_WSH_BULK_GRP.T_V2000 := OE_WSH_BULK_GRP.T_V2000(),
260: ORG_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
261: HOLD_RELEASE_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
262: HOLD_ENTITY_CODE2 OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30(),
263: HOLD_ENTITY_ID2 OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
264: HEADER_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
257: HOLD_UNTIL_DATE OE_WSH_BULK_GRP.T_DATE := OE_WSH_BULK_GRP.T_DATE(),
258: RELEASED_FLAG OE_WSH_BULK_GRP.T_V1 := OE_WSH_BULK_GRP.T_V1(),
259: HOLD_COMMENT OE_WSH_BULK_GRP.T_V2000 := OE_WSH_BULK_GRP.T_V2000(),
260: ORG_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
261: HOLD_RELEASE_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
262: HOLD_ENTITY_CODE2 OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30(),
263: HOLD_ENTITY_ID2 OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
264: HEADER_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
265: LINE_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
258: RELEASED_FLAG OE_WSH_BULK_GRP.T_V1 := OE_WSH_BULK_GRP.T_V1(),
259: HOLD_COMMENT OE_WSH_BULK_GRP.T_V2000 := OE_WSH_BULK_GRP.T_V2000(),
260: ORG_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
261: HOLD_RELEASE_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
262: HOLD_ENTITY_CODE2 OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30(),
263: HOLD_ENTITY_ID2 OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
264: HEADER_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
265: LINE_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
266: );
259: HOLD_COMMENT OE_WSH_BULK_GRP.T_V2000 := OE_WSH_BULK_GRP.T_V2000(),
260: ORG_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
261: HOLD_RELEASE_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
262: HOLD_ENTITY_CODE2 OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30(),
263: HOLD_ENTITY_ID2 OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
264: HEADER_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
265: LINE_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
266: );
267:
260: ORG_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
261: HOLD_RELEASE_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
262: HOLD_ENTITY_CODE2 OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30(),
263: HOLD_ENTITY_ID2 OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
264: HEADER_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
265: LINE_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
266: );
267:
268: g_hold_source_rec Hold_Source_Rec;
261: HOLD_RELEASE_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
262: HOLD_ENTITY_CODE2 OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30(),
263: HOLD_ENTITY_ID2 OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
264: HEADER_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
265: LINE_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
266: );
267:
268: g_hold_source_rec Hold_Source_Rec;
269: -----------------------------------------------------------------------