DBA Data[Home] [Help]

APPS.PQP_SS_VEHICLE_MILEAGE_CLAIMS dependencies on HR_API_TRANSACTIONS

Line 104: UPDATE hr_api_transactions hat

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

Line 304: l_transaction_id hr_api_transactions.transaction_id%type;

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

Line 697: l_function_id hr_api_transactions.function_id%TYPE;

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;

Line 698: p_function_id hr_api_transactions.function_id%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;

Line 699: ln_selected_person_id hr_api_transactions.selected_person_id%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;

Line 700: lv_process_name hr_api_transactions.process_name%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;

Line 701: lv_status hr_api_transactions.status%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;

Line 702: lv_section_display_name hr_api_transactions.section_display_name%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

Line 703: ln_assignment_id hr_api_transactions.assignment_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
707:

Line 704: ld_trans_effec_date hr_api_transactions.transaction_effective_date%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:
708: /* Bug Fix 13107787 Starts here.

Line 705: lv_transaction_type hr_api_transactions.transaction_type%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.
709: Assigning back null values to below two parameters if they have a value of zero. */