DBA Data[Home] [Help]

APPS.MSD_STRIPE_DEMAND_PLAN dependencies on FND_GLOBAL

Line 745: fnd_global.user_id,

741: mlv.level_id,
742: mlv.sr_level_pk,
743: mlv.level_pk,
744: sysdate,
745: fnd_global.user_id,
746: sysdate,
747: fnd_global.user_id,
748: mlv.system_attribute1,
749: mlv.system_attribute2,

Line 747: fnd_global.user_id,

743: mlv.level_pk,
744: sysdate,
745: fnd_global.user_id,
746: sysdate,
747: fnd_global.user_id,
748: mlv.system_attribute1,
749: mlv.system_attribute2,
750: mlv.dp_enabled_flag
751: from msd_level_values mlv,

Line 770: fnd_global.user_id,

766: level_id,
767: sr_level_pk,
768: level_pk,
769: sysdate,
770: fnd_global.user_id,
771: sysdate,
772: fnd_global.user_id,
773: system_attribute1,
774: system_attribute2,

Line 772: fnd_global.user_id,

768: level_pk,
769: sysdate,
770: fnd_global.user_id,
771: sysdate,
772: fnd_global.user_id,
773: system_attribute1,
774: system_attribute2,
775: dp_enabled_flag
776: from msd_level_values_ds_temp

Line 865: fnd_global.user_id,

861: mlv.level_id,
862: mlv.sr_level_pk,
863: mlv.level_pk,
864: sysdate,
865: fnd_global.user_id,
866: sysdate,
867: fnd_global.user_id,
868: mlv.system_attribute1,
869: mlv.system_attribute2,

Line 867: fnd_global.user_id,

863: mlv.level_pk,
864: sysdate,
865: fnd_global.user_id,
866: sysdate,
867: fnd_global.user_id,
868: mlv.system_attribute1,
869: mlv.system_attribute2,
870: mlv.dp_enabled_flag
871: from msd_level_values mlv,

Line 890: fnd_global.user_id,

886: level_id,
887: sr_level_pk,
888: level_pk,
889: sysdate,
890: fnd_global.user_id,
891: sysdate,
892: fnd_global.user_id,
893: system_attribute1,
894: system_attribute2,

Line 892: fnd_global.user_id,

888: level_pk,
889: sysdate,
890: fnd_global.user_id,
891: sysdate,
892: fnd_global.user_id,
893: system_attribute1,
894: system_attribute2,
895: dp_enabled_flag
896: from msd_level_values_ds_temp

Line 943: fnd_global.user_id,

939: mlv.level_id,
940: mlv.sr_level_pk,
941: mlv.level_pk,
942: sysdate,
943: fnd_global.user_id,
944: sysdate,
945: fnd_global.user_id,
946: mlv.system_attribute1,
947: mlv.system_attribute2,

Line 945: fnd_global.user_id,

941: mlv.level_pk,
942: sysdate,
943: fnd_global.user_id,
944: sysdate,
945: fnd_global.user_id,
946: mlv.system_attribute1,
947: mlv.system_attribute2,
948: mlv.dp_enabled_flag
949: from msd_level_org_asscns mlo,

Line 967: fnd_global.user_id,

963: level_id,
964: sr_level_pk,
965: level_pk,
966: sysdate,
967: fnd_global.user_id,
968: sysdate,
969: fnd_global.user_id,
970: system_attribute1,
971: system_attribute2,

Line 969: fnd_global.user_id,

965: level_pk,
966: sysdate,
967: fnd_global.user_id,
968: sysdate,
969: fnd_global.user_id,
970: system_attribute1,
971: system_attribute2,
972: dp_enabled_flag
973: from msd_level_values_ds_temp

Line 1062: fnd_global.user_id,

1058: mlv.level_id,
1059: mlv.sr_level_pk,
1060: mlv.level_pk,
1061: sysdate,
1062: fnd_global.user_id,
1063: sysdate,
1064: fnd_global.user_id,
1065: mlv.system_attribute1,
1066: mlv.system_attribute2,

Line 1064: fnd_global.user_id,

1060: mlv.level_pk,
1061: sysdate,
1062: fnd_global.user_id,
1063: sysdate,
1064: fnd_global.user_id,
1065: mlv.system_attribute1,
1066: mlv.system_attribute2,
1067: mlv.dp_enabled_flag
1068: from msd_level_org_asscns mlo,

Line 1089: fnd_global.user_id,

1085: level_id,
1086: sr_level_pk,
1087: level_pk,
1088: sysdate,
1089: fnd_global.user_id,
1090: sysdate,
1091: fnd_global.user_id,
1092: system_attribute1,
1093: system_attribute2,

Line 1091: fnd_global.user_id,

1087: level_pk,
1088: sysdate,
1089: fnd_global.user_id,
1090: sysdate,
1091: fnd_global.user_id,
1092: system_attribute1,
1093: system_attribute2,
1094: dp_enabled_flag
1095: from msd_level_values_ds_temp

Line 1122: fnd_global.user_id,

1118: mlv.level_id,
1119: mlv.sr_level_pk,
1120: mlv.level_pk,
1121: sysdate,
1122: fnd_global.user_id,
1123: sysdate,
1124: fnd_global.user_id,
1125: mlv.system_attribute1,
1126: mlv.system_attribute2,

Line 1124: fnd_global.user_id,

1120: mlv.level_pk,
1121: sysdate,
1122: fnd_global.user_id,
1123: sysdate,
1124: fnd_global.user_id,
1125: mlv.system_attribute1,
1126: mlv.system_attribute2,
1127: mlv.dp_enabled_flag
1128: FROM msd_dp_iso_organizations mdio,

Line 1148: fnd_global.user_id,

1144: level_id,
1145: sr_level_pk,
1146: level_pk,
1147: sysdate,
1148: fnd_global.user_id,
1149: sysdate,
1150: fnd_global.user_id,
1151: system_attribute1,
1152: system_attribute2,

Line 1150: fnd_global.user_id,

1146: level_pk,
1147: sysdate,
1148: fnd_global.user_id,
1149: sysdate,
1150: fnd_global.user_id,
1151: system_attribute1,
1152: system_attribute2,
1153: dp_enabled_flag
1154: FROM msd_level_values_ds_temp

Line 1203: fnd_global.user_id,

1199: mlv.level_id,
1200: mlv.sr_level_pk,
1201: mlv.level_pk,
1202: sysdate,
1203: fnd_global.user_id,
1204: sysdate,
1205: fnd_global.user_id,
1206: mlv.system_attribute1,
1207: mlv.system_attribute2,

Line 1205: fnd_global.user_id,

1201: mlv.level_pk,
1202: sysdate,
1203: fnd_global.user_id,
1204: sysdate,
1205: fnd_global.user_id,
1206: mlv.system_attribute1,
1207: mlv.system_attribute2,
1208: mlv.dp_enabled_flag
1209: from msd_level_values mlv,

Line 1220: fnd_global.user_id,

1216: level_id,
1217: sr_level_pk,
1218: level_pk,
1219: sysdate,
1220: fnd_global.user_id,
1221: sysdate,
1222: fnd_global.user_id,
1223: system_attribute1,
1224: system_attribute2,

Line 1222: fnd_global.user_id,

1218: level_pk,
1219: sysdate,
1220: fnd_global.user_id,
1221: sysdate,
1222: fnd_global.user_id,
1223: system_attribute1,
1224: system_attribute2,
1225: dp_enabled_flag
1226: from msd_level_values_ds_temp

Line 1252: fnd_global.user_id,

1248: mlv.level_id,
1249: mlv.sr_level_pk,
1250: mlv.level_pk,
1251: sysdate,
1252: fnd_global.user_id,
1253: sysdate,
1254: fnd_global.user_id,
1255: mlv.system_attribute1,
1256: mlv.system_attribute2,

Line 1254: fnd_global.user_id,

1250: mlv.level_pk,
1251: sysdate,
1252: fnd_global.user_id,
1253: sysdate,
1254: fnd_global.user_id,
1255: mlv.system_attribute1,
1256: mlv.system_attribute2,
1257: mlv.dp_enabled_flag
1258: from msd_level_values mlv,

Line 1269: fnd_global.user_id,

1265: level_id,
1266: sr_level_pk,
1267: level_pk,
1268: sysdate,
1269: fnd_global.user_id,
1270: sysdate,
1271: fnd_global.user_id,
1272: system_attribute1,
1273: system_attribute2,

Line 1271: fnd_global.user_id,

1267: level_pk,
1268: sysdate,
1269: fnd_global.user_id,
1270: sysdate,
1271: fnd_global.user_id,
1272: system_attribute1,
1273: system_attribute2,
1274: dp_enabled_flag
1275: from msd_level_values_ds_temp

Line 1301: fnd_global.user_id,

1297: mlv.level_id,
1298: mlv.sr_level_pk,
1299: mlv.level_pk,
1300: sysdate,
1301: fnd_global.user_id,
1302: sysdate,
1303: fnd_global.user_id,
1304: mlv.system_attribute1,
1305: mlv.system_attribute2,

Line 1303: fnd_global.user_id,

1299: mlv.level_pk,
1300: sysdate,
1301: fnd_global.user_id,
1302: sysdate,
1303: fnd_global.user_id,
1304: mlv.system_attribute1,
1305: mlv.system_attribute2,
1306: mlv.dp_enabled_flag
1307: from msd_level_values mlv,

Line 1318: fnd_global.user_id,

1314: level_id,
1315: sr_level_pk,
1316: level_pk,
1317: sysdate,
1318: fnd_global.user_id,
1319: sysdate,
1320: fnd_global.user_id,
1321: system_attribute1,
1322: system_attribute2,

Line 1320: fnd_global.user_id,

1316: level_pk,
1317: sysdate,
1318: fnd_global.user_id,
1319: sysdate,
1320: fnd_global.user_id,
1321: system_attribute1,
1322: system_attribute2,
1323: dp_enabled_flag
1324: from msd_level_values_ds_temp

Line 1350: fnd_global.user_id,

1346: mlv.level_id,
1347: mlv.sr_level_pk,
1348: mlv.level_pk,
1349: sysdate,
1350: fnd_global.user_id,
1351: sysdate,
1352: fnd_global.user_id,
1353: mlv.system_attribute1,
1354: mlv.system_attribute2,

Line 1352: fnd_global.user_id,

1348: mlv.level_pk,
1349: sysdate,
1350: fnd_global.user_id,
1351: sysdate,
1352: fnd_global.user_id,
1353: mlv.system_attribute1,
1354: mlv.system_attribute2,
1355: mlv.dp_enabled_flag
1356: from msd_level_values mlv,

Line 1367: fnd_global.user_id,

1363: level_id,
1364: sr_level_pk,
1365: level_pk,
1366: sysdate,
1367: fnd_global.user_id,
1368: sysdate,
1369: fnd_global.user_id,
1370: system_attribute1,
1371: system_attribute2,

Line 1369: fnd_global.user_id,

1365: level_pk,
1366: sysdate,
1367: fnd_global.user_id,
1368: sysdate,
1369: fnd_global.user_id,
1370: system_attribute1,
1371: system_attribute2,
1372: dp_enabled_flag
1373: from msd_level_values_ds_temp

Line 1479: -- fnd_global.user_id,

1475: -- csd.cs_data_id,
1476: -- csd.cs_definition_id,
1477: -- csd.cs_name,
1478: -- sysdate,
1479: -- fnd_global.user_id,
1480: -- sysdate,
1481: -- fnd_global.user_id
1482: -- from (select demand_plan_id from msd_dp_session) mds,
1483: -- msd_cs_data_v1 csd,

Line 1481: -- fnd_global.user_id

1477: -- csd.cs_name,
1478: -- sysdate,
1479: -- fnd_global.user_id,
1480: -- sysdate,
1481: -- fnd_global.user_id
1482: -- from (select demand_plan_id from msd_dp_session) mds,
1483: -- msd_cs_data_v1 csd,
1484: -- msd_level_values_ds mld
1485: -- where csd.cs_definition_id = 21

Line 1611: v_sql_stmt := v_sql_stmt || ' select /*+ ORDERED */ mds.demand_plan_id, cdv.cs_data_id, cdv.cs_definition_id, cdv.cs_name, sysdate, fnd_global.user_id, sysdate, fnd_global.user_id ';

1607:
1608: v_sql_stmt := v_sql_stmt || ' insert into msd_cs_data_ds ';
1609: v_sql_stmt := v_sql_stmt || ' (demand_plan_id, cs_data_id, cs_definition_id, cs_name, ';
1610: v_sql_stmt := v_sql_stmt || ' last_update_date, last_updated_by, creation_date, created_by) ';
1611: v_sql_stmt := v_sql_stmt || ' select /*+ ORDERED */ mds.demand_plan_id, cdv.cs_data_id, cdv.cs_definition_id, cdv.cs_name, sysdate, fnd_global.user_id, sysdate, fnd_global.user_id ';
1612: v_sql_stmt := v_sql_stmt || ' from (select demand_plan_id from msd_dp_session) mds, ';
1613: v_sql_stmt := v_sql_stmt || ' msd_cs_data_v1 cdv ';
1614: v_sql_where_stmt := v_sql_where_stmt || ' where cdv.cs_definition_id = ' || c1_rec.cs_definition_id || ' and mds.demand_plan_id = ' || p_demand_plan_id;
1615:

Line 1745: fnd_global.user_id,

1741: p_stripe_level_id,
1742: p_stripe_sr_level_pk,
1743: l_c1_rec.level_pk,
1744: sysdate,
1745: fnd_global.user_id,
1746: sysdate,
1747: fnd_global.user_id,
1748: l_c1_rec.system_attribute1, -- Bug# 4937978
1749: l_c1_rec.system_attribute2,

Line 1747: fnd_global.user_id,

1743: l_c1_rec.level_pk,
1744: sysdate,
1745: fnd_global.user_id,
1746: sysdate,
1747: fnd_global.user_id,
1748: l_c1_rec.system_attribute1, -- Bug# 4937978
1749: l_c1_rec.system_attribute2,
1750: l_c1_rec.dp_enabled_flag
1751: );

Line 2185: fnd_global.user_id,

2181: null,
2182: null,
2183: refresh_num,
2184: sysdate,
2185: fnd_global.user_id,
2186: sysdate,
2187: fnd_global.user_id
2188: from msd_dp_parameters_ds
2189: where demand_plan_id = C_LEVEL_PLAN

Line 2187: fnd_global.user_id

2183: refresh_num,
2184: sysdate,
2185: fnd_global.user_id,
2186: sysdate,
2187: fnd_global.user_id
2188: from msd_dp_parameters_ds
2189: where demand_plan_id = C_LEVEL_PLAN
2190: and data_type = C_LVL_VAL
2191: union all

Line 2198: fnd_global.user_id,

2194: mdp.parameter_type,
2195: mdp.parameter_name,
2196: max(csh.last_refresh_num),
2197: sysdate,
2198: fnd_global.user_id,
2199: sysdate,
2200: fnd_global.user_id
2201: from msd_dp_parameters mdp,
2202: msd_cs_data_headers csh,

Line 2200: fnd_global.user_id

2196: max(csh.last_refresh_num),
2197: sysdate,
2198: fnd_global.user_id,
2199: sysdate,
2200: fnd_global.user_id
2201: from msd_dp_parameters mdp,
2202: msd_cs_data_headers csh,
2203: msd_cs_definitions csd
2204: where mdp.parameter_type = csd.name

Line 2216: fnd_global.user_id,

