APPS.PQH_TABLE_ROUTE_PKG dependencies on PQH_TABLE_ROUTE_S

Line 189: update PQH_TABLE_ROUTE set

185: X_LAST_UPDATED_BY in NUMBER,
186: X_LAST_UPDATE_LOGIN in NUMBER
187: ) is
188: begin
189: update PQH_TABLE_ROUTE set
190: SHADOW_TABLE_ROUTE_ID = X_SHADOW_TABLE_ROUTE_ID,
191: FROM_CLAUSE = X_FROM_CLAUSE,
192: TABLE_ALIAS = X_TABLE_ALIAS,
193: WHERE_CLAUSE = X_WHERE_CLAUSE,

Line 340: l_shadow_table_route_id pqh_table_route.shadow_table_route_id%TYPE;

336: ) is
337:
338:
339: l_table_route_id pqh_table_route.table_route_id%TYPE;
340: l_shadow_table_route_id pqh_table_route.shadow_table_route_id%TYPE;
341: l_from_clause pqh_table_route.from_clause%TYPE;
342: l_table_alias pqh_table_route.table_alias%TYPE;
343: l_where_clause pqh_table_route.where_clause%TYPE;
344: l_display_name pqh_table_route.display_name%TYPE;

Line 347: l_select_allowed_flag pqh_table_route.select_allowed_flag%TYPE;

343: l_where_clause pqh_table_route.where_clause%TYPE;
344: l_display_name pqh_table_route.display_name%TYPE;
345: l_rowid ROWID;
346: l_map_required_flag pqh_table_route.map_required_flag%TYPE;
347: l_select_allowed_flag pqh_table_route.select_allowed_flag%TYPE;
348: l_hide_table_for_view_flag pqh_table_route.hide_table_for_view_flag%TYPE;
349: l_display_order pqh_table_route.display_order%TYPE;
350:
351:

Line 424: select pqh_table_route_s.nextval into l_table_route_id from dual;

420: End if;
421:
422: else
423: -- select table_route_id into local variable.
424: select pqh_table_route_s.nextval into l_table_route_id from dual;
425:
426: INSERT_ROW (
427: X_ROWID => l_rowid,
428: X_TABLE_ROUTE_ID => l_table_route_id ,

Line 468: select pqh_table_route_s.nextval into l_table_route_id from dual;

464:
465: exception
466: when NO_DATA_FOUND then
467: -- select table_route_id into local variable.
468: select pqh_table_route_s.nextval into l_table_route_id from dual;
469:
470: INSERT_ROW (
471: X_ROWID => l_rowid,
472: X_TABLE_ROUTE_ID => l_table_route_id ,