APPS.PAY_BALANCE_PKG dependencies on FF_ROUTES

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

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

Line 1364: l_route_id ff_routes.route_id%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;
1365: l_context_name ff_contexts.context_name%type;
1366: l_text varchar2(20000); -- large array for route text
1367: l_replace_text varchar2(80);
1368: l_error_text varchar2(200); -- used for sql error messages

Line 1407: , ff_routes RO

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
1410: and ( (ENT.legislation_code is null and ENT.business_group_id is null)
1411: or (ENT.business_group_id is null

Line 2341: from ff_routes RO

2337: select RO.text,
2338: RO.optimizer_hint
2339: into l_from_clause,
2340: l_o_hint
2341: from ff_routes RO
2342: where RO.route_id = p_route_id;
2343: --
2344: -- The following loop searches through and replaces all the bind variables
2345: -- (Bn) with the actual value for the context. For a text value, the

Line 2552: l_route_id ff_routes.route_id%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;
2552: l_route_id ff_routes.route_id%type;
2553: l_context_name ff_contexts.context_name%type;
2554: l_text varchar2(20000); -- large array for route text
2555: l_replace_text varchar2(80);
2556: l_error_text varchar2(200); -- used for sql error messages

Line 2600: , ff_routes RO

2596: l_route_id,
2597: l_text,
2598: l_o_hint
2599: from ff_user_entities ENT
2600: , ff_routes RO
2601: where ent.user_entity_name = p_user_name
2602: and ( (ENT.legislation_code is null and ENT.business_group_id is null)
2603: or (ENT.business_group_id is null
2604: and p_legislation_code = ENT.legislation_code )

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

4051: ELSE
4052: CLOSE bal_contexts_per;
4053: END IF;
4054: --
4055: -- If we could not find a latest balance, then derive from ff_routes
4056: --
4057: if g_debug then
4058: hr_utility.set_location ('pay_balance_pkg.get_old_latest_bal_value', 37);
4059: end if;