DBA Data[Home] [Help]

APPS.WF_ACTIVITIES_VL_PUB dependencies on WF_CORE

Line 524: Wf_Core.Context('wf_activities_vl_pub',

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),

Line 622: Wf_Core.Context('wf_activities_vl_pub',

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,

Line 697: l_summary_section_title := wf_core.translate('PROCESSES');

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.

Line 710: l_summary_section_title := wf_core.translate('WFITD_NOTIFICATIONS');

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

Line 734: l_summary_section_title := wf_core.translate('WFITD_FUNCTIONS');

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

Line 757: l_summary_section_title := wf_core.translate('WFITD_EVENTS');

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

Line 886: Wf_Core.Context('wf_activities_vl_pub', 'draw_activity_list');

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:

Line 921: wf_core.translate('WFITD_PROCESS_ATTRS'),

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:

Line 927: wf_core.translate('WFITD_NOTIFICATION_ATTRS'),

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:

Line 933: wf_core.translate('WFITD_FUNCTION_ATTRS'),

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:

Line 966: Wf_Core.Context('wf_activities_vl_pub', 'draw_activity_attr_list');

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:

Line 1054: l_activity_section_title := wf_core.translate('WFITD_PROCESS_DETAILS');

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

Line 1055: l_activity_name_prompt := wf_core.translate('WFITD_PROCESS_NAME');

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.

Line 1068: l_activity_section_title := wf_core.translate('WFITD_NOTIFICATION_DETAILS');

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

Line 1069: l_activity_name_prompt := wf_core.translate('WFITD_NOTIFICATION_NAME');

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

Line 1095: l_activity_section_title := wf_core.translate('WFITD_FUNCTION_DETAILS');

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

Line 1096: l_activity_name_prompt := wf_core.translate('WFITD_FUNCTION_NAME');

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

Line 1122: l_activity_section_title := wf_core.translate('WFITD_EVENT_DETAILS');

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

Line 1123: l_activity_name_prompt := wf_core.translate('WFITD_EVENT_NAME');

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

Line 1196: wf_core.translate('WFITD_INTERNAL_NAME'),

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

Line 1203: wf_core.translate('DESCRIPTION'),

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

Line 1217: wf_core.translate('WFITD_FUNCTION'),

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'),

Line 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:

Line 1235: wf_core.translate('WFITD_RESULT_TYPE'),

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:

Line 1267: wf_core.translate('WFITD_RUNNABLE'),

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:

Line 1268: wf_core.translate('WFITD_YES'));

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: /*

Line 1276: wf_core.translate('WFITD_RUNNABLE'),

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:

Line 1277: wf_core.translate('WFITD_NO'));

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

Line 1297: wf_core.translate('MESSAGE_NAME'),

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:

Line 1303: wf_core.translate('MESSAGE_NAME'),

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:

Line 1314: wf_core.translate('WFITD_EXPAND_ROLES'),

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:

Line 1315: wf_core.translate('WFITD_YES'));

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 (

Line 1320: wf_core.translate('WFITD_EXPAND_ROLES'),

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:

Line 1321: wf_core.translate('WFITD_NO'));

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

Line 1331: wf_core.translate('WFMON_COST'),

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:

Line 1340: wf_core.translate('WFITD_EVENT'),

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);

Line 1343: wf_core.translate('WFITD_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:

Line 1352: wf_core.translate('WFITD_ICON'),

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

Line 1359: wf_core.translate('WFMON_ERROR_TYPE'),

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

Line 1366: wf_core.translate('WFMON_ERROR_PROCESS'),

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: /*

Line 1402: wf_core.translate('WFITD_EFFECTIVE'),

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: /*

Line 1412: wf_core.translate('WFITD_LOOP_RESET'),

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:

Line 1413: wf_core.translate('WFITD_LOOP_RESET_VALUE'));

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 (

Line 1418: wf_core.translate('WFITD_LOOP_RESET'),

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:

Line 1419: wf_core.translate('WFITD_LOOP_RESET_LOOP'));

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 (

Line 1424: wf_core.translate('WFITD_LOOP_RESET'),

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:

Line 1425: wf_core.translate('WFITD_LOOP_RESET_IGNORE'));

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: /*

Line 1433: wf_core.translate('WFITD_VERSION'),

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

Line 1579: Wf_Core.Context('wf_activities_vl_pub', 'draw_activity_details');

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:

Line 1617: l_activity_section_title := wf_core.translate('WFITD_PROCESS_ATTR_DETAILS');

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

Line 1618: l_activity_name_prompt := wf_core.translate('WFITD_PROCESS_NAME');

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:

Line 1619: l_activity_attr_name_prompt := wf_core.translate('WFITD_PROCESS_ATTR_NAME');

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: /*

Line 1626: l_activity_section_title := wf_core.translate('WFITD_NOTIFICATION_ATTR_DETAIL');

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

Line 1627: l_activity_name_prompt := wf_core.translate('WFITD_NOTIFICATION_NAME');

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:

Line 1628: l_activity_attr_name_prompt := wf_core.translate('WFITD_NOTIFICATION_ATTR_NAME');

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: /*

Line 1635: l_activity_section_title := wf_core.translate('WFITD_FUNCTION_ATTR_DETAILS');

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;

Line 1636: l_activity_name_prompt := wf_core.translate('WFITD_FUNCTION_NAME');

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:

Line 1637: l_activity_attr_name_prompt := wf_core.translate('WFITD_FUNCTION_ATTR_NAME');

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:

Line 1679: wf_core.translate('WFITD_INTERNAL_NAME'),

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.

Line 1693: wf_core.translate('DESCRIPTION'),

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

Line 1700: wf_core.translate('WFITD_ATTRIBUTE_TYPE'),

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: /*

Line 1701: wf_core.translate('WFITD_ATTR_TYPE_'||

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.

Line 1714: wf_core.translate('LENGTH'),

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:

Line 1720: wf_core.translate('FORMAT'),

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:

Line 1726: wf_core.translate('LOOKUP'),

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: /*

Line 1735: (wf_core.translate('WFITD_FRAME_TARGET'), wf_core.translate('WFITD_TOP'));

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

Line 1738: (wf_core.translate('WFITD_FRAME_TARGET'), wf_core.translate('WFITD_BLANK'));

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

Line 1741: (wf_core.translate('WFITD_FRAME_TARGET'), wf_core.translate('WFITD_SELF'));

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;

Line 1744: (wf_core.translate('WFITD_FRAME_TARGET'), wf_core.translate('WFITD_PARENT'));

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;

Line 1754: wf_core.translate('WFITD_DEFAULT_TYPE'),

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:

Line 1755: wf_core.translate('WFITD_DEFAULT_TYPE_'||

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: /*

Line 1771: wf_core.translate('WFITD_DEFAULT_VALUE'),

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

Line 1782: wf_core.translate('WFITD_DEFAULT_VALUE'),

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

Line 1793: wf_core.translate('WFITD_DEFAULT_VALUE'),

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:

Line 1819: Wf_Core.Context('wf_activities_vl_pub', 'draw_activity_attr_details');

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: