[Home] [Help]
170: ,p_org_information2 in varchar2
171: ,p_org_information3 in varchar2
172: ) IS
173:
174: l_org_information1 hr_organization_information.org_information1%TYPE;
175: l_organization_id hr_organization_units.organization_id%TYPE;
176: l_business_group_id hr_organization_units.business_group_id%TYPE;
177:
178: /* Bug Fix 4994922, added record variable */
195: from hr_organization_units
196: where organization_id = p_organization_id;
197:
198: cursor orgnum is
199: select orgif.org_information1 from hr_organization_information orgif,hr_organization_units ou
200: where ( orgif.org_information_context = 'DK_SERVICE_PROVIDER_DETAILS' or orgif.org_information_context = 'DK_LEGAL_ENTITY_DETAILS')
201: and ou.organization_id = orgif.organization_id
202: and orgif.org_information1 = p_org_information1;
203:
203:
204: /* Bug Fix 4994922 added cursor csr_get_sickpay_defaults */
205: cursor csr_get_sickpay_defaults(p_business_group_id NUMBER) is
206: select orgif.org_information1, orgif.org_information2, orgif.org_information3
207: from hr_organization_information orgif,hr_organization_units ou
208: where orgif.org_information_context = 'DK_SICKPAY_DEFAULTS'
209: and ou.business_group_id = p_business_group_id
210: and ou.organization_id = p_organization_id
211: and ou.organization_id = orgif.organization_id;
299: ,p_org_information2 in varchar2
300: ,p_org_information3 in varchar2
301: ) IS
302:
303: l_org_information1 hr_organization_information.org_information1%TYPE;
304: l_organization_id hr_organization_information.organization_id%TYPE;
305: l_business_group_id hr_organization_units.business_group_id%TYPE;
306:
307: /* Bug Fix 4994922, added record variable */
300: ,p_org_information3 in varchar2
301: ) IS
302:
303: l_org_information1 hr_organization_information.org_information1%TYPE;
304: l_organization_id hr_organization_information.organization_id%TYPE;
305: l_business_group_id hr_organization_units.business_group_id%TYPE;
306:
307: /* Bug Fix 4994922, added record variable */
308: l_sickpay_records l_rec;
325: where organization_id = l_organization_id;
326:
327: cursor getorgid is
328: select organization_id
329: from hr_organization_information
330: where org_information_id = p_org_information_id;
331:
332: cursor orgnum is
333: select orgif.org_information1 from hr_organization_information orgif,hr_organization_units ou
329: from hr_organization_information
330: where org_information_id = p_org_information_id;
331:
332: cursor orgnum is
333: select orgif.org_information1 from hr_organization_information orgif,hr_organization_units ou
334: where ( orgif.org_information_context = 'DK_SERVICE_PROVIDER_DETAILS' or orgif.org_information_context = 'DK_LEGAL_ENTITY_DETAILS')
335: and ou.organization_id = orgif.organization_id
336: and orgif.organization_id <> nvl(l_organization_id,0)
337: and orgif.org_information1 = p_org_information1;
338:
339: /* Bug Fix 4994922 added cursor csr_get_sickpay_defaults */
340: cursor csr_get_sickpay_defaults(p_business_group_id NUMBER, p_organization_id NUMBER) is
341: select orgif.org_information1, orgif.org_information2, orgif.org_information3
342: from hr_organization_information orgif,hr_organization_units ou
343: where orgif.org_information_context = 'DK_SICKPAY_DEFAULTS'
344: and ou.business_group_id = p_business_group_id
345: and ou.organization_id = p_organization_id
346: and ou.organization_id = orgif.organization_id;
563: /* Not more than one Service Provider can be created in a Business Group */
564: --
565: CURSOR get_sp( p_business_group_id hr_organization_units.business_group_id%TYPE) IS
566: select count(hou.organization_id)
567: from HR_ORGANIZATION_INFORMATION hoi
568: ,HR_ORGANIZATION_UNITS hou
569: ,FND_SESSIONS s
570: where hoi.org_information_context ='CLASS'
571: and hoi.org_information1 ='DK_SERVICE_PROVIDER'