DBA Data[Home] [Help]

APPS.PY_W2_DBITEMS dependencies on FF_DATABASE_ITEMS

Line 85: insert into ff_database_items (

81: ) is
82: begin -- [
83: hr_utility.set_location('gbstrdbi.insert_curr_database_item', 1);
84: hr_utility.trace ('creating : ' || p_user_name);
85: insert into ff_database_items (
86: user_name,
87: user_entity_id,
88: data_type,
89: definition_text,

Line 126: insert into ff_database_items (

122: ) is
123: begin -- [
124: hr_utility.set_location('gbstrdbi.insert_database_item', 1);
125: hr_utility.trace ('creating : ' || p_user_name);
126: insert into ff_database_items (
127: user_name,
128: user_entity_id,
129: data_type,
130: definition_text,

Line 2365: from ff_database_items dbi,

2361: l_live_route_id,
2362: l_dbi_null_allowed_flag,
2363: l_dbi_description,
2364: l_dbi_data_type
2365: from ff_database_items dbi,
2366: ff_user_entities ue
2367: where dbi.user_name = SUBSTR(p_item_name,3,LENGTH(p_item_name)-2)
2368: and dbi.user_entity_id = ue.user_entity_id;
2369: -- and ue.business_group_id is null;

Line 2480: insert into ff_database_items (

2476: 0,
2477: 0,
2478: sysdate);
2479:
2480: insert into ff_database_items (
2481: user_name,
2482: user_entity_id,
2483: data_type,
2484: definition_text,

Line 2567: from ff_database_items dbi,

2563: ue.route_id,
2564: dbi.null_allowed_flag,
2565: dbi.description ,
2566: dbi.data_type
2567: from ff_database_items dbi,
2568: ff_user_entities ue
2569: where dbi.user_name = SUBSTR(p_item_name,3,LENGTH(p_item_name)-2)
2570: and dbi.user_entity_id = ue.user_entity_id;
2571:

Line 2925: insert into ff_database_items (

2921: 0,
2922: 0,
2923: sysdate);
2924:
2925: insert into ff_database_items (
2926: user_name,
2927: user_entity_id,
2928: data_type,
2929: definition_text,