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 323: l_shadow_table_route_id pqh_table_route.shadow_table_route_id%TYPE;

319: ) is
320:
321:
322: l_table_route_id pqh_table_route.table_route_id%TYPE;
323: l_shadow_table_route_id pqh_table_route.shadow_table_route_id%TYPE;
324: l_from_clause pqh_table_route.from_clause%TYPE;
325: l_table_alias pqh_table_route.table_alias%TYPE;
326: l_where_clause pqh_table_route.where_clause%TYPE;
327: l_display_name pqh_table_route.display_name%TYPE;

Line 330: l_select_allowed_flag pqh_table_route.select_allowed_flag%TYPE;

326: l_where_clause pqh_table_route.where_clause%TYPE;
327: l_display_name pqh_table_route.display_name%TYPE;
328: l_rowid ROWID;
329: l_map_required_flag pqh_table_route.map_required_flag%TYPE;
330: l_select_allowed_flag pqh_table_route.select_allowed_flag%TYPE;
331: l_hide_table_for_view_flag pqh_table_route.hide_table_for_view_flag%TYPE;
332: l_display_order pqh_table_route.display_order%TYPE;
333:
334:

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

403: End if;
404:
405: else
406: -- select table_route_id into local variable.
407: select pqh_table_route_s.nextval into l_table_route_id from dual;
408:
409: INSERT_ROW (
410: X_ROWID => l_rowid,
411: X_TABLE_ROUTE_ID => l_table_route_id ,

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

447:
448: exception
449: when NO_DATA_FOUND then
450: -- select table_route_id into local variable.
451: select pqh_table_route_s.nextval into l_table_route_id from dual;
452:
453: INSERT_ROW (
454: X_ROWID => l_rowid,
455: X_TABLE_ROUTE_ID => l_table_route_id ,