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_WF dependencies on PQH_TRANSACTION_CATEGORIES

Line 169: from pqh_transaction_categories

165: l_document varchar2(2000) := document;
166: l_document_type varchar2(2000) := document_type;
167:
168: cursor c1 is select post_txn_function,short_name
169: from pqh_transaction_categories
170: where transaction_category_id = l_tran_cat_id ;
171: begin
172: hr_utility.set_location(l_proc || 'Entering',10);
173: hr_utility.set_location(l_proc || 'document id ' || document_id,20);

Line 221: from pqh_transaction_categories

217: l_reject_notification varchar2(200);
218: l_document varchar2(2000) := document;
219: l_document_type varchar2(2000) := document_type;
220: cursor c1 is select post_txn_function,short_name
221: from pqh_transaction_categories
222: where transaction_category_id = l_tran_cat_id ;
223: begin
224: hr_utility.set_location(l_proc || 'Entering',10);
225: hr_utility.set_location(l_proc || 'document id ' || document_id,20);

Line 272: from pqh_transaction_categories

268: l_back_notification varchar2(200);
269: l_document varchar2(2000) := document;
270: l_document_type varchar2(2000) := document_type;
271: cursor c1 is select post_txn_function,short_name
272: from pqh_transaction_categories
273: where transaction_category_id = l_tran_cat_id ;
274: begin
275: hr_utility.set_location(l_proc || 'Entering',10);
276: hr_utility.set_location(l_proc || 'document id ' || document_id,20);

Line 323: from pqh_transaction_categories

319: l_override_notification varchar2(2000);
320: l_document varchar2(2000) := document;
321: l_document_type varchar2(2000) := document_type;
322: cursor c1 is select post_txn_function,short_name
323: from pqh_transaction_categories
324: where transaction_category_id = l_tran_cat_id ;
325: begin
326: hr_utility.set_location(l_proc || 'Entering',10);
327: hr_utility.set_location(l_proc || 'document id ' || document_id,20);

Line 374: from pqh_transaction_categories

370: l_document varchar2(2000) := document;
371: l_document_type varchar2(2000) := document_type;
372: l_apply_notification varchar2(200);
373: cursor c1 is select post_txn_function,short_name
374: from pqh_transaction_categories
375: where transaction_category_id = l_tran_cat_id ;
376: begin
377: hr_utility.set_location(l_proc || 'Entering',10);
378: hr_utility.set_location(l_proc || 'document id ' || document_id,20);

Line 425: from pqh_transaction_categories

421: l_document_type varchar2(2000) := document_type;
422: l_hyphen_pos number;
423: l_warning_notification varchar2(200);
424: cursor c1 is select post_txn_function,short_name
425: from pqh_transaction_categories
426: where transaction_category_id = l_tran_cat_id ;
427: begin
428: hr_utility.set_location(l_proc || 'Entering',10);
429: hr_utility.set_location(l_proc || 'document id ' || document_id,20);

Line 476: from pqh_transaction_categories

472: l_respond_notification varchar2(200);
473: l_document varchar2(2000) := document;
474: l_document_type varchar2(2000) := document_type;
475: cursor c1 is select post_txn_function,short_name
476: from pqh_transaction_categories
477: where transaction_category_id = l_tran_cat_id ;
478: begin
479: hr_utility.set_location(l_proc || 'Entering',10);
480: hr_utility.set_location(l_proc || 'document id ' || document_id,20);

Line 949: FROM pqh_transaction_categories tct

945: , post_txn_function
946: , post_style_cd
947: , future_action_cd
948: , short_name
949: FROM pqh_transaction_categories tct
950: WHERE transaction_category_id = p_transaction_category_id;
951: r_txn_cat c_txn_cat%ROWTYPE;
952: BEGIN
953: hr_utility.set_location(l_proc || ' Entering',10);

Line 2198: l_short_name pqh_transaction_categories.short_name%type;

2194: is
2195: l_proc VARCHAR2(61) := g_package || 'which_txn_cat';
2196: l_transaction_category_id number;
2197: l_transaction_id number;
2198: l_short_name pqh_transaction_categories.short_name%type;
2199: BEGIN
2200: hr_utility.set_location(l_proc || ' Entering',10);
2201: hr_utility.set_location(l_proc || ' FuncMode ' || funcmode, 20);
2202: IF (FUNCMODE = 'RUN') THEN

Line 2208: from pqh_transaction_categories

2204: decode_itemkey(p_itemkey => itemkey
2205: ,p_transaction_category_id => l_transaction_category_id
2206: ,p_transaction_id => l_transaction_id);
2207: select short_name into l_short_name
2208: from pqh_transaction_categories
2209: where transaction_category_id = l_transaction_category_id;
2210: result := 'COMPLETE:' || l_short_name;
2211: hr_utility.set_location(l_proc || ' short_name '||l_short_name,30);
2212: hr_utility.set_location(l_proc || ' Exiting ',100);

Line 2352: l_future_action_cd pqh_transaction_categories.future_action_cd%TYPE;

2348: )
2349: IS
2350: l_effective_date DATE;
2351: l_proc VARCHAR2(61) := g_package || 'approve_txn';
2352: l_future_action_cd pqh_transaction_categories.future_action_cd%TYPE;
2353: l_post_style_cd pqh_transaction_categories.post_style_cd%TYPE;
2354: BEGIN
2355: hr_utility.set_location(l_proc || ' Entering',10);
2356: hr_utility.set_location(l_proc || ' FuncMode ' || funcmode, 20);

Line 2353: l_post_style_cd pqh_transaction_categories.post_style_cd%TYPE;

2349: IS
2350: l_effective_date DATE;
2351: l_proc VARCHAR2(61) := g_package || 'approve_txn';
2352: l_future_action_cd pqh_transaction_categories.future_action_cd%TYPE;
2353: l_post_style_cd pqh_transaction_categories.post_style_cd%TYPE;
2354: BEGIN
2355: hr_utility.set_location(l_proc || ' Entering',10);
2356: hr_utility.set_location(l_proc || ' FuncMode ' || funcmode, 20);
2357: IF (FUNCMODE = 'RUN') THEN

Line 2708: l_member_cd pqh_transaction_categories.member_cd%type;

2704: RETURN NUMBER
2705: IS
2706:
2707: l_role_id number(15);
2708: l_member_cd pqh_transaction_categories.member_cd%type;
2709: l_position_id number;
2710: l_assignment_id number;
2711: l_workflow_enable_flag pqh_transaction_categories.workflow_enable_flag%type;
2712:

Line 2711: l_workflow_enable_flag pqh_transaction_categories.workflow_enable_flag%type;

2707: l_role_id number(15);
2708: l_member_cd pqh_transaction_categories.member_cd%type;
2709: l_position_id number;
2710: l_assignment_id number;
2711: l_workflow_enable_flag pqh_transaction_categories.workflow_enable_flag%type;
2712:
2713: cursor c_get_txn_cat (p_transaction_category_id NUMBER) IS
2714: SELECT member_cd, workflow_enable_flag
2715: FROM pqh_transaction_categories tct

Line 2715: FROM pqh_transaction_categories tct

2711: l_workflow_enable_flag pqh_transaction_categories.workflow_enable_flag%type;
2712:
2713: cursor c_get_txn_cat (p_transaction_category_id NUMBER) IS
2714: SELECT member_cd, workflow_enable_flag
2715: FROM pqh_transaction_categories tct
2716: WHERE transaction_category_id = p_transaction_category_id;
2717:
2718: cursor c_get_user_role (p_user_id NUMBER) is
2719: SELECT role_id

Line 2860: from pqh_transaction_categories

2856: l_post_txn_function varchar2(61);
2857: l_hyphen_pos number;
2858: l_set_status varchar2(200);
2859: cursor c1 is select post_txn_function,short_name
2860: from pqh_transaction_categories
2861: where transaction_category_id = l_tran_cat_id ;
2862: BEGIN
2863: hr_utility.set_location(l_proc || ' Entering',10);
2864: hr_utility.set_location(l_proc || ' workflow ' || p_workflow_name, 10);