APPS.MTH_UDA_PKG dependencies on DUAL

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

398: --DBMS_OUTPUT.PUT_LINE('INSERT THE NEW ROW');
399:
400:
401: v_stmt_no := 70;
402: v_stmt := 'SELECT EGO_EXTFWK_S.NEXTVAL FROM DUAL';
403: EXECUTE IMMEDIATE v_stmt INTO v_extId;
404:
405: 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||''''||' )';
406: --DBMS_OUTPUT.PUT_LINE('The new EXT ID is'||v_extId);

Line 673: SELECT SYSDATE INTO v_last_update_date FROM DUAL;

669: END IF;
670:
671: -- Get the sysdate
672: v_l_stmt := 20;
673: SELECT SYSDATE INTO v_last_update_date FROM DUAL;
674:
675: -- get the unassigned value for system id
676: v_l_stmt := 30;
677: SELECT MTH_UTIL_PKG.MTH_UA_GET_VAL() INTO v_last_update_system_id FROM DUAL;

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

673: SELECT SYSDATE INTO v_last_update_date FROM DUAL;
674:
675: -- get the unassigned value for system id
676: v_l_stmt := 30;
677: SELECT MTH_UTIL_PKG.MTH_UA_GET_VAL() INTO v_last_update_system_id FROM DUAL;
678:
679:
680: -- Check whether the pre map operation has been run or not
681: v_l_stmt := 40;

Line 773: SELECT SYSDATE INTO v_to_date FROM DUAL;

769: END IF;
770:
771: -- get the system date
772: v_l_stmt := 10;
773: SELECT SYSDATE INTO v_to_date FROM DUAL;
774:
775: v_last_update_date := v_to_date;
776:
777: -- get the unassigned value for system id

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

775: v_last_update_date := v_to_date;
776:
777: -- get the unassigned value for system id
778: v_l_stmt := 15;
779: SELECT MTH_UTIL_PKG.MTH_UA_GET_VAL() INTO v_last_update_system_id FROM DUAL;
780:
781: -- Check whether the load is being run for the first time or not
782: v_l_stmt := 20;
783: SELECT COUNT(FACT_TABLE) INTO v_cnt

Line 839: 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

835: v_colname := DBCOL.DB_COL;
836: v_stmt_no := 10;
837: v_stmt := 'MERGE INTO MTH_EQUIPMENTS_EXT_B ED
838: USING (
839: 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
840: WHERE DB_COL = '||''''||v_colname||''''||') TS
841: ON (';
842:
843: v_stmt := v_stmt||'ED.EQUIPMENT_PK_KEY = TS.EQUIPMENT_FK_KEY AND

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

1288: --DBMS_OUTPUT.PUT_LINE('INSERT THE NEW ROW');
1289:
1290:
1291: v_stmt_no := 70;
1292: v_stmt := 'SELECT EGO_EXTFWK_S.NEXTVAL FROM DUAL';
1293: EXECUTE IMMEDIATE v_stmt INTO v_extId;
1294:
1295: 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||''''||' )';
1296: --DBMS_OUTPUT.PUT_LINE('The new EXT ID is'||v_extId);