DBA Data[Home] [Help]

APPS.PER_GB_ORG_INFO dependencies on HR_API

Line 113: IF (p_org_information1 <> hr_api.g_varchar2) THEN

109: --
110: IF hr_utility.chk_product_install('Oracle Human Resources', 'HU') THEN
111: --
112: IF (p_org_info_type_code = 'Tax Details References') THEN
113: IF (p_org_information1 <> hr_api.g_varchar2) THEN
114: open csr_org_info_exists;
115: fetch csr_org_info_exists into l_found;
116: if csr_org_info_exists%found then
117: close csr_org_info_exists;

Line 134: IF (p_org_information1 <> hr_api.g_varchar2) THEN

130: END IF;
131: --Bug 7338614 Ends
132: IF p_org_information10 = 'UK' then /*Bug 5084055*/
133: IF (p_org_info_type_code = 'Tax Details References') THEN
134: IF (p_org_information1 <> hr_api.g_varchar2) THEN
135: BEGIN
136: l_tax_district_reference := substr( p_org_information1, 1, INSTR(p_org_information1,'/')-1 );
137: l_tax_reference_number := substr( p_org_information1, INSTR(p_org_information1,'/')+1 , length(p_org_information1) );
138: IF (l_tax_district_reference is NULL OR l_tax_reference_number is NULL