APPS.PAY_MX_ARCHIVE_DBI_PKG dependencies on FF_ROUTES

Line 10: l_text FF_ROUTES.TEXT%TYPE;

6: -- create_archive_dbi procedure
7: -------------------------------------------------------------------------
8: PROCEDURE create_archive_routes IS
9:
10: l_text FF_ROUTES.TEXT%TYPE;
11: l_gre_context_id NUMBER;
12: l_assignment_action_context_id NUMBER;
13: l_exists VARCHAR2(1);
14:

Line 43: FROM ff_routes

39: and fac.context = &B2 /* 2nd context of tax_unit_id */';
40:
41: SELECT 'Y'
42: INTO l_exists
43: FROM ff_routes
44: WHERE route_name = 'MX_BALANCES_ARCHIVE_ROUTE';
45:
46: UPDATE ff_routes
47: SET text = l_text

Line 46: UPDATE ff_routes

42: INTO l_exists
43: FROM ff_routes
44: WHERE route_name = 'MX_BALANCES_ARCHIVE_ROUTE';
45:
46: UPDATE ff_routes
47: SET text = l_text
48: WHERE route_name = 'MX_BALANCES_ARCHIVE_ROUTE';
49:
50: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 52: INSERT INTO ff_routes

48: WHERE route_name = 'MX_BALANCES_ARCHIVE_ROUTE';
49:
50: EXCEPTION WHEN NO_DATA_FOUND THEN
51:
52: INSERT INTO ff_routes
53: (
54: route_id,
55: route_name,
56: user_defined_flag,

Line 67: ff_routes_s.NEXTVAL,

63: creation_date
64: )
65: VALUES
66: (
67: ff_routes_s.NEXTVAL,
68: 'MX_BALANCES_ARCHIVE_ROUTE',
69: 'N',
70: 'MX Year End Balances Archive Route',
71: l_text,

Line 89: ff_routes_s.CURRVAL,

85: parameter_name,
86: sequence_no
87: )
88: SELECT ff_route_parameters_s.NEXTVAL,
89: ff_routes_s.CURRVAL,
90: 'N',
91: 'User Entity ID',
92: 1
93: FROM dual;

Line 102: SELECT ff_routes_s.CURRVAL,

98: route_id,
99: context_id,
100: sequence_no
101: )
102: SELECT ff_routes_s.CURRVAL,
103: l_assignment_action_context_id,
104: 1
105: FROM dual;
106:

Line 113: SELECT ff_routes_s.CURRVAL,

109: route_id,
110: context_id,
111: sequence_no
112: )
113: SELECT ff_routes_s.CURRVAL,
114: l_gre_context_id,
115: 2
116: from dual;
117:

Line 208: FROM ff_routes

204: END;
205:
206: /* SELECT route_id
207: INTO l_number_archive_route_id
208: FROM ff_routes
209: WHERE route_name = 'MX_NUMBER_ARCHIVE_ROUTE';
210:
211: SELECT route_id
212: INTO l_date_archive_route_id

Line 213: FROM ff_routes

209: WHERE route_name = 'MX_NUMBER_ARCHIVE_ROUTE';
210:
211: SELECT route_id
212: INTO l_date_archive_route_id
213: FROM ff_routes
214: WHERE route_name = 'MX_DATE_ARCHIVE_ROUTE';
215:
216: SELECT route_id
217: INTO l_character_archive_route_id

Line 218: FROM ff_routes

214: WHERE route_name = 'MX_DATE_ARCHIVE_ROUTE';
215:
216: SELECT route_id
217: INTO l_character_archive_route_id
218: FROM ff_routes
219: WHERE route_name = 'MX_CHARACTER_ARCHIVE_ROUTE';
220: */
221: SELECT route_id
222: INTO l_balances_route

Line 223: FROM ff_routes

219: WHERE route_name = 'MX_CHARACTER_ARCHIVE_ROUTE';
220: */
221: SELECT route_id
222: INTO l_balances_route
223: FROM ff_routes
224: WHERE route_name = 'MX_BALANCES_ARCHIVE_ROUTE';
225:
226: -- Choose the archive route, based on the live db item's data type
227: IF l_dbi_data_type = 'N' THEN