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 2474: from ff_database_items dbi,

2470: l_live_route_id,
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;

Line 2589: insert into ff_database_items (

2585: 0,
2586: 0,
2587: sysdate);
2588:
2589: insert into ff_database_items (
2590: user_name,
2591: user_entity_id,
2592: data_type,
2593: definition_text,

Line 2677: from ff_database_items dbi,

2673: ue.route_id,
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:

Line 3044: insert into ff_database_items (

3040: 0,
3041: 0,
3042: sysdate);
3043:
3044: insert into ff_database_items (
3045: user_name,
3046: user_entity_id,
3047: data_type,
3048: definition_text,