173:
174: CreDate_CreBy_Hold Hold_Entity_Tbl;
175: --ER#7479609 end
176:
177: g_hold_header_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
178: g_hold_line_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
179: g_hold_Source_Id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
180: g_hold_ship_set OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
181: g_hold_arrival_set OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
174: CreDate_CreBy_Hold Hold_Entity_Tbl;
175: --ER#7479609 end
176:
177: g_hold_header_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
178: g_hold_line_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
179: g_hold_Source_Id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
180: g_hold_ship_set OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
181: g_hold_arrival_set OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
182: g_hold_top_model_line_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
175: --ER#7479609 end
176:
177: g_hold_header_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
178: g_hold_line_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
179: g_hold_Source_Id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
180: g_hold_ship_set OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
181: g_hold_arrival_set OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
182: g_hold_top_model_line_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
183: g_hold_activity_name OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
176:
177: g_hold_header_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
178: g_hold_line_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
179: g_hold_Source_Id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
180: g_hold_ship_set OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
181: g_hold_arrival_set OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
182: g_hold_top_model_line_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
183: g_hold_activity_name OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
184:
177: g_hold_header_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
178: g_hold_line_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
179: g_hold_Source_Id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
180: g_hold_ship_set OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
181: g_hold_arrival_set OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
182: g_hold_top_model_line_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
183: g_hold_activity_name OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
184:
185: g_header_index NUMBER;
178: g_hold_line_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
179: g_hold_Source_Id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
180: g_hold_ship_set OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
181: g_hold_arrival_set OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
182: g_hold_top_model_line_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
183: g_hold_activity_name OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
184:
185: g_header_index NUMBER;
186:
179: g_hold_Source_Id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
180: g_hold_ship_set OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
181: g_hold_arrival_set OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
182: g_hold_top_model_line_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM();
183: g_hold_activity_name OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30();
184:
185: g_header_index NUMBER;
186:
187: TYPE Hold_Source_Rec IS RECORD
185: g_header_index NUMBER;
186:
187: TYPE Hold_Source_Rec IS RECORD
188: (
189: HOLD_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
190: HOLD_SOURCE_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
191: HOLD_ENTITY_CODE OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30(),
192: HOLD_ENTITY_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
193: HOLD_UNTIL_DATE OE_WSH_BULK_GRP.T_DATE := OE_WSH_BULK_GRP.T_DATE(),
186:
187: TYPE Hold_Source_Rec IS RECORD
188: (
189: HOLD_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
190: HOLD_SOURCE_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
191: HOLD_ENTITY_CODE OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30(),
192: HOLD_ENTITY_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
193: HOLD_UNTIL_DATE OE_WSH_BULK_GRP.T_DATE := OE_WSH_BULK_GRP.T_DATE(),
194: RELEASED_FLAG OE_WSH_BULK_GRP.T_V1 := OE_WSH_BULK_GRP.T_V1(),
187: TYPE Hold_Source_Rec IS RECORD
188: (
189: HOLD_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
190: HOLD_SOURCE_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
191: HOLD_ENTITY_CODE OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30(),
192: HOLD_ENTITY_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
193: HOLD_UNTIL_DATE OE_WSH_BULK_GRP.T_DATE := OE_WSH_BULK_GRP.T_DATE(),
194: RELEASED_FLAG OE_WSH_BULK_GRP.T_V1 := OE_WSH_BULK_GRP.T_V1(),
195: HOLD_COMMENT OE_WSH_BULK_GRP.T_V2000 := OE_WSH_BULK_GRP.T_V2000(),
188: (
189: HOLD_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
190: HOLD_SOURCE_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
191: HOLD_ENTITY_CODE OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30(),
192: HOLD_ENTITY_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
193: HOLD_UNTIL_DATE OE_WSH_BULK_GRP.T_DATE := OE_WSH_BULK_GRP.T_DATE(),
194: RELEASED_FLAG OE_WSH_BULK_GRP.T_V1 := OE_WSH_BULK_GRP.T_V1(),
195: HOLD_COMMENT OE_WSH_BULK_GRP.T_V2000 := OE_WSH_BULK_GRP.T_V2000(),
196: ORG_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
189: HOLD_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
190: HOLD_SOURCE_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
191: HOLD_ENTITY_CODE OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30(),
192: HOLD_ENTITY_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
193: HOLD_UNTIL_DATE OE_WSH_BULK_GRP.T_DATE := OE_WSH_BULK_GRP.T_DATE(),
194: RELEASED_FLAG OE_WSH_BULK_GRP.T_V1 := OE_WSH_BULK_GRP.T_V1(),
195: HOLD_COMMENT OE_WSH_BULK_GRP.T_V2000 := OE_WSH_BULK_GRP.T_V2000(),
196: ORG_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
197: HOLD_RELEASE_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
190: HOLD_SOURCE_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
191: HOLD_ENTITY_CODE OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30(),
192: HOLD_ENTITY_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
193: HOLD_UNTIL_DATE OE_WSH_BULK_GRP.T_DATE := OE_WSH_BULK_GRP.T_DATE(),
194: RELEASED_FLAG OE_WSH_BULK_GRP.T_V1 := OE_WSH_BULK_GRP.T_V1(),
195: HOLD_COMMENT OE_WSH_BULK_GRP.T_V2000 := OE_WSH_BULK_GRP.T_V2000(),
196: ORG_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
197: HOLD_RELEASE_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
198: HOLD_ENTITY_CODE2 OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30(),
191: HOLD_ENTITY_CODE OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30(),
192: HOLD_ENTITY_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
193: HOLD_UNTIL_DATE OE_WSH_BULK_GRP.T_DATE := OE_WSH_BULK_GRP.T_DATE(),
194: RELEASED_FLAG OE_WSH_BULK_GRP.T_V1 := OE_WSH_BULK_GRP.T_V1(),
195: HOLD_COMMENT OE_WSH_BULK_GRP.T_V2000 := OE_WSH_BULK_GRP.T_V2000(),
196: ORG_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
197: HOLD_RELEASE_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
198: HOLD_ENTITY_CODE2 OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30(),
199: HOLD_ENTITY_ID2 OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
192: HOLD_ENTITY_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
193: HOLD_UNTIL_DATE OE_WSH_BULK_GRP.T_DATE := OE_WSH_BULK_GRP.T_DATE(),
194: RELEASED_FLAG OE_WSH_BULK_GRP.T_V1 := OE_WSH_BULK_GRP.T_V1(),
195: HOLD_COMMENT OE_WSH_BULK_GRP.T_V2000 := OE_WSH_BULK_GRP.T_V2000(),
196: ORG_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
197: HOLD_RELEASE_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
198: HOLD_ENTITY_CODE2 OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30(),
199: HOLD_ENTITY_ID2 OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
200: HEADER_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
193: HOLD_UNTIL_DATE OE_WSH_BULK_GRP.T_DATE := OE_WSH_BULK_GRP.T_DATE(),
194: RELEASED_FLAG OE_WSH_BULK_GRP.T_V1 := OE_WSH_BULK_GRP.T_V1(),
195: HOLD_COMMENT OE_WSH_BULK_GRP.T_V2000 := OE_WSH_BULK_GRP.T_V2000(),
196: ORG_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
197: HOLD_RELEASE_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
198: HOLD_ENTITY_CODE2 OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30(),
199: HOLD_ENTITY_ID2 OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
200: HEADER_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
201: LINE_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
194: RELEASED_FLAG OE_WSH_BULK_GRP.T_V1 := OE_WSH_BULK_GRP.T_V1(),
195: HOLD_COMMENT OE_WSH_BULK_GRP.T_V2000 := OE_WSH_BULK_GRP.T_V2000(),
196: ORG_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
197: HOLD_RELEASE_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
198: HOLD_ENTITY_CODE2 OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30(),
199: HOLD_ENTITY_ID2 OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
200: HEADER_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
201: LINE_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
202: );
195: HOLD_COMMENT OE_WSH_BULK_GRP.T_V2000 := OE_WSH_BULK_GRP.T_V2000(),
196: ORG_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
197: HOLD_RELEASE_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
198: HOLD_ENTITY_CODE2 OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30(),
199: HOLD_ENTITY_ID2 OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
200: HEADER_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
201: LINE_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
202: );
203:
196: ORG_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
197: HOLD_RELEASE_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
198: HOLD_ENTITY_CODE2 OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30(),
199: HOLD_ENTITY_ID2 OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
200: HEADER_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
201: LINE_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
202: );
203:
204: g_hold_source_rec Hold_Source_Rec;
197: HOLD_RELEASE_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
198: HOLD_ENTITY_CODE2 OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30(),
199: HOLD_ENTITY_ID2 OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
200: HEADER_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM(),
201: LINE_ID OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
202: );
203:
204: g_hold_source_rec Hold_Source_Rec;
205: -----------------------------------------------------------------------