APPS.PAY_US_DATABASE_ITEMS_PKG dependencies on FF_ROUTES

Line 23: FF_ROUTES.TEXT%TYPE For Bug#13484606

19: M Reid 06-JUN-1997 40.3 Removed show errors
20: A Myers 12-FEB-1998 110.1 Added parameter to insert_user_entity and
21: associated logic, as per pydyndbi.pkb 110.10.
22: EMunisek 13-NOV-2011 115.2 Changed parameter specification to
23: FF_ROUTES.TEXT%TYPE For Bug#13484606
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 76: FROM ff_routes

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

Line 83: INSERT INTO ff_routes

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

Line 95: (ff_routes_s.nextval,

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

Line 106: SELECT ff_routes_s.currval

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