DBA Data[Home] [Help]

APPS.WF_ACTIVITIES_VL_PUB dependencies on WF_ITEM_DEFINITION

Line 531: wf_item_definition.Error;

527: p_activity_type,
528: TO_CHAR(p_effective_date),
529: p_name);
530:
531: wf_item_definition.Error;
532:
533: END fetch_activities;
534:
535:

Line 569: wf_item_definition_util_pub.validate_date (

565: /*
566: ** Get the NLS Date format that is currently set. All to_char of
567: ** date values should use the l_expected_format
568: */
569: wf_item_definition_util_pub.validate_date (
570: TO_CHAR(sysdate, 'DD-MON-RRRR HH24:MI:SS'),
571: l_date_date,
572: l_valid_date,
573: l_expected_format);

Line 581: wf_item_definition.draw_header(

577:
578: /*
579: ** Create a standard title page with the item_type display name as the title
580: */
581: wf_item_definition.draw_header(
582: p_item_type,
583: l_print_date,
584: 'DISPLAY');
585:

Line 629: wf_item_definition.Error;

625: p_activity_type,
626: p_effective_date,
627: p_name);
628:
629: wf_item_definition.Error;
630:
631: END fetch_draw_activity_details;
632:
633: /*===========================================================================

Line 717: wf_item_definition_util_pub.activity_titles_list (

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
715: ** here.
716: */
717: wf_item_definition_util_pub.activity_titles_list (
718: l_highest_activity,
719: 2,
720: p_indent_level);
721:

Line 741: wf_item_definition_util_pub.activity_titles_list (

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
739: ** header for the processes and/or notificaitons here.
740: */
741: wf_item_definition_util_pub.activity_titles_list (
742: l_highest_activity,
743: 3,
744: p_indent_level);
745:

Line 764: wf_item_definition_util_pub.activity_titles_list (

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
762: ** header for the processes and/or notificaitons here.
763: */
764: wf_item_definition_util_pub.activity_titles_list (
765: l_highest_activity,
766: 4,
767: p_indent_level);
768:

Line 781: wf_item_definition_util_pub.draw_summary_section_title(

777: /*
778: ** Create the the activity type summary title.
779: ** Indent it to the level specified
780: */
781: wf_item_definition_util_pub.draw_summary_section_title(
782: l_summary_section_title,
783: p_indent_level);
784:
785: END IF;

Line 798: wf_item_definition_util_pub.create_hotlink_to_details (

794: ** The creation of the anchor from the summary frame to the detail
795: ** frame was very complex so I've extracted the function into its
796: ** own routine.
797: */
798: wf_item_definition_util_pub.create_hotlink_to_details (
799: p_wf_activities_vl_tbl(l_activity_record_num).item_type,
800: p_effective_date,
801: l_activity_type,
802: p_wf_activities_vl_tbl(l_activity_record_num).name,

Line 879: wf_item_definition_util_pub.activity_titles_list (

875: ** Check to see if you skipped the processes section in case
876: ** there weren't any. If so print out the header for the processes
877: ** here.
878: */
879: wf_item_definition_util_pub.activity_titles_list (
880: l_highest_activity,
881: 4,
882: p_indent_level);
883:

Line 887: wf_item_definition.Error;

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

Line 920: wf_item_definition_util_pub.draw_summary_section_title(

916: ** type
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

Line 926: wf_item_definition_util_pub.draw_summary_section_title(

922: p_indent_level);
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

Line 932: wf_item_definition_util_pub.draw_summary_section_title(

928: p_indent_level);
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;

Line 951: wf_item_definition_util_pub.create_hotlink_to_details (

947: ** combination of the activity_type, the activity_name, and the
948: ** activity_attribute_name. This will ensure uniqueness. ie
949: ** #ACTIVITY_ATTR:FUNCTION:CHECK_FUNDS:FUNDS_AVAILABLE
950: */
951: wf_item_definition_util_pub.create_hotlink_to_details (
952: p_wf_activity_attr_vl_tbl(l_record_num).activity_item_type,
953: p_effective_date,
954: 'ACTIVITY_ATTR',
955: p_wf_activity_attr_vl_tbl(l_record_num).activity_type||':'||

Line 967: wf_item_definition.Error;

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

Line 1078: wf_item_definition_util_pub.activity_titles_details (

1074: ** here.
1075: */
1076: IF (p_print_skipped_titles = TRUE) THEN
1077:
1078: wf_item_definition_util_pub.activity_titles_details (
1079: l_highest_activity,
1080: 2);
1081:
1082: END IF;

Line 1105: wf_item_definition_util_pub.activity_titles_details (

1101: ** header for the processes and/or notificaitons here.
1102: */
1103: IF (p_print_skipped_titles = TRUE) THEN
1104:
1105: wf_item_definition_util_pub.activity_titles_details (
1106: l_highest_activity,
1107: 3);
1108:
1109: END IF;

Line 1133: wf_item_definition_util_pub.activity_titles_details (

1129: ** and/or notificaitons here.
1130: */
1131: IF (p_print_skipped_titles = TRUE) THEN
1132:
1133: wf_item_definition_util_pub.activity_titles_details (
1134: l_highest_activity,
1135: 4);
1136:
1137: END IF;

Line 1161: wf_item_definition_util_pub.draw_detail_section_title (

1157:
1158: /*
1159: ** Draw the section title for the activity detail section
1160: */
1161: wf_item_definition_util_pub.draw_detail_section_title (
1162: l_activity_section_title,
1163: 0);
1164:
1165: END IF;

Line 1185: wf_item_definition_util_pub.create_details_hotlink_target (

1181: ** Create the target for the hotlink from the summary view. Also
1182: ** create the first row in the table which is always the display
1183: ** name for the object.
1184: */
1185: wf_item_definition_util_pub.create_details_hotlink_target (
1186: p_wf_activities_vl_tbl(l_activity_record_num).type,
1187: p_wf_activities_vl_tbl(l_activity_record_num).name,
1188: p_wf_activities_vl_tbl(l_activity_record_num).display_name,
1189: l_activity_name_prompt,

Line 1195: wf_item_definition_util_pub.draw_detail_prompt_value_pair (

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

Line 1202: wf_item_definition_util_pub.draw_detail_prompt_value_pair (

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

Line 1216: wf_item_definition_util_pub.draw_detail_prompt_value_pair (

1212: p_wf_activities_vl_tbl(l_activity_record_num).function IS NOT NULL) OR
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 (

Line 1220: wf_item_definition_util_pub.draw_detail_prompt_value_pair (

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'),
1222: NVL(p_wf_activities_vl_tbl(l_activity_record_num).function_type, 'PL/SQL'));
1223:
1224: END IF;

Line 1234: wf_item_definition_util_pub.draw_detail_prompt_value_pair (

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

Line 1266: wf_item_definition_util_pub.draw_detail_prompt_value_pair (

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

Line 1275: wf_item_definition_util_pub.draw_detail_prompt_value_pair (

1271:
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;

Line 1291: wf_item_definition_util_pub.create_hotlink_to_details(

1287: ** the create_hotlink_to_details here. IN ( could
1288: */
1289: IF (p_create_child_links = TRUE) THEN
1290:
1291: wf_item_definition_util_pub.create_hotlink_to_details(
1292: p_wf_activities_vl_tbl(l_activity_record_num).item_type,
1293: p_effective_date,
1294: 'MESSAGE',
1295: p_wf_activities_vl_tbl(l_activity_record_num).message,

Line 1302: wf_item_definition_util_pub.draw_detail_prompt_value_pair (

1298: 0);
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;

Line 1313: wf_item_definition_util_pub.draw_detail_prompt_value_pair (

1309: ** Create the expand roles in the table
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

Line 1319: wf_item_definition_util_pub.draw_detail_prompt_value_pair (

1315: wf_core.translate('WFITD_YES'));
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;

Line 1330: wf_item_definition_util_pub.draw_detail_prompt_value_pair (

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

Line 1339: wf_item_definition_util_pub.draw_detail_prompt_value_pair (

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

Line 1342: wf_item_definition_util_pub.draw_detail_prompt_value_pair (

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);
1345:
1346: END IF;

Line 1351: wf_item_definition_util_pub.draw_detail_prompt_value_pair (

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

Line 1358: wf_item_definition_util_pub.draw_detail_prompt_value_pair (

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

Line 1365: wf_item_definition_util_pub.draw_detail_prompt_value_pair (

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

Line 1376: wf_item_definition_util_pub.validate_date (

1372: ** added a time element to sysdate. That ensures the time format
1373: ** will be included in l_expected_format. You don't care about the
1374: ** validation stuff
1375: */
1376: wf_item_definition_util_pub.validate_date (
1377: TO_CHAR(sysdate, 'DD-MON-YY')||' 00:00:00',
1378: l_date_date,
1379: l_valid_date,
1380: l_expected_format);

Line 1401: wf_item_definition_util_pub.draw_detail_prompt_value_pair (

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

Line 1411: wf_item_definition_util_pub.draw_detail_prompt_value_pair (

1407: ** Create the loop reset description
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

Line 1417: wf_item_definition_util_pub.draw_detail_prompt_value_pair (

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 (
1418: wf_core.translate('WFITD_LOOP_RESET'),
1419: wf_core.translate('WFITD_LOOP_RESET_LOOP'));
1420:
1421: ELSE

Line 1423: wf_item_definition_util_pub.draw_detail_prompt_value_pair (

1419: wf_core.translate('WFITD_LOOP_RESET_LOOP'));
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;

Line 1432: wf_item_definition_util_pub.draw_detail_prompt_value_pair (

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

Line 1439: wf_item_definition_util_pub.draw_read_write_exe_details(

1435:
1436: /*
1437: ** Call function to print the read/write/execute roles
1438: */
1439: wf_item_definition_util_pub.draw_read_write_exe_details(
1440: p_wf_activities_vl_tbl(l_activity_record_num).read_role,
1441: p_wf_activities_vl_tbl(l_activity_record_num).write_role,
1442: p_wf_activities_vl_tbl(l_activity_record_num).execute_role,
1443: TRUE);

Line 1448: wf_item_definition_util_pub.draw_custom_protect_details(

1444:
1445: /*
1446: ** Call function to print the customization/protection levels
1447: */
1448: wf_item_definition_util_pub.draw_custom_protect_details(
1449: p_wf_activities_vl_tbl(l_activity_record_num).custom_level,
1450: p_wf_activities_vl_tbl(l_activity_record_num).protect_level);
1451:
1452: /*

Line 1537: wf_item_definition_util_pub.draw_detail_section_title (

1533:
1534: /*
1535: ** Draw the section title for the Activity detail section
1536: */
1537: wf_item_definition_util_pub.draw_detail_section_title (
1538: l_activity_section_title,
1539: 0);
1540:
1541: END IF;

Line 1571: wf_item_definition_util_pub.activity_titles_details (

1567: ** here.
1568: */
1569: IF (p_print_skipped_titles = TRUE) THEN
1570:
1571: wf_item_definition_util_pub.activity_titles_details (
1572: l_highest_activity,
1573: 4);
1574:
1575: END IF;

Line 1580: wf_item_definition.Error;

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

Line 1645: wf_item_definition_util_pub.draw_detail_section_title (

1641:
1642: /*
1643: ** Draw the section title for the activity attribute detail section
1644: */
1645: wf_item_definition_util_pub.draw_detail_section_title (
1646: l_activity_section_title,
1647: 0);
1648:
1649: /*

Line 1666: wf_item_definition_util_pub.create_details_hotlink_target (

1662: ** Create the target for the hotlink from the summary view. Also
1663: ** create the first row in the table which is always the display
1664: ** name for the object.
1665: */
1666: wf_item_definition_util_pub.create_details_hotlink_target (
1667: 'ACTIVITY_ATTR',
1668: p_wf_activity_attr_vl_tbl(l_record_num).activity_type||':'||
1669: p_wf_activity_attr_vl_tbl(l_record_num).activity_name||':'||
1670: p_wf_activity_attr_vl_tbl(l_record_num).name,

Line 1678: wf_item_definition_util_pub.draw_detail_prompt_value_pair (

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

Line 1685: wf_item_definition_util_pub.draw_detail_prompt_value_pair (

1681:
1682: /*
1683: ** Create the activity display name row in the table.
1684: */
1685: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1686: l_activity_name_prompt,
1687: p_wf_activity_attr_vl_tbl(l_record_num).activity_display_name);
1688:
1689: /*

Line 1692: wf_item_definition_util_pub.draw_detail_prompt_value_pair (

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

Line 1699: wf_item_definition_util_pub.draw_detail_prompt_value_pair (

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

Line 1713: wf_item_definition_util_pub.draw_detail_prompt_value_pair (

1709: ** If it is any other type then don't show the row at all
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

Line 1719: wf_item_definition_util_pub.draw_detail_prompt_value_pair (

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

Line 1725: wf_item_definition_util_pub.draw_detail_prompt_value_pair (

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

Line 1734: wf_item_definition_util_pub.draw_detail_prompt_value_pair

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

Line 1737: wf_item_definition_util_pub.draw_detail_prompt_value_pair

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
1740: wf_item_definition_util_pub.draw_detail_prompt_value_pair
1741: (wf_core.translate('WFITD_FRAME_TARGET'), wf_core.translate('WFITD_SELF'));

Line 1740: wf_item_definition_util_pub.draw_detail_prompt_value_pair

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
1743: wf_item_definition_util_pub.draw_detail_prompt_value_pair
1744: (wf_core.translate('WFITD_FRAME_TARGET'), wf_core.translate('WFITD_PARENT'));

Line 1743: wf_item_definition_util_pub.draw_detail_prompt_value_pair

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;
1746:
1747:

Line 1753: wf_item_definition_util_pub.draw_detail_prompt_value_pair (

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

Line 1770: wf_item_definition_util_pub.draw_detail_prompt_value_pair (

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

Line 1781: wf_item_definition_util_pub.draw_detail_prompt_value_pair (

1777: ** the lookup code that was fetch.
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: /*

Line 1792: wf_item_definition_util_pub.draw_detail_prompt_value_pair (

1788: ** default. If there is no number default then try the date.
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))));

Line 1820: wf_item_definition.Error;

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:
1824: END wf_activities_vl_pub;