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_APPRAISAL_WORKFLOW_SS dependencies on HR_API

Line 128: l_transaction_privilege hr_api_transactions.transaction_privilege%type;

124: -- --------------------------------------------------------------------------
125: -- declare local variables
126: -- --------------------------------------------------------------------------
127: l_proc varchar2(72);
128: l_transaction_privilege hr_api_transactions.transaction_privilege%type;
129: l_transaction_id hr_api_transactions.transaction_id%type;
130:
131: l_function_id hr_api_transactions.function_id%TYPE;
132: ln_selected_person_id hr_api_transactions.selected_person_id%TYPE;

Line 129: l_transaction_id hr_api_transactions.transaction_id%type;

125: -- declare local variables
126: -- --------------------------------------------------------------------------
127: l_proc varchar2(72);
128: l_transaction_privilege hr_api_transactions.transaction_privilege%type;
129: l_transaction_id hr_api_transactions.transaction_id%type;
130:
131: l_function_id hr_api_transactions.function_id%TYPE;
132: ln_selected_person_id hr_api_transactions.selected_person_id%TYPE;
133: lv_process_name hr_api_transactions.process_name%TYPE;

Line 131: l_function_id hr_api_transactions.function_id%TYPE;

127: l_proc varchar2(72);
128: l_transaction_privilege hr_api_transactions.transaction_privilege%type;
129: l_transaction_id hr_api_transactions.transaction_id%type;
130:
131: l_function_id hr_api_transactions.function_id%TYPE;
132: ln_selected_person_id hr_api_transactions.selected_person_id%TYPE;
133: lv_process_name hr_api_transactions.process_name%TYPE;
134: lv_status hr_api_transactions.status%TYPE;
135: lv_section_display_name hr_api_transactions.section_display_name%TYPE;

Line 132: ln_selected_person_id hr_api_transactions.selected_person_id%TYPE;

128: l_transaction_privilege hr_api_transactions.transaction_privilege%type;
129: l_transaction_id hr_api_transactions.transaction_id%type;
130:
131: l_function_id hr_api_transactions.function_id%TYPE;
132: ln_selected_person_id hr_api_transactions.selected_person_id%TYPE;
133: lv_process_name hr_api_transactions.process_name%TYPE;
134: lv_status hr_api_transactions.status%TYPE;
135: lv_section_display_name hr_api_transactions.section_display_name%TYPE;
136: ln_assignment_id hr_api_transactions.assignment_id%TYPE;

Line 133: lv_process_name hr_api_transactions.process_name%TYPE;

129: l_transaction_id hr_api_transactions.transaction_id%type;
130:
131: l_function_id hr_api_transactions.function_id%TYPE;
132: ln_selected_person_id hr_api_transactions.selected_person_id%TYPE;
133: lv_process_name hr_api_transactions.process_name%TYPE;
134: lv_status hr_api_transactions.status%TYPE;
135: lv_section_display_name hr_api_transactions.section_display_name%TYPE;
136: ln_assignment_id hr_api_transactions.assignment_id%TYPE;
137: ld_trans_effec_date hr_api_transactions.transaction_effective_date%TYPE;

Line 134: lv_status hr_api_transactions.status%TYPE;

130:
131: l_function_id hr_api_transactions.function_id%TYPE;
132: ln_selected_person_id hr_api_transactions.selected_person_id%TYPE;
133: lv_process_name hr_api_transactions.process_name%TYPE;
134: lv_status hr_api_transactions.status%TYPE;
135: lv_section_display_name hr_api_transactions.section_display_name%TYPE;
136: ln_assignment_id hr_api_transactions.assignment_id%TYPE;
137: ld_trans_effec_date hr_api_transactions.transaction_effective_date%TYPE;
138: lv_transaction_type hr_api_transactions.transaction_type%TYPE;

Line 135: lv_section_display_name hr_api_transactions.section_display_name%TYPE;

131: l_function_id hr_api_transactions.function_id%TYPE;
132: ln_selected_person_id hr_api_transactions.selected_person_id%TYPE;
133: lv_process_name hr_api_transactions.process_name%TYPE;
134: lv_status hr_api_transactions.status%TYPE;
135: lv_section_display_name hr_api_transactions.section_display_name%TYPE;
136: ln_assignment_id hr_api_transactions.assignment_id%TYPE;
137: ld_trans_effec_date hr_api_transactions.transaction_effective_date%TYPE;
138: lv_transaction_type hr_api_transactions.transaction_type%TYPE;
139: ln_login_person_id number;

Line 136: ln_assignment_id hr_api_transactions.assignment_id%TYPE;

132: ln_selected_person_id hr_api_transactions.selected_person_id%TYPE;
133: lv_process_name hr_api_transactions.process_name%TYPE;
134: lv_status hr_api_transactions.status%TYPE;
135: lv_section_display_name hr_api_transactions.section_display_name%TYPE;
136: ln_assignment_id hr_api_transactions.assignment_id%TYPE;
137: ld_trans_effec_date hr_api_transactions.transaction_effective_date%TYPE;
138: lv_transaction_type hr_api_transactions.transaction_type%TYPE;
139: ln_login_person_id number;
140: ln_appraisal_id number;

Line 137: ld_trans_effec_date hr_api_transactions.transaction_effective_date%TYPE;

133: lv_process_name hr_api_transactions.process_name%TYPE;
134: lv_status hr_api_transactions.status%TYPE;
135: lv_section_display_name hr_api_transactions.section_display_name%TYPE;
136: ln_assignment_id hr_api_transactions.assignment_id%TYPE;
137: ld_trans_effec_date hr_api_transactions.transaction_effective_date%TYPE;
138: lv_transaction_type hr_api_transactions.transaction_type%TYPE;
139: ln_login_person_id number;
140: ln_appraisal_id number;
141: --

Line 138: lv_transaction_type hr_api_transactions.transaction_type%TYPE;

134: lv_status hr_api_transactions.status%TYPE;
135: lv_section_display_name hr_api_transactions.section_display_name%TYPE;
136: ln_assignment_id hr_api_transactions.assignment_id%TYPE;
137: ld_trans_effec_date hr_api_transactions.transaction_effective_date%TYPE;
138: lv_transaction_type hr_api_transactions.transaction_type%TYPE;
139: ln_login_person_id number;
140: ln_appraisal_id number;
141: --
142: begin

Line 291: lv_status hr_api_transactions.status%type;

287: lv_item_type wf_item_activity_statuses.item_type%type;
288: lv_item_key wf_item_activity_statuses.item_key%type;
289: lv_checkProfile VARCHAR2(10);
290: lv_profileValue VARCHAR2(1);
291: lv_status hr_api_transactions.status%type;
292: lv_link_label wf_message_attributes_vl.display_name%type;
293: lv_pageFunc wf_item_attribute_values.text_value%type;
294: lv_web_html_call fnd_form_functions_vl.web_html_call%type;
295: lv_params fnd_form_functions_vl.parameters%type;

Line 1071: FROM hr_api_transactions

1067: IS
1068: CURSOR get_txn_id
1069: IS
1070: SELECT transaction_id
1071: FROM hr_api_transactions
1072: WHERE item_type = p_itemtype AND item_key = p_itemkey;
1073:
1074: -- local variables
1075: notification_rec ame_util2.notificationrecord;