DBA Data[Home] [Help]

APPS.PAY_KR_REPORT_PKG dependencies on PAY_BALANCE_PKG

Line 538: -- Therefore, Collect balance result directly instead of using pay_balance_pkg.get_value.

534: --
535: l_value number;
536: --
537: -- There is no latest balance for _ASG_RUN.
538: -- Therefore, Collect balance result directly instead of using pay_balance_pkg.get_value.
539: --
540: cursor csr_balance_value
541: is
542: select

Line 733: l_value := pay_balance_pkg.get_value(p_defined_balance_id => p_defined_balance_id,

729: p_business_group_id => g_business_group_id);
730: l_value := get_archive_items(p_assignment_action_id => g_xassignment_action_id,
731: p_user_entity_id => l_user_entity_id);
732: else
733: l_value := pay_balance_pkg.get_value(p_defined_balance_id => p_defined_balance_id,
734: p_assignment_action_id => p_assignment_action_id);
735: end if;
736: --
737: return l_value;

Line 927: pay_balance_pkg.set_context('BUSINESS_GROUP_ID', g_business_group_id);

923: l_date_earned,
924: l_tax_unit_id,
925: l_user_name;
926: close csr_context;
927: pay_balance_pkg.set_context('BUSINESS_GROUP_ID', g_business_group_id);
928: pay_balance_pkg.set_context('PAYROLL_ID', l_payroll_id);
929: pay_balance_pkg.set_context('PAYROLL_ACTION_ID', l_payroll_action_id);
930: pay_balance_pkg.set_context('ASSIGNMENT_ID', l_assignment_id);
931: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID', g_assignment_action_id);

Line 928: pay_balance_pkg.set_context('PAYROLL_ID', l_payroll_id);

924: l_tax_unit_id,
925: l_user_name;
926: close csr_context;
927: pay_balance_pkg.set_context('BUSINESS_GROUP_ID', g_business_group_id);
928: pay_balance_pkg.set_context('PAYROLL_ID', l_payroll_id);
929: pay_balance_pkg.set_context('PAYROLL_ACTION_ID', l_payroll_action_id);
930: pay_balance_pkg.set_context('ASSIGNMENT_ID', l_assignment_id);
931: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID', g_assignment_action_id);
932: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(l_date_earned));

Line 929: pay_balance_pkg.set_context('PAYROLL_ACTION_ID', l_payroll_action_id);

925: l_user_name;
926: close csr_context;
927: pay_balance_pkg.set_context('BUSINESS_GROUP_ID', g_business_group_id);
928: pay_balance_pkg.set_context('PAYROLL_ID', l_payroll_id);
929: pay_balance_pkg.set_context('PAYROLL_ACTION_ID', l_payroll_action_id);
930: pay_balance_pkg.set_context('ASSIGNMENT_ID', l_assignment_id);
931: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID', g_assignment_action_id);
932: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(l_date_earned));
933: pay_balance_pkg.set_context('TAX_UNIT_ID', l_tax_unit_id);

Line 930: pay_balance_pkg.set_context('ASSIGNMENT_ID', l_assignment_id);

926: close csr_context;
927: pay_balance_pkg.set_context('BUSINESS_GROUP_ID', g_business_group_id);
928: pay_balance_pkg.set_context('PAYROLL_ID', l_payroll_id);
929: pay_balance_pkg.set_context('PAYROLL_ACTION_ID', l_payroll_action_id);
930: pay_balance_pkg.set_context('ASSIGNMENT_ID', l_assignment_id);
931: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID', g_assignment_action_id);
932: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(l_date_earned));
933: pay_balance_pkg.set_context('TAX_UNIT_ID', l_tax_unit_id);
934: l_value := pay_balance_pkg.run_db_item(p_database_name => l_user_name,

Line 931: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID', g_assignment_action_id);

927: pay_balance_pkg.set_context('BUSINESS_GROUP_ID', g_business_group_id);
928: pay_balance_pkg.set_context('PAYROLL_ID', l_payroll_id);
929: pay_balance_pkg.set_context('PAYROLL_ACTION_ID', l_payroll_action_id);
930: pay_balance_pkg.set_context('ASSIGNMENT_ID', l_assignment_id);
931: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID', g_assignment_action_id);
932: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(l_date_earned));
933: pay_balance_pkg.set_context('TAX_UNIT_ID', l_tax_unit_id);
934: l_value := pay_balance_pkg.run_db_item(p_database_name => l_user_name,
935: p_bus_group_id => g_business_group_id,

Line 932: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(l_date_earned));

928: pay_balance_pkg.set_context('PAYROLL_ID', l_payroll_id);
929: pay_balance_pkg.set_context('PAYROLL_ACTION_ID', l_payroll_action_id);
930: pay_balance_pkg.set_context('ASSIGNMENT_ID', l_assignment_id);
931: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID', g_assignment_action_id);
932: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(l_date_earned));
933: pay_balance_pkg.set_context('TAX_UNIT_ID', l_tax_unit_id);
934: l_value := pay_balance_pkg.run_db_item(p_database_name => l_user_name,
935: p_bus_group_id => g_business_group_id,
936: p_legislation_code => g_legislation_code);

Line 933: pay_balance_pkg.set_context('TAX_UNIT_ID', l_tax_unit_id);

929: pay_balance_pkg.set_context('PAYROLL_ACTION_ID', l_payroll_action_id);
930: pay_balance_pkg.set_context('ASSIGNMENT_ID', l_assignment_id);
931: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID', g_assignment_action_id);
932: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(l_date_earned));
933: pay_balance_pkg.set_context('TAX_UNIT_ID', l_tax_unit_id);
934: l_value := pay_balance_pkg.run_db_item(p_database_name => l_user_name,
935: p_bus_group_id => g_business_group_id,
936: p_legislation_code => g_legislation_code);
937: end if;

Line 934: l_value := pay_balance_pkg.run_db_item(p_database_name => l_user_name,

930: pay_balance_pkg.set_context('ASSIGNMENT_ID', l_assignment_id);
931: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID', g_assignment_action_id);
932: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(l_date_earned));
933: pay_balance_pkg.set_context('TAX_UNIT_ID', l_tax_unit_id);
934: l_value := pay_balance_pkg.run_db_item(p_database_name => l_user_name,
935: p_bus_group_id => g_business_group_id,
936: p_legislation_code => g_legislation_code);
937: end if;
938: --