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.PAY_BALANCE_FEEDS_API dependencies on PAY_BALANCE_FEEDS_F

Line 36: l_balance_feed_id pay_balance_feeds_f.balance_feed_id%type;

32: l_proc varchar2(72) := g_package||'create_balance_feed';
33: l_effective_date date;
34:
35: --Declare OUT variables
36: l_balance_feed_id pay_balance_feeds_f.balance_feed_id%type;
37: l_effective_start_date pay_balance_feeds_f.effective_start_date%type;
38: l_effective_end_date pay_balance_feeds_f.effective_end_date%type;
39: l_object_version_number pay_balance_feeds_f.object_version_number%type;
40: l_exist_run_result_warning boolean;

Line 37: l_effective_start_date pay_balance_feeds_f.effective_start_date%type;

33: l_effective_date date;
34:
35: --Declare OUT variables
36: l_balance_feed_id pay_balance_feeds_f.balance_feed_id%type;
37: l_effective_start_date pay_balance_feeds_f.effective_start_date%type;
38: l_effective_end_date pay_balance_feeds_f.effective_end_date%type;
39: l_object_version_number pay_balance_feeds_f.object_version_number%type;
40: l_exist_run_result_warning boolean;
41:

Line 38: l_effective_end_date pay_balance_feeds_f.effective_end_date%type;

34:
35: --Declare OUT variables
36: l_balance_feed_id pay_balance_feeds_f.balance_feed_id%type;
37: l_effective_start_date pay_balance_feeds_f.effective_start_date%type;
38: l_effective_end_date pay_balance_feeds_f.effective_end_date%type;
39: l_object_version_number pay_balance_feeds_f.object_version_number%type;
40: l_exist_run_result_warning boolean;
41:
42: begin

Line 39: l_object_version_number pay_balance_feeds_f.object_version_number%type;

35: --Declare OUT variables
36: l_balance_feed_id pay_balance_feeds_f.balance_feed_id%type;
37: l_effective_start_date pay_balance_feeds_f.effective_start_date%type;
38: l_effective_end_date pay_balance_feeds_f.effective_end_date%type;
39: l_object_version_number pay_balance_feeds_f.object_version_number%type;
40: l_exist_run_result_warning boolean;
41:
42: begin
43: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 206: from pay_balance_feeds_f

202:
203: cursor csr_sel is
204: select balance_type_id,input_value_id,legislation_code,
205: business_group_id,legislation_subgroup
206: from pay_balance_feeds_f
207: where balance_feed_id =p_balance_feed_id
208: and p_effective_date between effective_start_date and effective_end_date;
209:
210: l_proc varchar2(72) := g_package||'update_balance_feed';

Line 214: l_effective_start_date pay_balance_feeds_f.effective_start_date%type;

210: l_proc varchar2(72) := g_package||'update_balance_feed';
211: l_effective_date date;
212:
213: --Declare OUT variables
214: l_effective_start_date pay_balance_feeds_f.effective_start_date%type;
215: l_effective_end_date pay_balance_feeds_f.effective_end_date%type;
216: l_object_version_number pay_balance_feeds_f.object_version_number%type;
217: l_exist_run_result_warning boolean;
218:

Line 215: l_effective_end_date pay_balance_feeds_f.effective_end_date%type;

211: l_effective_date date;
212:
213: --Declare OUT variables
214: l_effective_start_date pay_balance_feeds_f.effective_start_date%type;
215: l_effective_end_date pay_balance_feeds_f.effective_end_date%type;
216: l_object_version_number pay_balance_feeds_f.object_version_number%type;
217: l_exist_run_result_warning boolean;
218:
219: l_balance_type_id pay_balance_feeds_f.balance_type_id%type;

Line 216: l_object_version_number pay_balance_feeds_f.object_version_number%type;

212:
213: --Declare OUT variables
214: l_effective_start_date pay_balance_feeds_f.effective_start_date%type;
215: l_effective_end_date pay_balance_feeds_f.effective_end_date%type;
216: l_object_version_number pay_balance_feeds_f.object_version_number%type;
217: l_exist_run_result_warning boolean;
218:
219: l_balance_type_id pay_balance_feeds_f.balance_type_id%type;
220: l_input_value_id pay_balance_feeds_f.input_value_id%type;

Line 219: l_balance_type_id pay_balance_feeds_f.balance_type_id%type;

