100: itemkey =>itemkey,
101: aname =>'HR_RUNTIME_APPROVAL_REQ_FLAG',
102: avalue =>'YES');
103:
104: UPDATE hr_api_transactions hat
105: SET hat.item_key = itemkey
106: WHERE hat.transaction_id=l_transaction_id;
107:
108: UPDATE hr_api_transaction_steps hats
300: -- --------------------------------------------------------------------------
301: -- declare local variables
302: -- --------------------------------------------------------------------------
303: l_proc varchar2(72);
304: l_transaction_id hr_api_transactions.transaction_id%type;
305: -- cursor to select the transaction_id of the step
306: cursor csr_hats is
307: select hats.transaction_id
308: from hr_api_transaction_steps hats
693: l_mileage_claim_element VARCHAR2(80);
694: l_element_entry_id NUMBER;
695: l_element_entry_date DATE;
696: l_mode VARCHAR2(10);
697: l_function_id hr_api_transactions.function_id%TYPE;
698: p_function_id hr_api_transactions.function_id%TYPE;
699: ln_selected_person_id hr_api_transactions.selected_person_id%TYPE;
700: lv_process_name hr_api_transactions.process_name%TYPE;
701: lv_status hr_api_transactions.status%TYPE;
694: l_element_entry_id NUMBER;
695: l_element_entry_date DATE;
696: l_mode VARCHAR2(10);
697: l_function_id hr_api_transactions.function_id%TYPE;
698: p_function_id hr_api_transactions.function_id%TYPE;
699: ln_selected_person_id hr_api_transactions.selected_person_id%TYPE;
700: lv_process_name hr_api_transactions.process_name%TYPE;
701: lv_status hr_api_transactions.status%TYPE;
702: lv_section_display_name hr_api_transactions.section_display_name%TYPE;
695: l_element_entry_date DATE;
696: l_mode VARCHAR2(10);
697: l_function_id hr_api_transactions.function_id%TYPE;
698: p_function_id hr_api_transactions.function_id%TYPE;
699: ln_selected_person_id hr_api_transactions.selected_person_id%TYPE;
700: lv_process_name hr_api_transactions.process_name%TYPE;
701: lv_status hr_api_transactions.status%TYPE;
702: lv_section_display_name hr_api_transactions.section_display_name%TYPE;
703: ln_assignment_id hr_api_transactions.assignment_id%TYPE;
696: l_mode VARCHAR2(10);
697: l_function_id hr_api_transactions.function_id%TYPE;
698: p_function_id hr_api_transactions.function_id%TYPE;
699: ln_selected_person_id hr_api_transactions.selected_person_id%TYPE;
700: lv_process_name hr_api_transactions.process_name%TYPE;
701: lv_status hr_api_transactions.status%TYPE;
702: lv_section_display_name hr_api_transactions.section_display_name%TYPE;
703: ln_assignment_id hr_api_transactions.assignment_id%TYPE;
704: ld_trans_effec_date hr_api_transactions.transaction_effective_date%TYPE;
697: l_function_id hr_api_transactions.function_id%TYPE;
698: p_function_id hr_api_transactions.function_id%TYPE;
699: ln_selected_person_id hr_api_transactions.selected_person_id%TYPE;
700: lv_process_name hr_api_transactions.process_name%TYPE;
701: lv_status hr_api_transactions.status%TYPE;
702: lv_section_display_name hr_api_transactions.section_display_name%TYPE;
703: ln_assignment_id hr_api_transactions.assignment_id%TYPE;
704: ld_trans_effec_date hr_api_transactions.transaction_effective_date%TYPE;
705: lv_transaction_type hr_api_transactions.transaction_type%TYPE;
698: p_function_id hr_api_transactions.function_id%TYPE;
699: ln_selected_person_id hr_api_transactions.selected_person_id%TYPE;
700: lv_process_name hr_api_transactions.process_name%TYPE;
701: lv_status hr_api_transactions.status%TYPE;
702: lv_section_display_name hr_api_transactions.section_display_name%TYPE;
703: ln_assignment_id hr_api_transactions.assignment_id%TYPE;
704: ld_trans_effec_date hr_api_transactions.transaction_effective_date%TYPE;
705: lv_transaction_type hr_api_transactions.transaction_type%TYPE;
706: BEGIN
699: ln_selected_person_id hr_api_transactions.selected_person_id%TYPE;
700: lv_process_name hr_api_transactions.process_name%TYPE;
701: lv_status hr_api_transactions.status%TYPE;
702: lv_section_display_name hr_api_transactions.section_display_name%TYPE;
703: ln_assignment_id hr_api_transactions.assignment_id%TYPE;
704: ld_trans_effec_date hr_api_transactions.transaction_effective_date%TYPE;
705: lv_transaction_type hr_api_transactions.transaction_type%TYPE;
706: BEGIN
707:
700: lv_process_name hr_api_transactions.process_name%TYPE;
701: lv_status hr_api_transactions.status%TYPE;
702: lv_section_display_name hr_api_transactions.section_display_name%TYPE;
703: ln_assignment_id hr_api_transactions.assignment_id%TYPE;
704: ld_trans_effec_date hr_api_transactions.transaction_effective_date%TYPE;
705: lv_transaction_type hr_api_transactions.transaction_type%TYPE;
706: BEGIN
707:
708: /* Bug Fix 13107787 Starts here.
701: lv_status hr_api_transactions.status%TYPE;
702: lv_section_display_name hr_api_transactions.section_display_name%TYPE;
703: ln_assignment_id hr_api_transactions.assignment_id%TYPE;
704: ld_trans_effec_date hr_api_transactions.transaction_effective_date%TYPE;
705: lv_transaction_type hr_api_transactions.transaction_type%TYPE;
706: BEGIN
707:
708: /* Bug Fix 13107787 Starts here.
709: Assigning back null values to below two parameters if they have a value of zero. */