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.PQP_SS_VEHICLE_MILEAGE_CLAIMS dependencies on HR_API

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 108: UPDATE hr_api_transaction_steps hats

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
109: SET hats.item_key = itemkey
110: WHERE hats.transaction_id=l_transaction_id;
111: result :='Y';
112: end;

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 308: from hr_api_transaction_steps hats

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
309: where hats.transaction_step_id = p_transaction_step_id;
310: begin
311:
312:

Line 488: FROM hr_api_transaction_steps hats

484:
485: CURSOR c_del_values
486: IS
487: SELECT transaction_step_id
488: FROM hr_api_transaction_steps hats
489: WHERE transaction_id = x_transaction_id;
490:
491: l_del_values c_del_values%ROWTYPE;
492: l_transaction_id NUMBER;

Line 496: l_api_name hr_api_transaction_steps.api_name%TYPE

492: l_transaction_id NUMBER;
493: l_trans_tbl hr_transaction_ss.transaction_table;
494: l_count NUMBER :=0;
495: l_transaction_step_id NUMBER;
496: l_api_name hr_api_transaction_steps.api_name%TYPE
497: := 'PQP_SS_VEHICLE_MILEAGE_CLAIMS.DELETE_PROCESS_API';
498: l_result VARCHAR2(100);
499: l_trns_object_version_number NUMBER;
500: l_review_proc_call VARCHAR2(30);-- := 'PqpVehStatusReview';

Line 594: DELETE from hr_api_transaction_values

590: ,p_transaction_step_id => l_transaction_step_id
591: ,p_object_version_number => l_ovn
592: );
593: ELSE
594: DELETE from hr_api_transaction_values
595: WHERE transaction_step_id = x_transaction_step_id;
596: l_transaction_step_id := x_transaction_step_id;
597: END IF;
598:

Line 677: FROM hr_api_transaction_steps hats

673: IS
674: CURSOR c_del_values
675: IS
676: SELECT transaction_step_id
677: FROM hr_api_transaction_steps hats
678: WHERE transaction_id = x_transaction_id;
679: l_del_values c_del_values%ROWTYPE;
680: l_transaction_id NUMBER;
681: l_trans_tbl hr_transaction_ss.transaction_table;

Line 684: l_api_name hr_api_transaction_steps.api_name%TYPE

680: l_transaction_id NUMBER;
681: l_trans_tbl hr_transaction_ss.transaction_table;
682: l_count NUMBER :=0;
683: l_transaction_step_id NUMBER;
684: l_api_name hr_api_transaction_steps.api_name%TYPE
685: := 'PQP_SS_VEHICLE_MILEAGE_CLAIMS.PROCESS_API';
686: l_result VARCHAR2(100);
687: l_trns_object_version_number NUMBER;
688: l_review_proc_call VARCHAR2(30) := 'PqpMileageClaimReview';

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. */

Line 946: DELETE from hr_api_transaction_values

942: hr_transaction_api.update_transaction
943: (p_transaction_id =>x_transaction_id
944: ,p_status =>x_status
945: );
946: DELETE from hr_api_transaction_values
947: WHERE transaction_step_id = x_transaction_step_id;
948: l_transaction_step_id := x_transaction_step_id;
949: ELSE
950: l_transaction_step_id := x_transaction_step_id;