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 170: l_organization_id hr_organization_units.organization_id%TYPE;

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

Line 171: l_business_group_id hr_organization_units.business_group_id%TYPE;

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

Line 185: from hr_organization_units

181: l_curr_sec27_ed DATE;
182:
183: cursor getbgid is
184: select business_group_id
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

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

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:

Line 197: from hr_organization_information orgif,hr_organization_units ou

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;

Line 278: l_business_group_id hr_organization_units.business_group_id%TYPE;

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

Line 292: from hr_organization_units

288: l_curr_sec27_ed DATE;
289:
290: cursor getbgid is
291: select business_group_id
292: from hr_organization_units
293: where organization_id = l_organization_id;
294:
295: cursor getorgid is
296: select organization_id

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

Line 310: from hr_organization_information orgif,hr_organization_units ou

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;

Line 499: l_organization_id hr_organization_units.organization_id%TYPE;

495: (p_organization_id in number
496: ,p_org_information1 in varchar2
497: ) IS
498:
499: l_organization_id hr_organization_units.organization_id%TYPE;
500: l_business_group_id hr_organization_units.business_group_id%TYPE;
501: l_int_ext_flag hr_organization_units.internal_external_flag%TYPE;
502: /* Added for bug fix 4227055 */
503: l_sp hr_organization_units.organization_id%TYPE;

Line 500: l_business_group_id hr_organization_units.business_group_id%TYPE;

496: ,p_org_information1 in varchar2
497: ) IS
498:
499: l_organization_id hr_organization_units.organization_id%TYPE;
500: l_business_group_id hr_organization_units.business_group_id%TYPE;
501: l_int_ext_flag hr_organization_units.internal_external_flag%TYPE;
502: /* Added for bug fix 4227055 */
503: l_sp hr_organization_units.organization_id%TYPE;
504:

Line 501: l_int_ext_flag hr_organization_units.internal_external_flag%TYPE;

497: ) IS
498:
499: l_organization_id hr_organization_units.organization_id%TYPE;
500: l_business_group_id hr_organization_units.business_group_id%TYPE;
501: l_int_ext_flag hr_organization_units.internal_external_flag%TYPE;
502: /* Added for bug fix 4227055 */
503: l_sp hr_organization_units.organization_id%TYPE;
504:
505: SP_DATA_FOUND EXCEPTION;

Line 503: l_sp hr_organization_units.organization_id%TYPE;

499: l_organization_id hr_organization_units.organization_id%TYPE;
500: l_business_group_id hr_organization_units.business_group_id%TYPE;
501: l_int_ext_flag hr_organization_units.internal_external_flag%TYPE;
502: /* Added for bug fix 4227055 */
503: l_sp hr_organization_units.organization_id%TYPE;
504:
505: SP_DATA_FOUND EXCEPTION;
506:
507: cursor orgtype is

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

504:
505: SP_DATA_FOUND EXCEPTION;
506:
507: cursor orgtype is
508: select ou.internal_external_flag from hr_organization_units ou ,FND_SESSIONS s
509: where ou.organization_id= p_organization_id
510: and s.session_id = userenv('sessionid')
511: and s.effective_date between ou.date_from and nvl(ou.date_to,to_date('31/12/4712','DD/MM/YYYY'));
512:

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

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

Line 519: ,HR_ORGANIZATION_UNITS hou

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

Line 530: from hr_organization_units

526: and s.effective_date between hou.date_from and nvl(hou.date_to,to_date('31/12/4712','DD/MM/YYYY'));
527:
528: CURSOR getbgid is
529: select business_group_id
530: from hr_organization_units
531: where organization_id = p_organization_id;
532: --
533: BEGIN
534: --