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.OE_SHIPPING_INTEGRATION_PVT dependencies on OE_BULK_ORDER_PVT

Line 4796: ('bulk call?? line id '|| OE_BULK_ORDER_PVT.G_LINE_REC.line_id

4792:
4793: IF OE_BULK_WF_UTIL.G_LINE_INDEX IS NOT NULL THEN
4794: IF l_debug_level > 0 THEN
4795: oe_debug_pub.add
4796: ('bulk call?? line id '|| OE_BULK_ORDER_PVT.G_LINE_REC.line_id
4797: (OE_BULK_WF_UTIL.G_LINE_INDEX), 2);
4798: END IF;
4799: END IF;
4800:

Line 4802: OE_BULK_ORDER_PVT.G_LINE_REC.line_id(OE_BULK_WF_UTIL.G_LINE_INDEX) =

4798: END IF;
4799: END IF;
4800:
4801: IF OE_BULK_WF_UTIL.G_LINE_INDEX IS NOT NULL AND
4802: OE_BULK_ORDER_PVT.G_LINE_REC.line_id(OE_BULK_WF_UTIL.G_LINE_INDEX) =
4803: p_line_id THEN
4804: IF l_debug_level > 0 THEN
4805: oe_debug_pub.add
4806: ('2 shipping bulk mode '|| OE_BULK_WF_UTIL.G_LINE_INDEX, 4);

Line 4809: l_line_category_code := OE_BULK_ORDER_PVT.G_LINE_REC.line_category_code

4805: oe_debug_pub.add
4806: ('2 shipping bulk mode '|| OE_BULK_WF_UTIL.G_LINE_INDEX, 4);
4807: END IF;
4808:
4809: l_line_category_code := OE_BULK_ORDER_PVT.G_LINE_REC.line_category_code
4810: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4811:
4812: l_source_type_code := OE_BULK_ORDER_PVT.G_LINE_REC.source_type_code
4813: (OE_BULK_WF_UTIL.G_LINE_INDEX);

Line 4812: l_source_type_code := OE_BULK_ORDER_PVT.G_LINE_REC.source_type_code

4808:
4809: l_line_category_code := OE_BULK_ORDER_PVT.G_LINE_REC.line_category_code
4810: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4811:
4812: l_source_type_code := OE_BULK_ORDER_PVT.G_LINE_REC.source_type_code
4813: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4814:
4815: --oe_debug_pub.add('here 2: ', 2);
4816:

Line 4818: := OE_BULK_ORDER_PVT.G_LINE_REC.ship_model_complete_flag

4814:
4815: --oe_debug_pub.add('here 2: ', 2);
4816:
4817: l_ship_model_complete_flag
4818: := OE_BULK_ORDER_PVT.G_LINE_REC.ship_model_complete_flag
4819: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4820:
4821: l_top_model_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.top_model_line_id
4822: (OE_BULK_WF_UTIL.G_LINE_INDEX);

Line 4821: l_top_model_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.top_model_line_id

4817: l_ship_model_complete_flag
4818: := OE_BULK_ORDER_PVT.G_LINE_REC.ship_model_complete_flag
4819: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4820:
4821: l_top_model_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.top_model_line_id
4822: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4823: l_link_to_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.link_to_line_id
4824: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4825:

Line 4823: l_link_to_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.link_to_line_id

4819: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4820:
4821: l_top_model_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.top_model_line_id
4822: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4823: l_link_to_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.link_to_line_id
4824: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4825:
4826: l_ato_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.ato_line_id
4827: (OE_BULK_WF_UTIL.G_LINE_INDEX);

Line 4826: l_ato_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.ato_line_id

4822: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4823: l_link_to_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.link_to_line_id
4824: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4825:
4826: l_ato_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.ato_line_id
4827: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4828: l_model_remnant_flag := OE_BULK_ORDER_PVT.G_LINE_REC.model_remnant_flag
4829: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4830:

Line 4828: l_model_remnant_flag := OE_BULK_ORDER_PVT.G_LINE_REC.model_remnant_flag

4824: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4825:
4826: l_ato_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.ato_line_id
4827: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4828: l_model_remnant_flag := OE_BULK_ORDER_PVT.G_LINE_REC.model_remnant_flag
4829: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4830:
4831: l_shippable_flag := OE_BULK_ORDER_PVT.G_LINE_REC.shippable_flag
4832: (OE_BULK_WF_UTIL.G_LINE_INDEX);

Line 4831: l_shippable_flag := OE_BULK_ORDER_PVT.G_LINE_REC.shippable_flag

4827: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4828: l_model_remnant_flag := OE_BULK_ORDER_PVT.G_LINE_REC.model_remnant_flag
4829: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4830:
4831: l_shippable_flag := OE_BULK_ORDER_PVT.G_LINE_REC.shippable_flag
4832: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4833:
4834: l_explosion_date := OE_BULK_ORDER_PVT.G_LINE_REC.explosion_date
4835: (OE_BULK_WF_UTIL.G_LINE_INDEX);

Line 4834: l_explosion_date := OE_BULK_ORDER_PVT.G_LINE_REC.explosion_date

4830:
4831: l_shippable_flag := OE_BULK_ORDER_PVT.G_LINE_REC.shippable_flag
4832: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4833:
4834: l_explosion_date := OE_BULK_ORDER_PVT.G_LINE_REC.explosion_date
4835: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4836:
4837: l_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.line_id
4838: (OE_BULK_WF_UTIL.G_LINE_INDEX);

Line 4837: l_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.line_id

4833:
4834: l_explosion_date := OE_BULK_ORDER_PVT.G_LINE_REC.explosion_date
4835: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4836:
4837: l_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.line_id
4838: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4839: l_item_type_code := OE_BULK_ORDER_PVT.G_LINE_REC.item_type_code
4840: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4841: --oe_debug_pub.add('here 3: ', 2);

Line 4839: l_item_type_code := OE_BULK_ORDER_PVT.G_LINE_REC.item_type_code

4835: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4836:
4837: l_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.line_id
4838: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4839: l_item_type_code := OE_BULK_ORDER_PVT.G_LINE_REC.item_type_code
4840: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4841: --oe_debug_pub.add('here 3: ', 2);
4842: l_header_id := OE_BULK_ORDER_PVT.G_LINE_REC.header_id
4843: (OE_BULK_WF_UTIL.G_LINE_INDEX);

Line 4842: l_header_id := OE_BULK_ORDER_PVT.G_LINE_REC.header_id

4838: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4839: l_item_type_code := OE_BULK_ORDER_PVT.G_LINE_REC.item_type_code
4840: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4841: --oe_debug_pub.add('here 3: ', 2);
4842: l_header_id := OE_BULK_ORDER_PVT.G_LINE_REC.header_id
4843: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4844:
4845: --oe_debug_pub.add('here 4: ', 2);
4846: ELSE

Line 4925: OE_BULK_ORDER_PVT.G_LINE_REC.line_id(OE_BULK_WF_UTIL.G_LINE_INDEX) =

4921: END IF;
4922:
4923: IF OE_BULK_WF_UTIL.G_LINE_INDEX IS NOT NULL AND
4924: OE_Code_Control.Code_Release_Level >= '110510' AND
4925: OE_BULK_ORDER_PVT.G_LINE_REC.line_id(OE_BULK_WF_UTIL.G_LINE_INDEX) =
4926: p_line_id THEN
4927: IF l_debug_level > 0 THEN
4928: oe_debug_pub.add('3 shipping bulk mode',5);
4929: END IF;

Line 4931: IF OE_BULK_ORDER_PVT.G_LINE_REC.shippable_flag

4927: IF l_debug_level > 0 THEN
4928: oe_debug_pub.add('3 shipping bulk mode',5);
4929: END IF;
4930:
4931: IF OE_BULK_ORDER_PVT.G_LINE_REC.shippable_flag
4932: (OE_BULK_WF_UTIL.G_LINE_INDEX) = 'Y' THEN
4933:
4934: IF l_debug_level > 0 THEN
4935: oe_debug_pub.add

Line 4936: (OE_BULK_ORDER_PVT.G_LINE_REC.shipping_eligible_flag.COUNT,5);

4932: (OE_BULK_WF_UTIL.G_LINE_INDEX) = 'Y' THEN
4933:
4934: IF l_debug_level > 0 THEN
4935: oe_debug_pub.add
4936: (OE_BULK_ORDER_PVT.G_LINE_REC.shipping_eligible_flag.COUNT,5);
4937: END IF;
4938:
4939: IF OE_BULK_ORDER_PVT.G_LINE_REC.shipping_eligible_flag.COUNT <
4940: OE_BULK_ORDER_PVT.G_LINE_REC.line_id.COUNT THEN

Line 4939: IF OE_BULK_ORDER_PVT.G_LINE_REC.shipping_eligible_flag.COUNT <

4935: oe_debug_pub.add
4936: (OE_BULK_ORDER_PVT.G_LINE_REC.shipping_eligible_flag.COUNT,5);
4937: END IF;
4938:
4939: IF OE_BULK_ORDER_PVT.G_LINE_REC.shipping_eligible_flag.COUNT <
4940: OE_BULK_ORDER_PVT.G_LINE_REC.line_id.COUNT THEN
4941:
4942: --------------------------------------------------------
4943: -- 1st eligible line for wsh interface, so extend all.

Line 4940: OE_BULK_ORDER_PVT.G_LINE_REC.line_id.COUNT THEN

4936: (OE_BULK_ORDER_PVT.G_LINE_REC.shipping_eligible_flag.COUNT,5);
4937: END IF;
4938:
4939: IF OE_BULK_ORDER_PVT.G_LINE_REC.shipping_eligible_flag.COUNT <
4940: OE_BULK_ORDER_PVT.G_LINE_REC.line_id.COUNT THEN
4941:
4942: --------------------------------------------------------
4943: -- 1st eligible line for wsh interface, so extend all.
4944: --------------------------------------------------------

Line 4946: l_count := OE_BULK_ORDER_PVT.G_LINE_REC.line_id.COUNT -

4942: --------------------------------------------------------
4943: -- 1st eligible line for wsh interface, so extend all.
4944: --------------------------------------------------------
4945:
4946: l_count := OE_BULK_ORDER_PVT.G_LINE_REC.line_id.COUNT -
4947: OE_BULK_ORDER_PVT.G_LINE_REC.shipping_eligible_flag.COUNT;
4948:
4949: IF l_debug_level > 0 THEN
4950: oe_debug_pub.add('bulk wsh attribs extend begin '

Line 4947: OE_BULK_ORDER_PVT.G_LINE_REC.shipping_eligible_flag.COUNT;

4943: -- 1st eligible line for wsh interface, so extend all.
4944: --------------------------------------------------------
4945:
4946: l_count := OE_BULK_ORDER_PVT.G_LINE_REC.line_id.COUNT -
4947: OE_BULK_ORDER_PVT.G_LINE_REC.shipping_eligible_flag.COUNT;
4948:
4949: IF l_debug_level > 0 THEN
4950: oe_debug_pub.add('bulk wsh attribs extend begin '
4951: || OE_BULK_ORDER_PVT.G_LINE_REC.line_id.COUNT

Line 4951: || OE_BULK_ORDER_PVT.G_LINE_REC.line_id.COUNT

4947: OE_BULK_ORDER_PVT.G_LINE_REC.shipping_eligible_flag.COUNT;
4948:
4949: IF l_debug_level > 0 THEN
4950: oe_debug_pub.add('bulk wsh attribs extend begin '
4951: || OE_BULK_ORDER_PVT.G_LINE_REC.line_id.COUNT
4952: || ' ' || l_count, 2);
4953: END IF;
4954:
4955:

Line 4957: OE_BULK_ORDER_PVT.G_LINE_REC.shipping_eligible_flag.extend(l_count);

4953: END IF;
4954:
4955:
4956: IF l_count > 0 THEN
4957: OE_BULK_ORDER_PVT.G_LINE_REC.shipping_eligible_flag.extend(l_count);
4958: OE_BULK_ORDER_PVT.G_LINE_REC.sold_to_contact_id.extend(l_count);
4959: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_number.extend(l_count);
4960: OE_BULK_ORDER_PVT.G_LINE_REC.order_date_type_code.extend(l_count);
4961: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_id.extend(l_count);

Line 4958: OE_BULK_ORDER_PVT.G_LINE_REC.sold_to_contact_id.extend(l_count);

4954:
4955:
4956: IF l_count > 0 THEN
4957: OE_BULK_ORDER_PVT.G_LINE_REC.shipping_eligible_flag.extend(l_count);
4958: OE_BULK_ORDER_PVT.G_LINE_REC.sold_to_contact_id.extend(l_count);
4959: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_number.extend(l_count);
4960: OE_BULK_ORDER_PVT.G_LINE_REC.order_date_type_code.extend(l_count);
4961: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_id.extend(l_count);
4962: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_name.extend(l_count);

Line 4959: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_number.extend(l_count);

4955:
4956: IF l_count > 0 THEN
4957: OE_BULK_ORDER_PVT.G_LINE_REC.shipping_eligible_flag.extend(l_count);
4958: OE_BULK_ORDER_PVT.G_LINE_REC.sold_to_contact_id.extend(l_count);
4959: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_number.extend(l_count);
4960: OE_BULK_ORDER_PVT.G_LINE_REC.order_date_type_code.extend(l_count);
4961: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_id.extend(l_count);
4962: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_name.extend(l_count);
4963: OE_BULK_ORDER_PVT.G_LINE_REC.source_line_number.extend(l_count);

Line 4960: OE_BULK_ORDER_PVT.G_LINE_REC.order_date_type_code.extend(l_count);

4956: IF l_count > 0 THEN
4957: OE_BULK_ORDER_PVT.G_LINE_REC.shipping_eligible_flag.extend(l_count);
4958: OE_BULK_ORDER_PVT.G_LINE_REC.sold_to_contact_id.extend(l_count);
4959: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_number.extend(l_count);
4960: OE_BULK_ORDER_PVT.G_LINE_REC.order_date_type_code.extend(l_count);
4961: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_id.extend(l_count);
4962: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_name.extend(l_count);
4963: OE_BULK_ORDER_PVT.G_LINE_REC.source_line_number.extend(l_count);
4964: OE_BULK_ORDER_PVT.G_LINE_REC.currency_code.extend(l_count);

Line 4961: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_id.extend(l_count);

4957: OE_BULK_ORDER_PVT.G_LINE_REC.shipping_eligible_flag.extend(l_count);
4958: OE_BULK_ORDER_PVT.G_LINE_REC.sold_to_contact_id.extend(l_count);
4959: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_number.extend(l_count);
4960: OE_BULK_ORDER_PVT.G_LINE_REC.order_date_type_code.extend(l_count);
4961: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_id.extend(l_count);
4962: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_name.extend(l_count);
4963: OE_BULK_ORDER_PVT.G_LINE_REC.source_line_number.extend(l_count);
4964: OE_BULK_ORDER_PVT.G_LINE_REC.currency_code.extend(l_count);
4965:

Line 4962: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_name.extend(l_count);

4958: OE_BULK_ORDER_PVT.G_LINE_REC.sold_to_contact_id.extend(l_count);
4959: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_number.extend(l_count);
4960: OE_BULK_ORDER_PVT.G_LINE_REC.order_date_type_code.extend(l_count);
4961: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_id.extend(l_count);
4962: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_name.extend(l_count);
4963: OE_BULK_ORDER_PVT.G_LINE_REC.source_line_number.extend(l_count);
4964: OE_BULK_ORDER_PVT.G_LINE_REC.currency_code.extend(l_count);
4965:
4966: OE_BULK_ORDER_PVT.G_LINE_REC.INTERMED_SHIP_TO_CONTACT_ID.extend(l_count);

Line 4963: OE_BULK_ORDER_PVT.G_LINE_REC.source_line_number.extend(l_count);

4959: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_number.extend(l_count);
4960: OE_BULK_ORDER_PVT.G_LINE_REC.order_date_type_code.extend(l_count);
4961: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_id.extend(l_count);
4962: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_name.extend(l_count);
4963: OE_BULK_ORDER_PVT.G_LINE_REC.source_line_number.extend(l_count);
4964: OE_BULK_ORDER_PVT.G_LINE_REC.currency_code.extend(l_count);
4965:
4966: OE_BULK_ORDER_PVT.G_LINE_REC.INTERMED_SHIP_TO_CONTACT_ID.extend(l_count);
4967: OE_BULK_ORDER_PVT.G_LINE_REC.INTERMED_SHIP_TO_ORG_ID.extend(l_count);

Line 4964: OE_BULK_ORDER_PVT.G_LINE_REC.currency_code.extend(l_count);

4960: OE_BULK_ORDER_PVT.G_LINE_REC.order_date_type_code.extend(l_count);
4961: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_id.extend(l_count);
4962: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_name.extend(l_count);
4963: OE_BULK_ORDER_PVT.G_LINE_REC.source_line_number.extend(l_count);
4964: OE_BULK_ORDER_PVT.G_LINE_REC.currency_code.extend(l_count);
4965:
4966: OE_BULK_ORDER_PVT.G_LINE_REC.INTERMED_SHIP_TO_CONTACT_ID.extend(l_count);
4967: OE_BULK_ORDER_PVT.G_LINE_REC.INTERMED_SHIP_TO_ORG_ID.extend(l_count);
4968:

Line 4966: OE_BULK_ORDER_PVT.G_LINE_REC.INTERMED_SHIP_TO_CONTACT_ID.extend(l_count);

4962: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_name.extend(l_count);
4963: OE_BULK_ORDER_PVT.G_LINE_REC.source_line_number.extend(l_count);
4964: OE_BULK_ORDER_PVT.G_LINE_REC.currency_code.extend(l_count);
4965:
4966: OE_BULK_ORDER_PVT.G_LINE_REC.INTERMED_SHIP_TO_CONTACT_ID.extend(l_count);
4967: OE_BULK_ORDER_PVT.G_LINE_REC.INTERMED_SHIP_TO_ORG_ID.extend(l_count);
4968:
4969: OE_BULK_ORDER_PVT.G_LINE_REC.item_description.extend(l_count);
4970: OE_BULK_ORDER_PVT.G_LINE_REC.hazard_class_id.extend(l_count);

Line 4967: OE_BULK_ORDER_PVT.G_LINE_REC.INTERMED_SHIP_TO_ORG_ID.extend(l_count);

4963: OE_BULK_ORDER_PVT.G_LINE_REC.source_line_number.extend(l_count);
4964: OE_BULK_ORDER_PVT.G_LINE_REC.currency_code.extend(l_count);
4965:
4966: OE_BULK_ORDER_PVT.G_LINE_REC.INTERMED_SHIP_TO_CONTACT_ID.extend(l_count);
4967: OE_BULK_ORDER_PVT.G_LINE_REC.INTERMED_SHIP_TO_ORG_ID.extend(l_count);
4968:
4969: OE_BULK_ORDER_PVT.G_LINE_REC.item_description.extend(l_count);
4970: OE_BULK_ORDER_PVT.G_LINE_REC.hazard_class_id.extend(l_count);
4971: OE_BULK_ORDER_PVT.G_LINE_REC.weight_uom_code.extend(l_count);

Line 4969: OE_BULK_ORDER_PVT.G_LINE_REC.item_description.extend(l_count);

4965:
4966: OE_BULK_ORDER_PVT.G_LINE_REC.INTERMED_SHIP_TO_CONTACT_ID.extend(l_count);
4967: OE_BULK_ORDER_PVT.G_LINE_REC.INTERMED_SHIP_TO_ORG_ID.extend(l_count);
4968:
4969: OE_BULK_ORDER_PVT.G_LINE_REC.item_description.extend(l_count);
4970: OE_BULK_ORDER_PVT.G_LINE_REC.hazard_class_id.extend(l_count);
4971: OE_BULK_ORDER_PVT.G_LINE_REC.weight_uom_code.extend(l_count);
4972: OE_BULK_ORDER_PVT.G_LINE_REC.volume_uom_code.extend(l_count);
4973: OE_BULK_ORDER_PVT.G_LINE_REC.requested_quantity_uom.extend(l_count);

Line 4970: OE_BULK_ORDER_PVT.G_LINE_REC.hazard_class_id.extend(l_count);

4966: OE_BULK_ORDER_PVT.G_LINE_REC.INTERMED_SHIP_TO_CONTACT_ID.extend(l_count);
4967: OE_BULK_ORDER_PVT.G_LINE_REC.INTERMED_SHIP_TO_ORG_ID.extend(l_count);
4968:
4969: OE_BULK_ORDER_PVT.G_LINE_REC.item_description.extend(l_count);
4970: OE_BULK_ORDER_PVT.G_LINE_REC.hazard_class_id.extend(l_count);
4971: OE_BULK_ORDER_PVT.G_LINE_REC.weight_uom_code.extend(l_count);
4972: OE_BULK_ORDER_PVT.G_LINE_REC.volume_uom_code.extend(l_count);
4973: OE_BULK_ORDER_PVT.G_LINE_REC.requested_quantity_uom.extend(l_count);
4974: OE_BULK_ORDER_PVT.G_LINE_REC.mtl_unit_weight.extend(l_count);

Line 4971: OE_BULK_ORDER_PVT.G_LINE_REC.weight_uom_code.extend(l_count);

4967: OE_BULK_ORDER_PVT.G_LINE_REC.INTERMED_SHIP_TO_ORG_ID.extend(l_count);
4968:
4969: OE_BULK_ORDER_PVT.G_LINE_REC.item_description.extend(l_count);
4970: OE_BULK_ORDER_PVT.G_LINE_REC.hazard_class_id.extend(l_count);
4971: OE_BULK_ORDER_PVT.G_LINE_REC.weight_uom_code.extend(l_count);
4972: OE_BULK_ORDER_PVT.G_LINE_REC.volume_uom_code.extend(l_count);
4973: OE_BULK_ORDER_PVT.G_LINE_REC.requested_quantity_uom.extend(l_count);
4974: OE_BULK_ORDER_PVT.G_LINE_REC.mtl_unit_weight.extend(l_count);
4975: OE_BULK_ORDER_PVT.G_LINE_REC.mtl_unit_volume.extend(l_count);

Line 4972: OE_BULK_ORDER_PVT.G_LINE_REC.volume_uom_code.extend(l_count);

4968:
4969: OE_BULK_ORDER_PVT.G_LINE_REC.item_description.extend(l_count);
4970: OE_BULK_ORDER_PVT.G_LINE_REC.hazard_class_id.extend(l_count);
4971: OE_BULK_ORDER_PVT.G_LINE_REC.weight_uom_code.extend(l_count);
4972: OE_BULK_ORDER_PVT.G_LINE_REC.volume_uom_code.extend(l_count);
4973: OE_BULK_ORDER_PVT.G_LINE_REC.requested_quantity_uom.extend(l_count);
4974: OE_BULK_ORDER_PVT.G_LINE_REC.mtl_unit_weight.extend(l_count);
4975: OE_BULK_ORDER_PVT.G_LINE_REC.mtl_unit_volume.extend(l_count);
4976: OE_BULK_ORDER_PVT.G_LINE_REC.pickable_flag.extend(l_count);

Line 4973: OE_BULK_ORDER_PVT.G_LINE_REC.requested_quantity_uom.extend(l_count);

4969: OE_BULK_ORDER_PVT.G_LINE_REC.item_description.extend(l_count);
4970: OE_BULK_ORDER_PVT.G_LINE_REC.hazard_class_id.extend(l_count);
4971: OE_BULK_ORDER_PVT.G_LINE_REC.weight_uom_code.extend(l_count);
4972: OE_BULK_ORDER_PVT.G_LINE_REC.volume_uom_code.extend(l_count);
4973: OE_BULK_ORDER_PVT.G_LINE_REC.requested_quantity_uom.extend(l_count);
4974: OE_BULK_ORDER_PVT.G_LINE_REC.mtl_unit_weight.extend(l_count);
4975: OE_BULK_ORDER_PVT.G_LINE_REC.mtl_unit_volume.extend(l_count);
4976: OE_BULK_ORDER_PVT.G_LINE_REC.pickable_flag.extend(l_count);
4977:

Line 4974: OE_BULK_ORDER_PVT.G_LINE_REC.mtl_unit_weight.extend(l_count);

4970: OE_BULK_ORDER_PVT.G_LINE_REC.hazard_class_id.extend(l_count);
4971: OE_BULK_ORDER_PVT.G_LINE_REC.weight_uom_code.extend(l_count);
4972: OE_BULK_ORDER_PVT.G_LINE_REC.volume_uom_code.extend(l_count);
4973: OE_BULK_ORDER_PVT.G_LINE_REC.requested_quantity_uom.extend(l_count);
4974: OE_BULK_ORDER_PVT.G_LINE_REC.mtl_unit_weight.extend(l_count);
4975: OE_BULK_ORDER_PVT.G_LINE_REC.mtl_unit_volume.extend(l_count);
4976: OE_BULK_ORDER_PVT.G_LINE_REC.pickable_flag.extend(l_count);
4977:
4978: IF l_debug_level > 0 THEN

Line 4975: OE_BULK_ORDER_PVT.G_LINE_REC.mtl_unit_volume.extend(l_count);

4971: OE_BULK_ORDER_PVT.G_LINE_REC.weight_uom_code.extend(l_count);
4972: OE_BULK_ORDER_PVT.G_LINE_REC.volume_uom_code.extend(l_count);
4973: OE_BULK_ORDER_PVT.G_LINE_REC.requested_quantity_uom.extend(l_count);
4974: OE_BULK_ORDER_PVT.G_LINE_REC.mtl_unit_weight.extend(l_count);
4975: OE_BULK_ORDER_PVT.G_LINE_REC.mtl_unit_volume.extend(l_count);
4976: OE_BULK_ORDER_PVT.G_LINE_REC.pickable_flag.extend(l_count);
4977:
4978: IF l_debug_level > 0 THEN
4979: oe_debug_pub.add('bulk wsh attribs extended '|| l_count,2);

Line 4976: OE_BULK_ORDER_PVT.G_LINE_REC.pickable_flag.extend(l_count);

4972: OE_BULK_ORDER_PVT.G_LINE_REC.volume_uom_code.extend(l_count);
4973: OE_BULK_ORDER_PVT.G_LINE_REC.requested_quantity_uom.extend(l_count);
4974: OE_BULK_ORDER_PVT.G_LINE_REC.mtl_unit_weight.extend(l_count);
4975: OE_BULK_ORDER_PVT.G_LINE_REC.mtl_unit_volume.extend(l_count);
4976: OE_BULK_ORDER_PVT.G_LINE_REC.pickable_flag.extend(l_count);
4977:
4978: IF l_debug_level > 0 THEN
4979: oe_debug_pub.add('bulk wsh attribs extended '|| l_count,2);
4980: END IF;

Line 4987: OE_BULK_ORDER_PVT.G_LINE_REC.shipping_eligible_flag

4983:
4984: --------------------------------------------------------
4985: -- Assign values to this line
4986: --------------------------------------------------------
4987: OE_BULK_ORDER_PVT.G_LINE_REC.shipping_eligible_flag
4988: (OE_BULK_WF_UTIL.G_LINE_INDEX) := 'Y';
4989:
4990: --oe_debug_pub.add('here 5: ', 2);
4991:

Line 4994: => OE_BULK_ORDER_PVT.G_LINE_REC.inventory_item_id

4990: --oe_debug_pub.add('here 5: ', 2);
4991:
4992: l_count := OE_BULK_CACHE.Load_Item
4993: ( p_key1
4994: => OE_BULK_ORDER_PVT.G_LINE_REC.inventory_item_id
4995: (OE_BULK_WF_UTIL.G_LINE_INDEX)
4996: ,p_key2
4997: => OE_BULK_ORDER_PVT.G_LINE_REC.ship_from_org_id
4998: (OE_BULK_WF_UTIL.G_LINE_INDEX));

Line 4997: => OE_BULK_ORDER_PVT.G_LINE_REC.ship_from_org_id

4993: ( p_key1
4994: => OE_BULK_ORDER_PVT.G_LINE_REC.inventory_item_id
4995: (OE_BULK_WF_UTIL.G_LINE_INDEX)
4996: ,p_key2
4997: => OE_BULK_ORDER_PVT.G_LINE_REC.ship_from_org_id
4998: (OE_BULK_WF_UTIL.G_LINE_INDEX));
4999:
5000: --oe_debug_pub.add('here 5-1: '
5001: --|| OE_BULK_ORDER_PVT.G_LINE_REC.ordered_item_id

Line 5001: --|| OE_BULK_ORDER_PVT.G_LINE_REC.ordered_item_id

4997: => OE_BULK_ORDER_PVT.G_LINE_REC.ship_from_org_id
4998: (OE_BULK_WF_UTIL.G_LINE_INDEX));
4999:
5000: --oe_debug_pub.add('here 5-1: '
5001: --|| OE_BULK_ORDER_PVT.G_LINE_REC.ordered_item_id
5002: --(OE_BULK_WF_UTIL.G_LINE_INDEX), 2);
5003:
5004: IF g_debug_call > 0 THEN
5005: G_DEBUG_MSG := G_DEBUG_MSG || '208';

Line 5008: OE_BULK_ORDER_PVT.G_LINE_REC.item_description

5004: IF g_debug_call > 0 THEN
5005: G_DEBUG_MSG := G_DEBUG_MSG || '208';
5006: END IF;
5007:
5008: OE_BULK_ORDER_PVT.G_LINE_REC.item_description
5009: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5010: OE_BULK_CACHE.G_ITEM_TBL(l_count).item_description;
5011:
5012: OE_BULK_ORDER_PVT.G_LINE_REC.hazard_class_id

Line 5012: OE_BULK_ORDER_PVT.G_LINE_REC.hazard_class_id

5008: OE_BULK_ORDER_PVT.G_LINE_REC.item_description
5009: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5010: OE_BULK_CACHE.G_ITEM_TBL(l_count).item_description;
5011:
5012: OE_BULK_ORDER_PVT.G_LINE_REC.hazard_class_id
5013: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5014: OE_BULK_CACHE.G_ITEM_TBL(l_count).hazard_class_id;
5015:
5016: OE_BULK_ORDER_PVT.G_LINE_REC.weight_uom_code

Line 5016: OE_BULK_ORDER_PVT.G_LINE_REC.weight_uom_code

5012: OE_BULK_ORDER_PVT.G_LINE_REC.hazard_class_id
5013: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5014: OE_BULK_CACHE.G_ITEM_TBL(l_count).hazard_class_id;
5015:
5016: OE_BULK_ORDER_PVT.G_LINE_REC.weight_uom_code
5017: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5018: OE_BULK_CACHE.G_ITEM_TBL(l_count).weight_uom_code;
5019:
5020: --oe_debug_pub.add('here 6: ', 2);

Line 5022: OE_BULK_ORDER_PVT.G_LINE_REC.volume_uom_code

5018: OE_BULK_CACHE.G_ITEM_TBL(l_count).weight_uom_code;
5019:
5020: --oe_debug_pub.add('here 6: ', 2);
5021:
5022: OE_BULK_ORDER_PVT.G_LINE_REC.volume_uom_code
5023: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5024: OE_BULK_CACHE.G_ITEM_TBL(l_count).volume_uom_code;
5025:
5026: --oe_debug_pub.add('here 6-1: ', 2);

Line 5028: OE_BULK_ORDER_PVT.G_LINE_REC.requested_quantity_uom

5024: OE_BULK_CACHE.G_ITEM_TBL(l_count).volume_uom_code;
5025:
5026: --oe_debug_pub.add('here 6-1: ', 2);
5027:
5028: OE_BULK_ORDER_PVT.G_LINE_REC.requested_quantity_uom
5029: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5030: OE_BULK_CACHE.G_ITEM_TBL(l_count).primary_uom_code;
5031:
5032: --oe_debug_pub.add('here 6-2: ', 2);

Line 5034: OE_BULK_ORDER_PVT.G_LINE_REC.mtl_unit_weight

5030: OE_BULK_CACHE.G_ITEM_TBL(l_count).primary_uom_code;
5031:
5032: --oe_debug_pub.add('here 6-2: ', 2);
5033:
5034: OE_BULK_ORDER_PVT.G_LINE_REC.mtl_unit_weight
5035: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5036: OE_BULK_CACHE.G_ITEM_TBL(l_count).unit_weight;
5037:
5038: --oe_debug_pub.add('here 6-3: ', 2);

Line 5040: OE_BULK_ORDER_PVT.G_LINE_REC.mtl_unit_volume

5036: OE_BULK_CACHE.G_ITEM_TBL(l_count).unit_weight;
5037:
5038: --oe_debug_pub.add('here 6-3: ', 2);
5039:
5040: OE_BULK_ORDER_PVT.G_LINE_REC.mtl_unit_volume
5041: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5042: OE_BULK_CACHE.G_ITEM_TBL(l_count).unit_volume;
5043:
5044: --oe_debug_pub.add('here 6-4: ', 2);

Line 5046: OE_BULK_ORDER_PVT.G_LINE_REC.pickable_flag

5042: OE_BULK_CACHE.G_ITEM_TBL(l_count).unit_volume;
5043:
5044: --oe_debug_pub.add('here 6-4: ', 2);
5045:
5046: OE_BULK_ORDER_PVT.G_LINE_REC.pickable_flag
5047: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5048: OE_BULK_CACHE.G_ITEM_TBL(l_count).pickable_flag;
5049:
5050: --oe_debug_pub.add('here 7: ', 2);

Line 5053: OE_BULK_ORDER_PVT.G_LINE_REC.sold_to_contact_id

5049:
5050: --oe_debug_pub.add('here 7: ', 2);
5051: --------------- from header/ xn types --------------------
5052:
5053: OE_BULK_ORDER_PVT.G_LINE_REC.sold_to_contact_id
5054: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5055: OE_Bulk_Order_PVT.g_header_rec.sold_to_contact_id
5056: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5057:

Line 5055: OE_Bulk_Order_PVT.g_header_rec.sold_to_contact_id

5051: --------------- from header/ xn types --------------------
5052:
5053: OE_BULK_ORDER_PVT.G_LINE_REC.sold_to_contact_id
5054: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5055: OE_Bulk_Order_PVT.g_header_rec.sold_to_contact_id
5056: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5057:
5058: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_number
5059: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=

Line 5058: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_number

5054: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5055: OE_Bulk_Order_PVT.g_header_rec.sold_to_contact_id
5056: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5057:
5058: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_number
5059: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5060: OE_Bulk_Order_PVT.g_header_rec.order_number
5061: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5062:

Line 5060: OE_Bulk_Order_PVT.g_header_rec.order_number

5056: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5057:
5058: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_number
5059: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5060: OE_Bulk_Order_PVT.g_header_rec.order_number
5061: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5062:
5063: OE_BULK_ORDER_PVT.G_LINE_REC.order_date_type_code
5064: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=

Line 5063: OE_BULK_ORDER_PVT.G_LINE_REC.order_date_type_code

5059: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5060: OE_Bulk_Order_PVT.g_header_rec.order_number
5061: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5062:
5063: OE_BULK_ORDER_PVT.G_LINE_REC.order_date_type_code
5064: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5065: OE_Bulk_Order_PVT.g_header_rec.order_date_type_code
5066: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5067:

Line 5065: OE_Bulk_Order_PVT.g_header_rec.order_date_type_code

5061: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5062:
5063: OE_BULK_ORDER_PVT.G_LINE_REC.order_date_type_code
5064: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5065: OE_Bulk_Order_PVT.g_header_rec.order_date_type_code
5066: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5067:
5068: --oe_debug_pub.add('here 8: ', 2);
5069: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_id

Line 5069: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_id

5065: OE_Bulk_Order_PVT.g_header_rec.order_date_type_code
5066: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5067:
5068: --oe_debug_pub.add('here 8: ', 2);
5069: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_id
5070: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5071: OE_Bulk_Order_PVT.g_header_rec.order_type_id
5072: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5073:

Line 5071: OE_Bulk_Order_PVT.g_header_rec.order_type_id

5067:
5068: --oe_debug_pub.add('here 8: ', 2);
5069: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_id
5070: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5071: OE_Bulk_Order_PVT.g_header_rec.order_type_id
5072: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5073:
5074: OE_BULK_ORDER_PVT.G_LINE_REC.currency_code
5075: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=

Line 5074: OE_BULK_ORDER_PVT.G_LINE_REC.currency_code

5070: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5071: OE_Bulk_Order_PVT.g_header_rec.order_type_id
5072: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5073:
5074: OE_BULK_ORDER_PVT.G_LINE_REC.currency_code
5075: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5076: OE_Bulk_Order_PVT.g_header_rec.transactional_curr_code
5077: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5078:

Line 5076: OE_Bulk_Order_PVT.g_header_rec.transactional_curr_code

5072: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5073:
5074: OE_BULK_ORDER_PVT.G_LINE_REC.currency_code
5075: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5076: OE_Bulk_Order_PVT.g_header_rec.transactional_curr_code
5077: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5078:
5079: l_count := OE_BULK_CACHE.Load_Order_Type
5080: ( p_key

Line 5081: => OE_BULK_ORDER_PVT.G_HEADER_REC.order_type_id

5077: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5078:
5079: l_count := OE_BULK_CACHE.Load_Order_Type
5080: ( p_key
5081: => OE_BULK_ORDER_PVT.G_HEADER_REC.order_type_id
5082: (OE_BULK_WF_UTIL.G_HEADER_INDEX));
5083:
5084: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_name
5085: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=

Line 5084: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_name

5080: ( p_key
5081: => OE_BULK_ORDER_PVT.G_HEADER_REC.order_type_id
5082: (OE_BULK_WF_UTIL.G_HEADER_INDEX));
5083:
5084: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_name
5085: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5086: OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_count).name;
5087:
5088: --oe_debug_pub.add('here 9: '|| OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_name(OE_BULK_WF_UTIL.G_LINE_INDEX), 2);

Line 5088: --oe_debug_pub.add('here 9: '|| OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_name(OE_BULK_WF_UTIL.G_LINE_INDEX), 2);

5084: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_name
5085: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5086: OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_count).name;
5087:
5088: --oe_debug_pub.add('here 9: '|| OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_name(OE_BULK_WF_UTIL.G_LINE_INDEX), 2);
5089:
5090: OE_BULK_ORDER_PVT.G_LINE_REC.source_line_number
5091: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5092: RTRIM(OE_BULK_ORDER_PVT.G_LINE_REC.line_number

Line 5090: OE_BULK_ORDER_PVT.G_LINE_REC.source_line_number

5086: OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_count).name;
5087:
5088: --oe_debug_pub.add('here 9: '|| OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_name(OE_BULK_WF_UTIL.G_LINE_INDEX), 2);
5089:
5090: OE_BULK_ORDER_PVT.G_LINE_REC.source_line_number
5091: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5092: RTRIM(OE_BULK_ORDER_PVT.G_LINE_REC.line_number
5093: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5094: OE_BULK_ORDER_PVT.G_LINE_REC.shipment_number

Line 5092: RTRIM(OE_BULK_ORDER_PVT.G_LINE_REC.line_number

5088: --oe_debug_pub.add('here 9: '|| OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_name(OE_BULK_WF_UTIL.G_LINE_INDEX), 2);
5089:
5090: OE_BULK_ORDER_PVT.G_LINE_REC.source_line_number
5091: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5092: RTRIM(OE_BULK_ORDER_PVT.G_LINE_REC.line_number
5093: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5094: OE_BULK_ORDER_PVT.G_LINE_REC.shipment_number
5095: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5096: OE_BULK_ORDER_PVT.G_LINE_REC.option_number

Line 5094: OE_BULK_ORDER_PVT.G_LINE_REC.shipment_number

5090: OE_BULK_ORDER_PVT.G_LINE_REC.source_line_number
5091: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5092: RTRIM(OE_BULK_ORDER_PVT.G_LINE_REC.line_number
5093: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5094: OE_BULK_ORDER_PVT.G_LINE_REC.shipment_number
5095: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5096: OE_BULK_ORDER_PVT.G_LINE_REC.option_number
5097: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5098: OE_BULK_ORDER_PVT.G_LINE_REC.component_number

Line 5096: OE_BULK_ORDER_PVT.G_LINE_REC.option_number

5092: RTRIM(OE_BULK_ORDER_PVT.G_LINE_REC.line_number
5093: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5094: OE_BULK_ORDER_PVT.G_LINE_REC.shipment_number
5095: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5096: OE_BULK_ORDER_PVT.G_LINE_REC.option_number
5097: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5098: OE_BULK_ORDER_PVT.G_LINE_REC.component_number
5099: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5100: OE_BULK_ORDER_PVT.G_LINE_REC.service_number

Line 5098: OE_BULK_ORDER_PVT.G_LINE_REC.component_number

5094: OE_BULK_ORDER_PVT.G_LINE_REC.shipment_number
5095: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5096: OE_BULK_ORDER_PVT.G_LINE_REC.option_number
5097: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5098: OE_BULK_ORDER_PVT.G_LINE_REC.component_number
5099: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5100: OE_BULK_ORDER_PVT.G_LINE_REC.service_number
5101: (OE_BULK_WF_UTIL.G_LINE_INDEX),'.');
5102:

Line 5100: OE_BULK_ORDER_PVT.G_LINE_REC.service_number

5096: OE_BULK_ORDER_PVT.G_LINE_REC.option_number
5097: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5098: OE_BULK_ORDER_PVT.G_LINE_REC.component_number
5099: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5100: OE_BULK_ORDER_PVT.G_LINE_REC.service_number
5101: (OE_BULK_WF_UTIL.G_LINE_INDEX),'.');
5102:
5103: --oe_debug_pub.add('here 10: ', 2);
5104:

Line 5107: OE_BULK_ORDER_PVT.G_LINE_REC.line_id

5103: --oe_debug_pub.add('here 10: ', 2);
5104:
5105: IF l_debug_level > 0 THEN
5106: oe_debug_pub.add('eligible for shipping '||
5107: OE_BULK_ORDER_PVT.G_LINE_REC.line_id
5108: (OE_BULK_WF_UTIL.G_LINE_INDEX), 1 ) ;
5109: END IF;
5110:
5111: END IF; -- if shippable

Line 6019: ,p_header_rec IN OE_BULK_ORDER_PVT.HEADER_REC_TYPE

6015: OM-WSH_HVOP
6016: ------------------------------------------------------------------*/
6017: PROCEDURE OM_To_WSH_Interface
6018: ( p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.LINE_REC_TYPE
6019: ,p_header_rec IN OE_BULK_ORDER_PVT.HEADER_REC_TYPE
6020: ,x_return_status OUT NOCOPY VARCHAR2)
6021: IS
6022: l_action_rec WSH_BULK_TYPES_GRP.action_parameters_rectype;
6023: l_out_rec WSH_BULK_TYPES_GRP.Bulk_process_out_rec_type;