DBA Data[Home] [Help]

APPS.HR_PAY_RATE_SS dependencies on HR_API_TRANSACTIONS

Line 1801: l_transaction_privilege hr_api_transactions.transaction_privilege%type;

1797: -- --------------------------------------------------------------------------
1798: -- declare local variables
1799: -- --------------------------------------------------------------------------
1800: l_proc varchar2(200) := g_package || 'start_transaction';
1801: l_transaction_privilege hr_api_transactions.transaction_privilege%type;
1802: l_transaction_id hr_api_transactions.transaction_id%type;
1803: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
1804:
1805: -- l_person_id hr_api_transactions.creator_person_id%type := p_selected_person_id;

Line 1802: l_transaction_id hr_api_transactions.transaction_id%type;

1798: -- declare local variables
1799: -- --------------------------------------------------------------------------
1800: l_proc varchar2(200) := g_package || 'start_transaction';
1801: l_transaction_privilege hr_api_transactions.transaction_privilege%type;
1802: l_transaction_id hr_api_transactions.transaction_id%type;
1803: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
1804:
1805: -- l_person_id hr_api_transactions.creator_person_id%type := p_selected_person_id;
1806:

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

1801: l_transaction_privilege hr_api_transactions.transaction_privilege%type;
1802: l_transaction_id hr_api_transactions.transaction_id%type;
1803: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
1804:
1805: -- l_person_id hr_api_transactions.creator_person_id%type := p_selected_person_id;
1806:
1807: Cursor c_get_transaction_step_id
1808: is
1809: select

Line 2411: ln_transaction_id hr_api_transactions.transaction_id%TYPE;

2407: IS
2408:
2409: l_proc varchar2(200) := g_package || 'get_transaction_step_details';
2410:
2411: ln_transaction_id hr_api_transactions.transaction_id%TYPE;
2412: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;
2413: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;
2414: ln_trans_step_rows NUMBER ;
2415: lv_activity_name VARCHAR2(100);

Line 2487: ln_transaction_id hr_api_transactions.transaction_id%TYPE;

2483: IS
2484:
2485:
2486: l_proc varchar2(200) := g_package || 'is_transaction_exists';
2487: ln_transaction_id hr_api_transactions.transaction_id%TYPE;
2488: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;
2489: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;
2490: ln_trans_step_rows NUMBER ;
2491: lv_activity_name VARCHAR2(100);

Line 4411: ln_transaction_id hr_api_transactions.transaction_id%TYPE;

4407: p_ltt_component IN OUT NOCOPY sshr_sal_comp_tab_typ ) IS
4408:
4409: l_proc varchar2(200) := g_package || 'get_transaction_details';
4410: ln_transaction_step_id NUMBER;
4411: ln_transaction_id hr_api_transactions.transaction_id%TYPE;
4412: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;
4413: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;
4414: ln_trans_step_rows NUMBER ;
4415: lv_activity_name wf_item_activity_statuses_v.activity_name%type ;

Line 5129: ln_transaction_id hr_api_transactions.transaction_id%TYPE;

5125: p_ltt_component IN OUT NOCOPY sshr_sal_comp_tab_typ ) IS
5126:
5127: l_proc varchar2(200) := g_package || 'get_txn_details_for_review';
5128: ln_transaction_step_id NUMBER;
5129: ln_transaction_id hr_api_transactions.transaction_id%TYPE;
5130: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;
5131: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;
5132: ln_trans_step_rows NUMBER ;
5133: lv_activity_name wf_item_activity_statuses_v.activity_name%type ;