DBA Data[Home] [Help]

APPS.MSD_STRIPE_DEMAND_PLAN dependencies on FND_GLOBAL

Line 748: fnd_global.user_id,

744: mlv.level_id,
745: mlv.sr_level_pk,
746: mlv.level_pk,
747: sysdate,
748: fnd_global.user_id,
749: sysdate,
750: fnd_global.user_id,
751: mlv.system_attribute1,
752: mlv.system_attribute2,

Line 750: fnd_global.user_id,

746: mlv.level_pk,
747: sysdate,
748: fnd_global.user_id,
749: sysdate,
750: fnd_global.user_id,
751: mlv.system_attribute1,
752: mlv.system_attribute2,
753: mlv.dp_enabled_flag
754: from msd_level_values mlv,

Line 773: fnd_global.user_id,

769: level_id,
770: sr_level_pk,
771: level_pk,
772: sysdate,
773: fnd_global.user_id,
774: sysdate,
775: fnd_global.user_id,
776: system_attribute1,
777: system_attribute2,

Line 775: fnd_global.user_id,

771: level_pk,
772: sysdate,
773: fnd_global.user_id,
774: sysdate,
775: fnd_global.user_id,
776: system_attribute1,
777: system_attribute2,
778: dp_enabled_flag
779: from msd_level_values_ds_temp

Line 868: fnd_global.user_id,

864: mlv.level_id,
865: mlv.sr_level_pk,
866: mlv.level_pk,
867: sysdate,
868: fnd_global.user_id,
869: sysdate,
870: fnd_global.user_id,
871: mlv.system_attribute1,
872: mlv.system_attribute2,

Line 870: fnd_global.user_id,

866: mlv.level_pk,
867: sysdate,
868: fnd_global.user_id,
869: sysdate,
870: fnd_global.user_id,
871: mlv.system_attribute1,
872: mlv.system_attribute2,
873: mlv.dp_enabled_flag
874: from msd_level_values mlv,

Line 893: fnd_global.user_id,

889: level_id,
890: sr_level_pk,
891: level_pk,
892: sysdate,
893: fnd_global.user_id,
894: sysdate,
895: fnd_global.user_id,
896: system_attribute1,
897: system_attribute2,

Line 895: fnd_global.user_id,

891: level_pk,
892: sysdate,
893: fnd_global.user_id,
894: sysdate,
895: fnd_global.user_id,
896: system_attribute1,
897: system_attribute2,
898: dp_enabled_flag
899: from msd_level_values_ds_temp

Line 946: fnd_global.user_id,

942: mlv.level_id,
943: mlv.sr_level_pk,
944: mlv.level_pk,
945: sysdate,
946: fnd_global.user_id,
947: sysdate,
948: fnd_global.user_id,
949: mlv.system_attribute1,
950: mlv.system_attribute2,

Line 948: fnd_global.user_id,

944: mlv.level_pk,
945: sysdate,
946: fnd_global.user_id,
947: sysdate,
948: fnd_global.user_id,
949: mlv.system_attribute1,
950: mlv.system_attribute2,
951: mlv.dp_enabled_flag
952: from msd_level_org_asscns mlo,

Line 970: fnd_global.user_id,

966: level_id,
967: sr_level_pk,
968: level_pk,
969: sysdate,
970: fnd_global.user_id,
971: sysdate,
972: fnd_global.user_id,
973: system_attribute1,
974: system_attribute2,

Line 972: fnd_global.user_id,

968: level_pk,
969: sysdate,
970: fnd_global.user_id,
971: sysdate,
972: fnd_global.user_id,
973: system_attribute1,
974: system_attribute2,
975: dp_enabled_flag
976: from msd_level_values_ds_temp

Line 1065: fnd_global.user_id,

1061: mlv.level_id,
1062: mlv.sr_level_pk,
1063: mlv.level_pk,
1064: sysdate,
1065: fnd_global.user_id,
1066: sysdate,
1067: fnd_global.user_id,
1068: mlv.system_attribute1,
1069: mlv.system_attribute2,

Line 1067: fnd_global.user_id,

1063: mlv.level_pk,
1064: sysdate,
1065: fnd_global.user_id,
1066: sysdate,
1067: fnd_global.user_id,
1068: mlv.system_attribute1,
1069: mlv.system_attribute2,
1070: mlv.dp_enabled_flag
1071: from msd_level_org_asscns mlo,

Line 1095: fnd_global.user_id,

1091: level_id,
1092: sr_level_pk,
1093: level_pk,
1094: sysdate,
1095: fnd_global.user_id,
1096: sysdate,
1097: fnd_global.user_id,
1098: system_attribute1,
1099: system_attribute2,

Line 1097: fnd_global.user_id,

1093: level_pk,
1094: sysdate,
1095: fnd_global.user_id,
1096: sysdate,
1097: fnd_global.user_id,
1098: system_attribute1,
1099: system_attribute2,
1100: dp_enabled_flag
1101: from msd_level_values_ds_temp

Line 1128: fnd_global.user_id,

1124: mlv.level_id,
1125: mlv.sr_level_pk,
1126: mlv.level_pk,
1127: sysdate,
1128: fnd_global.user_id,
1129: sysdate,
1130: fnd_global.user_id,
1131: mlv.system_attribute1,
1132: mlv.system_attribute2,

Line 1130: fnd_global.user_id,

1126: mlv.level_pk,
1127: sysdate,
1128: fnd_global.user_id,
1129: sysdate,
1130: fnd_global.user_id,
1131: mlv.system_attribute1,
1132: mlv.system_attribute2,
1133: mlv.dp_enabled_flag
1134: FROM msd_dp_iso_organizations mdio,

Line 1154: fnd_global.user_id,

1150: level_id,
1151: sr_level_pk,
1152: level_pk,
1153: sysdate,
1154: fnd_global.user_id,
1155: sysdate,
1156: fnd_global.user_id,
1157: system_attribute1,
1158: system_attribute2,

Line 1156: fnd_global.user_id,

1152: level_pk,
1153: sysdate,
1154: fnd_global.user_id,
1155: sysdate,
1156: fnd_global.user_id,
1157: system_attribute1,
1158: system_attribute2,
1159: dp_enabled_flag
1160: FROM msd_level_values_ds_temp

Line 1209: fnd_global.user_id,

1205: mlv.level_id,
1206: mlv.sr_level_pk,
1207: mlv.level_pk,
1208: sysdate,
1209: fnd_global.user_id,
1210: sysdate,
1211: fnd_global.user_id,
1212: mlv.system_attribute1,
1213: mlv.system_attribute2,

Line 1211: fnd_global.user_id,

1207: mlv.level_pk,
1208: sysdate,
1209: fnd_global.user_id,
1210: sysdate,
1211: fnd_global.user_id,
1212: mlv.system_attribute1,
1213: mlv.system_attribute2,
1214: mlv.dp_enabled_flag
1215: from msd_level_values mlv,

Line 1226: fnd_global.user_id,

1222: level_id,
1223: sr_level_pk,
1224: level_pk,
1225: sysdate,
1226: fnd_global.user_id,
1227: sysdate,
1228: fnd_global.user_id,
1229: system_attribute1,
1230: system_attribute2,

Line 1228: fnd_global.user_id,

1224: level_pk,
1225: sysdate,
1226: fnd_global.user_id,
1227: sysdate,
1228: fnd_global.user_id,
1229: system_attribute1,
1230: system_attribute2,
1231: dp_enabled_flag
1232: from msd_level_values_ds_temp

Line 1258: fnd_global.user_id,

1254: mlv.level_id,
1255: mlv.sr_level_pk,
1256: mlv.level_pk,
1257: sysdate,
1258: fnd_global.user_id,
1259: sysdate,
1260: fnd_global.user_id,
1261: mlv.system_attribute1,
1262: mlv.system_attribute2,

Line 1260: fnd_global.user_id,

1256: mlv.level_pk,
1257: sysdate,
1258: fnd_global.user_id,
1259: sysdate,
1260: fnd_global.user_id,
1261: mlv.system_attribute1,
1262: mlv.system_attribute2,
1263: mlv.dp_enabled_flag
1264: from msd_level_values mlv,

Line 1275: fnd_global.user_id,

1271: level_id,
1272: sr_level_pk,
1273: level_pk,
1274: sysdate,
1275: fnd_global.user_id,
1276: sysdate,
1277: fnd_global.user_id,
1278: system_attribute1,
1279: system_attribute2,

Line 1277: fnd_global.user_id,

1273: level_pk,
1274: sysdate,
1275: fnd_global.user_id,
1276: sysdate,
1277: fnd_global.user_id,
1278: system_attribute1,
1279: system_attribute2,
1280: dp_enabled_flag
1281: from msd_level_values_ds_temp

Line 1307: fnd_global.user_id,

1303: mlv.level_id,
1304: mlv.sr_level_pk,
1305: mlv.level_pk,
1306: sysdate,
1307: fnd_global.user_id,
1308: sysdate,
1309: fnd_global.user_id,
1310: mlv.system_attribute1,
1311: mlv.system_attribute2,

Line 1309: fnd_global.user_id,

1305: mlv.level_pk,
1306: sysdate,
1307: fnd_global.user_id,
1308: sysdate,
1309: fnd_global.user_id,
1310: mlv.system_attribute1,
1311: mlv.system_attribute2,
1312: mlv.dp_enabled_flag
1313: from msd_level_values mlv,

Line 1324: fnd_global.user_id,

1320: level_id,
1321: sr_level_pk,
1322: level_pk,
1323: sysdate,
1324: fnd_global.user_id,
1325: sysdate,
1326: fnd_global.user_id,
1327: system_attribute1,
1328: system_attribute2,

Line 1326: fnd_global.user_id,

1322: level_pk,
1323: sysdate,
1324: fnd_global.user_id,
1325: sysdate,
1326: fnd_global.user_id,
1327: system_attribute1,
1328: system_attribute2,
1329: dp_enabled_flag
1330: from msd_level_values_ds_temp

Line 1356: fnd_global.user_id,

1352: mlv.level_id,
1353: mlv.sr_level_pk,
1354: mlv.level_pk,
1355: sysdate,
1356: fnd_global.user_id,
1357: sysdate,
1358: fnd_global.user_id,
1359: mlv.system_attribute1,
1360: mlv.system_attribute2,

Line 1358: fnd_global.user_id,

1354: mlv.level_pk,
1355: sysdate,
1356: fnd_global.user_id,
1357: sysdate,
1358: fnd_global.user_id,
1359: mlv.system_attribute1,
1360: mlv.system_attribute2,
1361: mlv.dp_enabled_flag
1362: from msd_level_values mlv,

Line 1373: fnd_global.user_id,

1369: level_id,
1370: sr_level_pk,
1371: level_pk,
1372: sysdate,
1373: fnd_global.user_id,
1374: sysdate,
1375: fnd_global.user_id,
1376: system_attribute1,
1377: system_attribute2,

Line 1375: fnd_global.user_id,

1371: level_pk,
1372: sysdate,
1373: fnd_global.user_id,
1374: sysdate,
1375: fnd_global.user_id,
1376: system_attribute1,
1377: system_attribute2,
1378: dp_enabled_flag
1379: from msd_level_values_ds_temp

Line 1485: -- fnd_global.user_id,

