DBA Data[Home] [Help]

APPS.BSC_CUSTOM_VIEW_UI_WRAPPER dependencies on FND_GLOBAL

Line 950: X_CREATED_BY => fnd_global.user_id,

946: X_FONT_COLOR => p_font_color,
947: X_URL => null,
948: X_FUNCTION_ID => p_function_id,
949: X_CREATION_DATE => SYSDATE,
950: X_CREATED_BY => fnd_global.user_id,
951: X_LAST_UPDATE_DATE => SYSDATE,
952: X_LAST_UPDATED_BY => fnd_global.user_id,
953: X_LAST_UPDATE_LOGIN => fnd_global.login_id
954: );

Line 952: X_LAST_UPDATED_BY => fnd_global.user_id,

948: X_FUNCTION_ID => p_function_id,
949: X_CREATION_DATE => SYSDATE,
950: X_CREATED_BY => fnd_global.user_id,
951: X_LAST_UPDATE_DATE => SYSDATE,
952: X_LAST_UPDATED_BY => fnd_global.user_id,
953: X_LAST_UPDATE_LOGIN => fnd_global.login_id
954: );
955: ELSE
956: --update

Line 953: X_LAST_UPDATE_LOGIN => fnd_global.login_id

949: X_CREATION_DATE => SYSDATE,
950: X_CREATED_BY => fnd_global.user_id,
951: X_LAST_UPDATE_DATE => SYSDATE,
952: X_LAST_UPDATED_BY => fnd_global.user_id,
953: X_LAST_UPDATE_LOGIN => fnd_global.login_id
954: );
955: ELSE
956: --update
957: BSC_TAB_VIEW_LABELS_PKG.UPDATE_ROW (

Line 976: X_CREATED_BY => fnd_global.user_id,

972: X_FONT_COLOR => p_font_color,
973: X_URL => null,
974: X_FUNCTION_ID => p_function_id,
975: X_CREATION_DATE => SYSDATE,
976: X_CREATED_BY => fnd_global.user_id,
977: X_LAST_UPDATE_DATE => SYSDATE,
978: X_LAST_UPDATED_BY => fnd_global.user_id,
979: X_LAST_UPDATE_LOGIN => fnd_global.login_id
980: );

Line 978: X_LAST_UPDATED_BY => fnd_global.user_id,

974: X_FUNCTION_ID => p_function_id,
975: X_CREATION_DATE => SYSDATE,
976: X_CREATED_BY => fnd_global.user_id,
977: X_LAST_UPDATE_DATE => SYSDATE,
978: X_LAST_UPDATED_BY => fnd_global.user_id,
979: X_LAST_UPDATE_LOGIN => fnd_global.login_id
980: );
981: END IF;
982:

Line 979: X_LAST_UPDATE_LOGIN => fnd_global.login_id

975: X_CREATION_DATE => SYSDATE,
976: X_CREATED_BY => fnd_global.user_id,
977: X_LAST_UPDATE_DATE => SYSDATE,
978: X_LAST_UPDATED_BY => fnd_global.user_id,
979: X_LAST_UPDATE_LOGIN => fnd_global.login_id
980: );
981: END IF;
982:
983: EXCEPTION

Line 1045: X_CREATED_BY => fnd_global.user_id,

1041: X_COLOR_WIDTH => p_alarm_width,
1042: X_COLOR_HEIGHT => p_alarm_height,
1043: X_COLOR_SIZE => 0,
1044: X_CREATION_DATE => SYSDATE,
1045: X_CREATED_BY => fnd_global.user_id,
1046: X_LAST_UPDATE_DATE => SYSDATE,
1047: X_LAST_UPDATED_BY => fnd_global.user_id,
1048: X_LAST_UPDATE_LOGIN => fnd_global.login_id
1049: );

Line 1047: X_LAST_UPDATED_BY => fnd_global.user_id,

1043: X_COLOR_SIZE => 0,
1044: X_CREATION_DATE => SYSDATE,
1045: X_CREATED_BY => fnd_global.user_id,
1046: X_LAST_UPDATE_DATE => SYSDATE,
1047: X_LAST_UPDATED_BY => fnd_global.user_id,
1048: X_LAST_UPDATE_LOGIN => fnd_global.login_id
1049: );
1050: ELSE
1051: --update

Line 1048: X_LAST_UPDATE_LOGIN => fnd_global.login_id

1044: X_CREATION_DATE => SYSDATE,
1045: X_CREATED_BY => fnd_global.user_id,
1046: X_LAST_UPDATE_DATE => SYSDATE,
1047: X_LAST_UPDATED_BY => fnd_global.user_id,
1048: X_LAST_UPDATE_LOGIN => fnd_global.login_id
1049: );
1050: ELSE
1051: --update
1052: BSC_TAB_VIEW_KPI_PKG.UPDATE_ROW(

Line 1070: X_CREATED_BY => fnd_global.user_id,

1066: X_COLOR_WIDTH => p_alarm_width,
1067: X_COLOR_HEIGHT => p_alarm_height,
1068: X_COLOR_SIZE => 0,
1069: X_CREATION_DATE => SYSDATE,
1070: X_CREATED_BY => fnd_global.user_id,
1071: X_LAST_UPDATE_DATE => SYSDATE,
1072: X_LAST_UPDATED_BY => fnd_global.user_id,
1073: X_LAST_UPDATE_LOGIN => fnd_global.login_id
1074: );

Line 1072: X_LAST_UPDATED_BY => fnd_global.user_id,

1068: X_COLOR_SIZE => 0,
1069: X_CREATION_DATE => SYSDATE,
1070: X_CREATED_BY => fnd_global.user_id,
1071: X_LAST_UPDATE_DATE => SYSDATE,
1072: X_LAST_UPDATED_BY => fnd_global.user_id,
1073: X_LAST_UPDATE_LOGIN => fnd_global.login_id
1074: );
1075: END IF;
1076:

Line 1073: X_LAST_UPDATE_LOGIN => fnd_global.login_id

1069: X_CREATION_DATE => SYSDATE,
1070: X_CREATED_BY => fnd_global.user_id,
1071: X_LAST_UPDATE_DATE => SYSDATE,
1072: X_LAST_UPDATED_BY => fnd_global.user_id,
1073: X_LAST_UPDATE_LOGIN => fnd_global.login_id
1074: );
1075: END IF;
1076:
1077: EXCEPTION

Line 1116: X_CREATED_BY => fnd_global.user_id,

1112: X_DESCRIPTION => p_description,
1113: X_WIDTH => p_width,
1114: X_HEIGHT => p_height,
1115: X_MIME_TYPE => p_mime_type,
1116: X_CREATED_BY => fnd_global.user_id,
1117: X_LAST_UPDATED_BY => fnd_global.user_id,
1118: X_LAST_UPDATE_LOGIN => fnd_global.login_id
1119: );
1120:

Line 1117: X_LAST_UPDATED_BY => fnd_global.user_id,

1113: X_WIDTH => p_width,
1114: X_HEIGHT => p_height,
1115: X_MIME_TYPE => p_mime_type,
1116: X_CREATED_BY => fnd_global.user_id,
1117: X_LAST_UPDATED_BY => fnd_global.user_id,
1118: X_LAST_UPDATE_LOGIN => fnd_global.login_id
1119: );
1120:
1121: EXCEPTION

Line 1118: X_LAST_UPDATE_LOGIN => fnd_global.login_id

1114: X_HEIGHT => p_height,
1115: X_MIME_TYPE => p_mime_type,
1116: X_CREATED_BY => fnd_global.user_id,
1117: X_LAST_UPDATED_BY => fnd_global.user_id,
1118: X_LAST_UPDATE_LOGIN => fnd_global.login_id
1119: );
1120:
1121: EXCEPTION
1122: WHEN others THEN

Line 1135: X_CREATED_BY => fnd_global.user_id,

1131: X_SOURCE_CODE => p_tab_id,
1132: X_TYPE => p_tab_view_id,
1133: X_IMAGE_ID => l_next_image_id,
1134: X_CREATION_DATE => SYSDATE,
1135: X_CREATED_BY => fnd_global.user_id,
1136: X_LAST_UPDATE_DATE => SYSDATE,
1137: X_LAST_UPDATED_BY => fnd_global.user_id,
1138: X_LAST_UPDATE_LOGIN => fnd_global.login_id
1139: );

Line 1137: X_LAST_UPDATED_BY => fnd_global.user_id,

1133: X_IMAGE_ID => l_next_image_id,
1134: X_CREATION_DATE => SYSDATE,
1135: X_CREATED_BY => fnd_global.user_id,
1136: X_LAST_UPDATE_DATE => SYSDATE,
1137: X_LAST_UPDATED_BY => fnd_global.user_id,
1138: X_LAST_UPDATE_LOGIN => fnd_global.login_id
1139: );
1140: EXCEPTION
1141: WHEN others THEN

Line 1138: X_LAST_UPDATE_LOGIN => fnd_global.login_id

1134: X_CREATION_DATE => SYSDATE,
1135: X_CREATED_BY => fnd_global.user_id,
1136: X_LAST_UPDATE_DATE => SYSDATE,
1137: X_LAST_UPDATED_BY => fnd_global.user_id,
1138: X_LAST_UPDATE_LOGIN => fnd_global.login_id
1139: );
1140: EXCEPTION
1141: WHEN others THEN
1142: ROLLBACK TO RollBackPt;

Line 1202: LAST_UPDATED_BY = fnd_global.user_id,

1198: WIDTH = p_width,
1199: HEIGHT = p_height,
1200: MIME_TYPE = p_mime_type,
1201: LAST_UPDATE_DATE = SYSDATE,
1202: LAST_UPDATED_BY = fnd_global.user_id,
1203: LAST_UPDATE_LOGIN = fnd_global.login_id,
1204: FILE_BODY = EMPTY_BLOB()
1205: WHERE IMAGE_ID = p_image_id
1206: AND LAST_UPDATE_DATE <= SYSDATE;

Line 1203: LAST_UPDATE_LOGIN = fnd_global.login_id,

1199: HEIGHT = p_height,
1200: MIME_TYPE = p_mime_type,
1201: LAST_UPDATE_DATE = SYSDATE,
1202: LAST_UPDATED_BY = fnd_global.user_id,
1203: LAST_UPDATE_LOGIN = fnd_global.login_id,
1204: FILE_BODY = EMPTY_BLOB()
1205: WHERE IMAGE_ID = p_image_id
1206: AND LAST_UPDATE_DATE <= SYSDATE;
1207: EXCEPTION

Line 1221: X_CREATED_BY => fnd_global.user_id,

1217: X_SOURCE_CODE => p_tab_id,
1218: X_TYPE => p_tab_view_id,
1219: X_IMAGE_ID => p_image_id,
1220: X_CREATION_DATE => SYSDATE,
1221: X_CREATED_BY => fnd_global.user_id,
1222: X_LAST_UPDATE_DATE => SYSDATE,
1223: X_LAST_UPDATED_BY => fnd_global.user_id,
1224: X_LAST_UPDATE_LOGIN => fnd_global.login_id
1225: );

Line 1223: X_LAST_UPDATED_BY => fnd_global.user_id,

1219: X_IMAGE_ID => p_image_id,
1220: X_CREATION_DATE => SYSDATE,
1221: X_CREATED_BY => fnd_global.user_id,
1222: X_LAST_UPDATE_DATE => SYSDATE,
1223: X_LAST_UPDATED_BY => fnd_global.user_id,
1224: X_LAST_UPDATE_LOGIN => fnd_global.login_id
1225: );
1226:
1227: ELSE

Line 1224: X_LAST_UPDATE_LOGIN => fnd_global.login_id

1220: X_CREATION_DATE => SYSDATE,
1221: X_CREATED_BY => fnd_global.user_id,
1222: X_LAST_UPDATE_DATE => SYSDATE,
1223: X_LAST_UPDATED_BY => fnd_global.user_id,
1224: X_LAST_UPDATE_LOGIN => fnd_global.login_id
1225: );
1226:
1227: ELSE
1228: --image not owned by this NLS session, need to create a new image and update the image map

Line 1240: X_CREATED_BY => fnd_global.user_id,

1236: X_DESCRIPTION => p_description,
1237: X_WIDTH => p_width,
1238: X_HEIGHT => p_height,
1239: X_MIME_TYPE => p_mime_type,
1240: X_CREATED_BY => fnd_global.user_id,
1241: X_LAST_UPDATED_BY => fnd_global.user_id,
1242: X_LAST_UPDATE_LOGIN => fnd_global.login_id
1243: );
1244:

Line 1241: X_LAST_UPDATED_BY => fnd_global.user_id,

1237: X_WIDTH => p_width,
1238: X_HEIGHT => p_height,
1239: X_MIME_TYPE => p_mime_type,
1240: X_CREATED_BY => fnd_global.user_id,
1241: X_LAST_UPDATED_BY => fnd_global.user_id,
1242: X_LAST_UPDATE_LOGIN => fnd_global.login_id
1243: );
1244:
1245: EXCEPTION

Line 1242: X_LAST_UPDATE_LOGIN => fnd_global.login_id

1238: X_HEIGHT => p_height,
1239: X_MIME_TYPE => p_mime_type,
1240: X_CREATED_BY => fnd_global.user_id,
1241: X_LAST_UPDATED_BY => fnd_global.user_id,
1242: X_LAST_UPDATE_LOGIN => fnd_global.login_id
1243: );
1244:
1245: EXCEPTION
1246: WHEN others THEN

Line 1259: X_CREATED_BY => fnd_global.user_id,

1255: X_SOURCE_CODE => p_tab_id,
1256: X_TYPE => p_tab_view_id,
1257: X_IMAGE_ID => l_next_image_id,
1258: X_CREATION_DATE => SYSDATE,
1259: X_CREATED_BY => fnd_global.user_id,
1260: X_LAST_UPDATE_DATE => SYSDATE,
1261: X_LAST_UPDATED_BY => fnd_global.user_id,
1262: X_LAST_UPDATE_LOGIN => fnd_global.login_id
1263: );

Line 1261: X_LAST_UPDATED_BY => fnd_global.user_id,

1257: X_IMAGE_ID => l_next_image_id,
1258: X_CREATION_DATE => SYSDATE,
1259: X_CREATED_BY => fnd_global.user_id,
1260: X_LAST_UPDATE_DATE => SYSDATE,
1261: X_LAST_UPDATED_BY => fnd_global.user_id,
1262: X_LAST_UPDATE_LOGIN => fnd_global.login_id
1263: );
1264: END IF;
1265:

Line 1262: X_LAST_UPDATE_LOGIN => fnd_global.login_id

1258: X_CREATION_DATE => SYSDATE,
1259: X_CREATED_BY => fnd_global.user_id,
1260: X_LAST_UPDATE_DATE => SYSDATE,
1261: X_LAST_UPDATED_BY => fnd_global.user_id,
1262: X_LAST_UPDATE_LOGIN => fnd_global.login_id
1263: );
1264: END IF;
1265:
1266: ELSE

Line 1336: X_LAST_UPDATED_BY => fnd_global.user_id,

1332: X_ENABLED_FLAG => l_enabled_flag,
1333: X_NAME => p_name,
1334: X_HELP => p_description,
1335: X_LAST_UPDATE_DATE => SYSDATE,
1336: X_LAST_UPDATED_BY => fnd_global.user_id,
1337: X_LAST_UPDATE_LOGIN => fnd_global.login_id
1338: );
1339: ELSE
1340: BEGIN

Line 1337: X_LAST_UPDATE_LOGIN => fnd_global.login_id

1333: X_NAME => p_name,
1334: X_HELP => p_description,
1335: X_LAST_UPDATE_DATE => SYSDATE,
1336: X_LAST_UPDATED_BY => fnd_global.user_id,
1337: X_LAST_UPDATE_LOGIN => fnd_global.login_id
1338: );
1339: ELSE
1340: BEGIN
1341: BSC_TAB_VIEWS_PKG.INSERT_ROW(

Line 1349: X_CREATED_BY => fnd_global.user_id,

1345: X_ENABLED_FLAG => p_enable_flag,
1346: X_NAME => p_name,
1347: X_HELP => p_description,
1348: X_CREATION_DATE => SYSDATE,
1349: X_CREATED_BY => fnd_global.user_id,
1350: X_LAST_UPDATE_DATE => SYSDATE,
1351: X_LAST_UPDATED_BY => fnd_global.user_id,
1352: X_LAST_UPDATE_LOGIN => fnd_global.login_id
1353: );

Line 1351: X_LAST_UPDATED_BY => fnd_global.user_id,

1347: X_HELP => p_description,
1348: X_CREATION_DATE => SYSDATE,
1349: X_CREATED_BY => fnd_global.user_id,
1350: X_LAST_UPDATE_DATE => SYSDATE,
1351: X_LAST_UPDATED_BY => fnd_global.user_id,
1352: X_LAST_UPDATE_LOGIN => fnd_global.login_id
1353: );
1354:
1355: EXCEPTION

Line 1352: X_LAST_UPDATE_LOGIN => fnd_global.login_id

1348: X_CREATION_DATE => SYSDATE,
1349: X_CREATED_BY => fnd_global.user_id,
1350: X_LAST_UPDATE_DATE => SYSDATE,
1351: X_LAST_UPDATED_BY => fnd_global.user_id,
1352: X_LAST_UPDATE_LOGIN => fnd_global.login_id
1353: );
1354:
1355: EXCEPTION
1356: WHEN others THEN

Line 1365: LAST_UPDATED_BY = fnd_global.user_id,

1361: END;
1362:
1363: UPDATE BSC_TABS_B
1364: SET LAST_UPDATE_DATE = SYSDATE,
1365: LAST_UPDATED_BY = fnd_global.user_id,
1366: LAST_UPDATE_LOGIN = fnd_global.login_id
1367: WHERE TAB_ID = p_tab_id;
1368: END IF;
1369:

Line 1366: LAST_UPDATE_LOGIN = fnd_global.login_id

1362:
1363: UPDATE BSC_TABS_B
1364: SET LAST_UPDATE_DATE = SYSDATE,
1365: LAST_UPDATED_BY = fnd_global.user_id,
1366: LAST_UPDATE_LOGIN = fnd_global.login_id
1367: WHERE TAB_ID = p_tab_id;
1368: END IF;
1369:
1370: -- Enh 3934298, for each new custom view will create/update a form function to use in DBI

Line 1640: X_CREATED_BY => fnd_global.user_id,

1636: X_TYPE => C_FUNC_TYPE,
1637: X_USER_FUNCTION_NAME => p_name,
1638: X_DESCRIPTION => p_description,
1639: X_CREATION_DATE => sysdate,
1640: X_CREATED_BY => fnd_global.user_id,
1641: X_LAST_UPDATE_DATE => sysdate,
1642: X_LAST_UPDATED_BY => fnd_global.user_id,
1643: X_LAST_UPDATE_LOGIN => fnd_global.user_id,
1644: X_MAINTENANCE_MODE_SUPPORT => NULL,

Line 1642: X_LAST_UPDATED_BY => fnd_global.user_id,

1638: X_DESCRIPTION => p_description,
1639: X_CREATION_DATE => sysdate,
1640: X_CREATED_BY => fnd_global.user_id,
1641: X_LAST_UPDATE_DATE => sysdate,
1642: X_LAST_UPDATED_BY => fnd_global.user_id,
1643: X_LAST_UPDATE_LOGIN => fnd_global.user_id,
1644: X_MAINTENANCE_MODE_SUPPORT => NULL,
1645: X_CONTEXT_DEPENDENCE => NULL);
1646:

Line 1643: X_LAST_UPDATE_LOGIN => fnd_global.user_id,

1639: X_CREATION_DATE => sysdate,
1640: X_CREATED_BY => fnd_global.user_id,
1641: X_LAST_UPDATE_DATE => sysdate,
1642: X_LAST_UPDATED_BY => fnd_global.user_id,
1643: X_LAST_UPDATE_LOGIN => fnd_global.user_id,
1644: X_MAINTENANCE_MODE_SUPPORT => NULL,
1645: X_CONTEXT_DEPENDENCE => NULL);
1646:
1647: if l_ROWID is not null then

Line 1673: ,X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

1669: ,X_TYPE => C_FUNC_TYPE
1670: ,X_USER_FUNCTION_NAME => p_name
1671: ,X_DESCRIPTION => p_description
1672: ,X_LAST_UPDATE_DATE => SYSDATE
1673: ,X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
1674: ,X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID
1675: );
1676: END IF;
1677:

Line 1674: ,X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID

1670: ,X_USER_FUNCTION_NAME => p_name
1671: ,X_DESCRIPTION => p_description
1672: ,X_LAST_UPDATE_DATE => SYSDATE
1673: ,X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
1674: ,X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID
1675: );
1676: END IF;
1677:
1678: x_return_status := FND_API.G_RET_STS_SUCCESS;