APPS.PAY_CA_DATABASE_ITEMS_PKG dependencies on FF_ROUTES

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

25: p_route_name VARCHAR2,
26: p_param_value1 VARCHAR2 DEFAULT NULL,
27: p_param_value2 VARCHAR2 DEFAULT NULL,
28: p_route_description VARCHAR2 DEFAULT NULL,
29: p_route_text FF_ROUTES.TEXT%TYPE DEFAULT NULL,
30: p_context_name1 VARCHAR2 DEFAULT NULL,
31: p_context_name2 VARCHAR2 DEFAULT NULL,
32: p_context_name3 VARCHAR2 DEFAULT NULL,
33: p_context_name4 VARCHAR2 DEFAULT NULL,

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

76: p_route_name VARCHAR2,
77: p_param_value1 VARCHAR2 DEFAULT NULL,
78: p_param_value2 VARCHAR2 DEFAULT NULL,
79: p_route_description VARCHAR2 DEFAULT NULL,
80: p_route_text FF_ROUTES.TEXT%TYPE DEFAULT NULL,
81: p_context_name1 VARCHAR2 DEFAULT NULL,
82: p_context_name2 VARCHAR2 DEFAULT NULL,
83: p_context_name3 VARCHAR2 DEFAULT NULL,
84: p_context_name4 VARCHAR2 DEFAULT NULL,

Line 119: FROM ff_routes

115: BEGIN
116: --
117: SELECT route_id
118: INTO l_route_id
119: FROM ff_routes
120: WHERE route_name = upper(p_route_name);
121: --
122: hr_utility.trace(' selected route..');
123: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 127: INSERT INTO ff_routes

123: EXCEPTION WHEN NO_DATA_FOUND THEN
124: --
125: -- Create the route, context usages, and parameters
126: --
127: INSERT INTO ff_routes
128: (route_id,
129: route_name,
130: user_defined_flag,
131: description,

Line 139: (ff_routes_s.nextval,

135: last_update_login,
136: created_by,
137: creation_date)
138: VALUES
139: (ff_routes_s.nextval,
140: upper(p_route_name),
141: 'N',
142: p_route_description,
143: p_route_text,

Line 153: SELECT ff_routes_s.currval

149:
150: hr_utility.trace('after insert of route');
151:
152: --
153: SELECT ff_routes_s.currval
154: INTO l_route_id
155: FROM dual;
156: --
157: -- Insert any context usages