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 195: = nvl(ENG_Default_Revised_Item.G_OLD_SCHED_DATE,p_effectivity_date) -- Bug 6657209

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

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

225: l_return_status := FND_API.G_RET_STS_SUCCESS;
226: l_rev_sub_resource_rec.return_status := FND_API.G_RET_STS_SUCCESS;
227:
228: -- Bug 6657209
229: IF (l_op_parent_exists and ENG_Default_Revised_Item.G_OLD_SCHED_DATE is not null) THEN
230: l_rev_sub_resource_rec.op_start_effective_date := p_effectivity_date;
231: END IF;
232: --
233: -- Process Flow step 3 : Check if transaction_type is valid

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

1567: = p_change_notice AND
1568: l_rev_op_res_unexp_rec.organization_id
1569: = p_organization_id AND
1570: l_rev_op_resource_rec.op_start_effective_date
1571: = nvl(ENG_Default_Revised_Item.G_OLD_SCHED_DATE,p_effectivity_date) AND -- Bug 6657209
1572: NVL(l_rev_op_resource_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )
1573: = NVL(p_item_revision, FND_API.G_MISS_CHAR ) AND
1574: l_rev_op_resource_rec.revised_item_name
1575: = p_revised_item_name AND

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

1614: l_return_status := FND_API.G_RET_STS_SUCCESS;
1615: l_rev_op_resource_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1616:
1617: -- Bug 6657209
1618: IF (l_op_parent_exists and ENG_Default_Revised_Item.G_OLD_SCHED_DATE is not null) THEN
1619: l_rev_op_resource_rec.op_start_effective_date := p_effectivity_date;
1620: END IF;
1621:
1622: --

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

2909: (l_item_parent_exists AND
2910: (l_rev_operation_rec.ECO_Name = p_change_notice AND
2911: l_rev_op_unexp_rec.organization_id = p_organization_id AND
2912: l_rev_operation_rec.revised_item_name = p_revised_item_name AND
2913: l_rev_operation_rec.start_effective_date = nvl(ENG_Default_Revised_Item.G_OLD_SCHED_DATE,p_effectivity_date) AND -- Bug 6657209
2914: NVL(l_rev_operation_rec.new_routing_revision, FND_API.G_MISS_CHAR )
2915: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
2916: NVL(l_rev_operation_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
2917: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00

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

2923: l_return_status := FND_API.G_RET_STS_SUCCESS;
2924: l_rev_operation_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2925:
2926: -- Bug 6657209
2927: IF (l_item_parent_exists and ENG_Default_Revised_Item.G_OLD_SCHED_DATE is not null) THEN
2928: l_rev_operation_rec.start_effective_date := p_effectivity_date;
2929: END IF;
2930:
2931: --

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

4529:
4530: ((l_comp_parent_exists AND
4531: (l_sub_component_rec.ECO_Name = p_change_notice AND
4532: l_sub_comp_unexp_rec.organization_id = p_organization_id AND
4533: l_sub_component_rec.start_effective_date = nvl(ENG_Default_Revised_Item.G_OLD_SCHED_DATE,p_effectivity_date) AND -- Bug 6657209
4534: NVL(l_sub_component_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )
4535: = NVL(p_item_revision, FND_API.G_MISS_CHAR ) AND
4536: l_sub_component_rec.revised_item_name = p_revised_item_name AND
4537: NVL(l_sub_component_rec.alternate_bom_code,'NULL') = NVL(p_alternate_bom_code,'NULL') AND -- Bug 3991176

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

4572:
4573: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Processing substitite component: ' || l_sub_component_rec.substitute_component_name); END IF;
4574:
4575: -- Bug 6657209
4576: IF (l_comp_parent_exists and ENG_Default_Revised_Item.G_OLD_SCHED_DATE is not null) THEN
4577: l_sub_component_rec.start_effective_date := p_effectivity_date;
4578: END IF;
4579:
4580: -- Check if transaction_type is valid

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

5452:
5453: ((l_comp_parent_exists AND
5454: (l_ref_designator_rec.ECO_Name = p_change_notice AND
5455: l_ref_desg_unexp_rec.organization_id = p_organization_id AND
5456: l_ref_designator_rec.start_effective_date = nvl(ENG_Default_Revised_Item.G_OLD_SCHED_DATE,p_effectivity_date) AND -- bug 6657209
5457: NVL(l_ref_designator_rec.new_revised_item_revision, FND_API.G_MISS_CHAR )
5458: = NVL(p_item_revision, FND_API.G_MISS_CHAR ) AND
5459: NVL(l_ref_designator_rec.new_routing_revision, FND_API.G_MISS_CHAR )
5460: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00

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

5493:
5494: l_ref_designator_rec.return_status := FND_API.G_RET_STS_SUCCESS;
5495:
5496: -- Bug 6657209
5497: IF (l_comp_parent_exists and ENG_Default_Revised_Item.G_OLD_SCHED_DATE is not null) THEN
5498: l_ref_designator_rec.start_effective_date := p_effectivity_date;
5499: END IF;
5500:
5501: -- Check if transaction_type is valid

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

6283: l_rev_comp_unexp_rec.organization_id = p_organization_id AND
6284: l_rev_component_rec.revised_item_name = p_revised_item_name AND
6285: NVL(l_rev_component_rec.alternate_bom_code,'NULL') = NVL(p_alternate_bom_code,'NULL') AND
6286: -- Bug 2429272 Change 4
6287: l_rev_component_rec.start_effective_date = nvl(ENG_Default_Revised_Item.G_OLD_SCHED_DATE,p_effectivity_date) AND -- Bug 6657209
6288: NVL(l_rev_component_rec.new_routing_revision, FND_API.G_MISS_CHAR )
6289: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
6290: NVL(l_rev_component_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
6291: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00

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

6301: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Processing component: ' || l_rev_component_rec.component_item_name); END IF;
6302: -- Check if transaction_type is valid
6303: --
6304: -- Bug 6657209
6305: IF (l_item_parent_exists and ENG_Default_Revised_Item.G_OLD_SCHED_DATE is not null ) THEN
6306: l_rev_component_rec.start_effective_date := p_effectivity_date;
6307: END IF;
6308:
6309: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Check transaction_type validity'); END IF;

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

7633: l_rev_comp_unexp_rec.organization_id = p_organization_id AND
7634: l_rev_component_rec.revised_item_name = p_revised_item_name AND
7635: NVL(l_rev_component_rec.alternate_bom_code,'NULL') = NVL(p_alternate_bom_code,'NULL') AND
7636: -- Bug 2429272 Change 4
7637: l_rev_component_rec.start_effective_date = nvl(ENG_Default_Revised_Item.G_OLD_SCHED_DATE,p_effectivity_date) AND -- Bug 6657209
7638: NVL(l_rev_component_rec.new_routing_revision, FND_API.G_MISS_CHAR )
7639: = NVL(p_routing_revision, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00
7640: NVL(l_rev_component_rec.from_end_item_unit_number, FND_API.G_MISS_CHAR )
7641: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR ) AND -- Added by MK on 11/02/00

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

7651: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Processing component: ' || l_rev_component_rec.component_item_name); END IF;
7652: -- Check if transaction_type is valid
7653: --
7654: -- Bug 6657209
7655: IF (l_item_parent_exists and ENG_Default_Revised_Item.G_OLD_SCHED_DATE is not null ) THEN
7656: l_rev_component_rec.start_effective_date := p_effectivity_date;
7657: END IF;
7658:
7659: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Check transaction_type validity'); END IF;

Line 9367: Eng_Default_Revised_Item.Populate_NULL_Columns

9363: -- Process flow step 11 - Populate NULL columns for Update and
9364: -- Delete.
9365:
9366: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Populating NULL Columns'); END IF;
9367: Eng_Default_Revised_Item.Populate_NULL_Columns
9368: ( p_revised_item_rec => l_revised_item_rec
9369: , p_old_revised_item_rec => l_old_revised_item_rec
9370: , p_rev_item_unexp_rec => l_rev_item_unexp_rec
9371: , p_old_rev_item_unexp_rec => l_old_rev_item_unexp_rec

Line 9382: Eng_Default_Revised_Item.Attribute_Defaulting

9378: -- Process Flow step 12: Default missing values for Operation CREATE
9379: --
9380:
9381: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Attribute Defaulting'); END IF;
9382: Eng_Default_Revised_Item.Attribute_Defaulting
9383: ( p_revised_item_rec => l_revised_item_rec
9384: , p_rev_item_unexp_rec => l_rev_item_unexp_rec
9385: , x_revised_item_rec => l_revised_item_rec
9386: , x_rev_item_unexp_rec => l_rev_item_unexp_rec

Line 9501: ENG_Default_Revised_Item.Entity_Defaulting

9497: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Entity defaulting'); END IF;
9498: IF l_revised_item_rec.Transaction_Type IN
9499: (ENG_GLOBALS.G_OPR_CREATE, ENG_GLOBALS.G_OPR_UPDATE)
9500: THEN
9501: ENG_Default_Revised_Item.Entity_Defaulting
9502: ( p_revised_item_rec => l_revised_item_rec
9503: , p_rev_item_unexp_rec => l_rev_item_unexp_rec
9504: , p_old_revised_item_rec => l_old_revised_item_rec
9505: , p_old_rev_item_unexp_rec => l_old_rev_item_unexp_rec

Line 10893: Eng_Default_Revised_Item.Populate_NULL_Columns

10889: -- Process flow step 11 - Populate NULL columns for Update and
10890: -- Delete.
10891:
10892: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Populating NULL Columns'); END IF;
10893: Eng_Default_Revised_Item.Populate_NULL_Columns
10894: ( p_revised_item_rec => l_revised_item_rec
10895: , p_old_revised_item_rec => l_old_revised_item_rec
10896: , p_rev_item_unexp_rec => l_rev_item_unexp_rec
10897: , p_old_rev_item_unexp_rec => l_old_rev_item_unexp_rec

Line 10908: Eng_Default_Revised_Item.Attribute_Defaulting

10904: -- Process Flow step 12: Default missing values for Operation CREATE
10905: --
10906:
10907: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Attribute Defaulting'); END IF;
10908: Eng_Default_Revised_Item.Attribute_Defaulting
10909: ( p_revised_item_rec => l_revised_item_rec
10910: , p_rev_item_unexp_rec => l_rev_item_unexp_rec
10911: , x_revised_item_rec => l_revised_item_rec
10912: , x_rev_item_unexp_rec => l_rev_item_unexp_rec

Line 11027: ENG_Default_Revised_Item.Entity_Defaulting

11023: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Entity defaulting'); END IF;
11024: IF l_revised_item_rec.Transaction_Type IN
11025: (ENG_GLOBALS.G_OPR_CREATE, ENG_GLOBALS.G_OPR_UPDATE)
11026: THEN
11027: ENG_Default_Revised_Item.Entity_Defaulting
11028: ( p_revised_item_rec => l_revised_item_rec
11029: , p_rev_item_unexp_rec => l_rev_item_unexp_rec
11030: , p_old_revised_item_rec => l_old_revised_item_rec
11031: , p_old_rev_item_unexp_rec => l_old_rev_item_unexp_rec

Line 15409: Eng_Default_Revised_Item.G_OLD_SCHED_DATE := NULL;

15405: , x_disable_revision => x_disable_revision --Bug no:3034642
15406: );
15407:
15408: -- Bug 6657209. Reset the global variable after Rev_items are processed.
15409: Eng_Default_Revised_Item.G_OLD_SCHED_DATE := NULL;
15410:
15411: IF l_return_status <> 'S'
15412: THEN
15413: l_bo_return_status := l_return_status;

Line 15912: Eng_Default_Revised_Item.G_OLD_SCHED_DATE := NULL;

15908: , x_disable_revision => x_disable_revision --Bug no:3034642
15909: );
15910:
15911: -- Bug 6657209. Reset the global variable after Rev_items are processed.
15912: Eng_Default_Revised_Item.G_OLD_SCHED_DATE := NULL;
15913:
15914: -- Added by AS on 03/22/99 to fix bug 853529
15915:
15916: IF NVL(l_return_status, 'S') = 'Q'