APPS.PY_W2_DBITEMS dependencies on FF_USER_ENTITIES

Line 40: insert into ff_user_entities

36: p_description in varchar2
37: ) is
38: begin -- [
39: hr_utility.set_location('gbstrdbi.insert_user_entity', 1);
40: insert into ff_user_entities
41: (user_entity_id,
42: business_group_id,
43: legislation_code,
44: route_id,

Line 56: values (ff_user_entities_s.nextval,

52: last_update_login,
53: created_by,
54: creation_date)
55: --
56: values (ff_user_entities_s.nextval,
57: null,
58: 'US',
59: ff_routes_s.currval,
60: 'N',

Line 99: ff_user_entities_s.currval,

95: created_by,
96: creation_date)
97: --
98: values (p_user_name,
99: ff_user_entities_s.currval,
100: p_data_type,
101: p_definition_text,
102: p_null_allowed_flag,
103: p_description,

Line 289: --++ FROM ff_user_entities

285: --++ 'Y');
286:
287: --++ SELECT user_entity_id
288: --++ INTO l_user_entity_id
289: --++ FROM ff_user_entities
290: --++ WHERE user_entity_name = 'EMPLOYEE_PERSON_ADDRESS_DETAILS';
291:
292: --++ insert_database_item
293: --++ ('PER_ADR_COUNTRY_CODE',

Line 2475: ff_user_entities ue

2471: l_dbi_null_allowed_flag,
2472: l_dbi_description,
2473: l_dbi_data_type
2474: from ff_database_items dbi,
2475: ff_user_entities ue
2476: where dbi.user_name = SUBSTR(p_item_name,3,LENGTH(p_item_name)-2)
2477: and dbi.user_entity_id = ue.user_entity_id;
2478: -- and ue.business_group_id is null;
2479: end; -- ]

Line 2487: select ff_user_entities_s.nextval into l_user_entity_seq

2483: where rc.context_id = c.context_id
2484: and rc.route_id = l_live_route_id
2485: and context_name like 'ASSIGNMENT%';
2486:
2487: select ff_user_entities_s.nextval into l_user_entity_seq
2488: from dual;
2489:
2490:
2491: select route_id into l_er_archive_route_id

Line 2539: insert into ff_user_entities

2535: from ff_route_parameters
2536: where parameter_name = 'User Entity ID'
2537: and route_id = l_route_id;
2538:
2539: insert into ff_user_entities
2540: (user_entity_id,
2541: business_group_id,
2542: legislation_code,
2543: route_id,

Line 2678: ff_user_entities ue

2674: dbi.null_allowed_flag,
2675: dbi.description ,
2676: dbi.data_type
2677: from ff_database_items dbi,
2678: ff_user_entities ue
2679: where dbi.user_name = SUBSTR(p_item_name,3,LENGTH(p_item_name)-2)
2680: and dbi.user_entity_id = ue.user_entity_id;
2681:
2682: cursor get_context is

Line 2695: from ff_user_entities

2691:
2692: cursor get_user_entity is
2693: select user_entity_id,
2694: route_id
2695: from ff_user_entities
2696: where user_entity_name = p_item_name;
2697:
2698: cursor csr_get_jursd_level (p_defined_balance_id number) is
2699: select jurisdiction_level

Line 2979: update ff_user_entities

2975: hr_utility.trace ('New Route id : '||
2976: to_char(l_route_id));
2977: hr_utility.trace ('User Entity id : '||
2978: to_char(l_user_entity_id));
2979: update ff_user_entities
2980: set route_id = l_route_id
2981: where user_entity_id = l_user_entity_id;
2982:
2983: update ff_route_parameter_values

Line 2991: select ff_user_entities_s.nextval

2987: end if;
2988:
2989: else
2990:
2991: select ff_user_entities_s.nextval
2992: into l_user_entity_seq
2993: from dual;
2994:
2995: insert into ff_user_entities

Line 2995: insert into ff_user_entities

2991: select ff_user_entities_s.nextval
2992: into l_user_entity_seq
2993: from dual;
2994:
2995: insert into ff_user_entities
2996: (user_entity_id,
2997: business_group_id,
2998: legislation_code,
2999: route_id,