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 3960: ,OE_BULK_ORDER_PVT.G_REQUEST_ID

3956: ,p_line_rec.REFERENCE_HEADER_ID(i)
3957: ,p_line_rec.REFERENCE_LINE_ID(i)
3958: ,p_line_rec.REFERENCE_TYPE(i)
3959: ,p_line_rec.REQUEST_DATE(i)
3960: ,OE_BULK_ORDER_PVT.G_REQUEST_ID
3961: ,p_line_rec.RETURN_ATTRIBUTE1(i)
3962: ,p_line_rec.RETURN_ATTRIBUTE10(i)
3963: ,p_line_rec.RETURN_ATTRIBUTE11(i)
3964: ,p_line_rec.RETURN_ATTRIBUTE12(i)

Line 4771: ,p_header_rec IN OUT NOCOPY OE_BULK_ORDER_PVT.HEADER_REC_TYPE

4767: ,p_ii_start_index IN NUMBER
4768: ,p_parent_index IN NUMBER
4769: ,p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.LINE_REC_TYPE
4770: ,p_header_index IN NUMBER
4771: ,p_header_rec IN OUT NOCOPY OE_BULK_ORDER_PVT.HEADER_REC_TYPE
4772: ,x_ii_on_generic_hold OUT NOCOPY BOOLEAN
4773: )
4774: IS
4775: l_process_name VARCHAR2(30);

Line 4942: AND OE_BULK_ORDER_PVT.G_SCHEDULE_LINE_ON_HOLD = 'N'

4938: -- If line is to be scheduled AND lines on hold should NOT be
4939: -- scheduled, populate error message and clear scheduling
4940: -- fields on this included item.
4941: IF p_line_rec.schedule_status_code(l_index) IS NOT NULL
4942: AND OE_BULK_ORDER_PVT.G_SCHEDULE_LINE_ON_HOLD = 'N'
4943: THEN
4944: -- Add scheduling on hold message
4945: FND_MESSAGE.SET_NAME('ONT','OE_SCH_LINE_ON_HOLD');
4946: OE_BULK_MSG_PUB.Add;

Line 4962: AND OE_BULK_ORDER_PVT.G_SCHEDULE_LINE_ON_HOLD = 'N'

4958:
4959: IF p_line_rec.schedule_status_code(p_parent_index) IS NOT NULL THEN
4960:
4961: IF x_ii_on_generic_hold
4962: AND OE_BULK_ORDER_PVT.G_SCHEDULE_LINE_ON_HOLD = 'N'
4963: THEN
4964:
4965: -- Decrement the kit item from scheduling count
4966: -- For SMC and non-SMC, kit should not be scheduled if

Line 4968: OE_BULK_ORDER_PVT.G_SCH_COUNT :=

4964:
4965: -- Decrement the kit item from scheduling count
4966: -- For SMC and non-SMC, kit should not be scheduled if
4967: -- any included item is on generic hold
4968: OE_BULK_ORDER_PVT.G_SCH_COUNT :=
4969: OE_BULK_ORDER_PVT.G_SCH_COUNT - 1;
4970:
4971: -- If Non-SMC, increment the scheduling count by lines
4972: -- that need to be scheduled.

Line 4969: OE_BULK_ORDER_PVT.G_SCH_COUNT - 1;

4965: -- Decrement the kit item from scheduling count
4966: -- For SMC and non-SMC, kit should not be scheduled if
4967: -- any included item is on generic hold
4968: OE_BULK_ORDER_PVT.G_SCH_COUNT :=
4969: OE_BULK_ORDER_PVT.G_SCH_COUNT - 1;
4970:
4971: -- If Non-SMC, increment the scheduling count by lines
4972: -- that need to be scheduled.
4973: IF p_line_rec.ship_model_complete_flag(p_parent_index) = 'N' THEN

Line 4975: OE_BULK_ORDER_PVT.G_SCH_COUNT :=

4971: -- If Non-SMC, increment the scheduling count by lines
4972: -- that need to be scheduled.
4973: IF p_line_rec.ship_model_complete_flag(p_parent_index) = 'N' THEN
4974:
4975: OE_BULK_ORDER_PVT.G_SCH_COUNT :=
4976: OE_BULK_ORDER_PVT.G_SCH_COUNT + (p_ii_count - l_ii_on_hold_count);
4977: -- Mark parent line status as ON HOLD so that scheduling ignores
4978: -- the parent line BUT still schedules the included items that
4979: -- are not on hold. If the status is nulled out, none of the

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

4972: -- that need to be scheduled.
4973: IF p_line_rec.ship_model_complete_flag(p_parent_index) = 'N' THEN
4974:
4975: OE_BULK_ORDER_PVT.G_SCH_COUNT :=
4976: OE_BULK_ORDER_PVT.G_SCH_COUNT + (p_ii_count - l_ii_on_hold_count);
4977: -- Mark parent line status as ON HOLD so that scheduling ignores
4978: -- the parent line BUT still schedules the included items that
4979: -- are not on hold. If the status is nulled out, none of the
4980: -- included items will be scheduled !

Line 5003: OE_BULK_ORDER_PVT.G_SCH_COUNT :=

4999:
5000: -- NO Holds, increment the scheduling count by number of
5001: -- included items
5002: ELSE
5003: OE_BULK_ORDER_PVT.G_SCH_COUNT :=
5004: OE_BULK_ORDER_PVT.G_SCH_COUNT + p_ii_count;
5005: END IF;
5006:
5007: END IF;

Line 5004: OE_BULK_ORDER_PVT.G_SCH_COUNT + p_ii_count;

5000: -- NO Holds, increment the scheduling count by number of
5001: -- included items
5002: ELSE
5003: OE_BULK_ORDER_PVT.G_SCH_COUNT :=
5004: OE_BULK_ORDER_PVT.G_SCH_COUNT + p_ii_count;
5005: END IF;
5006:
5007: END IF;
5008:

Line 5030: (p_line_scredit_rec IN OE_BULK_ORDER_PVT.SCREDIT_REC_TYPE

5026: -- p_line_scredit_rec
5027: ---------------------------------------------------------------------
5028:
5029: PROCEDURE Create_Line_Scredits
5030: (p_line_scredit_rec IN OE_BULK_ORDER_PVT.SCREDIT_REC_TYPE
5031: )
5032: IS
5033: --
5034: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 5113: ,p_header_rec IN OUT NOCOPY OE_BULK_ORDER_PVT.HEADER_REC_TYPE

5109: PROCEDURE Append_Included_Items
5110: (p_parent_index IN NUMBER
5111: ,p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.LINE_REC_TYPE
5112: ,p_header_index IN NUMBER
5113: ,p_header_rec IN OUT NOCOPY OE_BULK_ORDER_PVT.HEADER_REC_TYPE
5114: ,x_ii_count OUT NOCOPY NUMBER
5115: ,x_ii_start_index OUT NOCOPY NUMBER
5116: ,x_ii_on_generic_hold OUT NOCOPY BOOLEAN
5117: )

Line 5140: AND bom.organization_id = OE_BULK_ORDER_PVT.G_ITEM_ORG

5136: , BOM_EXPLOSIONS be
5137: , MTL_SYSTEM_ITEMS_KFV i -- item in item validation org
5138: , MTL_SYSTEM_ITEMS wi -- item in ship from org
5139: WHERE bom.assembly_item_id = l_kit_item_id
5140: AND bom.organization_id = OE_BULK_ORDER_PVT.G_ITEM_ORG
5141: AND be.top_bill_sequence_id = bom.bill_sequence_id
5142: AND be.explosion_type = 'INCLUDED'
5143: AND be.plan_level >= 0
5144: AND be.effectivity_date <= sysdate

Line 5148: AND i.organization_id = OE_BULK_ORDER_PVT.G_ITEM_ORG

5144: AND be.effectivity_date <= sysdate
5145: AND be.disable_date > sysdate
5146: AND be.component_item_id <> be.top_item_id
5147: AND i.inventory_item_id = be.component_item_id
5148: AND i.organization_id = OE_BULK_ORDER_PVT.G_ITEM_ORG
5149: AND wi.inventory_item_id = be.component_item_id
5150: AND wi.organization_id = nvl(l_ship_from_org_id,OE_BULK_ORDER_PVT.G_ITEM_ORG)
5151: ORDER BY be.sort_order;
5152: --

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

5146: AND be.component_item_id <> be.top_item_id
5147: AND i.inventory_item_id = be.component_item_id
5148: AND i.organization_id = OE_BULK_ORDER_PVT.G_ITEM_ORG
5149: AND wi.inventory_item_id = be.component_item_id
5150: AND wi.organization_id = nvl(l_ship_from_org_id,OE_BULK_ORDER_PVT.G_ITEM_ORG)
5151: ORDER BY be.sort_order;
5152: --
5153: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5154: --

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

5158: -- Check if this kit line should be exploded/frozen
5159: ------------------------------------------------------------------
5160:
5161: -- 1. If freeze method is 'Entry', explode and freeze included items
5162: IF OE_BULK_ORDER_PVT.G_IIFM = 'ENTRY' THEN
5163: l_freeze := TRUE;
5164:
5165: -- 2. If freeze method is 'Booked', freeze if parent line is booked.
5166: -- If not booked, explode if parent line is to be scheduled

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

5164:
5165: -- 2. If freeze method is 'Booked', freeze if parent line is booked.
5166: -- If not booked, explode if parent line is to be scheduled
5167: -- but do not freeze.
5168: ELSIF OE_BULK_ORDER_PVT.G_IIFM = 'BOOKING' THEN
5169: IF p_line_rec.booked_flag(p_parent_index) = 'Y' THEN
5170: l_freeze := TRUE;
5171: ELSIF p_line_rec.schedule_status_code(p_parent_index) IS NULL THEN
5172: RETURN;

Line 5191: (p_validation_org => OE_BULK_ORDER_PVT.G_ITEM_ORG,

5187:
5188: IF NOT G_KIT_ITEM_TBL.EXISTS(l_kit_item_id) THEN
5189:
5190: OE_Config_UTIL.Explode
5191: (p_validation_org => OE_BULK_ORDER_PVT.G_ITEM_ORG,
5192: p_levels => 6, --??
5193: p_stdcompflag => 'INCLUDED',
5194: p_top_item_id => l_kit_item_id,
5195: p_revdate => sysdate,