DBA Data[Home] [Help]

APPS.PAY_JP_SPR_EFILE_PKG dependencies on PAY_CORE_UTILS

Line 656: nvl(fnd_date.canonical_to_date(pay_core_utils.get_parameter(''ITAX_DPNT_EFFECTIVE_DATE'',pjwa.legislative_parameters)),pjwa.effective_date) dpnt_effective_date,

652: pjwa.itax_organization_id,
653: pjwa.itax_category,
654: pjwa.itax_yea_category,
655: nvl(nvl(pap.prl_information1,''i_bg_itax_dpnt_ref_type''),''CTR_EE'') dpnt_ref_type,
656: nvl(fnd_date.canonical_to_date(pay_core_utils.get_parameter(''ITAX_DPNT_EFFECTIVE_DATE'',pjwa.legislative_parameters)),pjwa.effective_date) dpnt_effective_date,
657: pp.person_id,
658: pp.sex,
659: pp.date_of_birth,
660: pjwa.leaving_reason,

Line 1731: g_effective_soy := to_date(pay_core_utils.get_parameter('SUBJECT_YEAR',l_csr_action.legislative_parameters)||'/01/01','YYYY/MM/DD');

1727: close csr_action;
1728: --
1729: g_payroll_action_id := p_payroll_action_id;
1730: g_session_date := l_csr_action.effective_date;
1731: g_effective_soy := to_date(pay_core_utils.get_parameter('SUBJECT_YEAR',l_csr_action.legislative_parameters)||'/01/01','YYYY/MM/DD');
1732: g_effective_eoy := add_months(g_effective_soy,12) - 1;
1733: g_effective_yyyy := to_number(to_char(g_effective_soy,'YYYY'));
1734: g_business_group_id := l_csr_action.business_group_id;
1735: g_legislation_code := l_csr_action.legislation_code;

Line 1736: g_district_code := pay_core_utils.get_parameter('DISTRICT_CODE',l_csr_action.legislative_parameters);

1732: g_effective_eoy := add_months(g_effective_soy,12) - 1;
1733: g_effective_yyyy := to_number(to_char(g_effective_soy,'YYYY'));
1734: g_business_group_id := l_csr_action.business_group_id;
1735: g_legislation_code := l_csr_action.legislation_code;
1736: g_district_code := pay_core_utils.get_parameter('DISTRICT_CODE',l_csr_action.legislative_parameters);
1737: g_organization_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ORGANIZATION_ID',l_csr_action.legislative_parameters));
1738: g_assignment_set_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',l_csr_action.legislative_parameters));
1739: --g_request_id := fnd_global.conc_request_id;
1740: g_request_id := l_csr_action.request_id;

Line 1737: g_organization_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ORGANIZATION_ID',l_csr_action.legislative_parameters));

1733: g_effective_yyyy := to_number(to_char(g_effective_soy,'YYYY'));
1734: g_business_group_id := l_csr_action.business_group_id;
1735: g_legislation_code := l_csr_action.legislation_code;
1736: g_district_code := pay_core_utils.get_parameter('DISTRICT_CODE',l_csr_action.legislative_parameters);
1737: g_organization_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ORGANIZATION_ID',l_csr_action.legislative_parameters));
1738: g_assignment_set_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',l_csr_action.legislative_parameters));
1739: --g_request_id := fnd_global.conc_request_id;
1740: g_request_id := l_csr_action.request_id;
1741: g_file_split := pay_core_utils.get_parameter('FILE_SPLIT',l_csr_action.legislative_parameters);

Line 1738: g_assignment_set_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',l_csr_action.legislative_parameters));

1734: g_business_group_id := l_csr_action.business_group_id;
1735: g_legislation_code := l_csr_action.legislation_code;
1736: g_district_code := pay_core_utils.get_parameter('DISTRICT_CODE',l_csr_action.legislative_parameters);
1737: g_organization_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ORGANIZATION_ID',l_csr_action.legislative_parameters));
1738: g_assignment_set_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',l_csr_action.legislative_parameters));
1739: --g_request_id := fnd_global.conc_request_id;
1740: g_request_id := l_csr_action.request_id;
1741: g_file_split := pay_core_utils.get_parameter('FILE_SPLIT',l_csr_action.legislative_parameters);
1742: g_use_arch := pay_core_utils.get_parameter('USE_ARCH',l_csr_action.legislative_parameters);

Line 1741: g_file_split := pay_core_utils.get_parameter('FILE_SPLIT',l_csr_action.legislative_parameters);

1737: g_organization_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ORGANIZATION_ID',l_csr_action.legislative_parameters));
1738: g_assignment_set_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',l_csr_action.legislative_parameters));
1739: --g_request_id := fnd_global.conc_request_id;
1740: g_request_id := l_csr_action.request_id;
1741: g_file_split := pay_core_utils.get_parameter('FILE_SPLIT',l_csr_action.legislative_parameters);
1742: g_use_arch := pay_core_utils.get_parameter('USE_ARCH',l_csr_action.legislative_parameters);
1743: --g_kana_flag := pay_core_utils.get_parameter('KANA_FLAG',l_csr_action.legislative_parameters);
1744: --no support non-assignment creation to exclude assignment by assignment set (assignment_action_creation chache cannot be transfered to archinit)
1745: --g_process_assignments_flag := pay_core_utils.get_parameter('PROCESS_ASSIGNMENTS_FLAG',l_csr_action.legislative_parameters);

Line 1742: g_use_arch := pay_core_utils.get_parameter('USE_ARCH',l_csr_action.legislative_parameters);

1738: g_assignment_set_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',l_csr_action.legislative_parameters));
1739: --g_request_id := fnd_global.conc_request_id;
1740: g_request_id := l_csr_action.request_id;
1741: g_file_split := pay_core_utils.get_parameter('FILE_SPLIT',l_csr_action.legislative_parameters);
1742: g_use_arch := pay_core_utils.get_parameter('USE_ARCH',l_csr_action.legislative_parameters);
1743: --g_kana_flag := pay_core_utils.get_parameter('KANA_FLAG',l_csr_action.legislative_parameters);
1744: --no support non-assignment creation to exclude assignment by assignment set (assignment_action_creation chache cannot be transfered to archinit)
1745: --g_process_assignments_flag := pay_core_utils.get_parameter('PROCESS_ASSIGNMENTS_FLAG',l_csr_action.legislative_parameters);
1746: g_remove_act := pay_core_utils.get_parameter('REMOVE_ACT',l_csr_action.legislative_parameters);

Line 1743: --g_kana_flag := pay_core_utils.get_parameter('KANA_FLAG',l_csr_action.legislative_parameters);

1739: --g_request_id := fnd_global.conc_request_id;
1740: g_request_id := l_csr_action.request_id;
1741: g_file_split := pay_core_utils.get_parameter('FILE_SPLIT',l_csr_action.legislative_parameters);
1742: g_use_arch := pay_core_utils.get_parameter('USE_ARCH',l_csr_action.legislative_parameters);
1743: --g_kana_flag := pay_core_utils.get_parameter('KANA_FLAG',l_csr_action.legislative_parameters);
1744: --no support non-assignment creation to exclude assignment by assignment set (assignment_action_creation chache cannot be transfered to archinit)
1745: --g_process_assignments_flag := pay_core_utils.get_parameter('PROCESS_ASSIGNMENTS_FLAG',l_csr_action.legislative_parameters);
1746: g_remove_act := pay_core_utils.get_parameter('REMOVE_ACT',l_csr_action.legislative_parameters);
1747: --

Line 1745: --g_process_assignments_flag := pay_core_utils.get_parameter('PROCESS_ASSIGNMENTS_FLAG',l_csr_action.legislative_parameters);

1741: g_file_split := pay_core_utils.get_parameter('FILE_SPLIT',l_csr_action.legislative_parameters);
1742: g_use_arch := pay_core_utils.get_parameter('USE_ARCH',l_csr_action.legislative_parameters);
1743: --g_kana_flag := pay_core_utils.get_parameter('KANA_FLAG',l_csr_action.legislative_parameters);
1744: --no support non-assignment creation to exclude assignment by assignment set (assignment_action_creation chache cannot be transfered to archinit)
1745: --g_process_assignments_flag := pay_core_utils.get_parameter('PROCESS_ASSIGNMENTS_FLAG',l_csr_action.legislative_parameters);
1746: g_remove_act := pay_core_utils.get_parameter('REMOVE_ACT',l_csr_action.legislative_parameters);
1747: --
1748: -- not support partial archive unit (part of payroll)
1749: -- use archive when archive exist for itax_organization

Line 1746: g_remove_act := pay_core_utils.get_parameter('REMOVE_ACT',l_csr_action.legislative_parameters);

1742: g_use_arch := pay_core_utils.get_parameter('USE_ARCH',l_csr_action.legislative_parameters);
1743: --g_kana_flag := pay_core_utils.get_parameter('KANA_FLAG',l_csr_action.legislative_parameters);
1744: --no support non-assignment creation to exclude assignment by assignment set (assignment_action_creation chache cannot be transfered to archinit)
1745: --g_process_assignments_flag := pay_core_utils.get_parameter('PROCESS_ASSIGNMENTS_FLAG',l_csr_action.legislative_parameters);
1746: g_remove_act := pay_core_utils.get_parameter('REMOVE_ACT',l_csr_action.legislative_parameters);
1747: --
1748: -- not support partial archive unit (part of payroll)
1749: -- use archive when archive exist for itax_organization
1750: -- limitation is that excluding partial employee for whom archive has not been processed.