1481: -- csd.cs_data_id,
1482: -- csd.cs_definition_id,
1483: -- csd.cs_name,
1484: -- sysdate,
1485: -- fnd_global.user_id,
1486: -- sysdate,
1487: -- fnd_global.user_id
1488: -- from (select demand_plan_id from msd_dp_session) mds,
1489: -- msd_cs_data_v1 csd,

Line 1487: -- fnd_global.user_id

1483: -- csd.cs_name,
1484: -- sysdate,
1485: -- fnd_global.user_id,
1486: -- sysdate,
1487: -- fnd_global.user_id
1488: -- from (select demand_plan_id from msd_dp_session) mds,
1489: -- msd_cs_data_v1 csd,
1490: -- msd_level_values_ds mld
1491: -- where csd.cs_definition_id = 21

Line 1617: 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 ';

1613:
1614: v_sql_stmt := v_sql_stmt || ' insert into msd_cs_data_ds ';
1615: v_sql_stmt := v_sql_stmt || ' (demand_plan_id, cs_data_id, cs_definition_id, cs_name, ';
1616: v_sql_stmt := v_sql_stmt || ' last_update_date, last_updated_by, creation_date, created_by) ';
1617: 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 ';
1618: v_sql_stmt := v_sql_stmt || ' from (select demand_plan_id from msd_dp_session) mds, ';
1619: v_sql_stmt := v_sql_stmt || ' msd_cs_data_v1 cdv ';
1620: 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;
1621:

Line 1751: fnd_global.user_id,

1747: p_stripe_level_id,
1748: p_stripe_sr_level_pk,
1749: l_c1_rec.level_pk,
1750: sysdate,
1751: fnd_global.user_id,
1752: sysdate,
1753: fnd_global.user_id,
1754: l_c1_rec.system_attribute1, -- Bug# 4937978
1755: l_c1_rec.system_attribute2,

Line 1753: fnd_global.user_id,

1749: l_c1_rec.level_pk,
1750: sysdate,
1751: fnd_global.user_id,
1752: sysdate,
1753: fnd_global.user_id,
1754: l_c1_rec.system_attribute1, -- Bug# 4937978
1755: l_c1_rec.system_attribute2,
1756: l_c1_rec.dp_enabled_flag
1757: );

Line 2191: fnd_global.user_id,

2187: null,
2188: null,
2189: refresh_num,
2190: sysdate,
2191: fnd_global.user_id,
2192: sysdate,
2193: fnd_global.user_id
2194: from msd_dp_parameters_ds
2195: where demand_plan_id = C_LEVEL_PLAN

Line 2193: fnd_global.user_id

2189: refresh_num,
2190: sysdate,
2191: fnd_global.user_id,
2192: sysdate,
2193: fnd_global.user_id
2194: from msd_dp_parameters_ds
2195: where demand_plan_id = C_LEVEL_PLAN
2196: and data_type = C_LVL_VAL
2197: union all

Line 2204: fnd_global.user_id,

2200: mdp.parameter_type,
2201: mdp.parameter_name,
2202: max(csh.last_refresh_num),
2203: sysdate,
2204: fnd_global.user_id,
2205: sysdate,
2206: fnd_global.user_id
2207: from msd_dp_parameters mdp,
2208: msd_cs_data_headers csh,

Line 2206: fnd_global.user_id

2202: max(csh.last_refresh_num),
2203: sysdate,
2204: fnd_global.user_id,
2205: sysdate,
2206: fnd_global.user_id
2207: from msd_dp_parameters mdp,
2208: msd_cs_data_headers csh,
2209: msd_cs_definitions csd
2210: where mdp.parameter_type = csd.name

Line 2222: fnd_global.user_id,

2218: mdd.dimension_code,
2219: null,
2220: null,
2221: sysdate,
2222: fnd_global.user_id,
2223: sysdate,
2224: fnd_global.user_id
2225: from msd_dp_dimensions mdd
2226: where mdd.demand_plan_id = p_demand_plan_id;

Line 2224: fnd_global.user_id

