DBA Data[Home] [Help]

APPS.PAY_FR_REBATES dependencies on PAY_FR_GENERAL

Line 22: l_formula_id := pay_fr_general.get_formula_info

18: from fnd_sessions
19: where session_id = userenv('SESSIONID');
20: --
21: /* This function call returns -1 if the formula was not found */
22: l_formula_id := pay_fr_general.get_formula_info
23: (p_formula_name => p_formula_name
24: ,p_effective_date => l_effective_date
25: ,p_effective_start_date => l_start_date);
26: --

Line 501: l_contribution_usage := pay_fr_general.get_contribution_usage

497: Begin
498: --
499: hr_utility.set_location('Entering pay_fr_rebates.contribution info ', 10);
500: --
501: l_contribution_usage := pay_fr_general.get_contribution_usage
502: (p_process_type => p_process_type
503: ,p_element_name => p_element_name
504: ,p_usage_type => p_usage_type
505: ,p_effective_date => p_date_earned);

Line 508: l_contribution_code := pay_fr_general.sub_contrib_code(p_contribution_type => l_contribution_usage.contribution_type

504: ,p_usage_type => p_usage_type
505: ,p_effective_date => p_date_earned);
506: --
507: /* Call function to substitute base code into contribution code */
508: l_contribution_code := pay_fr_general.sub_contrib_code(p_contribution_type => l_contribution_usage.contribution_type
509: ,p_contribution_code => l_contribution_usage.contribution_code);
510: --
511: p_contribution_code := l_contribution_code;
512: p_contribution_id := l_contribution_usage.contribution_usage_id;

Line 689: pay_fr_general.g_prev_start_date and

685: pay_payroll_actions ppa
686: where paa.assignment_id = p_assignment_id
687: and ppa.payroll_action_id = paa.payroll_action_id
688: and ppa.effective_date between
689: pay_fr_general.g_prev_start_date and
690: pay_fr_general.g_prev_end_date
691: and ppa.action_type in ('R', 'Q', 'I', 'V', 'B');
692: --
693: cursor csr_get_defined_bal_id (p_balance_name in varchar2) is

Line 690: pay_fr_general.g_prev_end_date

686: where paa.assignment_id = p_assignment_id
687: and ppa.payroll_action_id = paa.payroll_action_id
688: and ppa.effective_date between
689: pay_fr_general.g_prev_start_date and
690: pay_fr_general.g_prev_end_date
691: and ppa.action_type in ('R', 'Q', 'I', 'V', 'B');
692: --
693: cursor csr_get_defined_bal_id (p_balance_name in varchar2) is
694: select creator_id

Line 705: l_err := pay_fr_general.get_prev_start_end(p_payroll_action_id,

701: --
702: Begin
703: --
704: hr_utility.set_location('In function ', 10);
705: l_err := pay_fr_general.get_prev_start_end(p_payroll_action_id,
706: pay_fr_general.g_prev_start_date,
707: pay_fr_general.g_prev_end_date);
708: hr_utility.set_location('PREV MONTH value '||to_char(l_err),10);
709: hr_utility.set_location('Start date = '||to_char(pay_fr_general.g_prev_start_date),10);

Line 706: pay_fr_general.g_prev_start_date,

702: Begin
703: --
704: hr_utility.set_location('In function ', 10);
705: l_err := pay_fr_general.get_prev_start_end(p_payroll_action_id,
706: pay_fr_general.g_prev_start_date,
707: pay_fr_general.g_prev_end_date);
708: hr_utility.set_location('PREV MONTH value '||to_char(l_err),10);
709: hr_utility.set_location('Start date = '||to_char(pay_fr_general.g_prev_start_date),10);
710: hr_utility.set_location('End date = '||to_char(pay_fr_general.g_prev_end_date),10);

Line 707: pay_fr_general.g_prev_end_date);

703: --
704: hr_utility.set_location('In function ', 10);
705: l_err := pay_fr_general.get_prev_start_end(p_payroll_action_id,
706: pay_fr_general.g_prev_start_date,
707: pay_fr_general.g_prev_end_date);
708: hr_utility.set_location('PREV MONTH value '||to_char(l_err),10);
709: hr_utility.set_location('Start date = '||to_char(pay_fr_general.g_prev_start_date),10);
710: hr_utility.set_location('End date = '||to_char(pay_fr_general.g_prev_end_date),10);
711: --

Line 709: hr_utility.set_location('Start date = '||to_char(pay_fr_general.g_prev_start_date),10);

705: l_err := pay_fr_general.get_prev_start_end(p_payroll_action_id,
706: pay_fr_general.g_prev_start_date,
707: pay_fr_general.g_prev_end_date);
708: hr_utility.set_location('PREV MONTH value '||to_char(l_err),10);
709: hr_utility.set_location('Start date = '||to_char(pay_fr_general.g_prev_start_date),10);
710: hr_utility.set_location('End date = '||to_char(pay_fr_general.g_prev_end_date),10);
711: --
712: if l_err = 0 then
713: --

Line 710: hr_utility.set_location('End date = '||to_char(pay_fr_general.g_prev_end_date),10);

706: pay_fr_general.g_prev_start_date,
707: pay_fr_general.g_prev_end_date);
708: hr_utility.set_location('PREV MONTH value '||to_char(l_err),10);
709: hr_utility.set_location('Start date = '||to_char(pay_fr_general.g_prev_start_date),10);
710: hr_utility.set_location('End date = '||to_char(pay_fr_general.g_prev_end_date),10);
711: --
712: if l_err = 0 then
713: --
714: open csr_get_assignment_action;