[Home] [Help]
1: PACKAGE BODY hr_pay_rate_ss AS
2: /* $Header: hrpaywrs.pkb 120.18 2010/10/17 05:25:24 ckondapi ship $*/
3:
4:
5: g_package varchar2(30) := 'hr_pay_rate_ss';
1: PACKAGE BODY hr_pay_rate_ss AS
2: /* $Header: hrpaywrs.pkb 120.18 2010/10/17 05:25:24 ckondapi ship $*/
3:
4:
5: g_package varchar2(30) := 'hr_pay_rate_ss';
6:
7: inv_next_sal_date_warn boolean;
8: proposed_salary_warn boolean;
9: approved_warn boolean;
3124: SELECT transaction_step_id
3125: FROM hr_api_transaction_steps
3126: WHERE item_type = c_item_type
3127: AND item_key = c_item_key
3128: --AND api_name = 'HR_PAY_RATE_SS.process_api_java';
3129: AND api_name = 'HR_PAY_RATE_SS.PROCESS_API';
3130:
3131: gtt_trans_steps hr_transaction_ss.transaction_table;
3132:
3125: FROM hr_api_transaction_steps
3126: WHERE item_type = c_item_type
3127: AND item_key = c_item_key
3128: --AND api_name = 'HR_PAY_RATE_SS.process_api_java';
3129: AND api_name = 'HR_PAY_RATE_SS.PROCESS_API';
3130:
3131: gtt_trans_steps hr_transaction_ss.transaction_table;
3132:
3133: BEGIN
6310: exception
6311: when no_data_found then
6312: l_flow_mode := null;
6313: end;
6314: hr_pay_rate_ss.check_asg_txn_data
6315: (lv_item_type
6316: ,lv_item_key
6317: ,ln_act_id
6318: ,ld_effective_date
6608: cursor c1(p_transaction_id number) is
6609: select transaction_step_id
6610: from hr_api_transaction_steps
6611: where transaction_id = p_transaction_id
6612: and api_name = 'HR_PAY_RATE_SS.PROCESS_API';
6613: BEGIN
6614: hr_utility.set_location(' Entering:' || l_proc,5);
6615: open c1(p_transaction_id);
6616: fetch c1 into l_transaction_step_id;
6621: hr_utility.set_location(' Leaving:' || l_proc,10);
6622: END;
6623:
6624:
6625: END hr_pay_rate_ss;