DBA Data[Home] [Help]

APPS.HR_PAY_RATE_GSP_SS dependencies on HR_API_TRANSACTION_STEPS

Line 195: lv_api_name hr_api_transaction_steps.api_name%type ;

191: -- save_gsp_txn local variables
192: ln_transaction_id NUMBER ;
193: lv_result VARCHAR2(100);
194: li_count INTEGER ;
195: lv_api_name hr_api_transaction_steps.api_name%type ;
196: ln_ovn hr_api_transaction_steps.object_version_number%TYPE;
197: ln_transaction_step_id hr_api_transaction_steps.transaction_step_id%TYPE default null;
198: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;
199: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;

Line 196: ln_ovn hr_api_transaction_steps.object_version_number%TYPE;

192: ln_transaction_id NUMBER ;
193: lv_result VARCHAR2(100);
194: li_count INTEGER ;
195: lv_api_name hr_api_transaction_steps.api_name%type ;
196: ln_ovn hr_api_transaction_steps.object_version_number%TYPE;
197: ln_transaction_step_id hr_api_transaction_steps.transaction_step_id%TYPE default null;
198: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;
199: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;
200: ln_trans_step_rows number default 0;

Line 197: ln_transaction_step_id hr_api_transaction_steps.transaction_step_id%TYPE default null;

193: lv_result VARCHAR2(100);
194: li_count INTEGER ;
195: lv_api_name hr_api_transaction_steps.api_name%type ;
196: ln_ovn hr_api_transaction_steps.object_version_number%TYPE;
197: ln_transaction_step_id hr_api_transaction_steps.transaction_step_id%TYPE default null;
198: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;
199: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;
200: ln_trans_step_rows number default 0;
201: lv_activity_name wf_item_activity_statuses_v.activity_name%TYPE;

Line 214: FROM hr_api_transaction_steps

210: c_item_type in wf_items.item_type%type
211: ,c_item_key in wf_items.item_key%type
212: ) IS
213: SELECT transaction_step_id
214: FROM hr_api_transaction_steps
215: WHERE item_type = c_item_type
216: AND item_key = c_item_key
217: --AND api_name = 'HR_PAY_RATE_SS.process_api_java';
218: AND api_name = 'HR_PAY_RATE_SS.PROCESS_API';