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.HR_WIP_TXNS dependencies on WF_ITEMS

Line 19: (p_item_type in wf_items.item_type%TYPE,

15: -- ----------------------------------------------------------------------------
16: -- |-----------------------< chk_item_type_item_key_mand >---------------------|
17: -- ----------------------------------------------------------------------------
18: Procedure chk_item_type_item_key_mand
19: (p_item_type in wf_items.item_type%TYPE,
20: p_item_key in wf_items.item_key%TYPE)
21: is
22: begin
23: --

Line 20: p_item_key in wf_items.item_key%TYPE)

16: -- |-----------------------< chk_item_type_item_key_mand >---------------------|
17: -- ----------------------------------------------------------------------------
18: Procedure chk_item_type_item_key_mand
19: (p_item_type in wf_items.item_type%TYPE,
20: p_item_key in wf_items.item_key%TYPE)
21: is
22: begin
23: --
24: If p_item_type is null

Line 39: (p_item_type IN wf_items.item_type%TYPE,

35: -- ----------------------------------------------------------------------------
36: -- |-----------------------< chk_item_type_item_key_exists >-------------------|
37: -- ----------------------------------------------------------------------------
38: procedure chk_item_type_item_key_exists
39: (p_item_type IN wf_items.item_type%TYPE,
40: p_item_key IN wf_items.item_key%TYPE)
41: is
42: --
43: l_end_date wf_items.end_date%TYPE;

Line 40: p_item_key IN wf_items.item_key%TYPE)

36: -- |-----------------------< chk_item_type_item_key_exists >-------------------|
37: -- ----------------------------------------------------------------------------
38: procedure chk_item_type_item_key_exists
39: (p_item_type IN wf_items.item_type%TYPE,
40: p_item_key IN wf_items.item_key%TYPE)
41: is
42: --
43: l_end_date wf_items.end_date%TYPE;
44: --

Line 43: l_end_date wf_items.end_date%TYPE;

39: (p_item_type IN wf_items.item_type%TYPE,
40: p_item_key IN wf_items.item_key%TYPE)
41: is
42: --
43: l_end_date wf_items.end_date%TYPE;
44: --
45: cursor csr_item_type_exists is
46: select end_date
47: from wf_items

Line 47: from wf_items

43: l_end_date wf_items.end_date%TYPE;
44: --
45: cursor csr_item_type_exists is
46: select end_date
47: from wf_items
48: where item_type = p_item_type
49: and item_key = p_item_key;
50: --
51: begin

