APPS.PAY_DATABASE_ITEMS_PKG dependencies on FF_ROUTES

Line 23: FF_ROUTES.TEXT%TYPE

19: created even if user entity was previously
20: created.
21: RThirlby 29-FEB-2000 No changes required for 11i upport
22: EMunisek 13-NOV-2011 Changed parameter specification to
23: FF_ROUTES.TEXT%TYPE
24: */
25: --
26: -- Procedures
27: --

Line 39: p_route_text FF_ROUTES.TEXT%TYPE DEFAULT NULL,

35: p_route_name VARCHAR2,
36: p_param_value1 VARCHAR2 DEFAULT NULL,
37: p_param_value2 VARCHAR2 DEFAULT NULL,
38: p_route_description VARCHAR2 DEFAULT NULL,
39: p_route_text FF_ROUTES.TEXT%TYPE DEFAULT NULL,
40: p_context_name1 VARCHAR2 DEFAULT NULL,
41: p_context_name2 VARCHAR2 DEFAULT NULL,
42: p_context_name3 VARCHAR2 DEFAULT NULL,
43: p_context_name4 VARCHAR2 DEFAULT NULL,

Line 78: FROM ff_routes

74: BEGIN
75: --
76: SELECT route_id
77: INTO l_route_id
78: FROM ff_routes
79: WHERE route_name = upper(p_route_name);
80: --
81: EXCEPTION WHEN NO_DATA_FOUND THEN
82: --

Line 85: INSERT INTO ff_routes

81: EXCEPTION WHEN NO_DATA_FOUND THEN
82: --
83: -- Create the route, context usages, and parameters
84: --
85: INSERT INTO ff_routes
86: (route_id,
87: route_name,
88: user_defined_flag,
89: description,

Line 97: (ff_routes_s.nextval,

93: last_update_login,
94: created_by,
95: creation_date)
96: VALUES
97: (ff_routes_s.nextval,
98: upper(p_route_name),
99: 'N',
100: p_route_description,
101: p_route_text,

Line 108: SELECT ff_routes_s.currval

104: 0,
105: 0,
106: sysdate);
107: --
108: SELECT ff_routes_s.currval
109: INTO l_route_id
110: FROM dual;
111: --
112: -- Insert any context usages