DBA Data[Home] [Help]

APPS.HR_WORKFLOW_INSTALL_PKG dependencies on HR_NAV_UNIT_GLOBAL_USAGES

Line 556: from hr_nav_unit_global_usages

552:
553: procedure get_global_usage_id (p_global_name varchar2) is
554: cursor id is
555: select global_usage_id
556: from hr_nav_unit_global_usages
557: where global_name = p_global_name
558: and nav_unit_id = current_nav_unit_id;
559: begin
560: open id;

Line 569: insert into hr_nav_unit_global_usages (

565: p_global_name varchar2,
566: p_in_or_out varchar2,
567: p_mandatory_flag varchar2) is
568: begin
569: insert into hr_nav_unit_global_usages (
570: global_usage_id,
571: nav_unit_id,
572: global_name,
573: in_or_out,

Line 576: hr_nav_unit_global_usages_s.nextval,

572: global_name,
573: in_or_out,
574: mandatory_flag)
575: values (
576: hr_nav_unit_global_usages_s.nextval,
577: current_nav_unit_id,
578: p_global_name,
579: p_in_or_out,
580: p_mandatory_flag);