Line 262: (p_item_type IN wf_items.item_type%TYPE

258: -- ----------------------------------------------------------------------------
259: -- |-----------------------< ins >-----------------------|
260: -- ----------------------------------------------------------------------------
261: Function ins
262: (p_item_type IN wf_items.item_type%TYPE
263: ,p_item_key IN wf_items.item_key%TYPE
264: ,p_function_id IN fnd_form_functions.function_id%TYPE
265: ,p_creator_user_id IN fnd_user.user_id%TYPE
266: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE

Line 263: ,p_item_key IN wf_items.item_key%TYPE

259: -- |-----------------------< ins >-----------------------|
260: -- ----------------------------------------------------------------------------
261: Function ins
262: (p_item_type IN wf_items.item_type%TYPE
263: ,p_item_key IN wf_items.item_key%TYPE
264: ,p_function_id IN fnd_form_functions.function_id%TYPE
265: ,p_creator_user_id IN fnd_user.user_id%TYPE
266: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
267: ,p_vo_xml IN VARCHAR2

Line 341: (p_item_type IN wf_items.item_type%TYPE

337: -- ----------------------------------------------------------------------------
338: -- |-----------------------< create_transaction >-----------------------|
339: -- ----------------------------------------------------------------------------
340: Function create_transaction
341: (p_item_type IN wf_items.item_type%TYPE
342: ,p_item_key IN wf_items.item_key%TYPE
343: ,p_function_id IN fnd_form_functions.function_id%TYPE
344: ,p_creator_user_id IN fnd_user.user_id%TYPE
345: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE

Line 342: ,p_item_key IN wf_items.item_key%TYPE

338: -- |-----------------------< create_transaction >-----------------------|
339: -- ----------------------------------------------------------------------------
340: Function create_transaction
341: (p_item_type IN wf_items.item_type%TYPE
342: ,p_item_key IN wf_items.item_key%TYPE
343: ,p_function_id IN fnd_form_functions.function_id%TYPE
344: ,p_creator_user_id IN fnd_user.user_id%TYPE
345: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
346: ,p_vo_xml IN VARCHAR2

Line 371: (p_item_type IN wf_items.item_type%TYPE

367: -- ----------------------------------------------------------------------------
368: -- |-----------------------< create_transaction >-----------------------|
369: -- ----------------------------------------------------------------------------
370: Procedure create_transaction
371: (p_item_type IN wf_items.item_type%TYPE
372: ,p_item_key IN wf_items.item_key%TYPE
373: ,p_function_id IN fnd_form_functions.function_id%TYPE
374: ,p_creator_user_id IN fnd_user.user_id%TYPE
375: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE

Line 372: ,p_item_key IN wf_items.item_key%TYPE

368: -- |-----------------------< create_transaction >-----------------------|
369: -- ----------------------------------------------------------------------------
370: Procedure create_transaction
371: (p_item_type IN wf_items.item_type%TYPE
372: ,p_item_key IN wf_items.item_key%TYPE
373: ,p_function_id IN fnd_form_functions.function_id%TYPE
374: ,p_creator_user_id IN fnd_user.user_id%TYPE
375: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
376: ,p_vo_xml IN VARCHAR2

Line 399: (p_item_type IN wf_items.item_type%TYPE

395: -- ----------------------------------------------------------------------------
396: -- |-----------------------< create_query_only_transaction >-----------------|
397: -- ----------------------------------------------------------------------------
398: Function create_query_only_transaction
399: (p_item_type IN wf_items.item_type%TYPE
400: ,p_item_key IN wf_items.item_key%TYPE
401: ,p_function_id IN fnd_form_functions.function_id%TYPE
402: ,p_creator_user_id IN fnd_user.user_id%TYPE
403: ,p_vo_xml IN VARCHAR2

Line 400: ,p_item_key IN wf_items.item_key%TYPE

396: -- |-----------------------< create_query_only_transaction >-----------------|
397: -- ----------------------------------------------------------------------------
398: Function create_query_only_transaction
399: (p_item_type IN wf_items.item_type%TYPE
400: ,p_item_key IN wf_items.item_key%TYPE
401: ,p_function_id IN fnd_form_functions.function_id%TYPE
402: ,p_creator_user_id IN fnd_user.user_id%TYPE
403: ,p_vo_xml IN VARCHAR2
404: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE

Line 426: (p_item_type IN wf_items.item_type%TYPE

422: -- ----------------------------------------------------------------------------
423: -- |-----------------------< create_query_only_transaction >-----------------|
424: -- ----------------------------------------------------------------------------
425: Procedure create_query_only_transaction
426: (p_item_type IN wf_items.item_type%TYPE
427: ,p_item_key IN wf_items.item_key%TYPE
428: ,p_function_id IN fnd_form_functions.function_id%TYPE
429: ,p_creator_user_id IN fnd_user.user_id%TYPE
430: ,p_vo_xml IN VARCHAR2

Line 427: ,p_item_key IN wf_items.item_key%TYPE

423: -- |-----------------------< create_query_only_transaction >-----------------|
424: -- ----------------------------------------------------------------------------
425: Procedure create_query_only_transaction
426: (p_item_type IN wf_items.item_type%TYPE
427: ,p_item_key IN wf_items.item_key%TYPE
428: ,p_function_id IN fnd_form_functions.function_id%TYPE
429: ,p_creator_user_id IN fnd_user.user_id%TYPE
430: ,p_vo_xml IN VARCHAR2
431: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE

Line 489: (p_item_type IN wf_items.item_type%TYPE

485: -- ----------------------------------------------------------------------------
486: -- |-----------------------< save_for_later >-----------------------|
487: -- ----------------------------------------------------------------------------
488: Procedure save_for_later
489: (p_item_type IN wf_items.item_type%TYPE
490: ,p_item_key IN wf_items.item_key%TYPE
491: ,p_current_user_id IN fnd_user.user_id%TYPE
492: ,p_vo_xml IN VARCHAR2
493: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE

Line 490: ,p_item_key IN wf_items.item_key%TYPE

486: -- |-----------------------< save_for_later >-----------------------|
487: -- ----------------------------------------------------------------------------
488: Procedure save_for_later
489: (p_item_type IN wf_items.item_type%TYPE
490: ,p_item_key IN wf_items.item_key%TYPE
491: ,p_current_user_id IN fnd_user.user_id%TYPE
492: ,p_vo_xml IN VARCHAR2
493: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE
494: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE

Line 707: (p_item_type IN wf_items.item_type%TYPE

703: -- ----------------------------------------------------------------------------
704: -- |-----------------------< pending_approval >-----------------------|
705: -- ----------------------------------------------------------------------------
706: Procedure pending_approval
707: (p_item_type IN wf_items.item_type%TYPE
708: ,p_item_key IN wf_items.item_key%TYPE
709: ,p_current_user_id IN fnd_user.user_id%TYPE
710: ,p_vo_xml IN VARCHAR2
711: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE

Line 708: ,p_item_key IN wf_items.item_key%TYPE

704: -- |-----------------------< pending_approval >-----------------------|
705: -- ----------------------------------------------------------------------------
706: Procedure pending_approval
707: (p_item_type IN wf_items.item_type%TYPE
708: ,p_item_key IN wf_items.item_key%TYPE
709: ,p_current_user_id IN fnd_user.user_id%TYPE
710: ,p_vo_xml IN VARCHAR2
711: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
712: default hr_api.g_varchar2

Line 875: (p_item_type IN wf_items.item_type%TYPE

871: -- ----------------------------------------------------------------------------
872: -- |-----------------------< reject_for_correction >-----------------------|
873: -- ----------------------------------------------------------------------------
874: Procedure reject_for_correction
875: (p_item_type IN wf_items.item_type%TYPE
876: ,p_item_key IN wf_items.item_key%TYPE
877: )is
878: PRAGMA AUTONOMOUS_TRANSACTION;
879: l_state hr_wip_transactions.state%TYPE;

Line 876: ,p_item_key IN wf_items.item_key%TYPE

872: -- |-----------------------< reject_for_correction >-----------------------|
873: -- ----------------------------------------------------------------------------
874: Procedure reject_for_correction
875: (p_item_type IN wf_items.item_type%TYPE
876: ,p_item_key IN wf_items.item_key%TYPE
877: )is
878: PRAGMA AUTONOMOUS_TRANSACTION;
879: l_state hr_wip_transactions.state%TYPE;
880: l_dml_mode hr_wip_transactions.dml_mode%TYPE;

Line 980: (p_item_type IN wf_items.item_type%TYPE

976: -- ----------------------------------------------------------------------------
977: -- |-----------------------< delete_transaction >-----------------------|
978: -- ----------------------------------------------------------------------------
979: Procedure delete_transaction
980: (p_item_type IN wf_items.item_type%TYPE
981: ,p_item_key IN wf_items.item_key%TYPE
982: )is
983: PRAGMA AUTONOMOUS_TRANSACTION;
984: l_transaction_id hr_wip_transactions.transaction_id%TYPE;

Line 981: ,p_item_key IN wf_items.item_key%TYPE

977: -- |-----------------------< delete_transaction >-----------------------|
978: -- ----------------------------------------------------------------------------
979: Procedure delete_transaction
980: (p_item_type IN wf_items.item_type%TYPE
981: ,p_item_key IN wf_items.item_key%TYPE
982: )is
983: PRAGMA AUTONOMOUS_TRANSACTION;
984: l_transaction_id hr_wip_transactions.transaction_id%TYPE;
985: cursor csr_transaction is

Line 1067: (p_item_type IN wf_items.item_type%TYPE

1063: -- ----------------------------------------------------------------------------
1064: -- |-----------------------< update_transaction >-----------------------|
1065: -- ----------------------------------------------------------------------------
1066: Procedure update_transaction
1067: (p_item_type IN wf_items.item_type%TYPE
1068: ,p_item_key IN wf_items.item_key%TYPE
1069: ,p_state IN hr_wip_transactions.state%TYPE
1070: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE
1071: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE

Line 1068: ,p_item_key IN wf_items.item_key%TYPE

1064: -- |-----------------------< update_transaction >-----------------------|
1065: -- ----------------------------------------------------------------------------
1066: Procedure update_transaction
1067: (p_item_type IN wf_items.item_type%TYPE
1068: ,p_item_key IN wf_items.item_key%TYPE
1069: ,p_state IN hr_wip_transactions.state%TYPE
1070: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE
1071: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
1072: default hr_api.g_varchar2