APPS.BOM_VALIDATE_COMP_OPERATION dependencies on DUAL

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

50: RETURN BOOLEAN
51: IS
52: l_Count NUMBER := 0;
53: CURSOR All_Dates IS
54: SELECT 'X' date_available FROM sys.dual
55: WHERE EXISTS (
56: SELECT 1 from BOM_Component_All_Operations_V
57: WHERE Component_Item_Id = p_Component_Item_Id
58: AND Bill_Sequence_Id = p_Bill_Sequence_Id

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

146: RETURN BOOLEAN
147: IS
148: l_Count NUMBER := 0;
149: CURSOR All_Numbers_BIC IS
150: SELECT 'X' unit_available FROM sys.dual
151: WHERE EXISTS (
152: SELECT 1 from BOM_INVENTORY_COMPONENTS
153: WHERE Component_Item_Id = p_Component_Item_Id
154: AND Bill_Sequence_Id = p_Bill_Sequence_Id

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

205: AND ( DISABLE_DATE IS NULL ) --bug:5347036 Consider enabled components only
206: );
207:
208: CURSOR All_Numbers_BCO IS
209: SELECT 'X' unit_available FROM sys.dual
210: WHERE EXISTS (
211: SELECT 1 from BOM_COMPONENT_OPERATIONS BCO,
212: BOM_INVENTORY_COMPONENTS BIC
213: WHERE BCO.COMPONENT_SEQUENCE_ID = BIC.COMPONENT_SEQUENCE_ID

Line 521: * Purpose : Attribute validation will validate individual attributes

517: * Procedure : Check_Attributes
518: * Parameters IN : Component Operation Record as given by the User
519: * Parameters OUT: Return_Status - Indicating success or faliure
520: * Mesg_Token_Tbl - Filled with any errors or warnings
521: * Purpose : Attribute validation will validate individual attributes
522: * and any errors will be populated in the Mesg_Token_Tbl
523: * and returned with a return_status.
524: ********************************************************************/
525: