[Home] [Help]
165: ,p_org_information2 in varchar2
166: ,p_org_information3 in varchar2
167: ) IS
168:
169: l_org_information1 hr_organization_information.org_information1%TYPE;
170: l_organization_id hr_organization_units.organization_id%TYPE;
171: l_business_group_id hr_organization_units.business_group_id%TYPE;
172:
173: /* Bug Fix 4994922, added record variable */
185: from hr_organization_units
186: where organization_id = p_organization_id;
187:
188: cursor orgnum is
189: select orgif.org_information1 from hr_organization_information orgif,hr_organization_units ou
190: where ( orgif.org_information_context = 'DK_SERVICE_PROVIDER_DETAILS' or orgif.org_information_context = 'DK_LEGAL_ENTITY_DETAILS')
191: and ou.organization_id = orgif.organization_id
192: and orgif.org_information1 = p_org_information1;
193:
193:
194: /* Bug Fix 4994922 added cursor csr_get_sickpay_defaults */
195: cursor csr_get_sickpay_defaults(p_business_group_id NUMBER) is
196: select orgif.org_information1, orgif.org_information2, orgif.org_information3
197: from hr_organization_information orgif,hr_organization_units ou
198: where orgif.org_information_context = 'DK_SICKPAY_DEFAULTS'
199: and ou.business_group_id = p_business_group_id
200: and ou.organization_id = p_organization_id
201: and ou.organization_id = orgif.organization_id;
272: ,p_org_information2 in varchar2
273: ,p_org_information3 in varchar2
274: ) IS
275:
276: l_org_information1 hr_organization_information.org_information1%TYPE;
277: l_organization_id hr_organization_information.organization_id%TYPE;
278: l_business_group_id hr_organization_units.business_group_id%TYPE;
279:
280: /* Bug Fix 4994922, added record variable */
273: ,p_org_information3 in varchar2
274: ) IS
275:
276: l_org_information1 hr_organization_information.org_information1%TYPE;
277: l_organization_id hr_organization_information.organization_id%TYPE;
278: l_business_group_id hr_organization_units.business_group_id%TYPE;
279:
280: /* Bug Fix 4994922, added record variable */
281: l_sickpay_records l_rec;
293: where organization_id = l_organization_id;
294:
295: cursor getorgid is
296: select organization_id
297: from hr_organization_information
298: where org_information_id = p_org_information_id;
299:
300: cursor orgnum is
301: select orgif.org_information1 from hr_organization_information orgif,hr_organization_units ou
297: from hr_organization_information
298: where org_information_id = p_org_information_id;
299:
300: cursor orgnum is
301: select orgif.org_information1 from hr_organization_information orgif,hr_organization_units ou
302: where ( orgif.org_information_context = 'DK_SERVICE_PROVIDER_DETAILS' or orgif.org_information_context = 'DK_LEGAL_ENTITY_DETAILS')
303: and ou.organization_id = orgif.organization_id
304: and orgif.organization_id <> nvl(l_organization_id,0)
305: and orgif.org_information1 = p_org_information1;
306:
307: /* Bug Fix 4994922 added cursor csr_get_sickpay_defaults */
308: cursor csr_get_sickpay_defaults(p_business_group_id NUMBER, p_organization_id NUMBER) is
309: select orgif.org_information1, orgif.org_information2, orgif.org_information3
310: from hr_organization_information orgif,hr_organization_units ou
311: where orgif.org_information_context = 'DK_SICKPAY_DEFAULTS'
312: and ou.business_group_id = p_business_group_id
313: and ou.organization_id = p_organization_id
314: and ou.organization_id = orgif.organization_id;
514: /* Not more than one Service Provider can be created in a Business Group */
515: --
516: CURSOR get_sp( p_business_group_id hr_organization_units.business_group_id%TYPE) IS
517: select count(hou.organization_id)
518: from HR_ORGANIZATION_INFORMATION hoi
519: ,HR_ORGANIZATION_UNITS hou
520: ,FND_SESSIONS s
521: where hoi.org_information_context ='CLASS'
522: and hoi.org_information1 ='DK_SERVICE_PROVIDER'