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 811: SELECT 'X' unit_available FROM sys.dual

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

Line 1741: FROM sys.dual

1737: FUNCTION Check_Locators RETURN BOOLEAN
1738: IS
1739: Cursor CheckDuplicate is
1740: SELECT 'checking for duplicates' dummy
1741: FROM sys.dual
1742: WHERE EXISTS (
1743: SELECT null
1744: FROM mtl_item_locations
1745: WHERE organization_id =

Line 2664: FROM SYS.DUAL

2660: , p_organization_id NUMBER
2661: , p_rev_item_id NUMBER )
2662: IS
2663: SELECT 'Cmp does not exist'
2664: FROM SYS.DUAL
2665: WHERE EXISTS (SELECT NULL
2666: FROM WIP_DISCRETE_JOBS wdj
2667: WHERE (wdj.status_type <> 1
2668: OR

Line 2688: FROM SYS.DUAL

2684: , p_operation_seq_num NUMBER
2685: , p_organization_id NUMBER )
2686: IS
2687: SELECT 'Cmp does not exist'
2688: FROM SYS.DUAL
2689: WHERE EXISTS (SELECT NULL
2690: FROM WIP_DISCRETE_JOBS wdj
2691: , WIP_ENTITIES we
2692: , WIP_ENTITIES we1

Line 2717: FROM SYS.DUAL

2713: , p_rev_comp_item_id NUMBER
2714: , p_operation_seq_num NUMBER)
2715: IS
2716: SELECT 'Cmp does not exist'
2717: FROM SYS.DUAL
2718: WHERE EXISTS (SELECT NULL
2719: FROM WIP_DISCRETE_JOBS wdj
2720: WHERE (wdj.status_type <> 1
2721: OR

Line 3188: FROM SYS.DUAL

3184: CURSOR old_comp_csr (p_old_comp_seq_id NUMBER ,
3185: p_eco_for_production NUMBER)
3186: IS
3187: SELECT 'Old Comp is invalid'
3188: FROM SYS.DUAL
3189: WHERE NOT EXISTS ( SELECT NULL
3190: FROM BOM_INVENTORY_COMPONENTS ic
3191: WHERE /*bug 11786826 comment this. TRUNC(ic.effectivity_date) <=
3192: TRUNC(p_rev_component_rec.start_effective_date)

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

4320: );
4321: l_return_status := FND_API.G_RET_STS_ERROR;
4322: END IF;
4323:
4324: /* Validations for OPM convergence Project, Dual UOM tracking items should not be allowed
4325: for updates and creates */
4326: IF (G_Assy_Tracking_Quantity_Ind <>'P' or G_Comp_Tracking_Quantity_Ind <>'P') then
4327: Error_Handler.Add_Error_Token
4328: ( p_Message_Name => 'BOM_DUAL_UOM_ITEMS'

Line 4328: ( p_Message_Name => 'BOM_DUAL_UOM_ITEMS'

4324: /* Validations for OPM convergence Project, Dual UOM tracking items should not be allowed
4325: for updates and creates */
4326: IF (G_Assy_Tracking_Quantity_Ind <>'P' or G_Comp_Tracking_Quantity_Ind <>'P') then
4327: Error_Handler.Add_Error_Token
4328: ( p_Message_Name => 'BOM_DUAL_UOM_ITEMS'
4329: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4330: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4331: , p_message_type => 'E'
4332: );

Line 6779: FROM sys.dual

6775: THEN
6776: BEGIN
6777: SELECT 'Component cancelled'
6778: INTO l_dummy
6779: FROM sys.dual
6780: WHERE NOT EXISTS
6781: (SELECT 1 from bom_inventory_components
6782: WHERE component_sequence_id =
6783: p_rev_comp_Unexp_rec.component_sequence_id

Line 7060: FROM sys.dual

7056: l_is_item_unit_controlled BOOLEAN := FALSE;
7057:
7058: CURSOR c_CheckCancelled IS
7059: SELECT 1
7060: FROM sys.dual
7061: WHERE NOT EXISTS
7062: ( SELECT component_sequence_id
7063: FROM bom_inventory_components
7064: WHERE component_item_id = p_component_item_id