APPS.PQH_CORPS_EXTRA_INFO_API dependencies on FND_NUMBER

Line 16: WHERE organization_id = fnd_number.canonical_to_number(p_organization_id)

12: SELECT 'Y'
13: FROM DUAL
14: WHERE EXISTS (SELECT 1
15: FROM hr_all_organization_units
16: WHERE organization_id = fnd_number.canonical_to_number(p_organization_id)
17: AND p_effective_date BETWEEN date_from AND NVL(date_to,hr_general.end_of_time));
18: l_valid_org varchar2(10) := 'N';
19: CURSOR csr_dup_org_chk IS
20: SELECT 'Y'

Line 63: WHERE shared_type_id = fnd_number.canonical_to_number(p_field_of_prof_activity_id));

59: SELECT 'Y'
60: FROM dual
61: WHERE EXISTS (SELECT 1
62: FROM per_shared_types
63: WHERE shared_type_id = fnd_number.canonical_to_number(p_field_of_prof_activity_id));
64: l_valid_prof_field varchar2(10) := 'N';
65: l_proc varchar2(72) := g_package||'.validate_corps_prof_field_info';
66: CURSOR csr_dup_prof_field_chk IS
67: SELECT 'Y'

Line 112: WHERE organization_id = fnd_number.canonical_to_number(p_institution_id)

108: SELECT 'Y'
109: FROM dual
110: WHERE EXISTS (SELECT 1
111: FROM hr_all_organization_units
112: WHERE organization_id = fnd_number.canonical_to_number(p_institution_id)
113: AND p_effective_date BETWEEN date_from AND nvl(date_to,hr_general.end_of_time));
114: l_valid_institution varchar2(10) :='N';
115: CURSOR csr_chk_dup_exam IS
116: SELECT 'Y'

Line 180: WHERE qualification_type_id = fnd_number.canonical_to_number(p_qualification_id) );

176: SELECT 'Y'
177: FROM dual
178: WHERE EXISTS (SELECT 1
179: FROM per_qualification_types
180: WHERE qualification_type_id = fnd_number.canonical_to_number(p_qualification_id) );
181: l_valid_qualification varchar2(10) := 'N';
182: CURSOR csr_valid_institution IS
183: SELECT 'Y'
184: FROM dual

Line 187: WHERE organization_id = fnd_number.canonical_to_number(p_institution_id)

183: SELECT 'Y'
184: FROM dual
185: WHERE EXISTS (SELECT 1
186: FROM hr_all_organization_units
187: WHERE organization_id = fnd_number.canonical_to_number(p_institution_id)
188: AND p_effective_date BETWEEN date_from AND nvl(date_to,hr_general.end_of_time));
189: l_valid_institution varchar2(10) :='N';
190: CURSOR csr_dup_train_dtls IS
191: SELECT 'Y'

Line 274: AND fnd_number.canonical_to_number(nvl(cei.information4,'-1')) = nvl(primary_prof_field_id,-1)

270: FROM pqh_corps_definitions cpd,
271: pqh_corps_extra_info cei
272: WHERE cei.information_type = 'FILERE'
273: AND cei.corps_definition_id = cpd.corps_definition_id
274: AND fnd_number.canonical_to_number(nvl(cei.information4,'-1')) = nvl(primary_prof_field_id,-1)
275: AND corps_extra_info_id = p_corps_extra_info_id);
276: l_primary_flag varchar2(10) := 'N';
277: l_proc varchar2(72) := g_package||'.chk_prim_field_for_corps';
278: BEGIN