DBA Data[Home] [Help]

APPS.EDW_SEC_PKG dependencies on FND_USER

Line 366: x_user_name fnd_user.user_name%type;

362: v_Errorcode number;
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';

Line 409: -- Capture apps user and get person_id by going across db_link to fnd_user on master source instance.

405: dbms_session.set_context('edw_context', 'def_access_column',null);
406: dbms_session.set_context('edw_context', 'def_access_id',null);
407:
408:
409: -- Capture apps user and get person_id by going across db_link to fnd_user on master source instance.
410:
411: -- Find application user
412:
413: x_user_name := FND_PROFILE.VALUE('USERNAME');

Line 430: sql_stmt := 'select count(*) from fnd_user@' || x_db_link_name ||

426:
427: -- Check if application user exists on source instance
428:
429:
430: sql_stmt := 'select count(*) from fnd_user@' || x_db_link_name ||
431: ' where user_name = ''' ||x_user_name || '''';
432: EXECUTE IMMEDIATE sql_stmt INTO x_user_count;
433:
434: /*

Line 435: sql_stmt := 'select count(*) from fnd_user' ||

431: ' where user_name = ''' ||x_user_name || '''';
432: EXECUTE IMMEDIATE sql_stmt INTO x_user_count;
433:
434: /*
435: sql_stmt := 'select count(*) from fnd_user' ||
436: ' where user_name = ''' ||x_user_name || '''';
437: EXECUTE IMMEDIATE sql_stmt INTO x_user_count;
438: */
439:

Line 446: -- Get person_id by refering to FND_USER on master source instance

442: RAISE USER_NOT_EXIST;
443: END IF;
444:
445:
446: -- Get person_id by refering to FND_USER on master source instance
447:
448: sql_stmt := 'select nvl(employee_id, -1) from fnd_user@' || x_db_link_name ||
449: ' where user_name = ''' ||x_user_name || '''';
450: EXECUTE IMMEDIATE sql_stmt INTO x_person_id;

Line 448: sql_stmt := 'select nvl(employee_id, -1) from fnd_user@' || x_db_link_name ||

444:
445:
446: -- Get person_id by refering to FND_USER on master source instance
447:
448: sql_stmt := 'select nvl(employee_id, -1) from fnd_user@' || x_db_link_name ||
449: ' where user_name = ''' ||x_user_name || '''';
450: EXECUTE IMMEDIATE sql_stmt INTO x_person_id;
451:
452: /*

Line 453: sql_stmt := 'select nvl(employee_id, -1) from fnd_user' ||

449: ' where user_name = ''' ||x_user_name || '''';
450: EXECUTE IMMEDIATE sql_stmt INTO x_person_id;
451:
452: /*
453: sql_stmt := 'select nvl(employee_id, -1) from fnd_user' ||
454: ' where user_name = ''' ||x_user_name || '''';
455: EXECUTE IMMEDIATE sql_stmt INTO x_person_id;
456: */
457: