APPS.HR_REGISTER_EITS dependencies on HR_ORG_INFO_TYPES_BY_CLASS

Line 482: INSERT INTO HR_ORG_INFO_TYPES_BY_CLASS

478: WHEN OTHERS THEN
479: fnd_file.put_line(fnd_file.log,l_fail);
480: end;
481:
482: INSERT INTO HR_ORG_INFO_TYPES_BY_CLASS
483: (ORG_CLASSIFICATION
484: ,ORG_INFORMATION_TYPE
485: ,MANDATORY_FLAG
486: ,ENABLED_FLAG )

Line 494: FROM HR_ORG_INFO_TYPES_BY_CLASS

490: ,'N'
491: ,'Y'
492: FROM sys.dual
493: WHERE not exists (SELECT 1
494: FROM HR_ORG_INFO_TYPES_BY_CLASS
495: WHERE ORG_INFORMATION_TYPE =v_info_type_name
496: and ORG_CLASSIFICATION = v_org_class);
497:
498: l_insert := 'The Information has been inserted into the table HR_ORG_INFO_TYPES_BY_CLASS for Organization Classification ' || v_org_class;

Line 498: l_insert := 'The Information has been inserted into the table HR_ORG_INFO_TYPES_BY_CLASS for Organization Classification ' || v_org_class;

494: FROM HR_ORG_INFO_TYPES_BY_CLASS
495: WHERE ORG_INFORMATION_TYPE =v_info_type_name
496: and ORG_CLASSIFICATION = v_org_class);
497:
498: l_insert := 'The Information has been inserted into the table HR_ORG_INFO_TYPES_BY_CLASS for Organization Classification ' || v_org_class;
499:
500: fnd_file.put_line(fnd_file.log,l_insert);
501: EXCEPTION
502: WHEN OTHERS THEN