DBA Data[Home] [Help]

APPS.HR_DOR_REVIEW_SS dependencies on WF_ITEMS

Line 15: itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,

11: -- |----------------------< get_approval_req >--------------------------|
12: -- ---------------------------------------------------------------------------
13: --
14: PROCEDURE get_approval_req (
15: itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
16: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
17: actid IN NUMBER,
18: funcmode IN VARCHAR2,
19: resultout OUT nocopy VARCHAR2 )

Line 16: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,

12: -- ---------------------------------------------------------------------------
13: --
14: PROCEDURE get_approval_req (
15: itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
16: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
17: actid IN NUMBER,
18: funcmode IN VARCHAR2,
19: resultout OUT nocopy VARCHAR2 )
20: IS

Line 2152: p_item_type wf_items.item_type%type;

2148: p_return_status varchar2(100);
2149: l_object_version_number number;
2150: l_effective_date date;
2151: l_validate number;
2152: p_item_type wf_items.item_type%type;
2153: p_item_key wf_items.item_key%type;
2154: p_action_mode varchar2(30);
2155: p_transaction_id hr_api_transactions.transaction_id%type;
2156: l_user_name varchar2(30);

Line 2153: p_item_key wf_items.item_key%type;

2149: l_object_version_number number;
2150: l_effective_date date;
2151: l_validate number;
2152: p_item_type wf_items.item_type%type;
2153: p_item_key wf_items.item_key%type;
2154: p_action_mode varchar2(30);
2155: p_transaction_id hr_api_transactions.transaction_id%type;
2156: l_user_name varchar2(30);
2157: l_verified_by_user_name varchar2(30);

Line 3899: p_item_type WF_ITEMS.ITEM_TYPE%TYPE;

3895: transaction status to E.
3896: ============================================================================*/
3897: procedure delete_transaction(p_transaction_id in number)
3898: IS
3899: p_item_type WF_ITEMS.ITEM_TYPE%TYPE;
3900: p_item_key WF_ITEMS.ITEM_KEY%TYPE;
3901: l_proc varchar2(50) := 'delete_transaction';
3902:
3903: BEGIN

Line 3900: p_item_key WF_ITEMS.ITEM_KEY%TYPE;

3896: ============================================================================*/
3897: procedure delete_transaction(p_transaction_id in number)
3898: IS
3899: p_item_type WF_ITEMS.ITEM_TYPE%TYPE;
3900: p_item_key WF_ITEMS.ITEM_KEY%TYPE;
3901: l_proc varchar2(50) := 'delete_transaction';
3902:
3903: BEGIN
3904:

Line 4235: PROCEDURE block_for_transaction (itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,

4231: hr_utility.set_location(' Leaving:'||l_proc, 20);
4232:
4233: end get_transaction_id;
4234:
4235: PROCEDURE block_for_transaction (itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
4236: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
4237: actid IN NUMBER,
4238: funcmode IN VARCHAR2,
4239: resultout OUT nocopy VARCHAR2 )

Line 4236: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,

4232:
4233: end get_transaction_id;
4234:
4235: PROCEDURE block_for_transaction (itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
4236: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
4237: actid IN NUMBER,
4238: funcmode IN VARCHAR2,
4239: resultout OUT nocopy VARCHAR2 )
4240: IS

Line 4275: PROCEDURE create_bprv_block (itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,

4271:
4272: end block_for_transaction;
4273:
4274: /* Added for bug#16449378*/
4275: PROCEDURE create_bprv_block (itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
4276: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
4277: actid IN NUMBER,
4278: funcmode IN VARCHAR2,
4279: resultout OUT nocopy VARCHAR2 )

Line 4276: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,

4272: end block_for_transaction;
4273:
4274: /* Added for bug#16449378*/
4275: PROCEDURE create_bprv_block (itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
4276: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
4277: actid IN NUMBER,
4278: funcmode IN VARCHAR2,
4279: resultout OUT nocopy VARCHAR2 )
4280: IS