DBA Data[Home] [Help]

APPS.HR_PAY_RATE_SS dependencies on HR_API_TRANSACTION_STEPS

Line 21: l_trans_step_id hr_api_transaction_steps.transaction_step_id%type;

17: l_praddr_ovrlap VARCHAR2(2);
18: -- ln_no_of_components INTEGER := 0;
19:
20: -- p_login_person_id per_all_people_f.person_id%TYPE;
21: l_trans_step_id hr_api_transaction_steps.transaction_step_id%type;
22: ltt_trans_obj_vers_num hr_api_transaction_steps.object_version_number%type;
23: p_trans_rec_count INTEGER;
24: g_data_error exception;
25: g_exceeded_grade_range exception;

Line 22: ltt_trans_obj_vers_num hr_api_transaction_steps.object_version_number%type;

18: -- ln_no_of_components INTEGER := 0;
19:
20: -- p_login_person_id per_all_people_f.person_id%TYPE;
21: l_trans_step_id hr_api_transaction_steps.transaction_step_id%type;
22: ltt_trans_obj_vers_num hr_api_transaction_steps.object_version_number%type;
23: p_trans_rec_count INTEGER;
24: g_data_error exception;
25: g_exceeded_grade_range exception;
26: g_asg_api_name constant varchar2(80)

Line 102: l_asg_txn_step_id hr_api_transaction_steps.transaction_step_id%type

98: l_new_pay_basis_id per_all_assignments_f.pay_basis_id%type default null;
99: l_pay_period_start_date date default null;
100: l_pay_period_end_date date default null;
101:
102: l_asg_txn_step_id hr_api_transaction_steps.transaction_step_id%type
103: default null;
104: l_effective_date date default null;
105:
106:

Line 123: from hr_api_transaction_steps trs

119: ,trs.item_type
120: ,trs.item_key
121: ,trs.activity_id
122: ,trs.creator_person_id
123: from hr_api_transaction_steps trs
124: where trs.item_type = p_item_type
125: and trs.item_key = p_item_key
126: order by trs.processing_order
127: ,trs.transaction_step_id ; --#2313279

Line 636: (p_transaction_step_id IN hr_api_transaction_steps.transaction_step_id%type

632: | parameter value from the hr_api_transaction_values table
633: |================================================================
634: */
635: PROCEDURE check_gsp_txn
636: (p_transaction_step_id IN hr_api_transaction_steps.transaction_step_id%type
637: ,p_effective_date in varchar2
638: ,p_gsp_assignment out nocopy varchar2
639: )
640: IS

Line 1803: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;

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:
1807: Cursor c_get_transaction_step_id

Line 1812: hr_api_transaction_steps

1808: is
1809: select
1810: transaction_step_id
1811: from
1812: hr_api_transaction_steps
1813: where
1814: transaction_id = l_transaction_id;
1815:
1816: Begin

Line 2949: lv_api_name hr_api_transaction_steps.api_name%type ;

2945: l_proc varchar2(200) := g_package || 'maintain_txn_java';
2946: ln_transaction_id NUMBER ;
2947: lv_result VARCHAR2(100);
2948: li_count INTEGER ;
2949: lv_api_name hr_api_transaction_steps.api_name%type ;
2950: ln_ovn hr_api_transaction_steps.object_version_number%TYPE;
2951: ln_transaction_step_id hr_api_transaction_steps.transaction_step_id%TYPE default null;
2952: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;
2953: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;

Line 2950: ln_ovn hr_api_transaction_steps.object_version_number%TYPE;

2946: ln_transaction_id NUMBER ;
2947: lv_result VARCHAR2(100);
2948: li_count INTEGER ;
2949: lv_api_name hr_api_transaction_steps.api_name%type ;
2950: ln_ovn hr_api_transaction_steps.object_version_number%TYPE;
2951: ln_transaction_step_id hr_api_transaction_steps.transaction_step_id%TYPE default null;
2952: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;
2953: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;
2954: ln_trans_step_rows number default 0;

Line 2951: ln_transaction_step_id hr_api_transaction_steps.transaction_step_id%TYPE default null;

2947: lv_result VARCHAR2(100);
2948: li_count INTEGER ;
2949: lv_api_name hr_api_transaction_steps.api_name%type ;
2950: ln_ovn hr_api_transaction_steps.object_version_number%TYPE;
2951: ln_transaction_step_id hr_api_transaction_steps.transaction_step_id%TYPE default null;
2952: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;
2953: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;
2954: ln_trans_step_rows number default 0;
2955: lv_activity_name wf_item_activity_statuses_v.activity_name%TYPE;

Line 2968: FROM hr_api_transaction_steps

2964: c_item_type in wf_items.item_type%type
2965: ,c_item_key in wf_items.item_key%type
2966: ) IS
2967: SELECT transaction_step_id
2968: FROM hr_api_transaction_steps
2969: WHERE item_type = c_item_type
2970: AND item_key = c_item_key
2971: --AND api_name = 'HR_PAY_RATE_SS.process_api_java';
2972: AND api_name = 'HR_PAY_RATE_SS.PROCESS_API';

Line 5846: p_transaction_step_id IN hr_api_transaction_steps.transaction_step_id%type,

5842: END get_txn_details_for_review;
5843: --End of GSP changes
5844:
5845: PROCEDURE PROCESS_API (
5846: p_transaction_step_id IN hr_api_transaction_steps.transaction_step_id%type,
5847: p_effective_date in varchar2,
5848: p_validate IN boolean
5849: ) IS
5850:

Line 6308: from hr_api_transaction_steps

6304: l_proc varchar2(200) := g_package || 'delete_transaction_step';
6305: l_transaction_step_id number;
6306: cursor c1(p_transaction_id number) is
6307: select transaction_step_id
6308: from hr_api_transaction_steps
6309: where transaction_id = p_transaction_id
6310: and api_name = 'HR_PAY_RATE_SS.PROCESS_API';
6311: BEGIN
6312: hr_utility.set_location(' Entering:' || l_proc,5);