eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_DK_VALIDATE_PKG dependencies on HR_ORGANIZATION_UNITS

Line 175: l_organization_id hr_organization_units.organization_id%TYPE;

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 */
179: l_sickpay_records l_rec;

Line 176: l_business_group_id hr_organization_units.business_group_id%TYPE;

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 */
179: l_sickpay_records l_rec;
180: l_no_records NUMBER ;

Line 195: from hr_organization_units

191: l_hol_acc_ed DATE;
192:
193: cursor getbgid is
194: select business_group_id
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

Line 199: select orgif.org_information1 from hr_organization_information orgif,hr_organization_units ou

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:

Line 207: from hr_organization_information orgif,hr_organization_units ou

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;

Line 305: l_business_group_id hr_organization_units.business_group_id%TYPE;

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;
309: l_no_records NUMBER ;

Line 324: from hr_organization_units

320: l_hol_acc_ed DATE;
321:
322: cursor getbgid is
323: select business_group_id
324: from hr_organization_units
325: where organization_id = l_organization_id;
326:
327: cursor getorgid is
328: select organization_id

Line 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;

Line 342: from hr_organization_information orgif,hr_organization_units ou

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;

Line 548: l_organization_id hr_organization_units.organization_id%TYPE;

544: (p_organization_id in number
545: ,p_org_information1 in varchar2
546: ) IS
547:
548: l_organization_id hr_organization_units.organization_id%TYPE;
549: l_business_group_id hr_organization_units.business_group_id%TYPE;
550: l_int_ext_flag hr_organization_units.internal_external_flag%TYPE;
551: /* Added for bug fix 4227055 */
552: l_sp hr_organization_units.organization_id%TYPE;

Line 549: l_business_group_id hr_organization_units.business_group_id%TYPE;

545: ,p_org_information1 in varchar2
546: ) IS
547:
548: l_organization_id hr_organization_units.organization_id%TYPE;
549: l_business_group_id hr_organization_units.business_group_id%TYPE;
550: l_int_ext_flag hr_organization_units.internal_external_flag%TYPE;
551: /* Added for bug fix 4227055 */
552: l_sp hr_organization_units.organization_id%TYPE;
553:

Line 550: l_int_ext_flag hr_organization_units.internal_external_flag%TYPE;

546: ) IS
547:
548: l_organization_id hr_organization_units.organization_id%TYPE;
549: l_business_group_id hr_organization_units.business_group_id%TYPE;
550: l_int_ext_flag hr_organization_units.internal_external_flag%TYPE;
551: /* Added for bug fix 4227055 */
552: l_sp hr_organization_units.organization_id%TYPE;
553:
554: SP_DATA_FOUND EXCEPTION;

Line 552: l_sp hr_organization_units.organization_id%TYPE;

548: l_organization_id hr_organization_units.organization_id%TYPE;
549: l_business_group_id hr_organization_units.business_group_id%TYPE;
550: l_int_ext_flag hr_organization_units.internal_external_flag%TYPE;
551: /* Added for bug fix 4227055 */
552: l_sp hr_organization_units.organization_id%TYPE;
553:
554: SP_DATA_FOUND EXCEPTION;
555:
556: cursor orgtype is

Line 557: select ou.internal_external_flag from hr_organization_units ou ,FND_SESSIONS s

553:
554: SP_DATA_FOUND EXCEPTION;
555:
556: cursor orgtype is
557: select ou.internal_external_flag from hr_organization_units ou ,FND_SESSIONS s
558: where ou.organization_id= p_organization_id
559: and s.session_id = userenv('sessionid')
560: and s.effective_date between ou.date_from and nvl(ou.date_to,to_date('31/12/4712','DD/MM/YYYY'));
561:

Line 565: CURSOR get_sp( p_business_group_id hr_organization_units.business_group_id%TYPE) IS

561:
562: /* Added for bug fix 4227055 */
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

Line 568: ,HR_ORGANIZATION_UNITS hou

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'
572: and hou.organization_id = hoi.organization_id

Line 579: from hr_organization_units

575: and s.effective_date between hou.date_from and nvl(hou.date_to,to_date('31/12/4712','DD/MM/YYYY'));
576:
577: CURSOR getbgid is
578: select business_group_id
579: from hr_organization_units
580: where organization_id = p_organization_id;
581: --
582: BEGIN
583: --