DBA Data[Home] [Help]

APPS.HR_PAY_RATE_GSP_SS dependencies on HR_API_TRANSACTION_STEPS

Line 199: lv_api_name hr_api_transaction_steps.api_name%type ;

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

Line 200: ln_ovn hr_api_transaction_steps.object_version_number%TYPE;

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

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

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

Line 218: FROM hr_api_transaction_steps

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