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 4778: ('bulk call?? line id '|| OE_BULK_ORDER_PVT.G_LINE_REC.line_id

4774:
4775: IF OE_BULK_WF_UTIL.G_LINE_INDEX IS NOT NULL THEN
4776: IF l_debug_level > 0 THEN
4777: oe_debug_pub.add
4778: ('bulk call?? line id '|| OE_BULK_ORDER_PVT.G_LINE_REC.line_id
4779: (OE_BULK_WF_UTIL.G_LINE_INDEX), 2);
4780: END IF;
4781: END IF;
4782:

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

4780: END IF;
4781: END IF;
4782:
4783: IF OE_BULK_WF_UTIL.G_LINE_INDEX IS NOT NULL AND
4784: OE_BULK_ORDER_PVT.G_LINE_REC.line_id(OE_BULK_WF_UTIL.G_LINE_INDEX) =
4785: p_line_id THEN
4786: IF l_debug_level > 0 THEN
4787: oe_debug_pub.add
4788: ('2 shipping bulk mode '|| OE_BULK_WF_UTIL.G_LINE_INDEX, 4);

Line 4791: l_line_category_code := OE_BULK_ORDER_PVT.G_LINE_REC.line_category_code

4787: oe_debug_pub.add
4788: ('2 shipping bulk mode '|| OE_BULK_WF_UTIL.G_LINE_INDEX, 4);
4789: END IF;
4790:
4791: l_line_category_code := OE_BULK_ORDER_PVT.G_LINE_REC.line_category_code
4792: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4793:
4794: l_source_type_code := OE_BULK_ORDER_PVT.G_LINE_REC.source_type_code
4795: (OE_BULK_WF_UTIL.G_LINE_INDEX);

Line 4794: l_source_type_code := OE_BULK_ORDER_PVT.G_LINE_REC.source_type_code

4790:
4791: l_line_category_code := OE_BULK_ORDER_PVT.G_LINE_REC.line_category_code
4792: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4793:
4794: l_source_type_code := OE_BULK_ORDER_PVT.G_LINE_REC.source_type_code
4795: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4796:
4797: --oe_debug_pub.add('here 2: ', 2);
4798:

Line 4800: := OE_BULK_ORDER_PVT.G_LINE_REC.ship_model_complete_flag

4796:
4797: --oe_debug_pub.add('here 2: ', 2);
4798:
4799: l_ship_model_complete_flag
4800: := OE_BULK_ORDER_PVT.G_LINE_REC.ship_model_complete_flag
4801: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4802:
4803: l_top_model_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.top_model_line_id
4804: (OE_BULK_WF_UTIL.G_LINE_INDEX);

Line 4803: l_top_model_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.top_model_line_id

4799: l_ship_model_complete_flag
4800: := OE_BULK_ORDER_PVT.G_LINE_REC.ship_model_complete_flag
4801: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4802:
4803: l_top_model_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.top_model_line_id
4804: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4805: l_link_to_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.link_to_line_id
4806: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4807:

Line 4805: l_link_to_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.link_to_line_id

4801: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4802:
4803: l_top_model_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.top_model_line_id
4804: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4805: l_link_to_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.link_to_line_id
4806: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4807:
4808: l_ato_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.ato_line_id
4809: (OE_BULK_WF_UTIL.G_LINE_INDEX);

Line 4808: l_ato_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.ato_line_id

4804: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4805: l_link_to_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.link_to_line_id
4806: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4807:
4808: l_ato_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.ato_line_id
4809: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4810: l_model_remnant_flag := OE_BULK_ORDER_PVT.G_LINE_REC.model_remnant_flag
4811: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4812:

Line 4810: l_model_remnant_flag := OE_BULK_ORDER_PVT.G_LINE_REC.model_remnant_flag

4806: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4807:
4808: l_ato_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.ato_line_id
4809: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4810: l_model_remnant_flag := OE_BULK_ORDER_PVT.G_LINE_REC.model_remnant_flag
4811: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4812:
4813: l_shippable_flag := OE_BULK_ORDER_PVT.G_LINE_REC.shippable_flag
4814: (OE_BULK_WF_UTIL.G_LINE_INDEX);

Line 4813: l_shippable_flag := OE_BULK_ORDER_PVT.G_LINE_REC.shippable_flag

4809: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4810: l_model_remnant_flag := OE_BULK_ORDER_PVT.G_LINE_REC.model_remnant_flag
4811: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4812:
4813: l_shippable_flag := OE_BULK_ORDER_PVT.G_LINE_REC.shippable_flag
4814: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4815:
4816: l_explosion_date := OE_BULK_ORDER_PVT.G_LINE_REC.explosion_date
4817: (OE_BULK_WF_UTIL.G_LINE_INDEX);

Line 4816: l_explosion_date := OE_BULK_ORDER_PVT.G_LINE_REC.explosion_date

4812:
4813: l_shippable_flag := OE_BULK_ORDER_PVT.G_LINE_REC.shippable_flag
4814: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4815:
4816: l_explosion_date := OE_BULK_ORDER_PVT.G_LINE_REC.explosion_date
4817: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4818:
4819: l_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.line_id
4820: (OE_BULK_WF_UTIL.G_LINE_INDEX);

Line 4819: l_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.line_id

4815:
4816: l_explosion_date := OE_BULK_ORDER_PVT.G_LINE_REC.explosion_date
4817: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4818:
4819: l_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.line_id
4820: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4821: l_item_type_code := OE_BULK_ORDER_PVT.G_LINE_REC.item_type_code
4822: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4823: --oe_debug_pub.add('here 3: ', 2);

Line 4821: l_item_type_code := OE_BULK_ORDER_PVT.G_LINE_REC.item_type_code

4817: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4818:
4819: l_line_id := OE_BULK_ORDER_PVT.G_LINE_REC.line_id
4820: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4821: l_item_type_code := OE_BULK_ORDER_PVT.G_LINE_REC.item_type_code
4822: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4823: --oe_debug_pub.add('here 3: ', 2);
4824: l_header_id := OE_BULK_ORDER_PVT.G_LINE_REC.header_id
4825: (OE_BULK_WF_UTIL.G_LINE_INDEX);

Line 4824: l_header_id := OE_BULK_ORDER_PVT.G_LINE_REC.header_id

4820: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4821: l_item_type_code := OE_BULK_ORDER_PVT.G_LINE_REC.item_type_code
4822: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4823: --oe_debug_pub.add('here 3: ', 2);
4824: l_header_id := OE_BULK_ORDER_PVT.G_LINE_REC.header_id
4825: (OE_BULK_WF_UTIL.G_LINE_INDEX);
4826:
4827: --oe_debug_pub.add('here 4: ', 2);
4828: ELSE

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

4903: END IF;
4904:
4905: IF OE_BULK_WF_UTIL.G_LINE_INDEX IS NOT NULL AND
4906: OE_Code_Control.Code_Release_Level >= '110510' AND
4907: OE_BULK_ORDER_PVT.G_LINE_REC.line_id(OE_BULK_WF_UTIL.G_LINE_INDEX) =
4908: p_line_id THEN
4909: IF l_debug_level > 0 THEN
4910: oe_debug_pub.add('3 shipping bulk mode',5);
4911: END IF;

Line 4913: IF OE_BULK_ORDER_PVT.G_LINE_REC.shippable_flag

4909: IF l_debug_level > 0 THEN
4910: oe_debug_pub.add('3 shipping bulk mode',5);
4911: END IF;
4912:
4913: IF OE_BULK_ORDER_PVT.G_LINE_REC.shippable_flag
4914: (OE_BULK_WF_UTIL.G_LINE_INDEX) = 'Y' THEN
4915:
4916: IF l_debug_level > 0 THEN
4917: oe_debug_pub.add

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

4914: (OE_BULK_WF_UTIL.G_LINE_INDEX) = 'Y' THEN
4915:
4916: IF l_debug_level > 0 THEN
4917: oe_debug_pub.add
4918: (OE_BULK_ORDER_PVT.G_LINE_REC.shipping_eligible_flag.COUNT,5);
4919: END IF;
4920:
4921: IF OE_BULK_ORDER_PVT.G_LINE_REC.shipping_eligible_flag.COUNT <
4922: OE_BULK_ORDER_PVT.G_LINE_REC.line_id.COUNT THEN

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

4917: oe_debug_pub.add
4918: (OE_BULK_ORDER_PVT.G_LINE_REC.shipping_eligible_flag.COUNT,5);
4919: END IF;
4920:
4921: IF OE_BULK_ORDER_PVT.G_LINE_REC.shipping_eligible_flag.COUNT <
4922: OE_BULK_ORDER_PVT.G_LINE_REC.line_id.COUNT THEN
4923:
4924: --------------------------------------------------------
4925: -- 1st eligible line for wsh interface, so extend all.

Line 4922: OE_BULK_ORDER_PVT.G_LINE_REC.line_id.COUNT THEN

4918: (OE_BULK_ORDER_PVT.G_LINE_REC.shipping_eligible_flag.COUNT,5);
4919: END IF;
4920:
4921: IF OE_BULK_ORDER_PVT.G_LINE_REC.shipping_eligible_flag.COUNT <
4922: OE_BULK_ORDER_PVT.G_LINE_REC.line_id.COUNT THEN
4923:
4924: --------------------------------------------------------
4925: -- 1st eligible line for wsh interface, so extend all.
4926: --------------------------------------------------------

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

4924: --------------------------------------------------------
4925: -- 1st eligible line for wsh interface, so extend all.
4926: --------------------------------------------------------
4927:
4928: l_count := OE_BULK_ORDER_PVT.G_LINE_REC.line_id.COUNT -
4929: OE_BULK_ORDER_PVT.G_LINE_REC.shipping_eligible_flag.COUNT;
4930:
4931: IF l_debug_level > 0 THEN
4932: oe_debug_pub.add('bulk wsh attribs extend begin '

Line 4929: OE_BULK_ORDER_PVT.G_LINE_REC.shipping_eligible_flag.COUNT;

4925: -- 1st eligible line for wsh interface, so extend all.
4926: --------------------------------------------------------
4927:
4928: l_count := OE_BULK_ORDER_PVT.G_LINE_REC.line_id.COUNT -
4929: OE_BULK_ORDER_PVT.G_LINE_REC.shipping_eligible_flag.COUNT;
4930:
4931: IF l_debug_level > 0 THEN
4932: oe_debug_pub.add('bulk wsh attribs extend begin '
4933: || OE_BULK_ORDER_PVT.G_LINE_REC.line_id.COUNT

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

4929: OE_BULK_ORDER_PVT.G_LINE_REC.shipping_eligible_flag.COUNT;
4930:
4931: IF l_debug_level > 0 THEN
4932: oe_debug_pub.add('bulk wsh attribs extend begin '
4933: || OE_BULK_ORDER_PVT.G_LINE_REC.line_id.COUNT
4934: || ' ' || l_count, 2);
4935: END IF;
4936:
4937:

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

4935: END IF;
4936:
4937:
4938: IF l_count > 0 THEN
4939: OE_BULK_ORDER_PVT.G_LINE_REC.shipping_eligible_flag.extend(l_count);
4940: OE_BULK_ORDER_PVT.G_LINE_REC.sold_to_contact_id.extend(l_count);
4941: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_number.extend(l_count);
4942: OE_BULK_ORDER_PVT.G_LINE_REC.order_date_type_code.extend(l_count);
4943: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_id.extend(l_count);

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

4936:
4937:
4938: IF l_count > 0 THEN
4939: OE_BULK_ORDER_PVT.G_LINE_REC.shipping_eligible_flag.extend(l_count);
4940: OE_BULK_ORDER_PVT.G_LINE_REC.sold_to_contact_id.extend(l_count);
4941: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_number.extend(l_count);
4942: OE_BULK_ORDER_PVT.G_LINE_REC.order_date_type_code.extend(l_count);
4943: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_id.extend(l_count);
4944: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_name.extend(l_count);

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

4937:
4938: IF l_count > 0 THEN
4939: OE_BULK_ORDER_PVT.G_LINE_REC.shipping_eligible_flag.extend(l_count);
4940: OE_BULK_ORDER_PVT.G_LINE_REC.sold_to_contact_id.extend(l_count);
4941: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_number.extend(l_count);
4942: OE_BULK_ORDER_PVT.G_LINE_REC.order_date_type_code.extend(l_count);
4943: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_id.extend(l_count);
4944: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_name.extend(l_count);
4945: OE_BULK_ORDER_PVT.G_LINE_REC.source_line_number.extend(l_count);

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

4938: IF l_count > 0 THEN
4939: OE_BULK_ORDER_PVT.G_LINE_REC.shipping_eligible_flag.extend(l_count);
4940: OE_BULK_ORDER_PVT.G_LINE_REC.sold_to_contact_id.extend(l_count);
4941: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_number.extend(l_count);
4942: OE_BULK_ORDER_PVT.G_LINE_REC.order_date_type_code.extend(l_count);
4943: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_id.extend(l_count);
4944: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_name.extend(l_count);
4945: OE_BULK_ORDER_PVT.G_LINE_REC.source_line_number.extend(l_count);
4946: OE_BULK_ORDER_PVT.G_LINE_REC.currency_code.extend(l_count);

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

4939: OE_BULK_ORDER_PVT.G_LINE_REC.shipping_eligible_flag.extend(l_count);
4940: OE_BULK_ORDER_PVT.G_LINE_REC.sold_to_contact_id.extend(l_count);
4941: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_number.extend(l_count);
4942: OE_BULK_ORDER_PVT.G_LINE_REC.order_date_type_code.extend(l_count);
4943: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_id.extend(l_count);
4944: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_name.extend(l_count);
4945: OE_BULK_ORDER_PVT.G_LINE_REC.source_line_number.extend(l_count);
4946: OE_BULK_ORDER_PVT.G_LINE_REC.currency_code.extend(l_count);
4947:

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

4940: OE_BULK_ORDER_PVT.G_LINE_REC.sold_to_contact_id.extend(l_count);
4941: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_number.extend(l_count);
4942: OE_BULK_ORDER_PVT.G_LINE_REC.order_date_type_code.extend(l_count);
4943: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_id.extend(l_count);
4944: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_name.extend(l_count);
4945: OE_BULK_ORDER_PVT.G_LINE_REC.source_line_number.extend(l_count);
4946: OE_BULK_ORDER_PVT.G_LINE_REC.currency_code.extend(l_count);
4947:
4948: OE_BULK_ORDER_PVT.G_LINE_REC.INTERMED_SHIP_TO_CONTACT_ID.extend(l_count);

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

4941: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_number.extend(l_count);
4942: OE_BULK_ORDER_PVT.G_LINE_REC.order_date_type_code.extend(l_count);
4943: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_id.extend(l_count);
4944: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_name.extend(l_count);
4945: OE_BULK_ORDER_PVT.G_LINE_REC.source_line_number.extend(l_count);
4946: OE_BULK_ORDER_PVT.G_LINE_REC.currency_code.extend(l_count);
4947:
4948: OE_BULK_ORDER_PVT.G_LINE_REC.INTERMED_SHIP_TO_CONTACT_ID.extend(l_count);
4949: OE_BULK_ORDER_PVT.G_LINE_REC.INTERMED_SHIP_TO_ORG_ID.extend(l_count);

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

4942: OE_BULK_ORDER_PVT.G_LINE_REC.order_date_type_code.extend(l_count);
4943: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_id.extend(l_count);
4944: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_name.extend(l_count);
4945: OE_BULK_ORDER_PVT.G_LINE_REC.source_line_number.extend(l_count);
4946: OE_BULK_ORDER_PVT.G_LINE_REC.currency_code.extend(l_count);
4947:
4948: OE_BULK_ORDER_PVT.G_LINE_REC.INTERMED_SHIP_TO_CONTACT_ID.extend(l_count);
4949: OE_BULK_ORDER_PVT.G_LINE_REC.INTERMED_SHIP_TO_ORG_ID.extend(l_count);
4950:

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

4944: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_name.extend(l_count);
4945: OE_BULK_ORDER_PVT.G_LINE_REC.source_line_number.extend(l_count);
4946: OE_BULK_ORDER_PVT.G_LINE_REC.currency_code.extend(l_count);
4947:
4948: OE_BULK_ORDER_PVT.G_LINE_REC.INTERMED_SHIP_TO_CONTACT_ID.extend(l_count);
4949: OE_BULK_ORDER_PVT.G_LINE_REC.INTERMED_SHIP_TO_ORG_ID.extend(l_count);
4950:
4951: OE_BULK_ORDER_PVT.G_LINE_REC.item_description.extend(l_count);
4952: OE_BULK_ORDER_PVT.G_LINE_REC.hazard_class_id.extend(l_count);

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

4945: OE_BULK_ORDER_PVT.G_LINE_REC.source_line_number.extend(l_count);
4946: OE_BULK_ORDER_PVT.G_LINE_REC.currency_code.extend(l_count);
4947:
4948: OE_BULK_ORDER_PVT.G_LINE_REC.INTERMED_SHIP_TO_CONTACT_ID.extend(l_count);
4949: OE_BULK_ORDER_PVT.G_LINE_REC.INTERMED_SHIP_TO_ORG_ID.extend(l_count);
4950:
4951: OE_BULK_ORDER_PVT.G_LINE_REC.item_description.extend(l_count);
4952: OE_BULK_ORDER_PVT.G_LINE_REC.hazard_class_id.extend(l_count);
4953: OE_BULK_ORDER_PVT.G_LINE_REC.weight_uom_code.extend(l_count);

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

4947:
4948: OE_BULK_ORDER_PVT.G_LINE_REC.INTERMED_SHIP_TO_CONTACT_ID.extend(l_count);
4949: OE_BULK_ORDER_PVT.G_LINE_REC.INTERMED_SHIP_TO_ORG_ID.extend(l_count);
4950:
4951: OE_BULK_ORDER_PVT.G_LINE_REC.item_description.extend(l_count);
4952: OE_BULK_ORDER_PVT.G_LINE_REC.hazard_class_id.extend(l_count);
4953: OE_BULK_ORDER_PVT.G_LINE_REC.weight_uom_code.extend(l_count);
4954: OE_BULK_ORDER_PVT.G_LINE_REC.volume_uom_code.extend(l_count);
4955: OE_BULK_ORDER_PVT.G_LINE_REC.requested_quantity_uom.extend(l_count);

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

4948: OE_BULK_ORDER_PVT.G_LINE_REC.INTERMED_SHIP_TO_CONTACT_ID.extend(l_count);
4949: OE_BULK_ORDER_PVT.G_LINE_REC.INTERMED_SHIP_TO_ORG_ID.extend(l_count);
4950:
4951: OE_BULK_ORDER_PVT.G_LINE_REC.item_description.extend(l_count);
4952: OE_BULK_ORDER_PVT.G_LINE_REC.hazard_class_id.extend(l_count);
4953: OE_BULK_ORDER_PVT.G_LINE_REC.weight_uom_code.extend(l_count);
4954: OE_BULK_ORDER_PVT.G_LINE_REC.volume_uom_code.extend(l_count);
4955: OE_BULK_ORDER_PVT.G_LINE_REC.requested_quantity_uom.extend(l_count);
4956: OE_BULK_ORDER_PVT.G_LINE_REC.mtl_unit_weight.extend(l_count);

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

4949: OE_BULK_ORDER_PVT.G_LINE_REC.INTERMED_SHIP_TO_ORG_ID.extend(l_count);
4950:
4951: OE_BULK_ORDER_PVT.G_LINE_REC.item_description.extend(l_count);
4952: OE_BULK_ORDER_PVT.G_LINE_REC.hazard_class_id.extend(l_count);
4953: OE_BULK_ORDER_PVT.G_LINE_REC.weight_uom_code.extend(l_count);
4954: OE_BULK_ORDER_PVT.G_LINE_REC.volume_uom_code.extend(l_count);
4955: OE_BULK_ORDER_PVT.G_LINE_REC.requested_quantity_uom.extend(l_count);
4956: OE_BULK_ORDER_PVT.G_LINE_REC.mtl_unit_weight.extend(l_count);
4957: OE_BULK_ORDER_PVT.G_LINE_REC.mtl_unit_volume.extend(l_count);

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

4950:
4951: OE_BULK_ORDER_PVT.G_LINE_REC.item_description.extend(l_count);
4952: OE_BULK_ORDER_PVT.G_LINE_REC.hazard_class_id.extend(l_count);
4953: OE_BULK_ORDER_PVT.G_LINE_REC.weight_uom_code.extend(l_count);
4954: OE_BULK_ORDER_PVT.G_LINE_REC.volume_uom_code.extend(l_count);
4955: OE_BULK_ORDER_PVT.G_LINE_REC.requested_quantity_uom.extend(l_count);
4956: OE_BULK_ORDER_PVT.G_LINE_REC.mtl_unit_weight.extend(l_count);
4957: OE_BULK_ORDER_PVT.G_LINE_REC.mtl_unit_volume.extend(l_count);
4958: OE_BULK_ORDER_PVT.G_LINE_REC.pickable_flag.extend(l_count);

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

4951: OE_BULK_ORDER_PVT.G_LINE_REC.item_description.extend(l_count);
4952: OE_BULK_ORDER_PVT.G_LINE_REC.hazard_class_id.extend(l_count);
4953: OE_BULK_ORDER_PVT.G_LINE_REC.weight_uom_code.extend(l_count);
4954: OE_BULK_ORDER_PVT.G_LINE_REC.volume_uom_code.extend(l_count);
4955: OE_BULK_ORDER_PVT.G_LINE_REC.requested_quantity_uom.extend(l_count);
4956: OE_BULK_ORDER_PVT.G_LINE_REC.mtl_unit_weight.extend(l_count);
4957: OE_BULK_ORDER_PVT.G_LINE_REC.mtl_unit_volume.extend(l_count);
4958: OE_BULK_ORDER_PVT.G_LINE_REC.pickable_flag.extend(l_count);
4959:

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

4952: OE_BULK_ORDER_PVT.G_LINE_REC.hazard_class_id.extend(l_count);
4953: OE_BULK_ORDER_PVT.G_LINE_REC.weight_uom_code.extend(l_count);
4954: OE_BULK_ORDER_PVT.G_LINE_REC.volume_uom_code.extend(l_count);
4955: OE_BULK_ORDER_PVT.G_LINE_REC.requested_quantity_uom.extend(l_count);
4956: OE_BULK_ORDER_PVT.G_LINE_REC.mtl_unit_weight.extend(l_count);
4957: OE_BULK_ORDER_PVT.G_LINE_REC.mtl_unit_volume.extend(l_count);
4958: OE_BULK_ORDER_PVT.G_LINE_REC.pickable_flag.extend(l_count);
4959:
4960: IF l_debug_level > 0 THEN

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

4953: OE_BULK_ORDER_PVT.G_LINE_REC.weight_uom_code.extend(l_count);
4954: OE_BULK_ORDER_PVT.G_LINE_REC.volume_uom_code.extend(l_count);
4955: OE_BULK_ORDER_PVT.G_LINE_REC.requested_quantity_uom.extend(l_count);
4956: OE_BULK_ORDER_PVT.G_LINE_REC.mtl_unit_weight.extend(l_count);
4957: OE_BULK_ORDER_PVT.G_LINE_REC.mtl_unit_volume.extend(l_count);
4958: OE_BULK_ORDER_PVT.G_LINE_REC.pickable_flag.extend(l_count);
4959:
4960: IF l_debug_level > 0 THEN
4961: oe_debug_pub.add('bulk wsh attribs extended '|| l_count,2);

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

4954: OE_BULK_ORDER_PVT.G_LINE_REC.volume_uom_code.extend(l_count);
4955: OE_BULK_ORDER_PVT.G_LINE_REC.requested_quantity_uom.extend(l_count);
4956: OE_BULK_ORDER_PVT.G_LINE_REC.mtl_unit_weight.extend(l_count);
4957: OE_BULK_ORDER_PVT.G_LINE_REC.mtl_unit_volume.extend(l_count);
4958: OE_BULK_ORDER_PVT.G_LINE_REC.pickable_flag.extend(l_count);
4959:
4960: IF l_debug_level > 0 THEN
4961: oe_debug_pub.add('bulk wsh attribs extended '|| l_count,2);
4962: END IF;

Line 4969: OE_BULK_ORDER_PVT.G_LINE_REC.shipping_eligible_flag

4965:
4966: --------------------------------------------------------
4967: -- Assign values to this line
4968: --------------------------------------------------------
4969: OE_BULK_ORDER_PVT.G_LINE_REC.shipping_eligible_flag
4970: (OE_BULK_WF_UTIL.G_LINE_INDEX) := 'Y';
4971:
4972: --oe_debug_pub.add('here 5: ', 2);
4973:

Line 4976: => OE_BULK_ORDER_PVT.G_LINE_REC.inventory_item_id

4972: --oe_debug_pub.add('here 5: ', 2);
4973:
4974: l_count := OE_BULK_CACHE.Load_Item
4975: ( p_key1
4976: => OE_BULK_ORDER_PVT.G_LINE_REC.inventory_item_id
4977: (OE_BULK_WF_UTIL.G_LINE_INDEX)
4978: ,p_key2
4979: => OE_BULK_ORDER_PVT.G_LINE_REC.ship_from_org_id
4980: (OE_BULK_WF_UTIL.G_LINE_INDEX));

Line 4979: => OE_BULK_ORDER_PVT.G_LINE_REC.ship_from_org_id

4975: ( p_key1
4976: => OE_BULK_ORDER_PVT.G_LINE_REC.inventory_item_id
4977: (OE_BULK_WF_UTIL.G_LINE_INDEX)
4978: ,p_key2
4979: => OE_BULK_ORDER_PVT.G_LINE_REC.ship_from_org_id
4980: (OE_BULK_WF_UTIL.G_LINE_INDEX));
4981:
4982: --oe_debug_pub.add('here 5-1: '
4983: --|| OE_BULK_ORDER_PVT.G_LINE_REC.ordered_item_id

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

4979: => OE_BULK_ORDER_PVT.G_LINE_REC.ship_from_org_id
4980: (OE_BULK_WF_UTIL.G_LINE_INDEX));
4981:
4982: --oe_debug_pub.add('here 5-1: '
4983: --|| OE_BULK_ORDER_PVT.G_LINE_REC.ordered_item_id
4984: --(OE_BULK_WF_UTIL.G_LINE_INDEX), 2);
4985:
4986: IF g_debug_call > 0 THEN
4987: G_DEBUG_MSG := G_DEBUG_MSG || '208';

Line 4990: OE_BULK_ORDER_PVT.G_LINE_REC.item_description

4986: IF g_debug_call > 0 THEN
4987: G_DEBUG_MSG := G_DEBUG_MSG || '208';
4988: END IF;
4989:
4990: OE_BULK_ORDER_PVT.G_LINE_REC.item_description
4991: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
4992: OE_BULK_CACHE.G_ITEM_TBL(l_count).item_description;
4993:
4994: OE_BULK_ORDER_PVT.G_LINE_REC.hazard_class_id

Line 4994: OE_BULK_ORDER_PVT.G_LINE_REC.hazard_class_id

4990: OE_BULK_ORDER_PVT.G_LINE_REC.item_description
4991: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
4992: OE_BULK_CACHE.G_ITEM_TBL(l_count).item_description;
4993:
4994: OE_BULK_ORDER_PVT.G_LINE_REC.hazard_class_id
4995: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
4996: OE_BULK_CACHE.G_ITEM_TBL(l_count).hazard_class_id;
4997:
4998: OE_BULK_ORDER_PVT.G_LINE_REC.weight_uom_code

Line 4998: OE_BULK_ORDER_PVT.G_LINE_REC.weight_uom_code

4994: OE_BULK_ORDER_PVT.G_LINE_REC.hazard_class_id
4995: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
4996: OE_BULK_CACHE.G_ITEM_TBL(l_count).hazard_class_id;
4997:
4998: OE_BULK_ORDER_PVT.G_LINE_REC.weight_uom_code
4999: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5000: OE_BULK_CACHE.G_ITEM_TBL(l_count).weight_uom_code;
5001:
5002: --oe_debug_pub.add('here 6: ', 2);

Line 5004: OE_BULK_ORDER_PVT.G_LINE_REC.volume_uom_code

5000: OE_BULK_CACHE.G_ITEM_TBL(l_count).weight_uom_code;
5001:
5002: --oe_debug_pub.add('here 6: ', 2);
5003:
5004: OE_BULK_ORDER_PVT.G_LINE_REC.volume_uom_code
5005: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5006: OE_BULK_CACHE.G_ITEM_TBL(l_count).volume_uom_code;
5007:
5008: --oe_debug_pub.add('here 6-1: ', 2);

Line 5010: OE_BULK_ORDER_PVT.G_LINE_REC.requested_quantity_uom

5006: OE_BULK_CACHE.G_ITEM_TBL(l_count).volume_uom_code;
5007:
5008: --oe_debug_pub.add('here 6-1: ', 2);
5009:
5010: OE_BULK_ORDER_PVT.G_LINE_REC.requested_quantity_uom
5011: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5012: OE_BULK_CACHE.G_ITEM_TBL(l_count).primary_uom_code;
5013:
5014: --oe_debug_pub.add('here 6-2: ', 2);

Line 5016: OE_BULK_ORDER_PVT.G_LINE_REC.mtl_unit_weight

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

Line 5022: OE_BULK_ORDER_PVT.G_LINE_REC.mtl_unit_volume

5018: OE_BULK_CACHE.G_ITEM_TBL(l_count).unit_weight;
5019:
5020: --oe_debug_pub.add('here 6-3: ', 2);
5021:
5022: OE_BULK_ORDER_PVT.G_LINE_REC.mtl_unit_volume
5023: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5024: OE_BULK_CACHE.G_ITEM_TBL(l_count).unit_volume;
5025:
5026: --oe_debug_pub.add('here 6-4: ', 2);

Line 5028: OE_BULK_ORDER_PVT.G_LINE_REC.pickable_flag

5024: OE_BULK_CACHE.G_ITEM_TBL(l_count).unit_volume;
5025:
5026: --oe_debug_pub.add('here 6-4: ', 2);
5027:
5028: OE_BULK_ORDER_PVT.G_LINE_REC.pickable_flag
5029: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5030: OE_BULK_CACHE.G_ITEM_TBL(l_count).pickable_flag;
5031:
5032: --oe_debug_pub.add('here 7: ', 2);

Line 5035: OE_BULK_ORDER_PVT.G_LINE_REC.sold_to_contact_id

5031:
5032: --oe_debug_pub.add('here 7: ', 2);
5033: --------------- from header/ xn types --------------------
5034:
5035: OE_BULK_ORDER_PVT.G_LINE_REC.sold_to_contact_id
5036: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5037: OE_Bulk_Order_PVT.g_header_rec.sold_to_contact_id
5038: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5039:

Line 5037: OE_Bulk_Order_PVT.g_header_rec.sold_to_contact_id

5033: --------------- from header/ xn types --------------------
5034:
5035: OE_BULK_ORDER_PVT.G_LINE_REC.sold_to_contact_id
5036: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5037: OE_Bulk_Order_PVT.g_header_rec.sold_to_contact_id
5038: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5039:
5040: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_number
5041: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=

Line 5040: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_number

5036: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5037: OE_Bulk_Order_PVT.g_header_rec.sold_to_contact_id
5038: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5039:
5040: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_number
5041: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5042: OE_Bulk_Order_PVT.g_header_rec.order_number
5043: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5044:

Line 5042: OE_Bulk_Order_PVT.g_header_rec.order_number

5038: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5039:
5040: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_number
5041: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5042: OE_Bulk_Order_PVT.g_header_rec.order_number
5043: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5044:
5045: OE_BULK_ORDER_PVT.G_LINE_REC.order_date_type_code
5046: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=

Line 5045: OE_BULK_ORDER_PVT.G_LINE_REC.order_date_type_code

5041: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5042: OE_Bulk_Order_PVT.g_header_rec.order_number
5043: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5044:
5045: OE_BULK_ORDER_PVT.G_LINE_REC.order_date_type_code
5046: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5047: OE_Bulk_Order_PVT.g_header_rec.order_date_type_code
5048: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5049:

Line 5047: OE_Bulk_Order_PVT.g_header_rec.order_date_type_code

5043: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5044:
5045: OE_BULK_ORDER_PVT.G_LINE_REC.order_date_type_code
5046: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5047: OE_Bulk_Order_PVT.g_header_rec.order_date_type_code
5048: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5049:
5050: --oe_debug_pub.add('here 8: ', 2);
5051: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_id

Line 5051: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_id

5047: OE_Bulk_Order_PVT.g_header_rec.order_date_type_code
5048: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5049:
5050: --oe_debug_pub.add('here 8: ', 2);
5051: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_id
5052: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5053: OE_Bulk_Order_PVT.g_header_rec.order_type_id
5054: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5055:

Line 5053: OE_Bulk_Order_PVT.g_header_rec.order_type_id

5049:
5050: --oe_debug_pub.add('here 8: ', 2);
5051: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_id
5052: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5053: OE_Bulk_Order_PVT.g_header_rec.order_type_id
5054: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5055:
5056: OE_BULK_ORDER_PVT.G_LINE_REC.currency_code
5057: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=

Line 5056: OE_BULK_ORDER_PVT.G_LINE_REC.currency_code

5052: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5053: OE_Bulk_Order_PVT.g_header_rec.order_type_id
5054: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5055:
5056: OE_BULK_ORDER_PVT.G_LINE_REC.currency_code
5057: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5058: OE_Bulk_Order_PVT.g_header_rec.transactional_curr_code
5059: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5060:

Line 5058: OE_Bulk_Order_PVT.g_header_rec.transactional_curr_code

5054: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5055:
5056: OE_BULK_ORDER_PVT.G_LINE_REC.currency_code
5057: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5058: OE_Bulk_Order_PVT.g_header_rec.transactional_curr_code
5059: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5060:
5061: l_count := OE_BULK_CACHE.Load_Order_Type
5062: ( p_key

Line 5063: => OE_BULK_ORDER_PVT.G_HEADER_REC.order_type_id

5059: (OE_BULK_WF_UTIL.G_HEADER_INDEX);
5060:
5061: l_count := OE_BULK_CACHE.Load_Order_Type
5062: ( p_key
5063: => OE_BULK_ORDER_PVT.G_HEADER_REC.order_type_id
5064: (OE_BULK_WF_UTIL.G_HEADER_INDEX));
5065:
5066: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_name
5067: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=

Line 5066: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_name

5062: ( p_key
5063: => OE_BULK_ORDER_PVT.G_HEADER_REC.order_type_id
5064: (OE_BULK_WF_UTIL.G_HEADER_INDEX));
5065:
5066: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_name
5067: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5068: OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_count).name;
5069:
5070: --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 5070: --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);

5066: OE_BULK_ORDER_PVT.G_LINE_REC.source_header_type_name
5067: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5068: OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_count).name;
5069:
5070: --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);
5071:
5072: OE_BULK_ORDER_PVT.G_LINE_REC.source_line_number
5073: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5074: RTRIM(OE_BULK_ORDER_PVT.G_LINE_REC.line_number

Line 5072: OE_BULK_ORDER_PVT.G_LINE_REC.source_line_number

5068: OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_count).name;
5069:
5070: --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);
5071:
5072: OE_BULK_ORDER_PVT.G_LINE_REC.source_line_number
5073: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5074: RTRIM(OE_BULK_ORDER_PVT.G_LINE_REC.line_number
5075: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5076: OE_BULK_ORDER_PVT.G_LINE_REC.shipment_number

Line 5074: RTRIM(OE_BULK_ORDER_PVT.G_LINE_REC.line_number

5070: --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);
5071:
5072: OE_BULK_ORDER_PVT.G_LINE_REC.source_line_number
5073: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5074: RTRIM(OE_BULK_ORDER_PVT.G_LINE_REC.line_number
5075: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5076: OE_BULK_ORDER_PVT.G_LINE_REC.shipment_number
5077: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5078: OE_BULK_ORDER_PVT.G_LINE_REC.option_number

Line 5076: OE_BULK_ORDER_PVT.G_LINE_REC.shipment_number

5072: OE_BULK_ORDER_PVT.G_LINE_REC.source_line_number
5073: (OE_BULK_WF_UTIL.G_LINE_INDEX) :=
5074: RTRIM(OE_BULK_ORDER_PVT.G_LINE_REC.line_number
5075: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5076: OE_BULK_ORDER_PVT.G_LINE_REC.shipment_number
5077: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5078: OE_BULK_ORDER_PVT.G_LINE_REC.option_number
5079: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5080: OE_BULK_ORDER_PVT.G_LINE_REC.component_number

Line 5078: OE_BULK_ORDER_PVT.G_LINE_REC.option_number

5074: RTRIM(OE_BULK_ORDER_PVT.G_LINE_REC.line_number
5075: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5076: OE_BULK_ORDER_PVT.G_LINE_REC.shipment_number
5077: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5078: OE_BULK_ORDER_PVT.G_LINE_REC.option_number
5079: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5080: OE_BULK_ORDER_PVT.G_LINE_REC.component_number
5081: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5082: OE_BULK_ORDER_PVT.G_LINE_REC.service_number

Line 5080: OE_BULK_ORDER_PVT.G_LINE_REC.component_number

5076: OE_BULK_ORDER_PVT.G_LINE_REC.shipment_number
5077: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5078: OE_BULK_ORDER_PVT.G_LINE_REC.option_number
5079: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5080: OE_BULK_ORDER_PVT.G_LINE_REC.component_number
5081: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5082: OE_BULK_ORDER_PVT.G_LINE_REC.service_number
5083: (OE_BULK_WF_UTIL.G_LINE_INDEX),'.');
5084:

Line 5082: OE_BULK_ORDER_PVT.G_LINE_REC.service_number

5078: OE_BULK_ORDER_PVT.G_LINE_REC.option_number
5079: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5080: OE_BULK_ORDER_PVT.G_LINE_REC.component_number
5081: (OE_BULK_WF_UTIL.G_LINE_INDEX) || '.' ||
5082: OE_BULK_ORDER_PVT.G_LINE_REC.service_number
5083: (OE_BULK_WF_UTIL.G_LINE_INDEX),'.');
5084:
5085: --oe_debug_pub.add('here 10: ', 2);
5086:

Line 5089: OE_BULK_ORDER_PVT.G_LINE_REC.line_id

5085: --oe_debug_pub.add('here 10: ', 2);
5086:
5087: IF l_debug_level > 0 THEN
5088: oe_debug_pub.add('eligible for shipping '||
5089: OE_BULK_ORDER_PVT.G_LINE_REC.line_id
5090: (OE_BULK_WF_UTIL.G_LINE_INDEX), 1 ) ;
5091: END IF;
5092:
5093: END IF; -- if shippable

Line 5994: ,p_header_rec IN OE_BULK_ORDER_PVT.HEADER_REC_TYPE

5990: OM-WSH_HVOP
5991: ------------------------------------------------------------------*/
5992: PROCEDURE OM_To_WSH_Interface
5993: ( p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.LINE_REC_TYPE
5994: ,p_header_rec IN OE_BULK_ORDER_PVT.HEADER_REC_TYPE
5995: ,x_return_status OUT NOCOPY VARCHAR2)
5996: IS
5997: l_action_rec WSH_BULK_TYPES_GRP.action_parameters_rectype;
5998: l_out_rec WSH_BULK_TYPES_GRP.Bulk_process_out_rec_type;