APPS.PAY_US_DATABASE_ITEMS_PKG dependencies on FF_ROUTES

Line 74: FROM ff_routes

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

Line 81: INSERT INTO ff_routes

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

Line 93: (ff_routes_s.nextval,

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

Line 104: SELECT ff_routes_s.currval

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