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 2506: SELECT Bom_Inventory_Components_S.NEXTVAL INTO l_component_seqeunce_id FROM dual;

2502: l_end_rev_id NUMBER;
2503: l_temp_num NUMBER;
2504: BEGIN
2505: --Get the new ComponentSequenceId
2506: SELECT Bom_Inventory_Components_S.NEXTVAL INTO l_component_seqeunce_id FROM dual;
2507:
2508: --Get the parents effectivity control
2509: SELECT Effectivity_Control INTO l_effectivity_control FROM BOM_STRUCTURES_B
2510: WHERE Bill_Sequence_Id = (SELECT Bill_Sequence_Id FROM BOM_COMPONENTS_B WHERE COMPONENT_SEQUENCE_ID = p_comp_seq_id);

Line 2519: SELECT SYSDATE INTO l_start_effectivity_date FROM dual;

2515: SELECT Disable_date INTO l_disable_date FROM BOM_COMPONENTS_B WHERE COMPONENT_SEQUENCE_ID = p_comp_seq_id;
2516: l_start_rev_id := null;
2517: l_end_rev_id := null;
2518: ELSIF l_effectivity_control = 4 THEN
2519: SELECT SYSDATE INTO l_start_effectivity_date FROM dual;
2520: l_disable_date := null;
2521: l_start_rev_id := p_rev_id;
2522: SELECT To_End_Item_Rev_Id INTO l_end_rev_id FROM BOM_COMPONENTS_B WHERE COMPONENT_SEQUENCE_ID = p_comp_seq_id;
2523: ELSE

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

3198: G_TIME_LOGGED.extend;
3199: G_METHOD_LOGGED.extend;
3200: IF G_TOP < G_STACK_SIZE THEN
3201: G_TOP := G_TOP + 1;
3202: SELECT dbms_utility.get_time INTO G_TIME_LOGGED(G_TOP) FROM dual;
3203: G_METHOD_LOGGED(G_TOP) := operation_name;
3204: END IF;
3205: END Log_Start_Time;
3206:

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

3214: BEGIN
3215: IF ((FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) AND ( G_PROFILE_ENABLED = FND_PROFILE.VALUE('BOM:LOG_EXECUTION_TIME'))) THEN
3216: IF G_TOP > 0 THEN
3217: temp1 := G_TIME_LOGGED(G_TOP);
3218: SELECT dbms_utility.get_time INTO temp2 FROM dual;
3219: FND_FILE.put_line(FND_FILE.LOG,'BOM Performance Log: ');
3220: G_TOP := G_TOP -1 ;
3221: END IF;
3222: END IF;