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.ENG_ECO_PVT dependencies on ENG_DEFAULT_REVISED_ITEM

Line 198: = nvl(ENG_Default_Revised_Item.G_OLD_SCHED_DATE,p_effectivity_date) -- Bug 6657209

194: = NVL(p_routing_revision,FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
195: NVL(l_rev_sub_resource_rec.from_end_item_unit_number,FND_API.G_MISS_CHAR )
196: = NVL(p_from_end_item_number,FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
197: l_rev_sub_resource_rec.op_start_effective_date
198: = nvl(ENG_Default_Revised_Item.G_OLD_SCHED_DATE,p_effectivity_date) -- Bug 6657209
199: -- NVL(l_rev_sub_resource_rec.operation_type, 1)
200: -- = NVL(p_operation_type, 1)
201:
202: )

Line 234: IF (l_op_parent_exists and ENG_Default_Revised_Item.G_OLD_SCHED_DATE is not null) THEN

230: l_return_status := FND_API.G_RET_STS_SUCCESS;
231: l_rev_sub_resource_rec.return_status := FND_API.G_RET_STS_SUCCESS;
232:
233: -- Bug 6657209
234: IF (l_op_parent_exists and ENG_Default_Revised_Item.G_OLD_SCHED_DATE is not null) THEN
235: l_rev_sub_resource_rec.op_start_effective_date := p_effectivity_date;
236: END IF;
237: --
238: -- Process Flow step 3 : Check if transaction_type is valid

Line 1578: = nvl(ENG_Default_Revised_Item.G_OLD_SCHED_DATE,p_effectivity_date) AND -- Bug 6657209

1574: = p_change_notice AND
1575: l_rev_op_res_unexp_rec.organization_id
1576: = p_organization_id AND
1577: l_rev_op_resource_rec.op_start_effective_date
1578: = nvl(ENG_Default_Revised_Item.G_OLD_SCHED_DATE,p_effectivity_date) AND -- Bug 6657209
1579: NVL(l_rev_op_resource_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )
1580: = NVL(p_item_revision, FND_API.G_MISS_CHAR ) AND
1581: l_rev_op_resource_rec.revised_item_name
1582: = p_revised_item_name AND

Line 1629: IF (l_op_parent_exists and ENG_Default_Revised_Item.G_OLD_SCHED_DATE is not null) THEN

1625: l_return_status := FND_API.G_RET_STS_SUCCESS;
1626: l_rev_op_resource_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1627:
1628: -- Bug 6657209
1629: IF (l_op_parent_exists and ENG_Default_Revised_Item.G_OLD_SCHED_DATE is not null) THEN
1630: l_rev_op_resource_rec.op_start_effective_date := p_effectivity_date;
1631: END IF;
1632:
1633: --

Line 2929: l_rev_operation_rec.start_effective_date = nvl(ENG_Default_Revised_Item.G_OLD_SCHED_DATE,p_effectivity_date) AND -- Bug 6657209

2925: l_rev_op_unexp_rec.organization_id = p_organization_id AND
2926: l_rev_operation_rec.revised_item_name = p_revised_item_name AND
2927: NVL(l_rev_operation_rec.alternate_routing_code, FND_API.G_MISS_CHAR )
2928: = NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR ) AND -- Added for bug 13440461
2929: l_rev_operation_rec.start_effective_date = nvl(ENG_Default_Revised_Item.G_OLD_SCHED_DATE,p_effectivity_date) AND -- Bug 6657209
2930: NVL(l_rev_operation_rec.new_routing_revision, FND_API.G_MISS_CHAR )
2931: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
2932: NVL(l_rev_operation_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
2933: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00

Line 2943: IF (l_item_parent_exists and ENG_Default_Revised_Item.G_OLD_SCHED_DATE is not null) THEN

2939: l_return_status := FND_API.G_RET_STS_SUCCESS;
2940: l_rev_operation_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2941:
2942: -- Bug 6657209
2943: IF (l_item_parent_exists and ENG_Default_Revised_Item.G_OLD_SCHED_DATE is not null) THEN
2944: l_rev_operation_rec.start_effective_date := p_effectivity_date;
2945: END IF;
2946:
2947: --

Line 4576: l_sub_component_rec.start_effective_date = nvl(ENG_Default_Revised_Item.G_OLD_SCHED_DATE,p_effectivity_date) AND -- Bug 6657209

4572:
4573: ((l_comp_parent_exists AND
4574: (l_sub_component_rec.ECO_Name = p_change_notice AND
4575: l_sub_comp_unexp_rec.organization_id = p_organization_id AND
4576: l_sub_component_rec.start_effective_date = nvl(ENG_Default_Revised_Item.G_OLD_SCHED_DATE,p_effectivity_date) AND -- Bug 6657209
4577: NVL(l_sub_component_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )
4578: = NVL(p_item_revision, FND_API.G_MISS_CHAR ) AND
4579: l_sub_component_rec.revised_item_name = p_revised_item_name AND
4580: NVL(l_sub_component_rec.alternate_bom_code,'NULL') = NVL(p_alternate_bom_code,'NULL') AND -- Bug 3991176

Line 4619: IF (l_comp_parent_exists and ENG_Default_Revised_Item.G_OLD_SCHED_DATE is not null) THEN

4615:
4616: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Processing substitite component: ' || l_sub_component_rec.substitute_component_name); END IF;
4617:
4618: -- Bug 6657209
4619: IF (l_comp_parent_exists and ENG_Default_Revised_Item.G_OLD_SCHED_DATE is not null) THEN
4620: l_sub_component_rec.start_effective_date := p_effectivity_date;
4621: END IF;
4622:
4623: -- Check if transaction_type is valid

Line 5499: l_ref_designator_rec.start_effective_date = nvl(ENG_Default_Revised_Item.G_OLD_SCHED_DATE,p_effectivity_date) AND -- bug 6657209

5495:
5496: ((l_comp_parent_exists AND
5497: (l_ref_designator_rec.ECO_Name = p_change_notice AND
5498: l_ref_desg_unexp_rec.organization_id = p_organization_id AND
5499: l_ref_designator_rec.start_effective_date = nvl(ENG_Default_Revised_Item.G_OLD_SCHED_DATE,p_effectivity_date) AND -- bug 6657209
5500: NVL(l_ref_designator_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )
5501: = NVL(p_item_revision, FND_API.G_MISS_CHAR ) AND
5502: NVL(l_ref_designator_rec.new_routing_revision, FND_API.G_MISS_CHAR )
5503: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00

Line 5540: IF (l_comp_parent_exists and ENG_Default_Revised_Item.G_OLD_SCHED_DATE is not null) THEN

5536:
5537: l_ref_designator_rec.return_status := FND_API.G_RET_STS_SUCCESS;
5538:
5539: -- Bug 6657209
5540: IF (l_comp_parent_exists and ENG_Default_Revised_Item.G_OLD_SCHED_DATE is not null) THEN
5541: l_ref_designator_rec.start_effective_date := p_effectivity_date;
5542: END IF;
5543:
5544: -- Check if transaction_type is valid

Line 6330: l_rev_component_rec.start_effective_date = nvl(ENG_Default_Revised_Item.G_OLD_SCHED_DATE,p_effectivity_date) AND -- Bug 6657209

6326: l_rev_comp_unexp_rec.organization_id = p_organization_id AND
6327: l_rev_component_rec.revised_item_name = p_revised_item_name AND
6328: NVL(l_rev_component_rec.alternate_bom_code,'NULL') = NVL(p_alternate_bom_code,'NULL') AND
6329: -- Bug 2429272 Change 4
6330: l_rev_component_rec.start_effective_date = nvl(ENG_Default_Revised_Item.G_OLD_SCHED_DATE,p_effectivity_date) AND -- Bug 6657209
6331: NVL(l_rev_component_rec.new_routing_revision, FND_API.G_MISS_CHAR )
6332: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
6333: NVL(l_rev_component_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
6334: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00

Line 6348: IF (l_item_parent_exists and ENG_Default_Revised_Item.G_OLD_SCHED_DATE is not null ) THEN

6344: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Processing component: ' || l_rev_component_rec.component_item_name); END IF;
6345: -- Check if transaction_type is valid
6346: --
6347: -- Bug 6657209
6348: IF (l_item_parent_exists and ENG_Default_Revised_Item.G_OLD_SCHED_DATE is not null ) THEN
6349: l_rev_component_rec.start_effective_date := p_effectivity_date;
6350: END IF;
6351:
6352: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Check transaction_type validity'); END IF;

Line 7681: l_rev_component_rec.start_effective_date = nvl(ENG_Default_Revised_Item.G_OLD_SCHED_DATE,p_effectivity_date) AND -- Bug 6657209

7677: l_rev_comp_unexp_rec.organization_id = p_organization_id AND
7678: l_rev_component_rec.revised_item_name = p_revised_item_name AND
7679: NVL(l_rev_component_rec.alternate_bom_code,'NULL') = NVL(p_alternate_bom_code,'NULL') AND
7680: -- Bug 2429272 Change 4
7681: l_rev_component_rec.start_effective_date = nvl(ENG_Default_Revised_Item.G_OLD_SCHED_DATE,p_effectivity_date) AND -- Bug 6657209
7682: NVL(l_rev_component_rec.new_routing_revision, FND_API.G_MISS_CHAR )
7683: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
7684: NVL(l_rev_component_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
7685: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00

Line 7699: IF (l_item_parent_exists and ENG_Default_Revised_Item.G_OLD_SCHED_DATE is not null ) THEN

7695: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Processing component: ' || l_rev_component_rec.component_item_name); END IF;
7696: -- Check if transaction_type is valid
7697: --
7698: -- Bug 6657209
7699: IF (l_item_parent_exists and ENG_Default_Revised_Item.G_OLD_SCHED_DATE is not null ) THEN
7700: l_rev_component_rec.start_effective_date := p_effectivity_date;
7701: END IF;
7702:
7703: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Check transaction_type validity'); END IF;

Line 9412: Eng_Default_Revised_Item.Populate_NULL_Columns

9408: -- Process flow step 11 - Populate NULL columns for Update and
9409: -- Delete.
9410:
9411: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Populating NULL Columns'); END IF;
9412: Eng_Default_Revised_Item.Populate_NULL_Columns
9413: ( p_revised_item_rec => l_revised_item_rec
9414: , p_old_revised_item_rec => l_old_revised_item_rec
9415: , p_rev_item_unexp_rec => l_rev_item_unexp_rec
9416: , p_old_rev_item_unexp_rec => l_old_rev_item_unexp_rec

Line 9427: Eng_Default_Revised_Item.Attribute_Defaulting

9423: -- Process Flow step 12: Default missing values for Operation CREATE
9424: --
9425:
9426: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Attribute Defaulting'); END IF;
9427: Eng_Default_Revised_Item.Attribute_Defaulting
9428: ( p_revised_item_rec => l_revised_item_rec
9429: , p_rev_item_unexp_rec => l_rev_item_unexp_rec
9430: , x_revised_item_rec => l_revised_item_rec
9431: , x_rev_item_unexp_rec => l_rev_item_unexp_rec

Line 9546: ENG_Default_Revised_Item.Entity_Defaulting

9542: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Entity defaulting'); END IF;
9543: IF l_revised_item_rec.Transaction_Type IN
9544: (ENG_GLOBALS.G_OPR_CREATE, ENG_GLOBALS.G_OPR_UPDATE)
9545: THEN
9546: ENG_Default_Revised_Item.Entity_Defaulting
9547: ( p_revised_item_rec => l_revised_item_rec
9548: , p_rev_item_unexp_rec => l_rev_item_unexp_rec
9549: , p_old_revised_item_rec => l_old_revised_item_rec
9550: , p_old_rev_item_unexp_rec => l_old_rev_item_unexp_rec

Line 10943: Eng_Default_Revised_Item.Populate_NULL_Columns

10939: -- Process flow step 11 - Populate NULL columns for Update and
10940: -- Delete.
10941:
10942: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Populating NULL Columns'); END IF;
10943: Eng_Default_Revised_Item.Populate_NULL_Columns
10944: ( p_revised_item_rec => l_revised_item_rec
10945: , p_old_revised_item_rec => l_old_revised_item_rec
10946: , p_rev_item_unexp_rec => l_rev_item_unexp_rec
10947: , p_old_rev_item_unexp_rec => l_old_rev_item_unexp_rec

Line 10958: Eng_Default_Revised_Item.Attribute_Defaulting

10954: -- Process Flow step 12: Default missing values for Operation CREATE
10955: --
10956:
10957: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Attribute Defaulting'); END IF;
10958: Eng_Default_Revised_Item.Attribute_Defaulting
10959: ( p_revised_item_rec => l_revised_item_rec
10960: , p_rev_item_unexp_rec => l_rev_item_unexp_rec
10961: , x_revised_item_rec => l_revised_item_rec
10962: , x_rev_item_unexp_rec => l_rev_item_unexp_rec

Line 11077: ENG_Default_Revised_Item.Entity_Defaulting

11073: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Entity defaulting'); END IF;
11074: IF l_revised_item_rec.Transaction_Type IN
11075: (ENG_GLOBALS.G_OPR_CREATE, ENG_GLOBALS.G_OPR_UPDATE)
11076: THEN
11077: ENG_Default_Revised_Item.Entity_Defaulting
11078: ( p_revised_item_rec => l_revised_item_rec
11079: , p_rev_item_unexp_rec => l_rev_item_unexp_rec
11080: , p_old_revised_item_rec => l_old_revised_item_rec
11081: , p_old_rev_item_unexp_rec => l_old_rev_item_unexp_rec

Line 15486: Eng_Default_Revised_Item.G_OLD_SCHED_DATE := NULL;

15482: , x_disable_revision => x_disable_revision --Bug no:3034642
15483: );
15484:
15485: -- Bug 6657209. Reset the global variable after Rev_items are processed.
15486: Eng_Default_Revised_Item.G_OLD_SCHED_DATE := NULL;
15487:
15488: IF l_return_status <> 'S'
15489: THEN
15490: l_bo_return_status := l_return_status;

Line 15991: Eng_Default_Revised_Item.G_OLD_SCHED_DATE := NULL;

15987: , x_disable_revision => x_disable_revision --Bug no:3034642
15988: );
15989:
15990: -- Bug 6657209. Reset the global variable after Rev_items are processed.
15991: Eng_Default_Revised_Item.G_OLD_SCHED_DATE := NULL;
15992:
15993: -- Added by AS on 03/22/99 to fix bug 853529
15994:
15995: IF NVL(l_return_status, 'S') = 'Q'