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_ITEMS

Line 21: (p_item_type in wf_items.item_type%type

17: -- ----------------------------------------------------------------------------
18: -- |-------------------------< item_attribute_exists >------------------------|
19: -- ----------------------------------------------------------------------------
20: function item_attribute_exists
21: (p_item_type in wf_items.item_type%type
22: ,p_item_key in wf_items.item_key%type
23: ,p_name in wf_item_attribute_values.name%type)
24: return boolean is
25: -- --------------------------------------------------------------------------

Line 22: ,p_item_key in wf_items.item_key%type

18: -- |-------------------------< item_attribute_exists >------------------------|
19: -- ----------------------------------------------------------------------------
20: function item_attribute_exists
21: (p_item_type in wf_items.item_type%type
22: ,p_item_key in wf_items.item_key%type
23: ,p_name in wf_item_attribute_values.name%type)
24: return boolean is
25: -- --------------------------------------------------------------------------
26: -- declare local variables

Line 101: (p_item_type in wf_items.item_type%type

97: -- ----------------------------------------------------------------------------
98: -- |------------------------< get_activity_name >-----------------------------|
99: -- ----------------------------------------------------------------------------
100: procedure get_activity_name
101: (p_item_type in wf_items.item_type%type
102: ,p_item_key in wf_items.item_key%type
103: ,p_actid in number
104: ,p_activity_name out nocopy varchar2
105: ,p_activity_display_name out nocopy varchar2) is

Line 102: ,p_item_key in wf_items.item_key%type

98: -- |------------------------< get_activity_name >-----------------------------|
99: -- ----------------------------------------------------------------------------
100: procedure get_activity_name
101: (p_item_type in wf_items.item_type%type
102: ,p_item_key in wf_items.item_key%type
103: ,p_actid in number
104: ,p_activity_name out nocopy varchar2
105: ,p_activity_display_name out nocopy varchar2) is
106: --

Line 150: (p_item_type in wf_items.item_type%type

146: -- ----------------------------------------------------------------------------
147: -- |------------------------< create_hr_directory_services >------------------|
148: -- ----------------------------------------------------------------------------
149: procedure create_hr_directory_services
150: (p_item_type in wf_items.item_type%type
151: ,p_item_key in wf_items.item_key%type
152: ,p_service_name in varchar2
153: ,p_service_person_id in per_all_people_f.person_id%type) is
154: --

Line 151: ,p_item_key in wf_items.item_key%type

147: -- |------------------------< create_hr_directory_services >------------------|
148: -- ----------------------------------------------------------------------------
149: procedure create_hr_directory_services
150: (p_item_type in wf_items.item_type%type
151: ,p_item_key in wf_items.item_key%type
152: ,p_service_name in varchar2
153: ,p_service_person_id in per_all_people_f.person_id%type) is
154: --
155: l_item_type_attribute_name varchar2(30);

Line 220: (p_item_type in wf_items.item_type%type

216: -- ----------------------------------------------------------------------------
217: -- |-------------------------< get_item_attr_expanded_info >------------------|
218: -- ----------------------------------------------------------------------------
219: procedure get_item_attr_expanded_info
220: (p_item_type in wf_items.item_type%type
221: ,p_item_key in wf_items.item_key%type
222: ,p_name in wf_item_attributes.name%type
223: ,p_exists out nocopy boolean
224: ,p_subtype out nocopy wf_item_attributes.subtype%type

Line 221: ,p_item_key in wf_items.item_key%type

217: -- |-------------------------< get_item_attr_expanded_info >------------------|
218: -- ----------------------------------------------------------------------------
219: procedure get_item_attr_expanded_info
220: (p_item_type in wf_items.item_type%type
221: ,p_item_key in wf_items.item_key%type
222: ,p_name in wf_item_attributes.name%type
223: ,p_exists out nocopy boolean
224: ,p_subtype out nocopy wf_item_attributes.subtype%type
225: ,p_type out nocopy wf_item_attributes.type%type

Line 290: (p_item_type in wf_items.item_type%type

286: -- ----------------------------------------------------------------------------
287: -- |-------------------------< get_act_attr_expanded_info >------------------|
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

Line 291: ,p_item_key in wf_items.item_key%type

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

Line 366: (p_item_type in wf_items.item_type%type

362: -- ----------------------------------------------------------------------------
363: -- |-------------------------< check_activity_type_attrs >--------------------|
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;

Line 367: ,p_item_key in wf_items.item_key%type

363: -- |-------------------------< check_activity_type_attrs >--------------------|
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;

Line 510: (p_item_type in wf_items.item_type%type

506: -- ----------------------------------------------------------------------------
507: -- |-------------------------< check_hr_window_title >------------------------|
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: --

Line 511: ,p_item_key in wf_items.item_key%type

507: -- |-------------------------< check_hr_window_title >------------------------|
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;

Line 544: (p_item_type in wf_items.item_type%type

540: -- ----------------------------------------------------------------------------
541: -- |---------------------------< get_hr_window_title >------------------------|
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: --

Line 545: ,p_item_key in wf_items.item_key%type

541: -- |---------------------------< get_hr_window_title >------------------------|
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;

Line 582: (p_item_type in wf_items.item_type%type

578: -- ----------------------------------------------------------------------------
579: -- |-------------------------< check_web_page_code >--------------------------|
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

Line 583: ,p_item_key in wf_items.item_key%type

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

Line 622: (p_item_type in wf_items.item_type%type

618: -- ----------------------------------------------------------------------------
619: -- |-----------------------------< get_web_page_code >------------------------|
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

Line 623: ,p_item_key in wf_items.item_key%type

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

Line 661: (p_item_type in wf_items.item_type%type

657: -- ----------------------------------------------------------------------------
658: -- |-------------------------< get_act_reentry_value_info >-------------------|
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

Line 662: ,p_item_key in wf_items.item_key%type

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

Line 710: (p_item_type in wf_items.item_type%type

706: -- ----------------------------------------------------------------------------
707: -- |-------------------------< check_activity_reentry >-----------------------|
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: --

Line 711: ,p_item_key in wf_items.item_key%type

707: -- |-------------------------< check_activity_reentry >-----------------------|
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;

Line 731: (p_item_type in wf_items.item_type%type

727: -- ----------------------------------------------------------------------------
728: -- |-------------------------< get_activity_reentry_value >-------------------|
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: --

Line 732: ,p_item_key in wf_items.item_key%type

728: -- |-------------------------< get_activity_reentry_value >-------------------|
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;

Line 752: (p_item_type in wf_items.item_type%type

748: -- ----------------------------------------------------------------------------
749: -- |--------------------< wf_get_runnable_process_name >----------------------|
750: -- ----------------------------------------------------------------------------
751: function wf_get_runnable_process_name
752: (p_item_type in wf_items.item_type%type
753: ,p_process_name in wf_process_activities.process_name%type)
754: return wf_runnable_processes_v.display_name%type is
755: -- cursor determines is the specified process is runnable
756: cursor csr_wrpv is

Line 779: (p_item_type in wf_items.item_type%type

775: -- ----------------------------------------------------------------------------
776: -- |-------------------------< wf_process_runnable >--------------------------|
777: -- ----------------------------------------------------------------------------
778: function wf_process_runnable
779: (p_item_type in wf_items.item_type%type
780: ,p_process_name in wf_process_activities.process_name%type)
781: return boolean is
782: --
783: begin

Line 797: ,p_item_type in wf_items.item_type%type

793: -- |------------------------------< create_process >--------------------------|
794: -- ----------------------------------------------------------------------------
795: procedure create_process
796: (p_process_name in wf_process_activities.process_name%type
797: ,p_item_type in wf_items.item_type%type
798: ,p_person_id in varchar2 default null
799: ,p_called_from in varchar2 default null
800: ,p_item_attribute in g_varchar2_tab_type
801: default g_varchar2_tab_default

Line 809: l_item_type wf_items.item_type%type := upper(p_item_type);

805: --
806: l_process_name wf_process_activities.process_name%type :=
807: upper(p_process_name);
808:
809: l_item_type wf_items.item_type%type := upper(p_item_type);
810: l_item_key wf_items.item_key%type;
811: --
812: l_creator_person_id per_people_f.person_id%type;
813: l_index binary_integer;

Line 810: l_item_key wf_items.item_key%type;

806: l_process_name wf_process_activities.process_name%type :=
807: upper(p_process_name);
808:
809: l_item_type wf_items.item_type%type := upper(p_item_type);
810: l_item_key wf_items.item_key%type;
811: --
812: l_creator_person_id per_people_f.person_id%type;
813: l_index binary_integer;
814: l_temp_item_attribute varchar2(2000);

Line 1072: ,p_item_type in wf_items.item_type%type

1068: -- |------------------------------< display_html >----------------------------|
1069: -- ----------------------------------------------------------------------------
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;

Line 1073: ,p_item_key in wf_items.item_key%type

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

Line 1103: (p_item_type in wf_items.item_type%type

1099: -- ----------------------------------------------------------------------------
1100: -- |---------------------------< continue_process >---------------------------|
1101: -- ----------------------------------------------------------------------------
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;

Line 1104: ,p_item_key in wf_items.item_key%type) is

1100: -- |---------------------------< continue_process >---------------------------|
1101: -- ----------------------------------------------------------------------------
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);

Line 1200: (p_item_type in wf_items.item_type%type

1196: -- ----------------------------------------------------------------------------
1197: -- |------------------------< transition_activity >---------------------------|
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: --

Line 1201: ,p_item_key in wf_items.item_key%type

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

Line 1220: -- |-------------------------< check_active_wf_items >-- ---------------------|

1216: --
1217: end transition_activity;
1218: --
1219: -- ----------------------------------------------------------------------------
1220: -- |-------------------------< check_active_wf_items >-- ---------------------|
1221: -- ----------------------------------------------------------------------------
1222: -- Purpose: This function is overloaded. It will only return the pending
1223: -- approval workflow items for a section of a page, ie. by
1224: -- activity_result_code to a table.

Line 1226: function check_active_wf_items

1222: -- Purpose: This function is overloaded. It will only return the pending
1223: -- approval workflow items for a section of a page, ie. by
1224: -- activity_result_code to a table.
1225: -- ----------------------------------------------------------------------------
1226: function check_active_wf_items
1227: (p_item_type in wf_items.item_type%type
1228: ,p_process_name in wf_process_activities.process_name%type
1229: ,p_current_person_id in per_people_f.person_id%type
1230: ,p_activity_name in wf_item_activity_statuses_v.activity_name%type

Line 1227: (p_item_type in wf_items.item_type%type

1223: -- approval workflow items for a section of a page, ie. by
1224: -- activity_result_code to a table.
1225: -- ----------------------------------------------------------------------------
1226: function check_active_wf_items
1227: (p_item_type in wf_items.item_type%type
1228: ,p_process_name in wf_process_activities.process_name%type
1229: ,p_current_person_id in per_people_f.person_id%type
1230: ,p_activity_name in wf_item_activity_statuses_v.activity_name%type
1231: ,p_activity_result_code in varchar2

Line 1233: return active_wf_items_list is

1229: ,p_current_person_id in per_people_f.person_id%type
1230: ,p_activity_name in wf_item_activity_statuses_v.activity_name%type
1231: ,p_activity_result_code in varchar2
1232: )
1233: return active_wf_items_list is
1234: --
1235: l_process_name wf_process_activities.process_name%type;
1236: l_active_item_key wf_items.item_key%type;
1237: l_dummy number(1);

Line 1236: l_active_item_key wf_items.item_key%type;

1232: )
1233: return active_wf_items_list is
1234: --
1235: l_process_name wf_process_activities.process_name%type;
1236: l_active_item_key wf_items.item_key%type;
1237: l_dummy number(1);
1238: l_count integer;
1239: l_active_wf_items_list hr_workflow_service.active_wf_items_list;
1240: l_activity_id wf_item_activity_statuses_v.activity_id%type;

Line 1239: l_active_wf_items_list hr_workflow_service.active_wf_items_list;

1235: l_process_name wf_process_activities.process_name%type;
1236: l_active_item_key wf_items.item_key%type;
1237: l_dummy number(1);
1238: l_count integer;
1239: l_active_wf_items_list hr_workflow_service.active_wf_items_list;
1240: l_activity_id wf_item_activity_statuses_v.activity_id%type;
1241: --
1242: -- Local cursor definations
1243: -- csr_wf_active_item Returns the item key of any process which

Line 1248: ,p_item_type in wf_items.item_type%type

1244: -- is currently active with the name of p_process and belonging to
1245: -- the given person id
1246: cursor csr_wfactitms (p_current_person_id in per_people_f.person_id%type
1247: ,p_process_name in wf_process_activities.process_name%type
1248: ,p_item_type in wf_items.item_type%type
1249: ) is
1250:
1251: -- fix for the bug1835437
1252: SELECT /*+ ordered */

Line 1389: -- to the l_active_wf_items_list table. Otherwise,

1385: -- upper(l_activity_result_code) THEN
1386: -------------------------------------------------------
1387: -- NOTE: The count increment statement must be at
1388: -- the place where a row is to be written
1389: -- to the l_active_wf_items_list table. Otherwise,
1390: -- we'll get index mismatched problem with the
1391: -- NO_DATA_FOUND error when accessing the table.
1392: -------------------------------------------------------
1393: l_count := l_count + 1;

Line 1394: l_active_wf_items_list(l_count).active_item_key

1390: -- we'll get index mismatched problem with the
1391: -- NO_DATA_FOUND error when accessing the table.
1392: -------------------------------------------------------
1393: l_count := l_count + 1;
1394: l_active_wf_items_list(l_count).active_item_key
1395: := l_active_item_key;
1396: l_active_wf_items_list(l_count).activity_id
1397: := l_activity_id;
1398: l_active_wf_items_list(l_count).activity_result_code

Line 1396: l_active_wf_items_list(l_count).activity_id

1392: -------------------------------------------------------
1393: l_count := l_count + 1;
1394: l_active_wf_items_list(l_count).active_item_key
1395: := l_active_item_key;
1396: l_active_wf_items_list(l_count).activity_id
1397: := l_activity_id;
1398: l_active_wf_items_list(l_count).activity_result_code
1399: := l_activity_result_code;
1400: --END IF;

Line 1398: l_active_wf_items_list(l_count).activity_result_code

1394: l_active_wf_items_list(l_count).active_item_key
1395: := l_active_item_key;
1396: l_active_wf_items_list(l_count).activity_id
1397: := l_activity_id;
1398: l_active_wf_items_list(l_count).activity_result_code
1399: := l_activity_result_code;
1400: --END IF;
1401: end if;
1402: close csr_wfactname;

Line 1407: return l_active_wf_items_list;

1403: end if;
1404: close csr_hats;
1405: end if;
1406: end loop;
1407: return l_active_wf_items_list;
1408: --
1409: end check_active_wf_items;
1410: -- ----------------------------------------------------------------------------
1411: -- |-------------------------< check_active_wf_items >-------------------------|

Line 1409: end check_active_wf_items;

1405: end if;
1406: end loop;
1407: return l_active_wf_items_list;
1408: --
1409: end check_active_wf_items;
1410: -- ----------------------------------------------------------------------------
1411: -- |-------------------------< check_active_wf_items >-------------------------|
1412: -- ----------------------------------------------------------------------------
1413: -- Purpose: This function will return all the pending approval workflow items

Line 1411: -- |-------------------------< check_active_wf_items >-------------------------|

1407: return l_active_wf_items_list;
1408: --
1409: end check_active_wf_items;
1410: -- ----------------------------------------------------------------------------
1411: -- |-------------------------< check_active_wf_items >-------------------------|
1412: -- ----------------------------------------------------------------------------
1413: -- Purpose: This function will return all the pending approval workflow items
1414: -- for a page. If a page has many sections, the caller need to filter
1415: -- the pending approval workflow items to find out if a particular

Line 1419: function check_active_wf_items

1415: -- the pending approval workflow items to find out if a particular
1416: -- section has active pending approval items by comparing the
1417: -- activity result code.
1418: -- ----------------------------------------------------------------------------
1419: function check_active_wf_items
1420: (p_item_type in wf_items.item_type%type
1421: ,p_process_name in wf_process_activities.process_name%type
1422: ,p_current_person_id in per_people_f.person_id%type
1423: ,p_activity_name in wf_item_activity_statuses_v.activity_name%type

Line 1420: (p_item_type in wf_items.item_type%type

1416: -- section has active pending approval items by comparing the
1417: -- activity result code.
1418: -- ----------------------------------------------------------------------------
1419: function check_active_wf_items
1420: (p_item_type in wf_items.item_type%type
1421: ,p_process_name in wf_process_activities.process_name%type
1422: ,p_current_person_id in per_people_f.person_id%type
1423: ,p_activity_name in wf_item_activity_statuses_v.activity_name%type
1424: )

Line 1425: return active_wf_items_list is

1421: ,p_process_name in wf_process_activities.process_name%type
1422: ,p_current_person_id in per_people_f.person_id%type
1423: ,p_activity_name in wf_item_activity_statuses_v.activity_name%type
1424: )
1425: return active_wf_items_list is
1426: --
1427: l_process_name wf_process_activities.process_name%type;
1428: l_active_item_key wf_items.item_key%type;
1429: l_dummy number(1);

Line 1428: l_active_item_key wf_items.item_key%type;

1424: )
1425: return active_wf_items_list is
1426: --
1427: l_process_name wf_process_activities.process_name%type;
1428: l_active_item_key wf_items.item_key%type;
1429: l_dummy number(1);
1430: l_count integer;
1431: l_active_wf_items_list hr_workflow_service.active_wf_items_list;
1432: l_activity_id wf_item_activity_statuses_v.activity_id%type;

Line 1431: l_active_wf_items_list hr_workflow_service.active_wf_items_list;

1427: l_process_name wf_process_activities.process_name%type;
1428: l_active_item_key wf_items.item_key%type;
1429: l_dummy number(1);
1430: l_count integer;
1431: l_active_wf_items_list hr_workflow_service.active_wf_items_list;
1432: l_activity_id wf_item_activity_statuses_v.activity_id%type;
1433: --
1434: -- Local cursor definations
1435: -- csr_wf_active_item Returns the item key of any process which

Line 1440: ,p_item_type in wf_items.item_type%type

1436: -- is currently active with the name of p_process and belonging to
1437: -- the given person id
1438: cursor csr_wfactitms (p_current_person_id in per_people_f.person_id%type
1439: ,p_process_name in wf_process_activities.process_name%type
1440: ,p_item_type in wf_items.item_type%type
1441: ) is
1442:
1443:
1444: -- fix for the bug1835437

Line 1555: l_active_wf_items_list(l_count).active_item_key

1551: if csr_hats%notfound then
1552: l_active_item_key := null;
1553: else
1554: l_count := l_count + 1;
1555: l_active_wf_items_list(l_count).active_item_key
1556: := l_active_item_key;
1557: -- Open cursor and get the activity name
1558: open csr_wfactname;
1559: fetch csr_wfactname into l_activity_id;

Line 1563: l_active_wf_items_list(l_count).activity_id

1559: fetch csr_wfactname into l_activity_id;
1560: if csr_wfactname%notfound then
1561: l_activity_id := null;
1562: else
1563: l_active_wf_items_list(l_count).activity_id
1564: := l_activity_id;
1565: l_active_wf_items_list(l_count).activity_result_code
1566: := hr_workflow_service.get_activity_reentry_value
1567: (p_item_type => p_item_type

Line 1565: l_active_wf_items_list(l_count).activity_result_code

1561: l_activity_id := null;
1562: else
1563: l_active_wf_items_list(l_count).activity_id
1564: := l_activity_id;
1565: l_active_wf_items_list(l_count).activity_result_code
1566: := hr_workflow_service.get_activity_reentry_value
1567: (p_item_type => p_item_type
1568: ,p_item_key => l_active_item_key
1569: ,p_actid => l_activity_id);

Line 1576: return l_active_wf_items_list;

1572: end if;
1573: close csr_hats;
1574: end if;
1575: end loop;
1576: return l_active_wf_items_list;
1577: --
1578: end check_active_wf_items;
1579: --
1580: -- ----------------------------------------------------------------------------

Line 1578: end check_active_wf_items;

1574: end if;
1575: end loop;
1576: return l_active_wf_items_list;
1577: --
1578: end check_active_wf_items;
1579: --
1580: -- ----------------------------------------------------------------------------
1581: -- |---------------------------< get_active_wf_items >-------------------------|
1582: -- ----------------------------------------------------------------------------

Line 1581: -- |---------------------------< get_active_wf_items >-------------------------|

1577: --
1578: end check_active_wf_items;
1579: --
1580: -- ----------------------------------------------------------------------------
1581: -- |---------------------------< get_active_wf_items >-------------------------|
1582: -- ----------------------------------------------------------------------------
1583: -- Purpose: This function will return all the pending approval workflow items
1584: -- for a page. If a page has many sections, the caller can pass
1585: -- the result code to find out if a particular section has active

Line 1595: FUNCTION get_active_wf_items

1591: -- a value of either "PRIMARY" or "SECONDARY" in the parameter
1592: -- p_address_context because Primary Address and Secondary Address
1593: -- share the same api name, which is hr_process_address_ss.
1594: -- ----------------------------------------------------------------------------
1595: FUNCTION get_active_wf_items
1596: (p_item_type in wf_items.item_type%type
1597: ,p_process_name in wf_process_activities.process_name%type
1598: ,p_current_person_id in per_people_f.person_id%type
1599: ,p_api_name in hr_api_transaction_steps.api_name%type

Line 1596: (p_item_type in wf_items.item_type%type

1592: -- p_address_context because Primary Address and Secondary Address
1593: -- share the same api name, which is hr_process_address_ss.
1594: -- ----------------------------------------------------------------------------
1595: FUNCTION get_active_wf_items
1596: (p_item_type in wf_items.item_type%type
1597: ,p_process_name in wf_process_activities.process_name%type
1598: ,p_current_person_id in per_people_f.person_id%type
1599: ,p_api_name in hr_api_transaction_steps.api_name%type
1600: ,p_activity_result_code in varchar2 default null

Line 1606: l_active_item_key wf_items.item_key%type;

1602: )
1603: return active_wf_trans_items_list is
1604: --
1605: l_process_name wf_process_activities.process_name%type;
1606: l_active_item_key wf_items.item_key%type;
1607: l_count integer;
1608: l_active_wf_items_list hr_workflow_service.active_wf_trans_items_list;
1609: l_activity_id wf_item_activity_statuses_v.activity_id%type;
1610: --

Line 1608: l_active_wf_items_list hr_workflow_service.active_wf_trans_items_list;

1604: --
1605: l_process_name wf_process_activities.process_name%type;
1606: l_active_item_key wf_items.item_key%type;
1607: l_count integer;
1608: l_active_wf_items_list hr_workflow_service.active_wf_trans_items_list;
1609: l_activity_id wf_item_activity_statuses_v.activity_id%type;
1610: --
1611: -- Local cursor definitions
1612: -----------------------------------------------------------------------------

Line 1624: ,p_item_type in wf_items.item_type%type

1620: -- submit for approval.
1621: -----------------------------------------------------------------------------
1622: cursor csr_wfactitms (p_current_person_id in per_people_f.person_id%type
1623: ,p_process_name in wf_process_activities.process_name%type
1624: ,p_item_type in wf_items.item_type%type
1625: ,p_result_code in varchar2
1626: ) is
1627:
1628: select process.item_key

Line 1656: ,p_item_type in wf_items.item_type%type

1652: -- The following cursor is for no result code passed in.
1653: -----------------------------------------------------------------------------
1654: cursor csr_wfactitms2 (p_current_person_id in per_people_f.person_id%type
1655: ,p_process_name in wf_process_activities.process_name%type
1656: ,p_item_type in wf_items.item_type%type
1657: ) is
1658:
1659: select process.item_key
1660: from wf_item_activity_statuses process

Line 1789: -- to the l_active_wf_items_list table. Otherwise,

1785: LOOP
1786: -------------------------------------------------------
1787: -- NOTE: The count increment statement must be at
1788: -- the place where a row is to be written
1789: -- to the l_active_wf_items_list table. Otherwise,
1790: -- we'll get index mismatched problem with the
1791: -- NO_DATA_FOUND error when accessing the table.
1792: -------------------------------------------------------
1793: l_count := l_count + 1;

Line 1794: l_active_wf_items_list(l_count).active_item_key

1790: -- we'll get index mismatched problem with the
1791: -- NO_DATA_FOUND error when accessing the table.
1792: -------------------------------------------------------
1793: l_count := l_count + 1;
1794: l_active_wf_items_list(l_count).active_item_key
1795: := l_active_item_key;
1796: l_active_wf_items_list(l_count).activity_id :=
1797: csr_trans.activity_id;
1798: l_active_wf_items_list(l_count).trans_step_id :=

Line 1796: l_active_wf_items_list(l_count).activity_id :=

1792: -------------------------------------------------------
1793: l_count := l_count + 1;
1794: l_active_wf_items_list(l_count).active_item_key
1795: := l_active_item_key;
1796: l_active_wf_items_list(l_count).activity_id :=
1797: csr_trans.activity_id;
1798: l_active_wf_items_list(l_count).trans_step_id :=
1799: csr_trans.transaction_step_id;
1800: l_active_wf_items_list(l_count).activity_result_code

Line 1798: l_active_wf_items_list(l_count).trans_step_id :=

1794: l_active_wf_items_list(l_count).active_item_key
1795: := l_active_item_key;
1796: l_active_wf_items_list(l_count).activity_id :=
1797: csr_trans.activity_id;
1798: l_active_wf_items_list(l_count).trans_step_id :=
1799: csr_trans.transaction_step_id;
1800: l_active_wf_items_list(l_count).activity_result_code
1801: := l_activity_result_code;
1802: END LOOP; -- end inner loop for address

Line 1800: l_active_wf_items_list(l_count).activity_result_code

1796: l_active_wf_items_list(l_count).activity_id :=
1797: csr_trans.activity_id;
1798: l_active_wf_items_list(l_count).trans_step_id :=
1799: csr_trans.transaction_step_id;
1800: l_active_wf_items_list(l_count).activity_result_code
1801: := l_activity_result_code;
1802: END LOOP; -- end inner loop for address
1803: -- ELSE Please remove comment if registration removed
1804: -- startregistration

Line 1814: -- to the l_active_wf_items_list table. Otherwise,

1810: LOOP
1811: -------------------------------------------------------
1812: -- NOTE: The count increment statement must be at
1813: -- the place where a row is to be written
1814: -- to the l_active_wf_items_list table. Otherwise,
1815: -- we'll get index mismatched problem with the
1816: -- NO_DATA_FOUND error when accessing the table.
1817: -------------------------------------------------------
1818: l_count := l_count + 1;

Line 1819: l_active_wf_items_list(l_count).active_item_key

1815: -- we'll get index mismatched problem with the
1816: -- NO_DATA_FOUND error when accessing the table.
1817: -------------------------------------------------------
1818: l_count := l_count + 1;
1819: l_active_wf_items_list(l_count).active_item_key
1820: := l_active_item_key;
1821: l_active_wf_items_list(l_count).activity_id :=
1822: csr_trans.activity_id;
1823: l_active_wf_items_list(l_count).trans_step_id :=

Line 1821: l_active_wf_items_list(l_count).activity_id :=

1817: -------------------------------------------------------
1818: l_count := l_count + 1;
1819: l_active_wf_items_list(l_count).active_item_key
1820: := l_active_item_key;
1821: l_active_wf_items_list(l_count).activity_id :=
1822: csr_trans.activity_id;
1823: l_active_wf_items_list(l_count).trans_step_id :=
1824: csr_trans.transaction_step_id;
1825: l_active_wf_items_list(l_count).activity_result_code

Line 1823: l_active_wf_items_list(l_count).trans_step_id :=

1819: l_active_wf_items_list(l_count).active_item_key
1820: := l_active_item_key;
1821: l_active_wf_items_list(l_count).activity_id :=
1822: csr_trans.activity_id;
1823: l_active_wf_items_list(l_count).trans_step_id :=
1824: csr_trans.transaction_step_id;
1825: l_active_wf_items_list(l_count).activity_result_code
1826: := l_activity_result_code;
1827: END LOOP; -- end inner loop

Line 1825: l_active_wf_items_list(l_count).activity_result_code

1821: l_active_wf_items_list(l_count).activity_id :=
1822: csr_trans.activity_id;
1823: l_active_wf_items_list(l_count).trans_step_id :=
1824: csr_trans.transaction_step_id;
1825: l_active_wf_items_list(l_count).activity_result_code
1826: := l_activity_result_code;
1827: END LOOP; -- end inner loop
1828: -- startregistration
1829: ELSIF l_use_csr_addr_hats = 'T'

Line 1837: -- to the l_active_wf_items_list table. Otherwise,

1833: LOOP
1834: -------------------------------------------------------
1835: -- NOTE: The count increment statement must be at
1836: -- the place where a row is to be written
1837: -- to the l_active_wf_items_list table. Otherwise,
1838: -- we'll get index mismatched problem with the
1839: -- NO_DATA_FOUND error when accessing the table.
1840: -------------------------------------------------------
1841: l_count := l_count + 1;

Line 1842: l_active_wf_items_list(l_count).active_item_key

1838: -- we'll get index mismatched problem with the
1839: -- NO_DATA_FOUND error when accessing the table.
1840: -------------------------------------------------------
1841: l_count := l_count + 1;
1842: l_active_wf_items_list(l_count).active_item_key
1843: := l_active_item_key;
1844: l_active_wf_items_list(l_count).activity_id :=
1845: csr_trans.activity_id;
1846: l_active_wf_items_list(l_count).trans_step_id :=

Line 1844: l_active_wf_items_list(l_count).activity_id :=

1840: -------------------------------------------------------
1841: l_count := l_count + 1;
1842: l_active_wf_items_list(l_count).active_item_key
1843: := l_active_item_key;
1844: l_active_wf_items_list(l_count).activity_id :=
1845: csr_trans.activity_id;
1846: l_active_wf_items_list(l_count).trans_step_id :=
1847: csr_trans.transaction_step_id;
1848: l_active_wf_items_list(l_count).activity_result_code

Line 1846: l_active_wf_items_list(l_count).trans_step_id :=

1842: l_active_wf_items_list(l_count).active_item_key
1843: := l_active_item_key;
1844: l_active_wf_items_list(l_count).activity_id :=
1845: csr_trans.activity_id;
1846: l_active_wf_items_list(l_count).trans_step_id :=
1847: csr_trans.transaction_step_id;
1848: l_active_wf_items_list(l_count).activity_result_code
1849: := l_activity_result_code;
1850: END LOOP; -- end inner loop

Line 1848: l_active_wf_items_list(l_count).activity_result_code

1844: l_active_wf_items_list(l_count).activity_id :=
1845: csr_trans.activity_id;
1846: l_active_wf_items_list(l_count).trans_step_id :=
1847: csr_trans.transaction_step_id;
1848: l_active_wf_items_list(l_count).activity_result_code
1849: := l_activity_result_code;
1850: END LOOP; -- end inner loop
1851: -- endregistration
1852: END IF;

Line 1876: -- to the l_active_wf_items_list table. Otherwise,

1872: LOOP
1873: -------------------------------------------------------
1874: -- NOTE: The count increment statement must be at
1875: -- the place where a row is to be written
1876: -- to the l_active_wf_items_list table. Otherwise,
1877: -- we'll get index mismatched problem with the
1878: -- NO_DATA_FOUND error when accessing the table.
1879: -------------------------------------------------------
1880: l_count := l_count + 1;

Line 1881: l_active_wf_items_list(l_count).active_item_key

1877: -- we'll get index mismatched problem with the
1878: -- NO_DATA_FOUND error when accessing the table.
1879: -------------------------------------------------------
1880: l_count := l_count + 1;
1881: l_active_wf_items_list(l_count).active_item_key
1882: := l_active_item_key;
1883: l_active_wf_items_list(l_count).activity_id :=
1884: csr_trans.activity_id;
1885: l_active_wf_items_list(l_count).trans_step_id :=

Line 1883: l_active_wf_items_list(l_count).activity_id :=

1879: -------------------------------------------------------
1880: l_count := l_count + 1;
1881: l_active_wf_items_list(l_count).active_item_key
1882: := l_active_item_key;
1883: l_active_wf_items_list(l_count).activity_id :=
1884: csr_trans.activity_id;
1885: l_active_wf_items_list(l_count).trans_step_id :=
1886: csr_trans.transaction_step_id;
1887: l_active_wf_items_list(l_count).activity_result_code

Line 1885: l_active_wf_items_list(l_count).trans_step_id :=

1881: l_active_wf_items_list(l_count).active_item_key
1882: := l_active_item_key;
1883: l_active_wf_items_list(l_count).activity_id :=
1884: csr_trans.activity_id;
1885: l_active_wf_items_list(l_count).trans_step_id :=
1886: csr_trans.transaction_step_id;
1887: l_active_wf_items_list(l_count).activity_result_code
1888: := l_activity_result_code;
1889: END LOOP; -- end inner loop for address

Line 1887: l_active_wf_items_list(l_count).activity_result_code

1883: l_active_wf_items_list(l_count).activity_id :=
1884: csr_trans.activity_id;
1885: l_active_wf_items_list(l_count).trans_step_id :=
1886: csr_trans.transaction_step_id;
1887: l_active_wf_items_list(l_count).activity_result_code
1888: := l_activity_result_code;
1889: END LOOP; -- end inner loop for address
1890: -- ELSE Please remove comment if registration removed
1891: --startregistration

Line 1901: -- to the l_active_wf_items_list table. Otherwise,

1897: LOOP
1898: -------------------------------------------------------
1899: -- NOTE: The count increment statement must be at
1900: -- the place where a row is to be written
1901: -- to the l_active_wf_items_list table. Otherwise,
1902: -- we'll get index mismatched problem with the
1903: -- NO_DATA_FOUND error when accessing the table.
1904: -------------------------------------------------------
1905: -- no result code passed in for filtering

Line 1907: l_active_wf_items_list(l_count).active_item_key

1903: -- NO_DATA_FOUND error when accessing the table.
1904: -------------------------------------------------------
1905: -- no result code passed in for filtering
1906: l_count := l_count + 1;
1907: l_active_wf_items_list(l_count).active_item_key
1908: := l_active_item_key;
1909: l_active_wf_items_list(l_count).activity_id :=
1910: csr_trans.activity_id;
1911: l_active_wf_items_list(l_count).trans_step_id :=

Line 1909: l_active_wf_items_list(l_count).activity_id :=

1905: -- no result code passed in for filtering
1906: l_count := l_count + 1;
1907: l_active_wf_items_list(l_count).active_item_key
1908: := l_active_item_key;
1909: l_active_wf_items_list(l_count).activity_id :=
1910: csr_trans.activity_id;
1911: l_active_wf_items_list(l_count).trans_step_id :=
1912: csr_trans.transaction_step_id;
1913: l_active_wf_items_list(l_count).activity_result_code

Line 1911: l_active_wf_items_list(l_count).trans_step_id :=

1907: l_active_wf_items_list(l_count).active_item_key
1908: := l_active_item_key;
1909: l_active_wf_items_list(l_count).activity_id :=
1910: csr_trans.activity_id;
1911: l_active_wf_items_list(l_count).trans_step_id :=
1912: csr_trans.transaction_step_id;
1913: l_active_wf_items_list(l_count).activity_result_code
1914: := l_activity_result_code;
1915: END LOOP; -- inner loop

Line 1913: l_active_wf_items_list(l_count).activity_result_code

1909: l_active_wf_items_list(l_count).activity_id :=
1910: csr_trans.activity_id;
1911: l_active_wf_items_list(l_count).trans_step_id :=
1912: csr_trans.transaction_step_id;
1913: l_active_wf_items_list(l_count).activity_result_code
1914: := l_activity_result_code;
1915: END LOOP; -- inner loop
1916: --startregistration
1917: ELSIF l_use_csr_addr_hats = 'T'

Line 1925: -- to the l_active_wf_items_list table. Otherwise,

1921: LOOP
1922: -------------------------------------------------------
1923: -- NOTE: The count increment statement must be at
1924: -- the place where a row is to be written
1925: -- to the l_active_wf_items_list table. Otherwise,
1926: -- we'll get index mismatched problem with the
1927: -- NO_DATA_FOUND error when accessing the table.
1928: -------------------------------------------------------
1929: -- no result code passed in for filtering

Line 1931: l_active_wf_items_list(l_count).active_item_key

1927: -- NO_DATA_FOUND error when accessing the table.
1928: -------------------------------------------------------
1929: -- no result code passed in for filtering
1930: l_count := l_count + 1;
1931: l_active_wf_items_list(l_count).active_item_key
1932: := l_active_item_key;
1933: l_active_wf_items_list(l_count).activity_id :=
1934: csr_trans.activity_id;
1935: l_active_wf_items_list(l_count).trans_step_id :=

Line 1933: l_active_wf_items_list(l_count).activity_id :=

1929: -- no result code passed in for filtering
1930: l_count := l_count + 1;
1931: l_active_wf_items_list(l_count).active_item_key
1932: := l_active_item_key;
1933: l_active_wf_items_list(l_count).activity_id :=
1934: csr_trans.activity_id;
1935: l_active_wf_items_list(l_count).trans_step_id :=
1936: csr_trans.transaction_step_id;
1937: l_active_wf_items_list(l_count).activity_result_code

Line 1935: l_active_wf_items_list(l_count).trans_step_id :=

1931: l_active_wf_items_list(l_count).active_item_key
1932: := l_active_item_key;
1933: l_active_wf_items_list(l_count).activity_id :=
1934: csr_trans.activity_id;
1935: l_active_wf_items_list(l_count).trans_step_id :=
1936: csr_trans.transaction_step_id;
1937: l_active_wf_items_list(l_count).activity_result_code
1938: := l_activity_result_code;
1939: END LOOP; -- inner loop

Line 1937: l_active_wf_items_list(l_count).activity_result_code

1933: l_active_wf_items_list(l_count).activity_id :=
1934: csr_trans.activity_id;
1935: l_active_wf_items_list(l_count).trans_step_id :=
1936: csr_trans.transaction_step_id;
1937: l_active_wf_items_list(l_count).activity_result_code
1938: := l_activity_result_code;
1939: END LOOP; -- inner loop
1940: -- endregistration
1941: END IF;

Line 1945: return l_active_wf_items_list;

1941: END IF;
1942: END LOOP; -- main loop
1943: END IF;
1944:
1945: return l_active_wf_items_list;
1946: --
1947: END get_active_wf_items;
1948: -- ----------------------------------------------------------------------------
1949: -- |-------------------------< remove_defunct_process >--------------------------|

Line 1947: END get_active_wf_items;

1943: END IF;
1944:
1945: return l_active_wf_items_list;
1946: --
1947: END get_active_wf_items;
1948: -- ----------------------------------------------------------------------------
1949: -- |-------------------------< remove_defunct_process >--------------------------|
1950: -- ----------------------------------------------------------------------------
1951: procedure remove_defunct_process

Line 1958: l_item_key wf_items.item_key%type;

1954: ,actid in number
1955: ,funcmode in varchar2
1956: ,resultout out nocopy varchar2) is
1957: --
1958: l_item_key wf_items.item_key%type;
1959: l_dummy INTEGER;
1960: l_transaction_id hr_api_transactions.transaction_id%type;
1961: l_transaction_age number default 30;
1962: l_transaction_status varchar2(5) ;

Line 2051: FROM wf_items wi

2047: CURSOR defunct_tx_ids IS
2048: /* SELECT distinct hats.transaction_id
2049: FROM hr_api_transaction_steps hats
2050: WHERE NOT EXISTS (SELECT 'Y'
2051: FROM wf_items wi
2052: WHERE wi.item_type = hats.item_type
2053: AND wi.item_key = hats.item_key);
2054: */
2055: -- Fix for bug#3322644

Line 2059: FROM wf_items wi

2055: -- Fix for bug#3322644
2056: SELECT hat.transaction_id
2057: FROM hr_api_transactions hat
2058: WHERE NOT EXISTS (SELECT 'Y'
2059: FROM wf_items wi
2060: WHERE wi.item_type = nvl(hat.item_type,hr_workflow_service.getItemType(hat.transaction_id))
2061: AND wi.item_key = nvl(hat.item_key,hr_workflow_service.getItemKey(hat.transaction_id))
2062: )
2063: AND Not Exists( select 'Y' from wf_items w --fix for bug 6121860

Line 2063: AND Not Exists( select 'Y' from wf_items w --fix for bug 6121860

2059: FROM wf_items wi
2060: WHERE wi.item_type = nvl(hat.item_type,hr_workflow_service.getItemType(hat.transaction_id))
2061: AND wi.item_key = nvl(hat.item_key,hr_workflow_service.getItemKey(hat.transaction_id))
2062: )
2063: AND Not Exists( select 'Y' from wf_items w --fix for bug 6121860
2064: where w.item_type = 'HRSFL'
2065: and w.user_key = hat.transaction_id)
2066: and hat.item_key is not null;
2067: --

Line 2075: -- fetch all the records from wf_items for given item type which

2071: -- an entry to the hr_api_transactions. Possible causes, user started
2072: -- new transaction and closed the web browser.
2073:
2074: -- fix for bug#2838117
2075: -- fetch all the records from wf_items for given item type which
2076: -- not in hr_api_transactions and icx session is disabled or does
2077: -- not exist.
2078:
2079: -- 4287117

Line 2083: from wf_items wi , wf_item_attribute_values av, icx_sessions s

2079: -- 4287117
2080: --5076290
2081: CURSOR defunct_wf_ids (c_transaction_age in number) IS
2082: select wi.item_key
2083: from wf_items wi , wf_item_attribute_values av, icx_sessions s
2084: where wi.item_type= itemtype
2085: and trunc(wi.begin_date) <= trunc(sysdate) --fix for bug 6642996
2086: and wi.end_date is null
2087: and av.item_type = wi.item_type

Line 2111: from wf_items wi

2107: );
2108: --5076290
2109: /* CURSOR defunct_wf_ids IS
2110: select wi.item_key
2111: from wf_items wi
2112: where wi.item_type = itemtype
2113: and wi.begin_date <= trunc(sysdate)
2114: and wi.end_date is null
2115: and not exists (select 'e' from hr_api_transactions t

Line 2155: from wf_items wi

2151:
2152: -- Fix for bug 6501341
2153: CURSOR defunct_wfsfl_ids IS
2154: select wi.item_key
2155: from wf_items wi
2156: where wi.item_type = 'HRSFL'
2157: and not exists (select transaction_id from hr_api_transactions
2158: where transaction_id = wi.user_key);
2159: --

Line 2414: (p_item_type in wf_items.item_type%type

2410: -- ----------------------------------------------------------------------------
2411: -- |--------------------------------------------------------|
2412: -- ----------------------------------------------------------------------------
2413: procedure start_cleanup_process
2414: (p_item_type in wf_items.item_type%type
2415: ,p_transaction_age in wf_item_attribute_values.number_value%type
2416: ,p_process_name in wf_process_activities.process_name%type default 'HR_BACKGROUND_CLEANUP_PRC',
2417: p_transaction_status in varchar2 default 'ALL'
2418: ) is

Line 2421: l_item_type wf_items.item_type%type := upper(p_item_type);

2417: p_transaction_status in varchar2 default 'ALL'
2418: ) is
2419: --
2420: l_process_name wf_process_activities.process_name%type := upper(p_process_name);
2421: l_item_type wf_items.item_type%type := upper(p_item_type);
2422: l_item_key wf_items.item_key%type;
2423: --
2424: --
2425: begin

Line 2422: l_item_key wf_items.item_key%type;

2418: ) is
2419: --
2420: l_process_name wf_process_activities.process_name%type := upper(p_process_name);
2421: l_item_type wf_items.item_type%type := upper(p_item_type);
2422: l_item_key wf_items.item_key%type;
2423: --
2424: --
2425: begin
2426: -- --------------------------------------------------------------------------

Line 2595: return wf_items.item_type%type is

2591: end TotalConcurrent;
2592:
2593:
2594: function getItemType(p_transaction_id in hr_api_transactions.transaction_id%type)
2595: return wf_items.item_type%type is
2596: l_item_type wf_items.item_type%type;
2597: begin
2598: select ts.item_type
2599: into getItemType.l_item_type

Line 2596: l_item_type wf_items.item_type%type;

2592:
2593:
2594: function getItemType(p_transaction_id in hr_api_transactions.transaction_id%type)
2595: return wf_items.item_type%type is
2596: l_item_type wf_items.item_type%type;
2597: begin
2598: select ts.item_type
2599: into getItemType.l_item_type
2600: from hr_api_transaction_steps ts

Line 2607: return wf_items.item_key%type is

2603: return getItemType.l_item_type;
2604: end getItemType;
2605:
2606: function getItemKey(p_transaction_id in hr_api_transactions.transaction_id%type)
2607: return wf_items.item_key%type is
2608: l_item_key wf_items.item_key%type;
2609: begin
2610: select ts.item_key
2611: into getItemkey.l_item_key

Line 2608: l_item_key wf_items.item_key%type;

2604: end getItemType;
2605:
2606: function getItemKey(p_transaction_id in hr_api_transactions.transaction_id%type)
2607: return wf_items.item_key%type is
2608: l_item_key wf_items.item_key%type;
2609: begin
2610: select ts.item_key
2611: into getItemkey.l_item_key
2612: from hr_api_transaction_steps ts