APPS.MTH_UDA_PKG dependencies on DUAL

Line 387: v_stmt := 'SELECT EGO_EXTFWK_S.NEXTVAL FROM DUAL';

383: --DBMS_OUTPUT.PUT_LINE('INSERT THE NEW ROW');
384:
385:
386: v_stmt_no := 70;
387: v_stmt := 'SELECT EGO_EXTFWK_S.NEXTVAL FROM DUAL';
388: EXECUTE IMMEDIATE v_stmt INTO v_extId;
389:
390: v_stmt := 'INSERT INTO '||v_tname||' (EXTENSION_ID, ATTR_GROUP_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE) VALUES (:1, :2, '||''''||SYSDATE||''''||', -1, -1,'||''''||SYSDATE||''''||' )';
391: --DBMS_OUTPUT.PUT_LINE('The new EXT ID is'||v_extId);

Line 632: SELECT SYSDATE INTO v_last_update_date FROM DUAL;

628: END IF;
629:
630: -- Get the sysdate
631: v_l_stmt := 20;
632: SELECT SYSDATE INTO v_last_update_date FROM DUAL;
633:
634: -- get the unassigned value for system id
635: v_l_stmt := 30;
636: SELECT MTH_UTIL_PKG.MTH_UA_GET_VAL() INTO v_last_update_system_id FROM DUAL;

Line 636: SELECT MTH_UTIL_PKG.MTH_UA_GET_VAL() INTO v_last_update_system_id FROM DUAL;

632: SELECT SYSDATE INTO v_last_update_date FROM DUAL;
633:
634: -- get the unassigned value for system id
635: v_l_stmt := 30;
636: SELECT MTH_UTIL_PKG.MTH_UA_GET_VAL() INTO v_last_update_system_id FROM DUAL;
637:
638:
639: -- Check whether the pre map operation has been run or not
640: v_l_stmt := 40;

Line 732: SELECT SYSDATE INTO v_to_date FROM DUAL;

728: END IF;
729:
730: -- get the system date
731: v_l_stmt := 10;
732: SELECT SYSDATE INTO v_to_date FROM DUAL;
733:
734: v_last_update_date := v_to_date;
735:
736: -- get the unassigned value for system id

Line 738: SELECT MTH_UTIL_PKG.MTH_UA_GET_VAL() INTO v_last_update_system_id FROM DUAL;

734: v_last_update_date := v_to_date;
735:
736: -- get the unassigned value for system id
737: v_l_stmt := 15;
738: SELECT MTH_UTIL_PKG.MTH_UA_GET_VAL() INTO v_last_update_system_id FROM DUAL;
739:
740: -- Check whether the load is being run for the first time or not
741: v_l_stmt := 20;
742: SELECT COUNT(FACT_TABLE) INTO v_cnt

Line 798: SELECT * FROM MTH_TAG_READINGS_T_STG,(SELECT NVL(FND_GLOBAL.User_Id,-1)l_updated_by,NVL(FND_GLOBAL.Login_Id,-1)l_last_update_login FROM DUAL )D

794: v_colname := DBCOL.DB_COL;
795: v_stmt_no := 10;
796: v_stmt := 'MERGE INTO MTH_EQUIPMENTS_EXT_B ED
797: USING (
798: SELECT * FROM MTH_TAG_READINGS_T_STG,(SELECT NVL(FND_GLOBAL.User_Id,-1)l_updated_by,NVL(FND_GLOBAL.Login_Id,-1)l_last_update_login FROM DUAL )D
799: WHERE DB_COL = '||''''||v_colname||''''||') TS
800: ON (';
801:
802: v_stmt := v_stmt||'ED.EQUIPMENT_PK_KEY = TS.EQUIPMENT_FK_KEY AND