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_PTX_UTL dependencies on PQH_WORKSHEETS

Line 2873: p_transaction_id IN pqh_worksheets.worksheet_id%TYPE,

2869:
2870: FUNCTION set_status
2871: (
2872: p_transaction_category_id IN pqh_transaction_categories.transaction_category_id%TYPE,
2873: p_transaction_id IN pqh_worksheets.worksheet_id%TYPE,
2874: p_status IN pqh_worksheets.transaction_status%TYPE
2875: ) RETURN varchar2 IS
2876: /*
2877: This procedure will update the txn status

Line 2874: p_status IN pqh_worksheets.transaction_status%TYPE

2870: FUNCTION set_status
2871: (
2872: p_transaction_category_id IN pqh_transaction_categories.transaction_category_id%TYPE,
2873: p_transaction_id IN pqh_worksheets.worksheet_id%TYPE,
2874: p_status IN pqh_worksheets.transaction_status%TYPE
2875: ) RETURN varchar2 IS
2876: /*
2877: This procedure will update the txn status
2878: */

Line 3885: from pqh_worksheets wks, pqh_worksheet_details wdt

3881: --
3882: cursor c_worksheets(p_position_transaction_id number) is
3883: select distinct wks.worksheet_id, wks.budget_version_id,
3884: wdt.worksheet_detail_id, wdt.budget_detail_id
3885: from pqh_worksheets wks, pqh_worksheet_details wdt
3886: where wks.worksheet_id = wdt.worksheet_id
3887: and wks.worksheet_mode_cd = 'O'
3888: and wdt.position_transaction_id = p_position_transaction_id;
3889: --