215: l_effective_end_date pay_balance_feeds_f.effective_end_date%type;
216: l_object_version_number pay_balance_feeds_f.object_version_number%type;
217: l_exist_run_result_warning boolean;
218:
219: l_balance_type_id pay_balance_feeds_f.balance_type_id%type;
220: l_input_value_id pay_balance_feeds_f.input_value_id%type;
221: l_legislation_code pay_balance_feeds_f.legislation_code%type;
222: l_business_group_id pay_balance_feeds_f.business_group_id%type;
223: l_legislation_subgroup pay_balance_feeds_f.legislation_subgroup%type;

Line 220: l_input_value_id pay_balance_feeds_f.input_value_id%type;

216: l_object_version_number pay_balance_feeds_f.object_version_number%type;
217: l_exist_run_result_warning boolean;
218:
219: l_balance_type_id pay_balance_feeds_f.balance_type_id%type;
220: l_input_value_id pay_balance_feeds_f.input_value_id%type;
221: l_legislation_code pay_balance_feeds_f.legislation_code%type;
222: l_business_group_id pay_balance_feeds_f.business_group_id%type;
223: l_legislation_subgroup pay_balance_feeds_f.legislation_subgroup%type;
224:

Line 221: l_legislation_code pay_balance_feeds_f.legislation_code%type;

217: l_exist_run_result_warning boolean;
218:
219: l_balance_type_id pay_balance_feeds_f.balance_type_id%type;
220: l_input_value_id pay_balance_feeds_f.input_value_id%type;
221: l_legislation_code pay_balance_feeds_f.legislation_code%type;
222: l_business_group_id pay_balance_feeds_f.business_group_id%type;
223: l_legislation_subgroup pay_balance_feeds_f.legislation_subgroup%type;
224:
225: begin

Line 222: l_business_group_id pay_balance_feeds_f.business_group_id%type;

218:
219: l_balance_type_id pay_balance_feeds_f.balance_type_id%type;
220: l_input_value_id pay_balance_feeds_f.input_value_id%type;
221: l_legislation_code pay_balance_feeds_f.legislation_code%type;
222: l_business_group_id pay_balance_feeds_f.business_group_id%type;
223: l_legislation_subgroup pay_balance_feeds_f.legislation_subgroup%type;
224:
225: begin
226: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 223: l_legislation_subgroup pay_balance_feeds_f.legislation_subgroup%type;

219: l_balance_type_id pay_balance_feeds_f.balance_type_id%type;
220: l_input_value_id pay_balance_feeds_f.input_value_id%type;
221: l_legislation_code pay_balance_feeds_f.legislation_code%type;
222: l_business_group_id pay_balance_feeds_f.business_group_id%type;
223: l_legislation_subgroup pay_balance_feeds_f.legislation_subgroup%type;
224:
225: begin
226: hr_utility.set_location('Entering:'|| l_proc, 10);
227: --

Line 391: l_effective_start_date pay_balance_feeds_f.effective_start_date%type;

387: l_proc varchar2(72) := g_package||'delete_balance_feed';
388: l_effective_date date;
389:
390: --Declare OUT variables
391: l_effective_start_date pay_balance_feeds_f.effective_start_date%type;
392: l_effective_end_date pay_balance_feeds_f.effective_end_date%type;
393: l_object_version_number pay_balance_feeds_f.object_version_number%type;
394: l_exist_run_result_warning boolean;
395:

Line 392: l_effective_end_date pay_balance_feeds_f.effective_end_date%type;

388: l_effective_date date;
389:
390: --Declare OUT variables
391: l_effective_start_date pay_balance_feeds_f.effective_start_date%type;
392: l_effective_end_date pay_balance_feeds_f.effective_end_date%type;
393: l_object_version_number pay_balance_feeds_f.object_version_number%type;
394: l_exist_run_result_warning boolean;
395:
396: begin

Line 393: l_object_version_number pay_balance_feeds_f.object_version_number%type;

389:
390: --Declare OUT variables
391: l_effective_start_date pay_balance_feeds_f.effective_start_date%type;
392: l_effective_end_date pay_balance_feeds_f.effective_end_date%type;
393: l_object_version_number pay_balance_feeds_f.object_version_number%type;
394: l_exist_run_result_warning boolean;
395:
396: begin
397: hr_utility.set_location('Entering:'|| l_proc, 10);