2212: mdd.dimension_code,
2213: null,
2214: null,
2215: sysdate,
2216: fnd_global.user_id,
2217: sysdate,
2218: fnd_global.user_id
2219: from msd_dp_dimensions mdd
2220: where mdd.demand_plan_id = p_demand_plan_id;

Line 2218: fnd_global.user_id

2214: null,
2215: sysdate,
2216: fnd_global.user_id,
2217: sysdate,
2218: fnd_global.user_id
2219: from msd_dp_dimensions mdd
2220: where mdd.demand_plan_id = p_demand_plan_id;
2221:
2222: if l_debug = C_YES_FLAG then

Line 2530: fnd_global.user_id,

2526: p_stripe_level_id,
2527: p_stripe_sr_level_pk,
2528: l_c1_rec.level_pk,
2529: sysdate,
2530: fnd_global.user_id,
2531: sysdate,
2532: fnd_global.user_id,
2533: l_c1_rec.system_attribute1, -- Bug# 4937978
2534: l_c1_rec.system_attribute2,

Line 2532: fnd_global.user_id,

2528: l_c1_rec.level_pk,
2529: sysdate,
2530: fnd_global.user_id,
2531: sysdate,
2532: fnd_global.user_id,
2533: l_c1_rec.system_attribute1, -- Bug# 4937978
2534: l_c1_rec.system_attribute2,
2535: l_c1_rec.dp_enabled_flag
2536: );

Line 2741: ' fnd_global.user_id, ' ||

2737: ' mlv.level_id, ' ||
2738: ' mlv.sr_level_pk, ' ||
2739: ' mlv.level_pk, ' ||
2740: ' sysdate, ' ||
2741: ' fnd_global.user_id, ' ||
2742: ' sysdate, ' ||
2743: ' fnd_global.user_id, ' ||
2744: ' mlv.system_attribute1, ' ||
2745: ' mlv.system_attribute2, ' ||

Line 2743: ' fnd_global.user_id, ' ||

2739: ' mlv.level_pk, ' ||
2740: ' sysdate, ' ||
2741: ' fnd_global.user_id, ' ||
2742: ' sysdate, ' ||
2743: ' fnd_global.user_id, ' ||
2744: ' mlv.system_attribute1, ' ||
2745: ' mlv.system_attribute2, ' ||
2746: ' mlv.dp_enabled_flag ' ||
2747: ' from msd_level_values mlv, ' ||

Line 3002: fnd_global.user_id,

2998: mlv.level_id,
2999: mlv.sr_level_pk,
3000: mlv.level_pk,
3001: sysdate,
3002: fnd_global.user_id,
3003: sysdate,
3004: fnd_global.user_id,
3005: mlv.system_attribute1,
3006: mlv.system_attribute2,

Line 3004: fnd_global.user_id,

3000: mlv.level_pk,
3001: sysdate,
3002: fnd_global.user_id,
3003: sysdate,
3004: fnd_global.user_id,
3005: mlv.system_attribute1,
3006: mlv.system_attribute2,
3007: mlv.dp_enabled_flag
3008: from msd_dp_events mde,

Line 3036: fnd_global.user_id,

3032: level_id,
3033: sr_level_pk,
3034: level_pk,
3035: sysdate,
3036: fnd_global.user_id,
3037: sysdate,
3038: fnd_global.user_id,
3039: system_attribute1,
3040: system_attribute2,

Line 3038: fnd_global.user_id,

3034: level_pk,
3035: sysdate,
3036: fnd_global.user_id,
3037: sysdate,
3038: fnd_global.user_id,
3039: system_attribute1,
3040: system_attribute2,
3041: dp_enabled_flag
3042: from msd_level_values_ds_temp

Line 3147: fnd_global.user_id,

3143: C_PSEUDO_PK,
3144: C_PSEUDO_PK,
3145: C_PSEUDO_PK,
3146: sysdate,
3147: fnd_global.user_id,
3148: sysdate,
3149: fnd_global.user_id
3150: );
3151:

Line 3149: fnd_global.user_id

