APPS.PAY_BALANCE_PKG dependencies on FF_ROUTES

Line 1229: particular the tables ff_database_items and ff_routes). Having retrieved

1225: --
1226: DESCRIPTION
1227: This function is used to retrieve a database item value. The sql to be run
1228: needs to be assembled from the information held in the entity horizon (in
1229: particular the tables ff_database_items and ff_routes). Having retrieved
1230: the route (the part of the sql statement after the 'FROM' clause) into a
1231: large string, the context bind variables and where clause fillers need to be
1232: replaced. The text string is then updated with the definition text
1233: information from ff_database_items (the part of the sql statement after

Line 1277: l_route_id ff_routes.route_id%type;

1273: l_data_type ff_database_items.data_type%type;
1274: l_user_entity_id ff_user_entities.user_entity_id%type;
1275: l_creator_type ff_user_entities.creator_type%type;
1276: l_notfound_allowed_flag ff_user_entities.notfound_allowed_flag%type;
1277: l_route_id ff_routes.route_id%type;
1278: l_context_name ff_contexts.context_name%type;
1279: l_text varchar2(20000); -- large array for route text
1280: l_replace_text varchar2(80);
1281: l_error_text varchar2(200); -- used for sql error messages

Line 1320: , ff_routes RO

1316: l_text,
1317: l_o_hint
1318: from ff_database_items DBI
1319: , ff_user_entities ENT
1320: , ff_routes RO
1321: where DBI.user_name = p_database_name
1322: and DBI.user_entity_id = ENT.user_entity_id
1323: and ( (ENT.legislation_code is null and ENT.business_group_id is null)
1324: or (ENT.business_group_id is null

Line 2174: from ff_routes RO

2170: select RO.text,
2171: RO.optimizer_hint
2172: into l_from_clause,
2173: l_o_hint
2174: from ff_routes RO
2175: where RO.route_id = p_route_id;
2176: --
2177: -- The following loop searches through and replaces all the bind variables
2178: -- (Bn) with the actual value for the context. For a text value, the

Line 2381: l_route_id ff_routes.route_id%type;

2377: l_data_type varchar2(1) := 'N';
2378: l_user_entity_id ff_user_entities.user_entity_id%type;
2379: l_creator_type ff_user_entities.creator_type%type;
2380: l_notfound_allowed_flag ff_user_entities.notfound_allowed_flag%type;
2381: l_route_id ff_routes.route_id%type;
2382: l_context_name ff_contexts.context_name%type;
2383: l_text varchar2(20000); -- large array for route text
2384: l_replace_text varchar2(80);
2385: l_error_text varchar2(200); -- used for sql error messages

Line 2416: , ff_routes RO

2412: l_route_id,
2413: l_text,
2414: l_o_hint
2415: from ff_user_entities ENT
2416: , ff_routes RO
2417: where ent.user_entity_name = p_user_name
2418: and ( (ENT.legislation_code is null and ENT.business_group_id is null)
2419: or (ENT.business_group_id is null
2420: and p_legislation_code = ENT.legislation_code )

Line 3757: -- If we could not find a latest balance, then derive from ff_routes

3753: ELSE
3754: CLOSE bal_contexts_per;
3755: END IF;
3756: --
3757: -- If we could not find a latest balance, then derive from ff_routes
3758: --
3759: if g_debug then
3760: hr_utility.set_location ('pay_balance_pkg.get_old_latest_bal_value', 37);
3761: end if;