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.HR_WORKFLOW_SERVICE dependencies on WF_ACTIVITY_ATTR_VALUES

Line 292: ,p_actid in wf_activity_attr_values.process_activity_id%type

288: -- ----------------------------------------------------------------------------
289: procedure get_act_attr_expanded_info
290: (p_item_type in wf_items.item_type%type
291: ,p_item_key in wf_items.item_key%type
292: ,p_actid in wf_activity_attr_values.process_activity_id%type
293: ,p_name in wf_activity_attributes.name%type
294: ,p_exists out nocopy boolean
295: ,p_subtype out nocopy wf_activity_attributes.subtype%type
296: ,p_type out nocopy wf_activity_attributes.type%type

Line 298: ,p_date_value out nocopy wf_activity_attr_values.date_value%type

294: ,p_exists out nocopy boolean
295: ,p_subtype out nocopy wf_activity_attributes.subtype%type
296: ,p_type out nocopy wf_activity_attributes.type%type
297: ,p_format out nocopy wf_activity_attributes.format%type
298: ,p_date_value out nocopy wf_activity_attr_values.date_value%type
299: ,p_number_value out nocopy wf_activity_attr_values.number_value%type
300: ,p_text_value out nocopy wf_activity_attr_values.text_value%type) is
301: -- --------------------------------------------------------------------------
302: -- declare local variables

Line 299: ,p_number_value out nocopy wf_activity_attr_values.number_value%type

295: ,p_subtype out nocopy wf_activity_attributes.subtype%type
296: ,p_type out nocopy wf_activity_attributes.type%type
297: ,p_format out nocopy wf_activity_attributes.format%type
298: ,p_date_value out nocopy wf_activity_attr_values.date_value%type
299: ,p_number_value out nocopy wf_activity_attr_values.number_value%type
300: ,p_text_value out nocopy wf_activity_attr_values.text_value%type) is
301: -- --------------------------------------------------------------------------
302: -- declare local variables
303: -- --------------------------------------------------------------------------

Line 300: ,p_text_value out nocopy wf_activity_attr_values.text_value%type) is

296: ,p_type out nocopy wf_activity_attributes.type%type
297: ,p_format out nocopy wf_activity_attributes.format%type
298: ,p_date_value out nocopy wf_activity_attr_values.date_value%type
299: ,p_number_value out nocopy wf_activity_attr_values.number_value%type
300: ,p_text_value out nocopy wf_activity_attr_values.text_value%type) is
301: -- --------------------------------------------------------------------------
302: -- declare local variables
303: -- --------------------------------------------------------------------------
304: l_type wf_activity_attributes.type%type;

Line 368: ,p_actid in wf_activity_attr_values.process_activity_id%type) is

364: -- ----------------------------------------------------------------------------
365: procedure check_activity_type_attrs
366: (p_item_type in wf_items.item_type%type
367: ,p_item_key in wf_items.item_key%type
368: ,p_actid in wf_activity_attr_values.process_activity_id%type) is
369: --
370: l_exists boolean;
371: l_subtype wf_activity_attributes.subtype%type;
372: l_type wf_activity_attributes.type%type;

Line 374: l_date_value wf_activity_attr_values.date_value%type;

370: l_exists boolean;
371: l_subtype wf_activity_attributes.subtype%type;
372: l_type wf_activity_attributes.type%type;
373: l_format wf_activity_attributes.format%type;
374: l_date_value wf_activity_attr_values.date_value%type;
375: l_number_value wf_activity_attr_values.number_value%type;
376: l_text_value wf_activity_attr_values.text_value%type;
377: l_activity_name wf_item_activity_statuses_v.activity_name%type;
378: l_activity_display_name wf_item_activity_statuses_v.activity_display_name%type;

Line 375: l_number_value wf_activity_attr_values.number_value%type;

371: l_subtype wf_activity_attributes.subtype%type;
372: l_type wf_activity_attributes.type%type;
373: l_format wf_activity_attributes.format%type;
374: l_date_value wf_activity_attr_values.date_value%type;
375: l_number_value wf_activity_attr_values.number_value%type;
376: l_text_value wf_activity_attr_values.text_value%type;
377: l_activity_name wf_item_activity_statuses_v.activity_name%type;
378: l_activity_display_name wf_item_activity_statuses_v.activity_display_name%type;
379: --

Line 376: l_text_value wf_activity_attr_values.text_value%type;

372: l_type wf_activity_attributes.type%type;
373: l_format wf_activity_attributes.format%type;
374: l_date_value wf_activity_attr_values.date_value%type;
375: l_number_value wf_activity_attr_values.number_value%type;
376: l_text_value wf_activity_attr_values.text_value%type;
377: l_activity_name wf_item_activity_statuses_v.activity_name%type;
378: l_activity_display_name wf_item_activity_statuses_v.activity_display_name%type;
379: --
380: begin

Line 512: ,p_actid in wf_activity_attr_values.process_activity_id%type)

508: -- ----------------------------------------------------------------------------
509: function check_hr_window_title
510: (p_item_type in wf_items.item_type%type
511: ,p_item_key in wf_items.item_key%type
512: ,p_actid in wf_activity_attr_values.process_activity_id%type)
513: return boolean is
514: --
515: l_exists boolean;
516: l_subtype wf_activity_attributes.subtype%type;

Line 519: l_date_value wf_activity_attr_values.date_value%type;

515: l_exists boolean;
516: l_subtype wf_activity_attributes.subtype%type;
517: l_type wf_activity_attributes.type%type;
518: l_format wf_activity_attributes.format%type;
519: l_date_value wf_activity_attr_values.date_value%type;
520: l_number_value wf_activity_attr_values.number_value%type;
521: l_text_value wf_activity_attr_values.text_value%type;
522: --
523: begin

Line 520: l_number_value wf_activity_attr_values.number_value%type;

516: l_subtype wf_activity_attributes.subtype%type;
517: l_type wf_activity_attributes.type%type;
518: l_format wf_activity_attributes.format%type;
519: l_date_value wf_activity_attr_values.date_value%type;
520: l_number_value wf_activity_attr_values.number_value%type;
521: l_text_value wf_activity_attr_values.text_value%type;
522: --
523: begin
524: -- check to see if the WINDOW_TITLE activity attribute exists

Line 521: l_text_value wf_activity_attr_values.text_value%type;

517: l_type wf_activity_attributes.type%type;
518: l_format wf_activity_attributes.format%type;
519: l_date_value wf_activity_attr_values.date_value%type;
520: l_number_value wf_activity_attr_values.number_value%type;
521: l_text_value wf_activity_attr_values.text_value%type;
522: --
523: begin
524: -- check to see if the WINDOW_TITLE activity attribute exists
525: get_act_attr_expanded_info

Line 546: ,p_actid in wf_activity_attr_values.process_activity_id%type)

542: -- ----------------------------------------------------------------------------
543: function get_hr_window_title
544: (p_item_type in wf_items.item_type%type
545: ,p_item_key in wf_items.item_key%type
546: ,p_actid in wf_activity_attr_values.process_activity_id%type)
547: return varchar2 is
548: --
549: l_exists boolean;
550: l_subtype wf_activity_attributes.subtype%type;

Line 553: l_date_value wf_activity_attr_values.date_value%type;

549: l_exists boolean;
550: l_subtype wf_activity_attributes.subtype%type;
551: l_type wf_activity_attributes.type%type;
552: l_format wf_activity_attributes.format%type;
553: l_date_value wf_activity_attr_values.date_value%type;
554: l_number_value wf_activity_attr_values.number_value%type;
555: l_text_value wf_activity_attr_values.text_value%type;
556: --
557: begin

Line 554: l_number_value wf_activity_attr_values.number_value%type;

550: l_subtype wf_activity_attributes.subtype%type;
551: l_type wf_activity_attributes.type%type;
552: l_format wf_activity_attributes.format%type;
553: l_date_value wf_activity_attr_values.date_value%type;
554: l_number_value wf_activity_attr_values.number_value%type;
555: l_text_value wf_activity_attr_values.text_value%type;
556: --
557: begin
558: -- check to see if the WINDOW_TITLE activity attribute exists

Line 555: l_text_value wf_activity_attr_values.text_value%type;

551: l_type wf_activity_attributes.type%type;
552: l_format wf_activity_attributes.format%type;
553: l_date_value wf_activity_attr_values.date_value%type;
554: l_number_value wf_activity_attr_values.number_value%type;
555: l_text_value wf_activity_attr_values.text_value%type;
556: --
557: begin
558: -- check to see if the WINDOW_TITLE activity attribute exists
559: get_act_attr_expanded_info

Line 584: ,p_actid in wf_activity_attr_values.process_activity_id%type

580: -- ----------------------------------------------------------------------------
581: function check_web_page_code
582: (p_item_type in wf_items.item_type%type
583: ,p_item_key in wf_items.item_key%type
584: ,p_actid in wf_activity_attr_values.process_activity_id%type
585: ,p_web_page_section_code in wf_activity_attributes.name%type)
586: return boolean is
587: --
588: l_exists boolean;

Line 592: l_date_value wf_activity_attr_values.date_value%type;

588: l_exists boolean;
589: l_subtype wf_activity_attributes.subtype%type;
590: l_type wf_activity_attributes.type%type;
591: l_format wf_activity_attributes.format%type;
592: l_date_value wf_activity_attr_values.date_value%type;
593: l_number_value wf_activity_attr_values.number_value%type;
594: l_text_value wf_activity_attr_values.text_value%type;
595: --
596: begin

Line 593: l_number_value wf_activity_attr_values.number_value%type;

589: l_subtype wf_activity_attributes.subtype%type;
590: l_type wf_activity_attributes.type%type;
591: l_format wf_activity_attributes.format%type;
592: l_date_value wf_activity_attr_values.date_value%type;
593: l_number_value wf_activity_attr_values.number_value%type;
594: l_text_value wf_activity_attr_values.text_value%type;
595: --
596: begin
597: -- check to see if the specified p_web_page_section_code activity

Line 594: l_text_value wf_activity_attr_values.text_value%type;

590: l_type wf_activity_attributes.type%type;
591: l_format wf_activity_attributes.format%type;
592: l_date_value wf_activity_attr_values.date_value%type;
593: l_number_value wf_activity_attr_values.number_value%type;
594: l_text_value wf_activity_attr_values.text_value%type;
595: --
596: begin
597: -- check to see if the specified p_web_page_section_code activity
598: -- attribute exists

Line 624: ,p_actid in wf_activity_attr_values.process_activity_id%type

620: -- ----------------------------------------------------------------------------
621: function get_web_page_code
622: (p_item_type in wf_items.item_type%type
623: ,p_item_key in wf_items.item_key%type
624: ,p_actid in wf_activity_attr_values.process_activity_id%type
625: ,p_web_page_section_code in wf_activity_attributes.name%type)
626: return varchar2 is
627: --
628: l_exists boolean;

Line 632: l_date_value wf_activity_attr_values.date_value%type;

628: l_exists boolean;
629: l_subtype wf_activity_attributes.subtype%type;
630: l_type wf_activity_attributes.type%type;
631: l_format wf_activity_attributes.format%type;
632: l_date_value wf_activity_attr_values.date_value%type;
633: l_number_value wf_activity_attr_values.number_value%type;
634: l_text_value wf_activity_attr_values.text_value%type;
635: --
636: begin

Line 633: l_number_value wf_activity_attr_values.number_value%type;

629: l_subtype wf_activity_attributes.subtype%type;
630: l_type wf_activity_attributes.type%type;
631: l_format wf_activity_attributes.format%type;
632: l_date_value wf_activity_attr_values.date_value%type;
633: l_number_value wf_activity_attr_values.number_value%type;
634: l_text_value wf_activity_attr_values.text_value%type;
635: --
636: begin
637: -- get the p_web_page_section_code activity attribute details

Line 634: l_text_value wf_activity_attr_values.text_value%type;

630: l_type wf_activity_attributes.type%type;
631: l_format wf_activity_attributes.format%type;
632: l_date_value wf_activity_attr_values.date_value%type;
633: l_number_value wf_activity_attr_values.number_value%type;
634: l_text_value wf_activity_attr_values.text_value%type;
635: --
636: begin
637: -- get the p_web_page_section_code activity attribute details
638: get_act_attr_expanded_info

Line 663: ,p_actid in wf_activity_attr_values.process_activity_id%type

659: -- ----------------------------------------------------------------------------
660: procedure get_act_reentry_value_info
661: (p_item_type in wf_items.item_type%type
662: ,p_item_key in wf_items.item_key%type
663: ,p_actid in wf_activity_attr_values.process_activity_id%type
664: ,p_exists out nocopy boolean
665: ,p_result_code out nocopy wf_item_activity_statuses_v.activity_result_code%type) is
666: --
667: cursor l_csr_wiasv is

Line 712: ,p_actid in wf_activity_attr_values.process_activity_id%type)

708: -- ----------------------------------------------------------------------------
709: function check_activity_reentry
710: (p_item_type in wf_items.item_type%type
711: ,p_item_key in wf_items.item_key%type
712: ,p_actid in wf_activity_attr_values.process_activity_id%type)
713: return boolean is
714: --
715: l_exists boolean;
716: l_activity_result_code wf_item_activity_statuses_v.activity_result_code%type;

Line 733: ,p_actid in wf_activity_attr_values.process_activity_id%type)

729: -- ----------------------------------------------------------------------------
730: function get_activity_reentry_value
731: (p_item_type in wf_items.item_type%type
732: ,p_item_key in wf_items.item_key%type
733: ,p_actid in wf_activity_attr_values.process_activity_id%type)
734: return wf_item_activity_statuses_v.activity_result_code%type is
735: --
736: l_exists boolean;
737: l_activity_result_code wf_item_activity_statuses_v.activity_result_code%type;

Line 1074: ,p_actid in wf_activity_attr_values.process_activity_id%type) is

1070: procedure display_html
1071: (p_procedure_name in varchar2
1072: ,p_item_type in wf_items.item_type%type
1073: ,p_item_key in wf_items.item_key%type
1074: ,p_actid in wf_activity_attr_values.process_activity_id%type) is
1075: --
1076: l_cursor_name integer;
1077: l_sqlbuf varchar2(2000);
1078: l_row_processed integer;

Line 1106: l_activity_type wf_activity_attr_values.text_value%type;

1102: procedure continue_process
1103: (p_item_type in wf_items.item_type%type
1104: ,p_item_key in wf_items.item_key%type) is
1105: --
1106: l_activity_type wf_activity_attr_values.text_value%type;
1107: l_activity_type_value wf_activity_attr_values.text_value%type;
1108: l_dummy number(1);
1109: --
1110: cursor csr_prc_active is

Line 1107: l_activity_type_value wf_activity_attr_values.text_value%type;

1103: (p_item_type in wf_items.item_type%type
1104: ,p_item_key in wf_items.item_key%type) is
1105: --
1106: l_activity_type wf_activity_attr_values.text_value%type;
1107: l_activity_type_value wf_activity_attr_values.text_value%type;
1108: l_dummy number(1);
1109: --
1110: cursor csr_prc_active is
1111: select 1

Line 1137: from wf_activity_attr_values waav

1133: and wiasv.activity_type_code = g_wf_function
1134: and wiasv.activity_status_code = g_wf_activity_notified
1135: and exists
1136: (select 1
1137: from wf_activity_attr_values waav
1138: where waav.process_activity_id = wiasv.activity_id
1139: and waav.name in (g_hr_activity_type, g_hr_activity_type_value));*/
1140: SELECT process_activity activity_id
1141: FROM WF_ITEM_ACTIVITY_STATUSES IAS

Line 1147: from wf_activity_attr_values waav

1143: and ias.item_key = p_item_key
1144: and ias.activity_status = g_wf_activity_notified
1145: and exists
1146: (select 1
1147: from wf_activity_attr_values waav
1148: where waav.process_activity_id = ias.process_activity
1149: and waav.name in (g_hr_activity_type, g_hr_activity_type_value));
1150:
1151: -- select the activity attribute NAME and TEXT_VALUE for the specified

Line 1155: (c_process_activity_id wf_activity_attr_values.process_activity_id%type) is

1151: -- select the activity attribute NAME and TEXT_VALUE for the specified
1152: -- ACTIVITY where the activity attribute name is either; HR_ACTIVITY_TYPE
1153: -- and HR_ACTIVITY_TYPE_VALUE
1154: cursor csr_waav
1155: (c_process_activity_id wf_activity_attr_values.process_activity_id%type) is
1156: select waav.name
1157: ,waav.text_value
1158: from wf_activity_attr_values waav
1159: where waav.process_activity_id = c_process_activity_id

Line 1158: from wf_activity_attr_values waav

1154: cursor csr_waav
1155: (c_process_activity_id wf_activity_attr_values.process_activity_id%type) is
1156: select waav.name
1157: ,waav.text_value
1158: from wf_activity_attr_values waav
1159: where waav.process_activity_id = c_process_activity_id
1160: and waav.name in (g_hr_activity_type, g_hr_activity_type_value);
1161: begin
1162: -- check to see if the process is still ACTIVE

Line 1202: ,p_actid in wf_activity_attr_values.process_activity_id%type

1198: -- ----------------------------------------------------------------------------
1199: procedure transition_activity
1200: (p_item_type in wf_items.item_type%type
1201: ,p_item_key in wf_items.item_key%type
1202: ,p_actid in wf_activity_attr_values.process_activity_id%type
1203: ,p_result_code in wf_item_activity_statuses_v.activity_result_code%type) is
1204: --
1205: begin
1206: -- transition the wf engine

Line 1979: wf_activity_attr_values waav,

1975: -- The changes to the program are tracked through bug # 2380121
1976: /*cursor csr_wfdfctitms is
1977: select wias.item_key
1978: from wf_item_activity_statuses wias,
1979: wf_activity_attr_values waav,
1980: wf_process_activities wpa,
1981: wf_item_attribute_values wiav
1982: where wias.item_type = itemtype
1983: and wias.activity_status = 'NOTIFIED'