520: END IF;
521:
522: EXCEPTION
523: WHEN OTHERS THEN
524: Wf_Core.Context('wf_activities_vl_pub',
525: 'fetch_activities',
526: p_item_type,
527: p_activity_type,
528: TO_CHAR(p_effective_date),
618: FALSE);
619:
620: EXCEPTION
621: WHEN OTHERS THEN
622: Wf_Core.Context('wf_activities_vl_pub',
623: 'fetch_draw_activity_details',
624: p_item_type,
625: p_activity_type,
626: p_effective_date,
693:
694: /*
695: ** Set the the processes title.
696: */
697: l_summary_section_title := wf_core.translate('PROCESSES');
698:
699: /*
700: ** Set the indicator for the highest activity found. This is
701: ** used later to print any missing headers.
706:
707: /*
708: ** Set the the notifications title.
709: */
710: l_summary_section_title := wf_core.translate('WFITD_NOTIFICATIONS');
711:
712: /*
713: ** Check to see if you skipped the processes section in case
714: ** there weren't any. If so print out the header for the processes
730:
731: /*
732: ** Set the functions title.
733: */
734: l_summary_section_title := wf_core.translate('WFITD_FUNCTIONS');
735:
736: /*
737: ** Check to see if you skipped the processes and or Notifications
738: ** section in case there weren't any. If so print out the
753:
754: /*
755: ** Set the functions title.
756: */
757: l_summary_section_title := wf_core.translate('WFITD_EVENTS');
758:
759: /*
760: ** Check to see if you skipped the processes and or Notifications
761: ** section in case there weren't any. If so print out the
882: p_indent_level);
883:
884: EXCEPTION
885: WHEN OTHERS THEN
886: Wf_Core.Context('wf_activities_vl_pub', 'draw_activity_list');
887: wf_item_definition.Error;
888:
889: END draw_activity_list;
890:
917: */
918: IF (p_wf_activity_attr_vl_tbl(1).activity_type = 'PROCESS') THEN
919:
920: wf_item_definition_util_pub.draw_summary_section_title(
921: wf_core.translate('WFITD_PROCESS_ATTRS'),
922: p_indent_level);
923:
924: ELSIF (p_wf_activity_attr_vl_tbl(1).activity_type = 'NOTICE') THEN
925:
923:
924: ELSIF (p_wf_activity_attr_vl_tbl(1).activity_type = 'NOTICE') THEN
925:
926: wf_item_definition_util_pub.draw_summary_section_title(
927: wf_core.translate('WFITD_NOTIFICATION_ATTRS'),
928: p_indent_level);
929:
930: ELSE
931:
929:
930: ELSE
931:
932: wf_item_definition_util_pub.draw_summary_section_title(
933: wf_core.translate('WFITD_FUNCTION_ATTRS'),
934: p_indent_level);
935:
936: END IF;
937:
962: END LOOP;
963:
964: EXCEPTION
965: WHEN OTHERS THEN
966: Wf_Core.Context('wf_activities_vl_pub', 'draw_activity_attr_list');
967: wf_item_definition.Error;
968:
969: END draw_activity_attr_list;
970:
1050:
1051: /*
1052: ** Put on the the processes title.
1053: */
1054: l_activity_section_title := wf_core.translate('WFITD_PROCESS_DETAILS');
1055: l_activity_name_prompt := wf_core.translate('WFITD_PROCESS_NAME');
1056:
1057: /*
1058: ** Set the indicator for the highest activity found. This is
1051: /*
1052: ** Put on the the processes title.
1053: */
1054: l_activity_section_title := wf_core.translate('WFITD_PROCESS_DETAILS');
1055: l_activity_name_prompt := wf_core.translate('WFITD_PROCESS_NAME');
1056:
1057: /*
1058: ** Set the indicator for the highest activity found. This is
1059: ** used later to print any missing headers.
1064:
1065: /*
1066: ** Put on the the processes title.
1067: */
1068: l_activity_section_title := wf_core.translate('WFITD_NOTIFICATION_DETAILS');
1069: l_activity_name_prompt := wf_core.translate('WFITD_NOTIFICATION_NAME');
1070:
1071: /*
1072: ** Check to see if you skipped the processes section in case
1065: /*
1066: ** Put on the the processes title.
1067: */
1068: l_activity_section_title := wf_core.translate('WFITD_NOTIFICATION_DETAILS');
1069: l_activity_name_prompt := wf_core.translate('WFITD_NOTIFICATION_NAME');
1070:
1071: /*
1072: ** Check to see if you skipped the processes section in case
1073: ** there weren't any. If so print out the header for the processes
1091:
1092: /*
1093: ** Put on the the processes title.
1094: */
1095: l_activity_section_title := wf_core.translate('WFITD_FUNCTION_DETAILS');
1096: l_activity_name_prompt := wf_core.translate('WFITD_FUNCTION_NAME');
1097:
1098: /*
1099: ** Check to see if you skipped the processes and or Notifications
1092: /*
1093: ** Put on the the processes title.
1094: */
1095: l_activity_section_title := wf_core.translate('WFITD_FUNCTION_DETAILS');
1096: l_activity_name_prompt := wf_core.translate('WFITD_FUNCTION_NAME');
1097:
1098: /*
1099: ** Check to see if you skipped the processes and or Notifications
1100: ** section in case there weren't any. If so print out the
1118:
1119: /*
1120: ** Put on the the event title.
1121: */
1122: l_activity_section_title := wf_core.translate('WFITD_EVENT_DETAILS');
1123: l_activity_name_prompt := wf_core.translate('WFITD_EVENT_NAME');
1124:
1125: /*
1126: ** Check to see if you skipped the events, processes
1119: /*
1120: ** Put on the the event title.
1121: */
1122: l_activity_section_title := wf_core.translate('WFITD_EVENT_DETAILS');
1123: l_activity_name_prompt := wf_core.translate('WFITD_EVENT_NAME');
1124:
1125: /*
1126: ** Check to see if you skipped the events, processes
1127: ** and or Notifications section in case there weren't
1192: /*
1193: ** Create the internal name row in the table.
1194: */
1195: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1196: wf_core.translate('WFITD_INTERNAL_NAME'),
1197: p_wf_activities_vl_tbl(l_activity_record_num).name);
1198:
1199: /*
1200: ** Create the description row in the table
1199: /*
1200: ** Create the description row in the table
1201: */
1202: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1203: wf_core.translate('DESCRIPTION'),
1204: p_wf_activities_vl_tbl(l_activity_record_num).description);
1205:
1206: /*
1207: ** If this is a process or notification activity, only show the function row
1213: p_wf_activities_vl_tbl(l_activity_record_num).type IN ('NOTICE', 'FUNCTION')) THEN
1214:
1215:
1216: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1217: wf_core.translate('WFITD_FUNCTION'),
1218: p_wf_activities_vl_tbl(l_activity_record_num).function);
1219:
1220: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1221: wf_core.translate('WFITD_FUNCTION_TYPE'),
1217: wf_core.translate('WFITD_FUNCTION'),
1218: p_wf_activities_vl_tbl(l_activity_record_num).function);
1219:
1220: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1221: wf_core.translate('WFITD_FUNCTION_TYPE'),
1222: NVL(p_wf_activities_vl_tbl(l_activity_record_num).function_type, 'PL/SQL'));
1223:
1224: END IF;
1225:
1231: IF (NVL(p_wf_activities_vl_tbl(l_activity_record_num).result_type,
1232: '*') <> '*') THEN
1233:
1234: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1235: wf_core.translate('WFITD_RESULT_TYPE'),
1236: p_wf_activities_vl_tbl(l_activity_record_num).result_type_display_name);
1237:
1238: END IF;
1239:
1263: /*
1264: ** Create the runnable row in the table
1265: */
1266: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1267: wf_core.translate('WFITD_RUNNABLE'),
1268: wf_core.translate('WFITD_YES'));
1269:
1270: ELSE
1271:
1264: ** Create the runnable row in the table
1265: */
1266: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1267: wf_core.translate('WFITD_RUNNABLE'),
1268: wf_core.translate('WFITD_YES'));
1269:
1270: ELSE
1271:
1272: /*
1272: /*
1273: ** Create the runnable row in the table
1274: */
1275: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1276: wf_core.translate('WFITD_RUNNABLE'),
1277: wf_core.translate('WFITD_NO'));
1278:
1279: END IF;
1280:
1273: ** Create the runnable row in the table
1274: */
1275: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1276: wf_core.translate('WFITD_RUNNABLE'),
1277: wf_core.translate('WFITD_NO'));
1278:
1279: END IF;
1280:
1281: ELSIF (l_activity_type = 'NOTICE') THEN
1293: p_effective_date,
1294: 'MESSAGE',
1295: p_wf_activities_vl_tbl(l_activity_record_num).message,
1296: p_wf_activities_vl_tbl(l_activity_record_num).message_display_name,
1297: wf_core.translate('MESSAGE_NAME'),
1298: 0);
1299:
1300: ELSE
1301:
1299:
1300: ELSE
1301:
1302: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1303: wf_core.translate('MESSAGE_NAME'),
1304: p_wf_activities_vl_tbl(l_activity_record_num).message_display_name);
1305:
1306: END IF;
1307:
1310: */
1311: IF (p_wf_activities_vl_tbl(l_activity_record_num).expand_role = 'Y') THEN
1312:
1313: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1314: wf_core.translate('WFITD_EXPAND_ROLES'),
1315: wf_core.translate('WFITD_YES'));
1316:
1317: ELSE
1318:
1311: IF (p_wf_activities_vl_tbl(l_activity_record_num).expand_role = 'Y') THEN
1312:
1313: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1314: wf_core.translate('WFITD_EXPAND_ROLES'),
1315: wf_core.translate('WFITD_YES'));
1316:
1317: ELSE
1318:
1319: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1316:
1317: ELSE
1318:
1319: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1320: wf_core.translate('WFITD_EXPAND_ROLES'),
1321: wf_core.translate('WFITD_NO'));
1322:
1323: END IF;
1324:
1317: ELSE
1318:
1319: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1320: wf_core.translate('WFITD_EXPAND_ROLES'),
1321: wf_core.translate('WFITD_NO'));
1322:
1323: END IF;
1324:
1325: ELSIF (l_activity_type = 'FUNCTION') THEN
1327: /*
1328: ** Create the cost row in the table
1329: */
1330: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1331: wf_core.translate('WFMON_COST'),
1332: TO_CHAR((p_wf_activities_vl_tbl(l_activity_record_num).cost/100)));
1333:
1334: ELSIF (l_activity_type = 'EVENT') THEN
1335:
1336: /*
1337: ** Create the event name and direction rows in the table
1338: */
1339: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1340: wf_core.translate('WFITD_EVENT'),
1341: p_wf_activities_vl_tbl(l_activity_record_num).event_name);
1342: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1343: wf_core.translate('WFITD_DIRECTION'),
1344: p_wf_activities_vl_tbl(l_activity_record_num).direction);
1339: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1340: wf_core.translate('WFITD_EVENT'),
1341: p_wf_activities_vl_tbl(l_activity_record_num).event_name);
1342: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1343: wf_core.translate('WFITD_DIRECTION'),
1344: p_wf_activities_vl_tbl(l_activity_record_num).direction);
1345:
1346: END IF;
1347:
1348: /*
1349: ** Create the icon name in the table
1350: */
1351: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1352: wf_core.translate('WFITD_ICON'),
1353: p_wf_activities_vl_tbl(l_activity_record_num).icon_name);
1354:
1355: /*
1356: ** Create the error item type name in the table
1355: /*
1356: ** Create the error item type name in the table
1357: */
1358: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1359: wf_core.translate('WFMON_ERROR_TYPE'),
1360: p_wf_activities_vl_tbl(l_activity_record_num).error_item_type);
1361:
1362: /*
1363: ** Create the error process name in the table
1362: /*
1363: ** Create the error process name in the table
1364: */
1365: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1366: wf_core.translate('WFMON_ERROR_PROCESS'),
1367: p_wf_activities_vl_tbl(l_activity_record_num).error_process);
1368:
1369:
1370: /*
1398: /*
1399: ** Create the effective date range in the table
1400: */
1401: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1402: wf_core.translate('WFITD_EFFECTIVE'),
1403: TO_CHAR(p_wf_activities_vl_tbl(l_activity_record_num).begin_date,
1404: l_expected_format)|| l_end_date);
1405:
1406: /*
1408: */
1409: IF (p_wf_activities_vl_tbl(l_activity_record_num).rerun = 'RESET') THEN
1410:
1411: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1412: wf_core.translate('WFITD_LOOP_RESET'),
1413: wf_core.translate('WFITD_LOOP_RESET_VALUE'));
1414:
1415: ELSIF (p_wf_activities_vl_tbl(l_activity_record_num).rerun = 'LOOP') THEN
1416:
1409: IF (p_wf_activities_vl_tbl(l_activity_record_num).rerun = 'RESET') THEN
1410:
1411: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1412: wf_core.translate('WFITD_LOOP_RESET'),
1413: wf_core.translate('WFITD_LOOP_RESET_VALUE'));
1414:
1415: ELSIF (p_wf_activities_vl_tbl(l_activity_record_num).rerun = 'LOOP') THEN
1416:
1417: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1414:
1415: ELSIF (p_wf_activities_vl_tbl(l_activity_record_num).rerun = 'LOOP') THEN
1416:
1417: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1418: wf_core.translate('WFITD_LOOP_RESET'),
1419: wf_core.translate('WFITD_LOOP_RESET_LOOP'));
1420:
1421: ELSE
1422:
1415: ELSIF (p_wf_activities_vl_tbl(l_activity_record_num).rerun = 'LOOP') THEN
1416:
1417: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1418: wf_core.translate('WFITD_LOOP_RESET'),
1419: wf_core.translate('WFITD_LOOP_RESET_LOOP'));
1420:
1421: ELSE
1422:
1423: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1420:
1421: ELSE
1422:
1423: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1424: wf_core.translate('WFITD_LOOP_RESET'),
1425: wf_core.translate('WFITD_LOOP_RESET_IGNORE'));
1426:
1427: END IF;
1428:
1421: ELSE
1422:
1423: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1424: wf_core.translate('WFITD_LOOP_RESET'),
1425: wf_core.translate('WFITD_LOOP_RESET_IGNORE'));
1426:
1427: END IF;
1428:
1429: /*
1429: /*
1430: ** Create the version row in the table
1431: */
1432: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1433: wf_core.translate('WFITD_VERSION'),
1434: p_wf_activities_vl_tbl(l_activity_record_num).version);
1435:
1436: /*
1437: ** Call function to print the read/write/execute roles
1575: END IF;
1576:
1577: EXCEPTION
1578: WHEN OTHERS THEN
1579: Wf_Core.Context('wf_activities_vl_pub', 'draw_activity_details');
1580: wf_item_definition.Error;
1581:
1582: END draw_activity_details;
1583:
1613:
1614: /*
1615: ** Put on the the processes title.
1616: */
1617: l_activity_section_title := wf_core.translate('WFITD_PROCESS_ATTR_DETAILS');
1618: l_activity_name_prompt := wf_core.translate('WFITD_PROCESS_NAME');
1619: l_activity_attr_name_prompt := wf_core.translate('WFITD_PROCESS_ATTR_NAME');
1620:
1621: ELSIF (p_wf_activity_attr_vl_tbl(1).activity_type = 'NOTICE') THEN
1614: /*
1615: ** Put on the the processes title.
1616: */
1617: l_activity_section_title := wf_core.translate('WFITD_PROCESS_ATTR_DETAILS');
1618: l_activity_name_prompt := wf_core.translate('WFITD_PROCESS_NAME');
1619: l_activity_attr_name_prompt := wf_core.translate('WFITD_PROCESS_ATTR_NAME');
1620:
1621: ELSIF (p_wf_activity_attr_vl_tbl(1).activity_type = 'NOTICE') THEN
1622:
1615: ** Put on the the processes title.
1616: */
1617: l_activity_section_title := wf_core.translate('WFITD_PROCESS_ATTR_DETAILS');
1618: l_activity_name_prompt := wf_core.translate('WFITD_PROCESS_NAME');
1619: l_activity_attr_name_prompt := wf_core.translate('WFITD_PROCESS_ATTR_NAME');
1620:
1621: ELSIF (p_wf_activity_attr_vl_tbl(1).activity_type = 'NOTICE') THEN
1622:
1623: /*
1622:
1623: /*
1624: ** Put on the the notification title.
1625: */
1626: l_activity_section_title := wf_core.translate('WFITD_NOTIFICATION_ATTR_DETAIL');
1627: l_activity_name_prompt := wf_core.translate('WFITD_NOTIFICATION_NAME');
1628: l_activity_attr_name_prompt := wf_core.translate('WFITD_NOTIFICATION_ATTR_NAME');
1629:
1630: ELSIF (p_wf_activity_attr_vl_tbl(1).activity_type = 'FUNCTION') THEN
1623: /*
1624: ** Put on the the notification title.
1625: */
1626: l_activity_section_title := wf_core.translate('WFITD_NOTIFICATION_ATTR_DETAIL');
1627: l_activity_name_prompt := wf_core.translate('WFITD_NOTIFICATION_NAME');
1628: l_activity_attr_name_prompt := wf_core.translate('WFITD_NOTIFICATION_ATTR_NAME');
1629:
1630: ELSIF (p_wf_activity_attr_vl_tbl(1).activity_type = 'FUNCTION') THEN
1631:
1624: ** Put on the the notification title.
1625: */
1626: l_activity_section_title := wf_core.translate('WFITD_NOTIFICATION_ATTR_DETAIL');
1627: l_activity_name_prompt := wf_core.translate('WFITD_NOTIFICATION_NAME');
1628: l_activity_attr_name_prompt := wf_core.translate('WFITD_NOTIFICATION_ATTR_NAME');
1629:
1630: ELSIF (p_wf_activity_attr_vl_tbl(1).activity_type = 'FUNCTION') THEN
1631:
1632: /*
1631:
1632: /*
1633: ** Put on the the function title.
1634: */
1635: l_activity_section_title := wf_core.translate('WFITD_FUNCTION_ATTR_DETAILS');
1636: l_activity_name_prompt := wf_core.translate('WFITD_FUNCTION_NAME');
1637: l_activity_attr_name_prompt := wf_core.translate('WFITD_FUNCTION_ATTR_NAME');
1638:
1639: END IF;
1632: /*
1633: ** Put on the the function title.
1634: */
1635: l_activity_section_title := wf_core.translate('WFITD_FUNCTION_ATTR_DETAILS');
1636: l_activity_name_prompt := wf_core.translate('WFITD_FUNCTION_NAME');
1637: l_activity_attr_name_prompt := wf_core.translate('WFITD_FUNCTION_ATTR_NAME');
1638:
1639: END IF;
1640:
1633: ** Put on the the function title.
1634: */
1635: l_activity_section_title := wf_core.translate('WFITD_FUNCTION_ATTR_DETAILS');
1636: l_activity_name_prompt := wf_core.translate('WFITD_FUNCTION_NAME');
1637: l_activity_attr_name_prompt := wf_core.translate('WFITD_FUNCTION_ATTR_NAME');
1638:
1639: END IF;
1640:
1641:
1675: /*
1676: ** Create the internal name row in the table.
1677: */
1678: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1679: wf_core.translate('WFITD_INTERNAL_NAME'),
1680: p_wf_activity_attr_vl_tbl(l_record_num).name);
1681:
1682: /*
1683: ** Create the activity display name row in the table.
1689: /*
1690: ** Create the description row in the table
1691: */
1692: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1693: wf_core.translate('DESCRIPTION'),
1694: p_wf_activity_attr_vl_tbl(l_record_num).description);
1695:
1696: /*
1697: ** Create the attribute type row in the table
1696: /*
1697: ** Create the attribute type row in the table
1698: */
1699: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1700: wf_core.translate('WFITD_ATTRIBUTE_TYPE'),
1701: wf_core.translate('WFITD_ATTR_TYPE_'||
1702: p_wf_activity_attr_vl_tbl(l_record_num).type));
1703:
1704: /*
1697: ** Create the attribute type row in the table
1698: */
1699: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1700: wf_core.translate('WFITD_ATTRIBUTE_TYPE'),
1701: wf_core.translate('WFITD_ATTR_TYPE_'||
1702: p_wf_activity_attr_vl_tbl(l_record_num).type));
1703:
1704: /*
1705: ** Create the length/format/lookup type row in the table.
1710: */
1711: IF (p_wf_activity_attr_vl_tbl(l_record_num).type = 'VARCHAR2') THEN
1712:
1713: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1714: wf_core.translate('LENGTH'),
1715: p_wf_activity_attr_vl_tbl(l_record_num).format);
1716:
1717: ELSIF (p_wf_activity_attr_vl_tbl(l_record_num).type IN ('DATE', 'NUMBER')) THEN
1718:
1716:
1717: ELSIF (p_wf_activity_attr_vl_tbl(l_record_num).type IN ('DATE', 'NUMBER')) THEN
1718:
1719: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1720: wf_core.translate('FORMAT'),
1721: p_wf_activity_attr_vl_tbl(l_record_num).format);
1722:
1723: ELSIF (p_wf_activity_attr_vl_tbl(l_record_num).type = 'LOOKUP') THEN
1724:
1722:
1723: ELSIF (p_wf_activity_attr_vl_tbl(l_record_num).type = 'LOOKUP') THEN
1724:
1725: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1726: wf_core.translate('LOOKUP'),
1727: p_wf_activity_attr_vl_tbl(l_record_num).lookup_type_display_name);
1728:
1729: ELSIF (p_wf_activity_attr_vl_tbl(l_record_num).type IN ('URL','DOCUMENT')) THEN
1730: /*
1731: ** If it is URL or DOCUMENT, indicate where the resulting page should be displayed
1732: */
1733: IF (NVL(p_wf_activity_attr_vl_tbl(l_record_num).format, '_top') = '_top') THEN
1734: wf_item_definition_util_pub.draw_detail_prompt_value_pair
1735: (wf_core.translate('WFITD_FRAME_TARGET'), wf_core.translate('WFITD_TOP'));
1736: ELSIF (p_wf_activity_attr_vl_tbl(l_record_num).format = '_blank') THEN
1737: wf_item_definition_util_pub.draw_detail_prompt_value_pair
1738: (wf_core.translate('WFITD_FRAME_TARGET'), wf_core.translate('WFITD_BLANK'));
1739: ELSIF (p_wf_activity_attr_vl_tbl(l_record_num).format = '_self') THEN
1734: wf_item_definition_util_pub.draw_detail_prompt_value_pair
1735: (wf_core.translate('WFITD_FRAME_TARGET'), wf_core.translate('WFITD_TOP'));
1736: ELSIF (p_wf_activity_attr_vl_tbl(l_record_num).format = '_blank') THEN
1737: wf_item_definition_util_pub.draw_detail_prompt_value_pair
1738: (wf_core.translate('WFITD_FRAME_TARGET'), wf_core.translate('WFITD_BLANK'));
1739: ELSIF (p_wf_activity_attr_vl_tbl(l_record_num).format = '_self') THEN
1740: wf_item_definition_util_pub.draw_detail_prompt_value_pair
1741: (wf_core.translate('WFITD_FRAME_TARGET'), wf_core.translate('WFITD_SELF'));
1742: ELSIF (p_wf_activity_attr_vl_tbl(l_record_num).format = '_parent') THEN
1737: wf_item_definition_util_pub.draw_detail_prompt_value_pair
1738: (wf_core.translate('WFITD_FRAME_TARGET'), wf_core.translate('WFITD_BLANK'));
1739: ELSIF (p_wf_activity_attr_vl_tbl(l_record_num).format = '_self') THEN
1740: wf_item_definition_util_pub.draw_detail_prompt_value_pair
1741: (wf_core.translate('WFITD_FRAME_TARGET'), wf_core.translate('WFITD_SELF'));
1742: ELSIF (p_wf_activity_attr_vl_tbl(l_record_num).format = '_parent') THEN
1743: wf_item_definition_util_pub.draw_detail_prompt_value_pair
1744: (wf_core.translate('WFITD_FRAME_TARGET'), wf_core.translate('WFITD_PARENT'));
1745: END IF;
1740: wf_item_definition_util_pub.draw_detail_prompt_value_pair
1741: (wf_core.translate('WFITD_FRAME_TARGET'), wf_core.translate('WFITD_SELF'));
1742: ELSIF (p_wf_activity_attr_vl_tbl(l_record_num).format = '_parent') THEN
1743: wf_item_definition_util_pub.draw_detail_prompt_value_pair
1744: (wf_core.translate('WFITD_FRAME_TARGET'), wf_core.translate('WFITD_PARENT'));
1745: END IF;
1746:
1747:
1748: END IF;
1750: /*
1751: ** Create the default type row
1752: */
1753: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1754: wf_core.translate('WFITD_DEFAULT_TYPE'),
1755: wf_core.translate('WFITD_DEFAULT_TYPE_'||
1756: p_wf_activity_attr_vl_tbl(l_record_num).value_type));
1757:
1758:
1751: ** Create the default type row
1752: */
1753: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1754: wf_core.translate('WFITD_DEFAULT_TYPE'),
1755: wf_core.translate('WFITD_DEFAULT_TYPE_'||
1756: p_wf_activity_attr_vl_tbl(l_record_num).value_type));
1757:
1758:
1759: /*
1767: ** Create the default item attribute row in the table. This is based on the
1768: ** p_wf_activity_attr_vl_tbl(l_record_num).attr_default_display_name
1769: */
1770: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1771: wf_core.translate('WFITD_DEFAULT_VALUE'),
1772: p_wf_activity_attr_vl_tbl(l_record_num).attr_default_display_name);
1773:
1774: /*
1775: ** Create the default value row in the table. If the attribute type is based on
1778: */
1779: ELSIF (p_wf_activity_attr_vl_tbl(l_record_num).type = 'LOOKUP') THEN
1780:
1781: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1782: wf_core.translate('WFITD_DEFAULT_VALUE'),
1783: p_wf_activity_attr_vl_tbl(l_record_num).lookup_code_display_name);
1784:
1785: /*
1786: ** If this is any other attribute type then
1789: */
1790: ELSE
1791:
1792: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1793: wf_core.translate('WFITD_DEFAULT_VALUE'),
1794: NVL(p_wf_activity_attr_vl_tbl(l_record_num).text_default,
1795: NVL(TO_CHAR(p_wf_activity_attr_vl_tbl(l_record_num).number_default),
1796: TO_CHAR(p_wf_activity_attr_vl_tbl(l_record_num).date_default))));
1797:
1815: END LOOP;
1816:
1817: EXCEPTION
1818: WHEN OTHERS THEN
1819: Wf_Core.Context('wf_activities_vl_pub', 'draw_activity_attr_details');
1820: wf_item_definition.Error;
1821:
1822: END draw_activity_attr_details;
1823: