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_TRANSACTION_CATEGORIES

Line 1111: l_transaction_category_id pqh_transaction_categories.transaction_category_id%type;

1107: p_position_id hr_all_positions_f.position_id%TYPE;
1108: p_effective_start_date hr_all_positions_f.effective_start_date%TYPE;
1109: l_pei_position_extra_info_id per_position_extra_info.position_extra_info_id%type;
1110: l_pei_object_version_number per_position_extra_info.object_version_number%type;
1111: l_transaction_category_id pqh_transaction_categories.transaction_category_id%type;
1112: l_return varchar2(30) := 'SUCCESS';
1113: l_seasonal_dates_present boolean := false;
1114: l_overlap_dates_present boolean := false;
1115: l_position_family_flag boolean := false;

Line 1174: from pqh_transaction_categories

1170:
1171: /*
1172: CURSOR c_transaction_category is
1173: select transaction_category_id
1174: from pqh_transaction_categories
1175: where short_name = 'POSITION_TRANSACTION';
1176: */
1177: --
1178: cursor c_pes(p_ptx_extra_info_id number) is

Line 2872: p_transaction_category_id IN pqh_transaction_categories.transaction_category_id%TYPE,

2868: --------------------------------------------------------------------------------------------------------------
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: /*