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,
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;
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:
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: