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_BULK_LINE_UTIL dependencies on OE_BULK_ORDER_PVT

Line 3949: ,OE_BULK_ORDER_PVT.G_REQUEST_ID

3945: ,p_line_rec.REFERENCE_HEADER_ID(i)
3946: ,p_line_rec.REFERENCE_LINE_ID(i)
3947: ,p_line_rec.REFERENCE_TYPE(i)
3948: ,p_line_rec.REQUEST_DATE(i)
3949: ,OE_BULK_ORDER_PVT.G_REQUEST_ID
3950: ,p_line_rec.RETURN_ATTRIBUTE1(i)
3951: ,p_line_rec.RETURN_ATTRIBUTE10(i)
3952: ,p_line_rec.RETURN_ATTRIBUTE11(i)
3953: ,p_line_rec.RETURN_ATTRIBUTE12(i)

Line 4759: ,p_header_rec IN OUT NOCOPY OE_BULK_ORDER_PVT.HEADER_REC_TYPE

4755: ,p_ii_start_index IN NUMBER
4756: ,p_parent_index IN NUMBER
4757: ,p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.LINE_REC_TYPE
4758: ,p_header_index IN NUMBER
4759: ,p_header_rec IN OUT NOCOPY OE_BULK_ORDER_PVT.HEADER_REC_TYPE
4760: ,x_ii_on_generic_hold OUT NOCOPY BOOLEAN
4761: )
4762: IS
4763: l_process_name VARCHAR2(30);

Line 4921: AND OE_BULK_ORDER_PVT.G_SCHEDULE_LINE_ON_HOLD = 'N'

4917: -- If line is to be scheduled AND lines on hold should NOT be
4918: -- scheduled, populate error message and clear scheduling
4919: -- fields on this included item.
4920: IF p_line_rec.schedule_status_code(l_index) IS NOT NULL
4921: AND OE_BULK_ORDER_PVT.G_SCHEDULE_LINE_ON_HOLD = 'N'
4922: THEN
4923: -- Add scheduling on hold message
4924: FND_MESSAGE.SET_NAME('ONT','OE_SCH_LINE_ON_HOLD');
4925: OE_BULK_MSG_PUB.Add;

Line 4941: AND OE_BULK_ORDER_PVT.G_SCHEDULE_LINE_ON_HOLD = 'N'

4937:
4938: IF p_line_rec.schedule_status_code(p_parent_index) IS NOT NULL THEN
4939:
4940: IF x_ii_on_generic_hold
4941: AND OE_BULK_ORDER_PVT.G_SCHEDULE_LINE_ON_HOLD = 'N'
4942: THEN
4943:
4944: -- Decrement the kit item from scheduling count
4945: -- For SMC and non-SMC, kit should not be scheduled if

Line 4947: OE_BULK_ORDER_PVT.G_SCH_COUNT :=

4943:
4944: -- Decrement the kit item from scheduling count
4945: -- For SMC and non-SMC, kit should not be scheduled if
4946: -- any included item is on generic hold
4947: OE_BULK_ORDER_PVT.G_SCH_COUNT :=
4948: OE_BULK_ORDER_PVT.G_SCH_COUNT - 1;
4949:
4950: -- If Non-SMC, increment the scheduling count by lines
4951: -- that need to be scheduled.

Line 4948: OE_BULK_ORDER_PVT.G_SCH_COUNT - 1;

4944: -- Decrement the kit item from scheduling count
4945: -- For SMC and non-SMC, kit should not be scheduled if
4946: -- any included item is on generic hold
4947: OE_BULK_ORDER_PVT.G_SCH_COUNT :=
4948: OE_BULK_ORDER_PVT.G_SCH_COUNT - 1;
4949:
4950: -- If Non-SMC, increment the scheduling count by lines
4951: -- that need to be scheduled.
4952: IF p_line_rec.ship_model_complete_flag(p_parent_index) = 'N' THEN

Line 4954: OE_BULK_ORDER_PVT.G_SCH_COUNT :=

4950: -- If Non-SMC, increment the scheduling count by lines
4951: -- that need to be scheduled.
4952: IF p_line_rec.ship_model_complete_flag(p_parent_index) = 'N' THEN
4953:
4954: OE_BULK_ORDER_PVT.G_SCH_COUNT :=
4955: OE_BULK_ORDER_PVT.G_SCH_COUNT + (p_ii_count - l_ii_on_hold_count);
4956: -- Mark parent line status as ON HOLD so that scheduling ignores
4957: -- the parent line BUT still schedules the included items that
4958: -- are not on hold. If the status is nulled out, none of the

Line 4955: OE_BULK_ORDER_PVT.G_SCH_COUNT + (p_ii_count - l_ii_on_hold_count);

4951: -- that need to be scheduled.
4952: IF p_line_rec.ship_model_complete_flag(p_parent_index) = 'N' THEN
4953:
4954: OE_BULK_ORDER_PVT.G_SCH_COUNT :=
4955: OE_BULK_ORDER_PVT.G_SCH_COUNT + (p_ii_count - l_ii_on_hold_count);
4956: -- Mark parent line status as ON HOLD so that scheduling ignores
4957: -- the parent line BUT still schedules the included items that
4958: -- are not on hold. If the status is nulled out, none of the
4959: -- included items will be scheduled !

Line 4982: OE_BULK_ORDER_PVT.G_SCH_COUNT :=

4978:
4979: -- NO Holds, increment the scheduling count by number of
4980: -- included items
4981: ELSE
4982: OE_BULK_ORDER_PVT.G_SCH_COUNT :=
4983: OE_BULK_ORDER_PVT.G_SCH_COUNT + p_ii_count;
4984: END IF;
4985:
4986: END IF;

Line 4983: OE_BULK_ORDER_PVT.G_SCH_COUNT + p_ii_count;

4979: -- NO Holds, increment the scheduling count by number of
4980: -- included items
4981: ELSE
4982: OE_BULK_ORDER_PVT.G_SCH_COUNT :=
4983: OE_BULK_ORDER_PVT.G_SCH_COUNT + p_ii_count;
4984: END IF;
4985:
4986: END IF;
4987:

Line 5009: (p_line_scredit_rec IN OE_BULK_ORDER_PVT.SCREDIT_REC_TYPE

5005: -- p_line_scredit_rec
5006: ---------------------------------------------------------------------
5007:
5008: PROCEDURE Create_Line_Scredits
5009: (p_line_scredit_rec IN OE_BULK_ORDER_PVT.SCREDIT_REC_TYPE
5010: )
5011: IS
5012: --
5013: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 5092: ,p_header_rec IN OUT NOCOPY OE_BULK_ORDER_PVT.HEADER_REC_TYPE

5088: PROCEDURE Append_Included_Items
5089: (p_parent_index IN NUMBER
5090: ,p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.LINE_REC_TYPE
5091: ,p_header_index IN NUMBER
5092: ,p_header_rec IN OUT NOCOPY OE_BULK_ORDER_PVT.HEADER_REC_TYPE
5093: ,x_ii_count OUT NOCOPY NUMBER
5094: ,x_ii_start_index OUT NOCOPY NUMBER
5095: ,x_ii_on_generic_hold OUT NOCOPY BOOLEAN
5096: )

Line 5119: AND bom.organization_id = OE_BULK_ORDER_PVT.G_ITEM_ORG

5115: , BOM_EXPLOSIONS be
5116: , MTL_SYSTEM_ITEMS_KFV i -- item in item validation org
5117: , MTL_SYSTEM_ITEMS wi -- item in ship from org
5118: WHERE bom.assembly_item_id = l_kit_item_id
5119: AND bom.organization_id = OE_BULK_ORDER_PVT.G_ITEM_ORG
5120: AND be.top_bill_sequence_id = bom.bill_sequence_id
5121: AND be.explosion_type = 'INCLUDED'
5122: AND be.plan_level >= 0
5123: AND be.effectivity_date <= sysdate

Line 5127: AND i.organization_id = OE_BULK_ORDER_PVT.G_ITEM_ORG

5123: AND be.effectivity_date <= sysdate
5124: AND be.disable_date > sysdate
5125: AND be.component_item_id <> be.top_item_id
5126: AND i.inventory_item_id = be.component_item_id
5127: AND i.organization_id = OE_BULK_ORDER_PVT.G_ITEM_ORG
5128: AND wi.inventory_item_id = be.component_item_id
5129: AND wi.organization_id = nvl(l_ship_from_org_id,OE_BULK_ORDER_PVT.G_ITEM_ORG)
5130: ORDER BY be.sort_order;
5131: --

Line 5129: AND wi.organization_id = nvl(l_ship_from_org_id,OE_BULK_ORDER_PVT.G_ITEM_ORG)

5125: AND be.component_item_id <> be.top_item_id
5126: AND i.inventory_item_id = be.component_item_id
5127: AND i.organization_id = OE_BULK_ORDER_PVT.G_ITEM_ORG
5128: AND wi.inventory_item_id = be.component_item_id
5129: AND wi.organization_id = nvl(l_ship_from_org_id,OE_BULK_ORDER_PVT.G_ITEM_ORG)
5130: ORDER BY be.sort_order;
5131: --
5132: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5133: --

Line 5141: IF OE_BULK_ORDER_PVT.G_IIFM = 'ENTRY' THEN

5137: -- Check if this kit line should be exploded/frozen
5138: ------------------------------------------------------------------
5139:
5140: -- 1. If freeze method is 'Entry', explode and freeze included items
5141: IF OE_BULK_ORDER_PVT.G_IIFM = 'ENTRY' THEN
5142: l_freeze := TRUE;
5143:
5144: -- 2. If freeze method is 'Booked', freeze if parent line is booked.
5145: -- If not booked, explode if parent line is to be scheduled

Line 5147: ELSIF OE_BULK_ORDER_PVT.G_IIFM = 'BOOKING' THEN

5143:
5144: -- 2. If freeze method is 'Booked', freeze if parent line is booked.
5145: -- If not booked, explode if parent line is to be scheduled
5146: -- but do not freeze.
5147: ELSIF OE_BULK_ORDER_PVT.G_IIFM = 'BOOKING' THEN
5148: IF p_line_rec.booked_flag(p_parent_index) = 'Y' THEN
5149: l_freeze := TRUE;
5150: ELSIF p_line_rec.schedule_status_code(p_parent_index) IS NULL THEN
5151: RETURN;

Line 5170: (p_validation_org => OE_BULK_ORDER_PVT.G_ITEM_ORG,

5166:
5167: IF NOT G_KIT_ITEM_TBL.EXISTS(l_kit_item_id) THEN
5168:
5169: OE_Config_UTIL.Explode
5170: (p_validation_org => OE_BULK_ORDER_PVT.G_ITEM_ORG,
5171: p_levels => 6, --??
5172: p_stdcompflag => 'INCLUDED',
5173: p_top_item_id => l_kit_item_id,
5174: p_revdate => sysdate,