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_SS_PRINT dependencies on PQH_TABLE_ROUTE

Line 887: from pqh_table_route

883: IS
884: --
885: CURSOR csr_table_route IS
886: Select TABLE_ROUTE_ID
887: from pqh_table_route
888: where table_alias like 'PQH_SS%';
889:
890: l_table_route_id pqh_table_route.table_route_id%type := null;
891: BEGIN

Line 890: l_table_route_id pqh_table_route.table_route_id%type := null;

886: Select TABLE_ROUTE_ID
887: from pqh_table_route
888: where table_alias like 'PQH_SS%';
889:
890: l_table_route_id pqh_table_route.table_route_id%type := null;
891: BEGIN
892: --
893: if p_table_alias is not null then
894: --

Line 1023: PROCEDURE replace_where_clause_params(p_where_clause_in IN PQH_TABLE_ROUTE.where_clause%TYPE,

1019: END IF;
1020: RETURN l_col_val;
1021: END get_value_from_params_table;
1022:
1023: PROCEDURE replace_where_clause_params(p_where_clause_in IN PQH_TABLE_ROUTE.where_clause%TYPE,
1024: p_where_clause_out OUT NOCOPY PQH_TABLE_ROUTE.where_clause%TYPE)
1025: IS
1026: l_proc varchar2(72) := g_package||'replace_where_clause_params';
1027: l_atoms_tab PQH_REFRESH_DATA.atoms_tabtype;

Line 1024: p_where_clause_out OUT NOCOPY PQH_TABLE_ROUTE.where_clause%TYPE)

1020: RETURN l_col_val;
1021: END get_value_from_params_table;
1022:
1023: PROCEDURE replace_where_clause_params(p_where_clause_in IN PQH_TABLE_ROUTE.where_clause%TYPE,
1024: p_where_clause_out OUT NOCOPY PQH_TABLE_ROUTE.where_clause%TYPE)
1025: IS
1026: l_proc varchar2(72) := g_package||'replace_where_clause_params';
1027: l_atoms_tab PQH_REFRESH_DATA.atoms_tabtype;
1028: -- to hold the where_clause atoms

Line 1032: l_where_out pqh_table_route.where_clause%TYPE;

1028: -- to hold the where_clause atoms
1029: l_no_atoms number;
1030: l_key_column pqh_attributes.column_name%TYPE;
1031: l_key_val VARCHAR2(8000);
1032: l_where_out pqh_table_route.where_clause%TYPE;
1033: l_atom_length number;
1034: BEGIN
1035: hr_utility.set_location('Entering:'||l_proc, 5);
1036: PQH_REFRESH_DATA.parse_string(

Line 1186: from & where clause from pqh_table_route, bind the variables in where clause

1182: END populate_data_from_ff;
1183:
1184: /*----------------------------------------------------------------------------------
1185: POPULATE_DATA_FROM_QUERY: Common routine to build the dynamic query using the
1186: from & where clause from pqh_table_route, bind the variables in where clause
1187: and execute the query.
1188: ------------------------------------------------------------------------------------*/
1189: procedure populate_data_from_query (
1190: p_doc_short_name in varchar2,

Line 1201: l_where_clause_out PQH_TABLE_ROUTE.where_clause%TYPE;

1197: sql_query varchar2(32000) :=null;
1198: columntag varchar2(32000) :=null;
1199: l_statement varchar2(32000) ;
1200:
1201: l_where_clause_out PQH_TABLE_ROUTE.where_clause%TYPE;
1202:
1203: /* Removed the RECORD TYPE current_values_record in version 120.5 as selecting into this record type was limiting the attributes to 42. */
1204:
1205: /*Bug fix 4722431*/

Line 1217: pqh_table_route ptr

1213: doc.document_category
1214: from pqh_documents_f doc,
1215: pqh_document_attributes_f doa,
1216: pqh_attributes att,
1217: pqh_table_route ptr
1218: where doc.short_name = p_doc_short_name
1219: AND doa.document_id = doc.document_id
1220: AND p_effective_date between doc.effective_start_date and doc.effective_end_date
1221: AND p_effective_date between doa.effective_start_date and doa.effective_end_date

Line 1226: cursor column_tag_names(p_table_route_id pqh_table_route.table_route_id %TYPE) is

1222: AND att.attribute_id = doa.attribute_id
1223: AND att.master_table_route_id=ptr.table_route_id
1224: AND ptr.where_clause is not null;
1225: -- This curosr selects the column names and tag anme that need to be queried to form a dynamic sql query
1226: cursor column_tag_names(p_table_route_id pqh_table_route.table_route_id %TYPE) is
1227: select att.column_name att_column,doa.tag_name doc_tag,att.enable_flag flag
1228: from pqh_documents_f doc,
1229: pqh_document_attributes_f doa,
1230: pqh_attributes att

Line 1329: l_where_clause_out PQH_TABLE_ROUTE.where_clause%TYPE;

1325: tag_no integer :=0;
1326: p integer :=0;
1327: l_no_cols integer :=0;
1328:
1329: l_where_clause_out PQH_TABLE_ROUTE.where_clause%TYPE;
1330:
1331: BEGIN
1332: --
1333: -- Create a save point

Line 1385: pqh_table_route ptr

1381: , hr_api_transaction_values atv,
1382: pqh_documents_f doc,
1383: pqh_document_attributes_f doa,
1384: pqh_attributes att,
1385: pqh_table_route ptr
1386: -- Bug Fix 2945716,Added Select Stmt to retrieve max step_id
1387: WHERE atv.transaction_step_id in (Select max(transaction_step_id)
1388: From hr_api_transaction_steps
1389: where transaction_id = p_Transaction_Id

Line 1430: pqh_table_route ptr

1426: , pqh_ss_value_history atv,
1427: pqh_documents_f doc,
1428: pqh_document_attributes_f doa,
1429: pqh_attributes att,
1430: pqh_table_route ptr
1431: WHERE steps.step_history_id = atv.step_history_id
1432: AND steps.approval_history_id = atv.approval_history_id
1433: AND (atv.step_history_id,atv.approval_history_id) in
1434: (