2220: null,
2221: sysdate,
2222: fnd_global.user_id,
2223: sysdate,
2224: fnd_global.user_id
2225: from msd_dp_dimensions mdd
2226: where mdd.demand_plan_id = p_demand_plan_id;
2227:
2228: if l_debug = C_YES_FLAG then

Line 2536: fnd_global.user_id,

2532: p_stripe_level_id,
2533: p_stripe_sr_level_pk,
2534: l_c1_rec.level_pk,
2535: sysdate,
2536: fnd_global.user_id,
2537: sysdate,
2538: fnd_global.user_id,
2539: l_c1_rec.system_attribute1, -- Bug# 4937978
2540: l_c1_rec.system_attribute2,

Line 2538: fnd_global.user_id,

2534: l_c1_rec.level_pk,
2535: sysdate,
2536: fnd_global.user_id,
2537: sysdate,
2538: fnd_global.user_id,
2539: l_c1_rec.system_attribute1, -- Bug# 4937978
2540: l_c1_rec.system_attribute2,
2541: l_c1_rec.dp_enabled_flag
2542: );

Line 2747: ' fnd_global.user_id, ' ||

2743: ' mlv.level_id, ' ||
2744: ' mlv.sr_level_pk, ' ||
2745: ' mlv.level_pk, ' ||
2746: ' sysdate, ' ||
2747: ' fnd_global.user_id, ' ||
2748: ' sysdate, ' ||
2749: ' fnd_global.user_id, ' ||
2750: ' mlv.system_attribute1, ' ||
2751: ' mlv.system_attribute2, ' ||

Line 2749: ' fnd_global.user_id, ' ||

2745: ' mlv.level_pk, ' ||
2746: ' sysdate, ' ||
2747: ' fnd_global.user_id, ' ||
2748: ' sysdate, ' ||
2749: ' fnd_global.user_id, ' ||
2750: ' mlv.system_attribute1, ' ||
2751: ' mlv.system_attribute2, ' ||
2752: ' mlv.dp_enabled_flag ' ||
2753: ' from msd_level_values mlv, ' ||

Line 3008: fnd_global.user_id,

3004: mlv.level_id,
3005: mlv.sr_level_pk,
3006: mlv.level_pk,
3007: sysdate,
3008: fnd_global.user_id,
3009: sysdate,
3010: fnd_global.user_id,
3011: mlv.system_attribute1,
3012: mlv.system_attribute2,

Line 3010: fnd_global.user_id,

3006: mlv.level_pk,
3007: sysdate,
3008: fnd_global.user_id,
3009: sysdate,
3010: fnd_global.user_id,
3011: mlv.system_attribute1,
3012: mlv.system_attribute2,
3013: mlv.dp_enabled_flag
3014: from msd_dp_events mde,

Line 3042: fnd_global.user_id,

3038: level_id,
3039: sr_level_pk,
3040: level_pk,
3041: sysdate,
3042: fnd_global.user_id,
3043: sysdate,
3044: fnd_global.user_id,
3045: system_attribute1,
3046: system_attribute2,

Line 3044: fnd_global.user_id,

3040: level_pk,
3041: sysdate,
3042: fnd_global.user_id,
3043: sysdate,
3044: fnd_global.user_id,
3045: system_attribute1,
3046: system_attribute2,
3047: dp_enabled_flag
3048: from msd_level_values_ds_temp

Line 3153: fnd_global.user_id,

3149: C_PSEUDO_PK,
3150: C_PSEUDO_PK,
3151: C_PSEUDO_PK,
3152: sysdate,
3153: fnd_global.user_id,
3154: sysdate,
3155: fnd_global.user_id
3156: );
3157:

Line 3155: fnd_global.user_id

3151: C_PSEUDO_PK,
3152: sysdate,
3153: fnd_global.user_id,
3154: sysdate,
3155: fnd_global.user_id
3156: );
3157:
3158: end if;
3159:

Line 3211: fnd_global.user_id,

3207: mlv.level_id,
3208: mlv.sr_level_pk,
3209: mlv.level_pk,
3210: sysdate,
3211: fnd_global.user_id,
3212: sysdate,
3213: fnd_global.user_id,
3214: mlv.system_attribute1,
3215: mlv.system_attribute2,

Line 3213: fnd_global.user_id,

3209: mlv.level_pk,
3210: sysdate,
3211: fnd_global.user_id,
3212: sysdate,
3213: fnd_global.user_id,
3214: mlv.system_attribute1,
3215: mlv.system_attribute2,
3216: mlv.dp_enabled_flag
3217: from msd_level_values mlv

Line 3226: fnd_global.user_id,

3222: level_id,
3223: sr_level_pk,
3224: level_pk,
3225: sysdate,
3226: fnd_global.user_id,
3227: sysdate,
3228: fnd_global.user_id,
3229: system_attribute1,
3230: system_attribute2,

Line 3228: fnd_global.user_id,

3224: level_pk,
3225: sysdate,
3226: fnd_global.user_id,
3227: sysdate,
3228: fnd_global.user_id,
3229: system_attribute1,
3230: system_attribute2,
3231: dp_enabled_flag
3232: from msd_level_values_ds_temp

Line 3273: fnd_global.user_id,

3269: mlv.level_id,
3270: mlv.sr_level_pk,
3271: mlv.level_pk,
3272: sysdate,
3273: fnd_global.user_id,
3274: sysdate,
3275: fnd_global.user_id,
3276: mlv.system_attribute1,
3277: mlv.system_attribute2,

Line 3275: fnd_global.user_id,

3271: mlv.level_pk,
3272: sysdate,
3273: fnd_global.user_id,
3274: sysdate,
3275: fnd_global.user_id,
3276: mlv.system_attribute1,
3277: mlv.system_attribute2,
3278: mlv.dp_enabled_flag
3279: from msd_level_values mlv

Line 3289: fnd_global.user_id,

3285: level_id,
3286: sr_level_pk,
3287: level_pk,
3288: sysdate,
3289: fnd_global.user_id,
3290: sysdate,
3291: fnd_global.user_id,
3292: system_attribute1,
3293: system_attribute2,

Line 3291: fnd_global.user_id,

3287: level_pk,
3288: sysdate,
3289: fnd_global.user_id,
3290: sysdate,
3291: fnd_global.user_id,
3292: system_attribute1,
3293: system_attribute2,
3294: dp_enabled_flag
3295: from msd_level_values_ds_temp

Line 3366: fnd_global.user_id,

3362: mlv.level_id,
3363: mlv.sr_level_pk,
3364: mlv.level_pk,
3365: sysdate,
3366: fnd_global.user_id,
3367: sysdate,
3368: fnd_global.user_id,
3369: mlv.system_attribute1,
3370: mlv.system_attribute2,

Line 3368: fnd_global.user_id,

3364: mlv.level_pk,
3365: sysdate,
3366: fnd_global.user_id,
3367: sysdate,
3368: fnd_global.user_id,
3369: mlv.system_attribute1,
3370: mlv.system_attribute2,
3371: mlv.dp_enabled_flag
3372: from msd_level_values mlv

Line 3381: fnd_global.user_id,

3377: level_id,
3378: sr_level_pk,
3379: level_pk,
3380: sysdate,
3381: fnd_global.user_id,
3382: sysdate,
3383: fnd_global.user_id,
3384: system_attribute1,
3385: system_attribute2,

Line 3383: fnd_global.user_id,

3379: level_pk,
3380: sysdate,
3381: fnd_global.user_id,
3382: sysdate,
3383: fnd_global.user_id,
3384: system_attribute1,
3385: system_attribute2,
3386: dp_enabled_flag
3387: from msd_level_values_ds_temp