eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_VALIDATE_WF dependencies on WF_ACTIVITY_ATTR_VALUES

Line 530: FROM wf_activity_attr_values

526: -- and the attributes of Wait Mode
527: BEGIN
528: SELECT text_value, name
529: INTO l_text_value, l_wait_mode_name
530: FROM wf_activity_attr_values
531: WHERE process_activity_id = l_activity_id
532: AND name = 'WAIT_MODE';
533: EXCEPTION
534: WHEN NO_DATA_FOUND THEN

Line 544: FROM wf_activity_attr_values

540: IF l_text_value = 'ABSOLUTE' THEN
541: BEGIN
542: SELECT text_value, name
543: INTO l_mode_text_value, l_mode_name
544: FROM wf_activity_attr_values
545: WHERE process_activity_id = l_activity_id
546: AND value_type = 'CONSTANT'
547: AND name = 'WAIT_ABSOLUTE_DATE';
548: EXCEPTION

Line 558: FROM wf_activity_attr_values

554: ELSIF l_text_value = 'DAY_OF_MONTH' THEN
555: BEGIN
556: SELECT text_value, name
557: INTO l_mode_text_value, l_mode_name
558: FROM wf_activity_attr_values
559: WHERE process_activity_id = l_activity_id
560: AND value_type = 'CONSTANT'
561: AND name = 'WAIT_DAY_OF_MONTH';
562: EXCEPTION

Line 572: FROM wf_activity_attr_values

568: ELSIF l_text_value = 'DAY_OF_WEEK' THEN
569: BEGIN
570: SELECT text_value, name
571: INTO l_mode_text_value, l_mode_name
572: FROM wf_activity_attr_values
573: WHERE process_activity_id = l_activity_id
574: AND value_type = 'CONSTANT'
575: AND name = 'WAIT_DAY_OF_WEEK';
576: EXCEPTION

Line 586: FROM wf_activity_attr_values

582: ELSIF l_text_value = 'RELATIVE' THEN
583: BEGIN
584: SELECT text_value, name
585: INTO l_mode_text_value, l_mode_name
586: FROM wf_activity_attr_values
587: WHERE process_activity_id = l_activity_id
588: AND value_type = 'CONSTANT'
589: AND name = 'WAIT_RELATIVE_TIME';
590: EXCEPTION

Line 600: FROM wf_activity_attr_values

596: ELSIF l_text_value = 'TIME' THEN
597: BEGIN
598: SELECT text_value, name
599: INTO l_mode_text_value, l_mode_name
600: FROM wf_activity_attr_values
601: WHERE process_activity_id = l_activity_id
602: AND value_type = 'CONSTANT'
603: AND name = 'WAIT_TIME';
604: EXCEPTION

Line 652: FROM wf_activity_attr_values

648: IF l_api = 'WF_STANDARD.WAIT' THEN
649: BEGIN
650: SELECT text_value
651: INTO l_text_value_relative
652: FROM wf_activity_attr_values
653: WHERE process_activity_id = l_activity_id
654: AND name = 'WAIT_MODE';
655: EXCEPTION
656: WHEN NO_DATA_FOUND THEN

Line 666: FROM wf_activity_attr_values

662: IF l_text_value_relative = 'RELATIVE' THEN
663: BEGIN
664: SELECT number_value
665: INTO l_number_value
666: FROM wf_activity_attr_values
667: WHERE process_activity_id = l_activity_id
668: AND name = 'WAIT_RELATIVE_TIME';
669: EXCEPTION
670: WHEN NO_DATA_FOUND THEN

Line 949: FROM wf_activity_attr_values waa

945:
946: BEGIN
947: SELECT text_value
948: INTO l_wait_text_default
949: FROM wf_activity_attr_values waa
950: WHERE waa.name = 'WAITING_ACTIVITY'
951: AND process_activity_id = l_instance_id;
952: -- l_all_activity_tbl(l_instance).instance_id;
953: -- The above sql determines the WAITING_ACTIVITY of the

Line 999: FROM wf_activity_attr_values waa

995:
996: BEGIN
997: SELECT text_value
998: INTO l_flow_name
999: FROM wf_activity_attr_values waa
1000: WHERE waa.name = 'WAITING_FLOW'
1001: AND process_activity_id = l_instance_id;
1002: -- l_all_activity_tbl(l_instance).instance_id
1003: -- This sql determines the corresponding waiting flow type

Line 1053: FROM wf_activity_attr_values waa

1049: -- l_all_activity_tbl(l_instance).function
1050: BEGIN
1051: SELECT text_value
1052: INTO l_cont_text_default
1053: FROM wf_activity_attr_values waa
1054: WHERE waa.name = 'CONTINUATION_ACTIVITY'
1055: AND process_activity_id = l_instance_id;
1056: -- The above sql determines the CONTINUATION_ACTIVITY of the
1057: -- passed activity with WAITFORFLOW function

Line 1102: FROM wf_activity_attr_values waa

1098:
1099: BEGIN
1100: SELECT text_value
1101: INTO l_flow_name
1102: FROM wf_activity_attr_values waa
1103: WHERE waa.name = 'CONTINUATION_FLOW'
1104: AND process_activity_id = l_instance_id;
1105: -- This sql determines the corresponding continue flow type
1106: -- [MASTER/DETAIL]

Line 1525: from wf_activity_attr_values

1521: IS
1522: -- Cursor Decleration
1523: CURSOR c_fulfill_attributes(c_instance_id NUMBER) IS
1524: select TEXT_VALUE FulfillAttr
1525: from wf_activity_attr_values
1526: where process_activity_id = c_instance_id
1527: and NAME IN ( 'FULFILLMENT_ACTIVITY'
1528: , 'INBOUND_FULFILLMENT_ACTIVITY');
1529:

Line 1703: FROM wf_activity_attr_values waa

1699: IF l_hdr_activity_tbl(hdr_instance).function = 'WF_STANDARD.CONTINUEFLOW' THEN
1700: BEGIN
1701: SELECT text_value
1702: INTO l_activity
1703: FROM wf_activity_attr_values waa
1704: WHERE waa.name = 'WAITING_ACTIVITY'
1705: AND process_activity_id = l_hdr_activity_tbl(hdr_instance).instance_id;
1706: -- The above sql determines the WAITING_ACTIVITY of the
1707: -- passed activity with CONTINUEFLOW function

Line 1725: FROM wf_activity_attr_values waa

1721: ELSIF l_hdr_activity_tbl(hdr_instance).function = 'WF_STANDARD.WAITFORFLOW' THEN
1722: BEGIN
1723: SELECT text_value
1724: INTO l_activity
1725: FROM wf_activity_attr_values waa
1726: WHERE waa.name = 'CONTINUATION_ACTIVITY'
1727: AND process_activity_id = l_hdr_activity_tbl(hdr_instance).instance_id;
1728: -- The above sql determines the CONTINUATION_ACTIVITY of the
1729: -- passed activity with WAITFORFLOW function

Line 2079: FROM wf_activity_attr_values waa

2075: IF l_lin_activity_tbl(line_instance).function = 'WF_STANDARD.CONTINUEFLOW' THEN
2076: BEGIN
2077: SELECT text_value
2078: INTO l_activity
2079: FROM wf_activity_attr_values waa
2080: WHERE waa.name = 'WAITING_ACTIVITY'
2081: AND process_activity_id = l_lin_activity_tbl(line_instance).instance_id;
2082: -- The above sql determines the WAITING_ACTIVITY of the
2083: -- passed activity with CONTINUEFLOW function

Line 2101: FROM wf_activity_attr_values waa

2097: ELSIF l_lin_activity_tbl(line_instance).function = 'WF_STANDARD.WAITFORFLOW' THEN
2098: BEGIN
2099: SELECT text_value
2100: INTO l_activity
2101: FROM wf_activity_attr_values waa
2102: WHERE waa.name = 'CONTINUATION_ACTIVITY'
2103: AND process_activity_id = l_lin_activity_tbl(line_instance).instance_id;
2104: -- The above sql determines the CONTINUATION_ACTIVITY of the
2105: -- passed activity with WAITFORFLOW function