APPS.BOM_VALIDATE_BOM_COMPONENT dependencies on DUAL

Line 215: SELECT 'Y' INTO l_return_status FROM DUAL

211: AND TEMPLATES.CLASSIFICATION1 = l_parent_item_type;
212: --dbms_output.put_line('l_customization_code '||l_customization_code);
213: BEGIN
214:
215: SELECT 'Y' INTO l_return_status FROM DUAL
216: WHERE l_child_item_type IN
217: (
218: SELECT VALUE_VARCHAR2 FROM EGO_CRITERIA_V
219: WHERE

Line 748: SELECT 'X' date_available FROM sys.dual

744: RETURN BOOLEAN
745: IS
746: X_Count NUMBER := 0;
747: CURSOR X_All_Dates IS
748: SELECT 'X' date_available FROM sys.dual
749: WHERE EXISTS (
750: SELECT 1 from BOM_Inventory_Components
751: WHERE Component_Item_Id = X_Member_Item_Id
752: AND Bill_Sequence_Id = X_Bill_Sequence_Id

Line 809: SELECT 'X' unit_available FROM sys.dual

805: RETURN BOOLEAN
806: IS
807: X_Count NUMBER := 0;
808: CURSOR X_All_Numbers IS
809: SELECT 'X' unit_available FROM sys.dual
810: WHERE EXISTS (
811: SELECT 1 from BOM_Inventory_Components
812: WHERE Component_Item_Id = X_Member_Item_Id
813: AND Bill_Sequence_Id = X_Bill_Sequence_Id

Line 1733: FROM sys.dual

1729: FUNCTION Check_Locators RETURN BOOLEAN
1730: IS
1731: Cursor CheckDuplicate is
1732: SELECT 'checking for duplicates' dummy
1733: FROM sys.dual
1734: WHERE EXISTS (
1735: SELECT null
1736: FROM mtl_item_locations
1737: WHERE organization_id =

Line 2656: FROM SYS.DUAL

2652: , p_organization_id NUMBER
2653: , p_rev_item_id NUMBER )
2654: IS
2655: SELECT 'Cmp does not exist'
2656: FROM SYS.DUAL
2657: WHERE EXISTS (SELECT NULL
2658: FROM WIP_DISCRETE_JOBS wdj
2659: WHERE (wdj.status_type <> 1
2660: OR

Line 2680: FROM SYS.DUAL

2676: , p_operation_seq_num NUMBER
2677: , p_organization_id NUMBER )
2678: IS
2679: SELECT 'Cmp does not exist'
2680: FROM SYS.DUAL
2681: WHERE EXISTS (SELECT NULL
2682: FROM WIP_DISCRETE_JOBS wdj
2683: , WIP_ENTITIES we
2684: , WIP_ENTITIES we1

Line 2709: FROM SYS.DUAL

2705: , p_rev_comp_item_id NUMBER
2706: , p_operation_seq_num NUMBER)
2707: IS
2708: SELECT 'Cmp does not exist'
2709: FROM SYS.DUAL
2710: WHERE EXISTS (SELECT NULL
2711: FROM WIP_DISCRETE_JOBS wdj
2712: WHERE (wdj.status_type <> 1
2713: OR

Line 3153: FROM SYS.DUAL

3149: CURSOR old_comp_csr (p_old_comp_seq_id NUMBER ,
3150: p_eco_for_production NUMBER)
3151: IS
3152: SELECT 'Old Comp is invalid'
3153: FROM SYS.DUAL
3154: WHERE NOT EXISTS ( SELECT NULL
3155: FROM BOM_INVENTORY_COMPONENTS ic
3156: WHERE TRUNC(ic.effectivity_date) <=
3157: TRUNC(p_rev_component_rec.start_effective_date)

Line 4135: /* Validations for OPM convergence Project, Dual UOM tracking items should not be allowed

4131: );
4132: l_return_status := FND_API.G_RET_STS_ERROR;
4133: END IF;
4134:
4135: /* Validations for OPM convergence Project, Dual UOM tracking items should not be allowed
4136: for updates and creates */
4137: IF (G_Assy_Tracking_Quantity_Ind <>'P' or G_Comp_Tracking_Quantity_Ind <>'P') then
4138: Error_Handler.Add_Error_Token
4139: ( p_Message_Name => 'BOM_DUAL_UOM_ITEMS'

Line 4139: ( p_Message_Name => 'BOM_DUAL_UOM_ITEMS'

4135: /* Validations for OPM convergence Project, Dual UOM tracking items should not be allowed
4136: for updates and creates */
4137: IF (G_Assy_Tracking_Quantity_Ind <>'P' or G_Comp_Tracking_Quantity_Ind <>'P') then
4138: Error_Handler.Add_Error_Token
4139: ( p_Message_Name => 'BOM_DUAL_UOM_ITEMS'
4140: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4141: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4142: , p_message_type => 'E'
4143: );

Line 6540: FROM sys.dual

6536: THEN
6537: BEGIN
6538: SELECT 'Component cancelled'
6539: INTO l_dummy
6540: FROM sys.dual
6541: WHERE NOT EXISTS
6542: (SELECT 1 from bom_inventory_components
6543: WHERE component_sequence_id =
6544: p_rev_comp_Unexp_rec.component_sequence_id

Line 6821: FROM sys.dual

6817: l_is_item_unit_controlled BOOLEAN := FALSE;
6818:
6819: CURSOR c_CheckCancelled IS
6820: SELECT 1
6821: FROM sys.dual
6822: WHERE NOT EXISTS
6823: ( SELECT component_sequence_id
6824: FROM bom_inventory_components
6825: WHERE component_item_id = p_component_item_id