DBA Data[Home] [Help]

APPS.HR_WIP_TXNS dependencies on FND_USER

Line 79: (p_creator_user_id in fnd_user.user_id%TYPE)

75: -- ----------------------------------------------------------------------------
76: -- |-----------------------< chk_creator_user_id >-----------------------|
77: -- ----------------------------------------------------------------------------
78: Procedure chk_creator_user_id
79: (p_creator_user_id in fnd_user.user_id%TYPE)
80: is
81: --
82: l_end_date fnd_user.end_date%TYPE;
83: cursor csr_creator_user_id is

Line 82: l_end_date fnd_user.end_date%TYPE;

78: Procedure chk_creator_user_id
79: (p_creator_user_id in fnd_user.user_id%TYPE)
80: is
81: --
82: l_end_date fnd_user.end_date%TYPE;
83: cursor csr_creator_user_id is
84: select end_date
85: from fnd_user
86: where user_id = p_creator_user_id;

Line 85: from fnd_user

81: --
82: l_end_date fnd_user.end_date%TYPE;
83: cursor csr_creator_user_id is
84: select end_date
85: from fnd_user
86: where user_id = p_creator_user_id;
87: --
88: begin
89: If p_creator_user_id is null

Line 156: Procedure chk_transaction_creator(p_creator_user_id in fnd_user.user_id%TYPE

152: --
153: -- ----------------------------------------------------------------------------
154: -- |-----------------------< chk_transaction_creator >-----------------------|
155: -- ----------------------------------------------------------------------------
156: Procedure chk_transaction_creator(p_creator_user_id in fnd_user.user_id%TYPE
157: ,p_current_user_id in fnd_user.user_id%TYPE
158: )is
159: begin
160: If p_creator_user_id <> p_current_user_id

Line 157: ,p_current_user_id in fnd_user.user_id%TYPE

153: -- ----------------------------------------------------------------------------
154: -- |-----------------------< chk_transaction_creator >-----------------------|
155: -- ----------------------------------------------------------------------------
156: Procedure chk_transaction_creator(p_creator_user_id in fnd_user.user_id%TYPE
157: ,p_current_user_id in fnd_user.user_id%TYPE
158: )is
159: begin
160: If p_creator_user_id <> p_current_user_id
161: then

Line 265: ,p_creator_user_id IN fnd_user.user_id%TYPE

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
268: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
269: ) RETURN hr_wip_transactions.transaction_id%TYPE is

Line 344: ,p_creator_user_id IN fnd_user.user_id%TYPE

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
347: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
348: ) RETURN hr_wip_transactions.transaction_id%TYPE

Line 374: ,p_creator_user_id IN fnd_user.user_id%TYPE

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
377: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
378: ,p_transaction_id OUT NOCOPY hr_wip_transactions.transaction_id%TYPE

Line 402: ,p_creator_user_id IN fnd_user.user_id%TYPE

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
405: ) RETURN hr_wip_transactions.transaction_id%TYPE is
406: PRAGMA AUTONOMOUS_TRANSACTION;

Line 429: ,p_creator_user_id IN fnd_user.user_id%TYPE

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
432: ,p_transaction_id OUT NOCOPY hr_wip_transactions.transaction_id%TYPE
433: )is

Line 491: ,p_current_user_id IN fnd_user.user_id%TYPE

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
495: default hr_api.g_varchar2

Line 564: ,p_current_user_id IN fnd_user.user_id%TYPE

560: -- |-----------------------< save_for_later >-----------------------|
561: -- ----------------------------------------------------------------------------
562: Procedure save_for_later
563: (p_transaction_id IN hr_wip_transactions.transaction_id%TYPE
564: ,p_current_user_id IN fnd_user.user_id%TYPE
565: ,p_vo_xml IN VARCHAR2
566: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE
567: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
568: default hr_api.g_varchar2

Line 709: ,p_current_user_id IN fnd_user.user_id%TYPE

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
713: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE

Line 781: ,p_current_user_id IN fnd_user.user_id%TYPE

777: -- |-----------------------< pending_approval >-----------------------|
778: -- ----------------------------------------------------------------------------
779: Procedure pending_approval
780: (p_transaction_id IN hr_wip_transactions.transaction_id%TYPE
781: ,p_current_user_id IN fnd_user.user_id%TYPE
782: ,p_vo_xml IN VARCHAR2
783: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
784: default hr_api.g_varchar2
785: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE