APPS.MTH_UTIL_PKG dependencies on DUAL

Line 1013: select fnd_profile.value(p_profile_name) into v_profile_value from dual;

1009: --Initialize the session for default values -1.
1010: /* fnd_global.apps_initialize(v_uid, v_rid, v_applid); */
1011:
1012: --select the value of the profile into the local variable.
1013: select fnd_profile.value(p_profile_name) into v_profile_value from dual;
1014:
1015: --Return the value.
1016: RETURN(v_profile_value);
1017:

Line 1085: FROM dual;

1081: Decode(InStr(v_str,'/',v_str_len),0,4000,InStr(v_str,'/',v_str_len)),
1082: Decode(InStr(v_str,'(',v_str_len),0,4000,InStr(v_str,'(',v_str_len)),
1083: Decode(InStr(v_str,')',v_str_len),0,4000,InStr(v_str,')',v_str_len)))
1084: INTO v_position
1085: FROM dual;
1086:
1087: SELECT SubStr(v_str,v_str_len,v_position-1-(v_str_len-1))
1088: INTO v_meter_id
1089: FROM dual;

Line 1089: FROM dual;

1085: FROM dual;
1086:
1087: SELECT SubStr(v_str,v_str_len,v_position-1-(v_str_len-1))
1088: INTO v_meter_id
1089: FROM dual;
1090: IF(v_meter_id IS NULL)
1091: THEN
1092: v_meter_id := v_str;
1093: END IF;

Line 2807: p_user_measure4 p_user_measure4, p_user_measure5 p_user_measure5 FROM dual) var

2803: p_user_dim4_fk_key p_user_dim4_fk_key, p_user_dim5_fk_key p_user_dim5_fk_key,
2804: p_user_attr1 p_user_attr1,p_user_attr2 p_user_attr2, p_user_attr3 p_user_attr3,
2805: p_user_attr4 p_user_attr4, p_user_attr5 p_user_attr5, p_user_measure1 p_user_measure1,
2806: p_user_measure2 p_user_measure2, p_user_measure3 p_user_measure3,
2807: p_user_measure4 p_user_measure4, p_user_measure5 p_user_measure5 FROM dual) var
2808: ON (stat.equipment_fk_key = var.p_equipment_fk_key AND
2809: stat.shift_workday_fk_key = var.p_shift_workday_fk_key AND
2810: stat.hour_fk_key = var.p_hour_fk_key AND
2811: stat.from_date = var.p_from_date)

Line 2847: p_user_measure3 p_user_measure3,p_user_measure4 p_user_measure4, p_user_measure5 p_user_measure5 FROM dual) var

2843: p_user_dim2_fk_key p_user_dim2_fk_key, p_user_dim3_fk_key p_user_dim3_fk_key,
2844: p_user_dim4_fk_key p_user_dim4_fk_key, p_user_dim5_fk_key p_user_dim5_fk_key,p_user_attr1 p_user_attr1,
2845: p_user_attr2 p_user_attr2, p_user_attr3 p_user_attr3, p_user_attr4 p_user_attr4,
2846: p_user_attr5 p_user_attr5, p_user_measure1 p_user_measure1, p_user_measure2 p_user_measure2,
2847: p_user_measure3 p_user_measure3,p_user_measure4 p_user_measure4, p_user_measure5 p_user_measure5 FROM dual) var
2848: ON (stat.equipment_fk_key = var.p_equipment_fk_key AND
2849: stat.shift_workday_fk_key = var.p_shift_workday_fk_key AND
2850: stat.hour_fk_key = var.p_hour_fk_key AND
2851: stat.from_date = var.p_from_date)

Line 2877: SELECT FLOOR((p_to_date -p_hour_to_time)*24) INTO v_count FROM DUAL;

2873: p_user_attr2, p_user_attr3, p_user_attr4, p_user_attr5, p_user_measure1, p_user_measure2, p_user_measure3,
2874: p_user_measure4, p_user_measure5,SYSDATE,SYSDATE,Nvl(p_system_fk_key,v_unassigned_string),
2875: Nvl(p_system_fk_key,v_unassigned_string),NULL,NULL,NULL,NULL,NULL,p_hour_fk_key);
2876:
2877: SELECT FLOOR((p_to_date -p_hour_to_time)*24) INTO v_count FROM DUAL;
2878:
2879: FOR i IN 1..v_count+1 LOOP
2880:
2881: SELECT LEAD_HOUR,LEAD_FROM_DATE,LEAD_TO_DATE, LEAST(p_to_date, LEAD_TO_DATE)

Line 2900: v_next_hour_from_time v_next_hour_from_time,v_next_hour_to_time v_next_hour_to_time FROM dual) var

2896: p_user_attr1 p_user_attr1,p_user_attr2 p_user_attr2, p_user_attr3 p_user_attr3,
2897: p_user_attr4 p_user_attr4, p_user_attr5 p_user_attr5, p_user_measure1 p_user_measure1,
2898: p_user_measure2 p_user_measure2, p_user_measure3 p_user_measure3,p_user_measure4 p_user_measure4,
2899: p_user_measure5 p_user_measure5,v_next_hour_fk_key v_next_hour_fk_key,
2900: v_next_hour_from_time v_next_hour_from_time,v_next_hour_to_time v_next_hour_to_time FROM dual) var
2901: ON (stat.equipment_fk_key = var.p_equipment_fk_key AND
2902: stat.shift_workday_fk_key = var.p_shift_workday_fk_key AND
2903: stat.hour_fk_key = var.v_next_hour_fk_key AND
2904: stat.from_date = var.v_next_hour_from_time)

Line 4141: SELECT MTH_UTIL_PKG.GET_PROFILE_VAL('MTH_SHIFT_SETUP' ) INTO v_profile FROM DUAL ;

4137:
4138: mth_util_pkg.log_msg('MTH_WORKDAY_SHIFTS_SF start', mth_util_pkg.G_DBG_PROC_FUN_START);
4139:
4140:
4141: SELECT MTH_UTIL_PKG.GET_PROFILE_VAL('MTH_SHIFT_SETUP' ) INTO v_profile FROM DUAL ;
4142:
4143: INSERT INTO MTH_WORKDAY_SHIFTS_STG
4144: (SHIFT_DATE,
4145: SOURCE_ORG_CODE,

Line 4650: v_stmt := 'SELECT ' || p_seq_name || '.nextval FROM dual';

4646: -- main body
4647: BEGIN
4648:
4649: --Prepare the truncate statement using schema name and table name
4650: v_stmt := 'SELECT ' || p_seq_name || '.nextval FROM dual';
4651: OPEN c FOR v_stmt;
4652: FETCH c INTO v_seq_val;
4653: CLOSE c;
4654: IF(v_seq_val > 1)

Line 4660: v_stmt := 'SELECT ' || p_seq_name || '.nextval FROM dual';

4656: v_stmt := 'ALTER SEQUENCE ' || V_SCHEMA_NAME || '.' || p_seq_name || ' MAXVALUE ' || v_seq_val || ' CYCLE NOCACHE';
4657:
4658: EXECUTE IMMEDIATE v_stmt;
4659:
4660: v_stmt := 'SELECT ' || p_seq_name || '.nextval FROM dual';
4661: OPEN c FOR v_stmt;
4662: FETCH c INTO v_seq_val;
4663: CLOSE c;
4664: v_stmt := 'ALTER SEQUENCE ' || V_SCHEMA_NAME || '.' || p_seq_name || ' MAXVALUE 2147483647 NOCYCLE CACHE 20';