3145: C_PSEUDO_PK,
3146: sysdate,
3147: fnd_global.user_id,
3148: sysdate,
3149: fnd_global.user_id
3150: );
3151:
3152: end if;
3153:

Line 3205: fnd_global.user_id,

3201: mlv.level_id,
3202: mlv.sr_level_pk,
3203: mlv.level_pk,
3204: sysdate,
3205: fnd_global.user_id,
3206: sysdate,
3207: fnd_global.user_id,
3208: mlv.system_attribute1,
3209: mlv.system_attribute2,

Line 3207: fnd_global.user_id,

3203: mlv.level_pk,
3204: sysdate,
3205: fnd_global.user_id,
3206: sysdate,
3207: fnd_global.user_id,
3208: mlv.system_attribute1,
3209: mlv.system_attribute2,
3210: mlv.dp_enabled_flag
3211: from msd_level_values mlv

Line 3220: fnd_global.user_id,

3216: level_id,
3217: sr_level_pk,
3218: level_pk,
3219: sysdate,
3220: fnd_global.user_id,
3221: sysdate,
3222: fnd_global.user_id,
3223: system_attribute1,
3224: system_attribute2,

Line 3222: fnd_global.user_id,

3218: level_pk,
3219: sysdate,
3220: fnd_global.user_id,
3221: sysdate,
3222: fnd_global.user_id,
3223: system_attribute1,
3224: system_attribute2,
3225: dp_enabled_flag
3226: from msd_level_values_ds_temp

Line 3267: fnd_global.user_id,

3263: mlv.level_id,
3264: mlv.sr_level_pk,
3265: mlv.level_pk,
3266: sysdate,
3267: fnd_global.user_id,
3268: sysdate,
3269: fnd_global.user_id,
3270: mlv.system_attribute1,
3271: mlv.system_attribute2,

Line 3269: fnd_global.user_id,

3265: mlv.level_pk,
3266: sysdate,
3267: fnd_global.user_id,
3268: sysdate,
3269: fnd_global.user_id,
3270: mlv.system_attribute1,
3271: mlv.system_attribute2,
3272: mlv.dp_enabled_flag
3273: from msd_level_values mlv

Line 3283: fnd_global.user_id,

3279: level_id,
3280: sr_level_pk,
3281: level_pk,
3282: sysdate,
3283: fnd_global.user_id,
3284: sysdate,
3285: fnd_global.user_id,
3286: system_attribute1,
3287: system_attribute2,

Line 3285: fnd_global.user_id,

3281: level_pk,
3282: sysdate,
3283: fnd_global.user_id,
3284: sysdate,
3285: fnd_global.user_id,
3286: system_attribute1,
3287: system_attribute2,
3288: dp_enabled_flag
3289: from msd_level_values_ds_temp

Line 3360: fnd_global.user_id,

3356: mlv.level_id,
3357: mlv.sr_level_pk,
3358: mlv.level_pk,
3359: sysdate,
3360: fnd_global.user_id,
3361: sysdate,
3362: fnd_global.user_id,
3363: mlv.system_attribute1,
3364: mlv.system_attribute2,

Line 3362: fnd_global.user_id,

3358: mlv.level_pk,
3359: sysdate,
3360: fnd_global.user_id,
3361: sysdate,
3362: fnd_global.user_id,
3363: mlv.system_attribute1,
3364: mlv.system_attribute2,
3365: mlv.dp_enabled_flag
3366: from msd_level_values mlv

Line 3375: fnd_global.user_id,

3371: level_id,
3372: sr_level_pk,
3373: level_pk,
3374: sysdate,
3375: fnd_global.user_id,
3376: sysdate,
3377: fnd_global.user_id,
3378: system_attribute1,
3379: system_attribute2,

Line 3377: fnd_global.user_id,

3373: level_pk,
3374: sysdate,
3375: fnd_global.user_id,
3376: sysdate,
3377: fnd_global.user_id,
3378: system_attribute1,
3379: system_attribute2,
3380: dp_enabled_flag
3381: from msd_level_values_ds_temp