DBA Data[Home] [Help]

APPS.HR_PAY_RATE_SS dependencies on HR_API_TRANSACTIONS

Line 1901: l_transaction_privilege hr_api_transactions.transaction_privilege%type;

1897: -- --------------------------------------------------------------------------
1898: -- declare local variables
1899: -- --------------------------------------------------------------------------
1900: l_proc varchar2(200) := g_package || 'start_transaction';
1901: l_transaction_privilege hr_api_transactions.transaction_privilege%type;
1902: l_transaction_id hr_api_transactions.transaction_id%type;
1903: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
1904:
1905: -- l_person_id hr_api_transactions.creator_person_id%type := p_selected_person_id;

Line 1902: l_transaction_id hr_api_transactions.transaction_id%type;

1898: -- declare local variables
1899: -- --------------------------------------------------------------------------
1900: l_proc varchar2(200) := g_package || 'start_transaction';
1901: l_transaction_privilege hr_api_transactions.transaction_privilege%type;
1902: l_transaction_id hr_api_transactions.transaction_id%type;
1903: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
1904:
1905: -- l_person_id hr_api_transactions.creator_person_id%type := p_selected_person_id;
1906:

Line 1905: -- l_person_id hr_api_transactions.creator_person_id%type := p_selected_person_id;

1901: l_transaction_privilege hr_api_transactions.transaction_privilege%type;
1902: l_transaction_id hr_api_transactions.transaction_id%type;
1903: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
1904:
1905: -- l_person_id hr_api_transactions.creator_person_id%type := p_selected_person_id;
1906:
1907: Cursor c_get_transaction_step_id
1908: is
1909: select

Line 2511: ln_transaction_id hr_api_transactions.transaction_id%TYPE;

2507: IS
2508:
2509: l_proc varchar2(200) := g_package || 'get_transaction_step_details';
2510:
2511: ln_transaction_id hr_api_transactions.transaction_id%TYPE;
2512: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;
2513: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;
2514: ln_trans_step_rows NUMBER ;
2515: lv_activity_name VARCHAR2(100);

Line 2587: ln_transaction_id hr_api_transactions.transaction_id%TYPE;

2583: IS
2584:
2585:
2586: l_proc varchar2(200) := g_package || 'is_transaction_exists';
2587: ln_transaction_id hr_api_transactions.transaction_id%TYPE;
2588: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;
2589: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;
2590: ln_trans_step_rows NUMBER ;
2591: lv_activity_name VARCHAR2(100);

Line 4572: ln_transaction_id hr_api_transactions.transaction_id%TYPE;

4568: p_ltt_component IN OUT NOCOPY sshr_sal_comp_tab_typ ) IS
4569:
4570: l_proc varchar2(200) := g_package || 'get_transaction_details';
4571: ln_transaction_step_id NUMBER;
4572: ln_transaction_id hr_api_transactions.transaction_id%TYPE;
4573: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;
4574: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;
4575: ln_trans_step_rows NUMBER ;
4576: lv_activity_name wf_item_activity_statuses_v.activity_name%type ;

Line 5290: ln_transaction_id hr_api_transactions.transaction_id%TYPE;

5286: p_ltt_component IN OUT NOCOPY sshr_sal_comp_tab_typ ) IS
5287:
5288: l_proc varchar2(200) := g_package || 'get_txn_details_for_review';
5289: ln_transaction_step_id NUMBER;
5290: ln_transaction_id hr_api_transactions.transaction_id%TYPE;
5291: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;
5292: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;
5293: ln_trans_step_rows NUMBER ;
5294: lv_activity_name wf_item_activity_statuses_v.activity_name%type ;