APPS.BOM_GLOBALS dependencies on DUAL

Line 2093: FROM DUAL;

2089: IF (viewPrivilegeName IS NOT NULL)
2090: THEN
2091: SELECT EGO_DATA_SECURITY.CHECK_FUNCTION(1.0,viewPrivilegeName,'EGO_ITEM',inventoryItemId,
2092: organizationId,null, null, null,partyId) INTO l_view_privilege
2093: FROM DUAL;
2094: END IF;
2095:
2096: IF (editPrivilegeName IS NOT NULL)
2097: THEN

Line 2100: FROM DUAL;

2096: IF (editPrivilegeName IS NOT NULL)
2097: THEN
2098: SELECT EGO_DATA_SECURITY.CHECK_FUNCTION(1.0,editPrivilegeName,'EGO_ITEM',inventoryItemId,
2099: organizationId,null, null, null,partyId) INTO l_edit_privilege
2100: FROM DUAL;
2101: END IF;
2102:
2103: IF (l_view_privilege IS NOT NULL)
2104: THEN

Line 2544: SELECT Bom_Inventory_Components_S.NEXTVAL INTO l_component_seqeunce_id FROM dual;

2540: l_end_rev_id NUMBER;
2541: l_temp_num NUMBER;
2542: BEGIN
2543: --Get the new ComponentSequenceId
2544: SELECT Bom_Inventory_Components_S.NEXTVAL INTO l_component_seqeunce_id FROM dual;
2545:
2546: --Get the parents effectivity control
2547: SELECT Effectivity_Control INTO l_effectivity_control FROM BOM_STRUCTURES_B
2548: WHERE Bill_Sequence_Id = (SELECT Bill_Sequence_Id FROM BOM_COMPONENTS_B WHERE COMPONENT_SEQUENCE_ID = p_comp_seq_id);

Line 2557: SELECT SYSDATE INTO l_start_effectivity_date FROM dual;

2553: SELECT Disable_date INTO l_disable_date FROM BOM_COMPONENTS_B WHERE COMPONENT_SEQUENCE_ID = p_comp_seq_id;
2554: l_start_rev_id := null;
2555: l_end_rev_id := null;
2556: ELSIF l_effectivity_control = 4 THEN
2557: SELECT SYSDATE INTO l_start_effectivity_date FROM dual;
2558: l_disable_date := null;
2559: l_start_rev_id := p_rev_id;
2560: SELECT To_End_Item_Rev_Id INTO l_end_rev_id FROM BOM_COMPONENTS_B WHERE COMPONENT_SEQUENCE_ID = p_comp_seq_id;
2561: ELSE

Line 3265: SELECT dbms_utility.get_time INTO G_TIME_LOGGED(G_TOP) FROM dual;

3261: G_TIME_LOGGED.extend;
3262: G_METHOD_LOGGED.extend;
3263: IF G_TOP < G_STACK_SIZE THEN
3264: G_TOP := G_TOP + 1;
3265: SELECT dbms_utility.get_time INTO G_TIME_LOGGED(G_TOP) FROM dual;
3266: G_METHOD_LOGGED(G_TOP) := operation_name;
3267: END IF;
3268: END Log_Start_Time;
3269:

Line 3281: SELECT dbms_utility.get_time INTO temp2 FROM dual;

3277: BEGIN
3278: IF ((FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) AND ( G_PROFILE_ENABLED = FND_PROFILE.VALUE('BOM:LOG_EXECUTION_TIME'))) THEN
3279: IF G_TOP > 0 THEN
3280: temp1 := G_TIME_LOGGED(G_TOP);
3281: SELECT dbms_utility.get_time INTO temp2 FROM dual;
3282: FND_FILE.put_line(FND_FILE.LOG,'BOM Performance Log: ');
3283: G_TOP := G_TOP -1 ;
3284: END IF;
3285: END IF;