44: procedure process_run(p_business_group_id number
45: ,p_process_type varchar2
46: ,p_template_id number
47: ,p_process_name varchar2
48: ,p_parameters hr_summary_util.prmTabType
49: ,p_item_type_usage_id number default null
50: ,p_store_data boolean default FALSE
51: ,p_debug varchar2 default 'N'
52: ,p_statement out NOCOPY varchar2
137:
138: -- Set STORE_DATA utility package global
139: --
140: hr_utility.set_location('Entering : hrumrep.process_run ', 5);
141: hr_summary_util.store_data := p_store_data;
142: --
143: -- If the process needs to write data then initialize it by writing
144: -- and process row and parameter rows, otherwise just setup business group
145: -- for bsutil
143: -- If the process needs to write data then initialize it by writing
144: -- and process row and parameter rows, otherwise just setup business group
145: -- for bsutil
146: --
147: hr_summary_util.initialize_run(p_store_data
148: ,p_business_group_id
149: ,p_template_id
150: ,p_process_name
151: ,p_process_type
182: for x in 1..i-1 loop
183: --
184: -- Populate local and global variables
185: --
186: hr_summary_util.item_type_usage_id := ituTab(x).item_type_usage_id;
187: l_item_type_usage_id := ituTab(x).item_type_usage_id;
188: l_datatype := ituTab(x).datatype;
189: --
190: -- Delete existing results where appropriate
193: Need to call Initialize procedure before evaluating the key functions because
194: initialize_procedure populates the zero_item_value_id for the item_type being
195: processed, the key functions subsequently reference it.
196: ------------------------------------------------------------------ */
197: hr_summary_util.initialize_procedure(p_business_group_id);
198: --
199: -- Initialize dynamic SQL components
200: --
201: l_stmt := null;
472: process_run(p_business_group_id => p_business_group_id
473: ,p_process_type => p_process_type
474: ,p_template_id => p_template_id
475: ,p_process_name => p_process_name
476: ,p_parameters => hr_summary_util.nullprmTab
477: ,p_item_type_usage_id => p_item_type_usage_id
478: ,p_store_data => p_store_data
479: ,p_statement => p_statement
480: ,p_debug => p_debug
484: procedure process_run(p_business_group_id number
485: ,p_process_type varchar2
486: ,p_template_id number
487: ,p_process_name varchar2
488: ,p_parameters hr_summary_util.prmTabType
489: ,p_item_type_usage_id number default null
490: ,p_store_data boolean default FALSE
491: ,p_debug varchar2 default 'N'
492: ,p_statement out NOCOPY varchar2) is
498: ,p_process_type => p_process_type
499: ,p_template_id => p_template_id
500: ,p_process_name => p_process_name
501: ,p_item_type_usage_id => p_item_type_usage_id
502: --bug 3008112 ,parameters => hr_summary_util.nullprmTab
503: ,p_parameters => p_parameters
504: ,p_store_data => p_store_data
505: ,p_statement => p_statement
506: ,p_debug => p_debug
597: begin
598: -- Set STORE_DATA utility package global
599: --
600: hr_utility.set_location('Entering : hrumrep.process_run ', 5);
601: hr_summary_util.store_data := p_store_data;
602: --
603: --
604: /* ------------------------------------------------------------------
605: For each of the item types that are required for the selected template,
632: for x in 1..i-1 loop
633: --
634: -- Populate local and global variables
635: --
636: hr_summary_util.item_type_usage_id := ituTab(x).item_type_usage_id;
637: l_item_type_usage_id := ituTab(x).item_type_usage_id;
638: l_datatype := ituTab(x).datatype;
639: --
640: -- Delete existing results where appropriate
643: Need to call Initialize procedure before evaluating the key functions because
644: initialize_procedure populates the zero_item_value_id for the item_type being
645: processed, the key functions subsequently reference it.
646: ------------------------------------------------------------------ */
647: hr_summary_util.initialize_procedure(p_business_group_id);
648: --
649: -- Initialize dynamic SQL components
650: --
651: l_stmt := null;