APPS.HR_WORKFLOW_SERVICE dependencies on WF_ACTIVITY_ATTRIBUTES

Line 293: ,p_name in wf_activity_attributes.name%type

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
297: ,p_format out nocopy wf_activity_attributes.format%type

Line 295: ,p_subtype out nocopy wf_activity_attributes.subtype%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
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

Line 296: ,p_type out nocopy wf_activity_attributes.type%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
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

Line 297: ,p_format out nocopy wf_activity_attributes.format%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
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: -- --------------------------------------------------------------------------

Line 304: l_type wf_activity_attributes.type%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;
305: l_name wf_activity_attributes.name%type := upper(p_name);
306: --
307: begin
308: -- initialise the OUT parameters

Line 305: l_name wf_activity_attributes.name%type := upper(p_name);

301: -- --------------------------------------------------------------------------
302: -- declare local variables
303: -- --------------------------------------------------------------------------
304: l_type wf_activity_attributes.type%type;
305: l_name wf_activity_attributes.name%type := upper(p_name);
306: --
307: begin
308: -- initialise the OUT parameters
309: p_exists := true;

Line 371: l_subtype wf_activity_attributes.subtype%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;
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;

Line 372: l_type wf_activity_attributes.type%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;
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;

Line 373: l_format wf_activity_attributes.format%type;

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

Line 516: l_subtype wf_activity_attributes.subtype%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;
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;

Line 517: l_type wf_activity_attributes.type%type;

513: return boolean is
514: --
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;

Line 518: l_format wf_activity_attributes.format%type;

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

Line 550: l_subtype wf_activity_attributes.subtype%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;
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;

Line 551: l_type wf_activity_attributes.type%type;

547: return varchar2 is
548: --
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;

Line 552: l_format wf_activity_attributes.format%type;

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

Line 585: ,p_web_page_section_code in wf_activity_attributes.name%type)

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;
589: l_subtype wf_activity_attributes.subtype%type;

Line 589: l_subtype wf_activity_attributes.subtype%type;

585: ,p_web_page_section_code in wf_activity_attributes.name%type)
586: return boolean is
587: --
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;

Line 590: l_type wf_activity_attributes.type%type;

586: return boolean is
587: --
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;

Line 591: l_format wf_activity_attributes.format%type;

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

Line 625: ,p_web_page_section_code in wf_activity_attributes.name%type)

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;
629: l_subtype wf_activity_attributes.subtype%type;

Line 629: l_subtype wf_activity_attributes.subtype%type;

625: ,p_web_page_section_code in wf_activity_attributes.name%type)
626: return varchar2 is
627: --
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;

Line 630: l_type wf_activity_attributes.type%type;

626: return varchar2 is
627: --
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;

Line 631: l_format wf_activity_attributes.format%type;

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