[Home] [Help]
1312: --
1313: DESCRIPTION
1314: This function is used to retrieve a database item value. The sql to be run
1315: needs to be assembled from the information held in the entity horizon (in
1316: particular the tables ff_database_items and ff_routes). Having retrieved
1317: the route (the part of the sql statement after the 'FROM' clause) into a
1318: large string, the context bind variables and where clause fillers need to be
1319: replaced. The text string is then updated with the definition text
1320: information from ff_database_items (the part of the sql statement after
1316: particular the tables ff_database_items and ff_routes). Having retrieved
1317: the route (the part of the sql statement after the 'FROM' clause) into a
1318: large string, the context bind variables and where clause fillers need to be
1319: replaced. The text string is then updated with the definition text
1320: information from ff_database_items (the part of the sql statement after
1321: the 'SELECT' and before the 'FROM'). The complete text string is then
1322: executed using dynamic pl/sql.
1323: */
1324: function run_db_item
1355: order by RP.sequence_no;
1356: --
1357: sql_cursor integer;
1358: l_rows integer;
1359: l_definition_text ff_database_items.definition_text%type;
1360: l_data_type ff_database_items.data_type%type;
1361: l_user_entity_id ff_user_entities.user_entity_id%type;
1362: l_creator_type ff_user_entities.creator_type%type;
1363: l_notfound_allowed_flag ff_user_entities.notfound_allowed_flag%type;
1356: --
1357: sql_cursor integer;
1358: l_rows integer;
1359: l_definition_text ff_database_items.definition_text%type;
1360: l_data_type ff_database_items.data_type%type;
1361: l_user_entity_id ff_user_entities.user_entity_id%type;
1362: l_creator_type ff_user_entities.creator_type%type;
1363: l_notfound_allowed_flag ff_user_entities.notfound_allowed_flag%type;
1364: l_route_id ff_routes.route_id%type;
1401: l_notfound_allowed_flag,
1402: l_route_id,
1403: l_text,
1404: l_o_hint
1405: from ff_database_items DBI
1406: , ff_user_entities ENT
1407: , ff_routes RO
1408: where DBI.user_name = p_database_name
1409: and DBI.user_entity_id = ENT.user_entity_id
2543: --
2544: sql_cursor integer;
2545: l_rows integer;
2546: l_definition_text varchar2(240);
2547: --l_data_type ff_database_items.data_type%type;
2548: l_data_type varchar2(1) := 'N';
2549: l_user_entity_id ff_user_entities.user_entity_id%type;
2550: l_creator_type ff_user_entities.creator_type%type;
2551: l_notfound_allowed_flag ff_user_entities.notfound_allowed_flag%type;
2991: is
2992: select dbi.user_name
2993: , nvl(ent.business_group_id, -1)
2994: , nvl(ent.legislation_code, ' ')
2995: from ff_database_items dbi
2996: , ff_user_entities ent
2997: where ent.creator_id = p_def_bal
2998: and ent.creator_type = 'B'
2999: and ent.user_entity_id = dbi.user_entity_id;
2998: and ent.creator_type = 'B'
2999: and ent.user_entity_id = dbi.user_entity_id;
3000: --
3001: l_balance_val varchar2(240);
3002: l_user_name ff_database_items.user_name%type;
3003: l_business_group_id ff_user_entities.business_group_id%type;
3004: l_legislation_code ff_user_entities.legislation_code%type;
3005: --
3006: BEGIN