eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_REFRESH_DATA dependencies on PQH_TABLE_ROUTE

Line 62: ( p_where_clause_in IN pqh_table_route.where_clause%TYPE,

58: RETURN VARCHAR2 ;
59:
60:
61: PROCEDURE replace_where_params
62: ( p_where_clause_in IN pqh_table_route.where_clause%TYPE,
63: p_txn_tab_flag IN VARCHAR2,
64: p_txn_id IN number,
65: p_where_clause_out OUT NOCOPY pqh_table_route.where_clause%TYPE );
66:

Line 65: p_where_clause_out OUT NOCOPY pqh_table_route.where_clause%TYPE );

61: PROCEDURE replace_where_params
62: ( p_where_clause_in IN pqh_table_route.where_clause%TYPE,
63: p_txn_tab_flag IN VARCHAR2,
64: p_txn_id IN number,
65: p_where_clause_out OUT NOCOPY pqh_table_route.where_clause%TYPE );
66:
67: PROCEDURE replace_where_params_purge
68: ( p_where_clause_in IN pqh_table_route.where_clause%TYPE,
69: p_txn_tab_flag IN VARCHAR2,

Line 68: ( p_where_clause_in IN pqh_table_route.where_clause%TYPE,

64: p_txn_id IN number,
65: p_where_clause_out OUT NOCOPY pqh_table_route.where_clause%TYPE );
66:
67: PROCEDURE replace_where_params_purge
68: ( p_where_clause_in IN pqh_table_route.where_clause%TYPE,
69: p_txn_tab_flag IN VARCHAR2,
70: p_txn_id IN number,
71: p_where_clause_out OUT NOCOPY pqh_table_route.where_clause%TYPE );
72:

Line 71: p_where_clause_out OUT NOCOPY pqh_table_route.where_clause%TYPE );

67: PROCEDURE replace_where_params_purge
68: ( p_where_clause_in IN pqh_table_route.where_clause%TYPE,
69: p_txn_tab_flag IN VARCHAR2,
70: p_txn_id IN number,
71: p_where_clause_out OUT NOCOPY pqh_table_route.where_clause%TYPE );
72:
73:
74: PROCEDURE get_all_rows
75: (p_select_stmt IN t_where_clause_typ,

Line 76: p_from_clause IN pqh_table_route.from_clause%TYPE,

72:
73:
74: PROCEDURE get_all_rows
75: (p_select_stmt IN t_where_clause_typ,
76: p_from_clause IN pqh_table_route.from_clause%TYPE,
77: p_where_clause IN pqh_table_route.where_clause%TYPE,
78: p_total_columns IN NUMBER,
79: p_total_rows OUT NOCOPY NUMBER,
80: p_all_txn_rows OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE );

Line 77: p_where_clause IN pqh_table_route.where_clause%TYPE,

73:
74: PROCEDURE get_all_rows
75: (p_select_stmt IN t_where_clause_typ,
76: p_from_clause IN pqh_table_route.from_clause%TYPE,
77: p_where_clause IN pqh_table_route.where_clause%TYPE,
78: p_total_columns IN NUMBER,
79: p_total_rows OUT NOCOPY NUMBER,
80: p_all_txn_rows OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE );
81:

Line 90: p_from_clause_txn IN pqh_table_route.from_clause%TYPE,

86: PROCEDURE update_tables
87: (p_column_name IN pqh_attributes.column_name%TYPE,
88: p_column_type IN pqh_attributes.column_type%TYPE,
89: p_column_val IN VARCHAR2,
90: p_from_clause_txn IN pqh_table_route.from_clause%TYPE,
91: p_from_clause_shd IN pqh_table_route.from_clause%TYPE,
92: p_rep_where_clause_shd IN pqh_table_route.where_clause%TYPE );
93:
94:

Line 91: p_from_clause_shd IN pqh_table_route.from_clause%TYPE,

87: (p_column_name IN pqh_attributes.column_name%TYPE,
88: p_column_type IN pqh_attributes.column_type%TYPE,
89: p_column_val IN VARCHAR2,
90: p_from_clause_txn IN pqh_table_route.from_clause%TYPE,
91: p_from_clause_shd IN pqh_table_route.from_clause%TYPE,
92: p_rep_where_clause_shd IN pqh_table_route.where_clause%TYPE );
93:
94:
95: -- String Parsing functions and Procedures

Line 92: p_rep_where_clause_shd IN pqh_table_route.where_clause%TYPE );

88: p_column_type IN pqh_attributes.column_type%TYPE,
89: p_column_val IN VARCHAR2,
90: p_from_clause_txn IN pqh_table_route.from_clause%TYPE,
91: p_from_clause_shd IN pqh_table_route.from_clause%TYPE,
92: p_rep_where_clause_shd IN pqh_table_route.where_clause%TYPE );
93:
94:
95: -- String Parsing functions and Procedures
96: /*

Line 116: (p_string_in IN pqh_table_route.where_clause%TYPE,

112: /*
113: || The parse_string procedure: puts all atomics into a PL/SQL table.
114: */
115: PROCEDURE parse_string
116: (p_string_in IN pqh_table_route.where_clause%TYPE,
117: p_atomics_list_out OUT NOCOPY atoms_tabtype,
118: p_num_atomics_out IN OUT NOCOPY NUMBER,
119: p_delimiters_in IN VARCHAR2 := std_delimiters);
120: