APPS.EDW_SEC_PKG dependencies on EDW_HR_PERSON_M

Line 282: x_context_value := 'select ASGN_ASSIGNMENT_PK_KEY from EDW_HR_PERSON_M where '

278: max_context_length := 4000;
279: end if;
280:
281:
282: x_context_value := 'select ASGN_ASSIGNMENT_PK_KEY from EDW_HR_PERSON_M where '
283: || SYS_CONTEXT('edw_context','def_access_column')
284: || ' = '
285: || SYS_CONTEXT('edw_context','def_access_id');
286:

Line 306: where dim_name = 'EDW_HR_PERSON_M';

302: commit;
303:
304: -- Set attribute def_dim_id
305: select dim_id into x_def_dim_id from edw_sec_dim_info_t
306: where dim_name = 'EDW_HR_PERSON_M';
307: dbms_session.set_context('edw_context', 'DEF_DIM_ID', to_char(x_def_dim_id));
308:
309:
310: EXCEPTION

Line 371: x_pk edw_hr_person_m.asgn_assignment_pk%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;
372: x_pk_key edw_hr_person_m.asgn_assignment_pk_key%type;
373: x_name varchar2(2000); -- edw_hr_person_m.s01_name%type;
374: x_asgn_name edw_hr_person_m.asgn_name%type;
375: x_number number;

Line 372: x_pk_key edw_hr_person_m.asgn_assignment_pk_key%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;
372: x_pk_key edw_hr_person_m.asgn_assignment_pk_key%type;
373: x_name varchar2(2000); -- edw_hr_person_m.s01_name%type;
374: x_asgn_name edw_hr_person_m.asgn_name%type;
375: x_number number;
376: x_char varchar2(30);

Line 373: x_name varchar2(2000); -- edw_hr_person_m.s01_name%type;

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;
372: x_pk_key edw_hr_person_m.asgn_assignment_pk_key%type;
373: x_name varchar2(2000); -- edw_hr_person_m.s01_name%type;
374: x_asgn_name edw_hr_person_m.asgn_name%type;
375: x_number number;
376: x_char varchar2(30);
377: x_double_char varchar2(30);

Line 374: x_asgn_name edw_hr_person_m.asgn_name%type;

370: x_pk_fixed_string varchar2(30) := '-EMPLOYEE-PERS';
371: x_pk edw_hr_person_m.asgn_assignment_pk%type;
372: x_pk_key edw_hr_person_m.asgn_assignment_pk_key%type;
373: x_name varchar2(2000); -- edw_hr_person_m.s01_name%type;
374: x_asgn_name edw_hr_person_m.asgn_name%type;
375: x_number number;
376: x_char varchar2(30);
377: x_double_char varchar2(30);
378: x_access_id edw_hr_person_m.asgn_assignment_pk_key%type;

Line 378: x_access_id edw_hr_person_m.asgn_assignment_pk_key%type;

374: x_asgn_name edw_hr_person_m.asgn_name%type;
375: x_number number;
376: x_char varchar2(30);
377: x_double_char varchar2(30);
378: x_access_id edw_hr_person_m.asgn_assignment_pk_key%type;
379: x_access_column varchar2(30);
380: sql_stmt varchar2(4000);
381:
382: USER_NOT_EXIST EXCEPTION;

Line 467: from edw_hr_person_m

463:
464: x_pk := x_person_id || '-' || x_instance_code || x_pk_fixed_string;
465:
466: select asgn_assignment_pk_key into x_pk_key
467: from edw_hr_person_m
468: where asgn_assignment_pk = x_pk;
469:
470:
471:

Line 497: edw_hr_person_m

493: s13_person_id,
494: s14_person_id,
495: s15_person_id
496: from
497: edw_hr_person_m
498: where
499: asgn_assignment_pk_key = '|| x_pk_key;
500:
501:

Line 572: sql_stmt := 'select ' || x_access_column || ' from edw_hr_person_m where asgn_assignment_pk_key = ' || x_pk_key;

568:
569:
570: -- Need to use dynamic SQL as x_access_column not known in advance
571:
572: sql_stmt := 'select ' || x_access_column || ' from edw_hr_person_m where asgn_assignment_pk_key = ' || x_pk_key;
573:
574: EXECUTE IMMEDIATE sql_stmt INTO x_access_id;
575:
576: