DBA Data[Home] [Help]

APPS.EDW_SEC_PKG dependencies on EDW_SOURCE_INSTANCES

Line 367: x_db_link_name edw_source_instances.warehouse_to_instance_link%type;

363: v_ErrorText varchar2(200);
364:
365: x_user_count number;
366: x_user_name fnd_user.user_name%type;
367: x_db_link_name edw_source_instances.warehouse_to_instance_link%type;
368: x_person_id number;
369: x_instance_code edw_system_parameters.instance_code%type;
370: x_pk_fixed_string varchar2(30) := '-EMPLOYEE-PERS';
371: x_pk edw_hr_person_m.asgn_assignment_pk%type;

Line 423: select warehouse_to_instance_link into x_db_link_name from edw_source_instances

419:
420:
421: -- Find database link to master source instance
422:
423: select warehouse_to_instance_link into x_db_link_name from edw_source_instances
424: where instance_code = x_instance_code;
425:
426:
427: -- Check if application user exists on source instance