eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 1903: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;

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

Line 1912: hr_api_transaction_steps

1908: is
1909: select
1910: transaction_step_id
1911: from
1912: hr_api_transaction_steps
1913: where
1914: transaction_id = l_transaction_id;
1915:
1916: Begin

Line 3106: lv_api_name hr_api_transaction_steps.api_name%type ;

3102: l_proc varchar2(200) := g_package || 'maintain_txn_java';
3103: ln_transaction_id NUMBER ;
3104: lv_result VARCHAR2(100);
3105: li_count INTEGER ;
3106: lv_api_name hr_api_transaction_steps.api_name%type ;
3107: ln_ovn hr_api_transaction_steps.object_version_number%TYPE;
3108: ln_transaction_step_id hr_api_transaction_steps.transaction_step_id%TYPE default null;
3109: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;
3110: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;

Line 3107: ln_ovn hr_api_transaction_steps.object_version_number%TYPE;

3103: ln_transaction_id NUMBER ;
3104: lv_result VARCHAR2(100);
3105: li_count INTEGER ;
3106: lv_api_name hr_api_transaction_steps.api_name%type ;
3107: ln_ovn hr_api_transaction_steps.object_version_number%TYPE;
3108: ln_transaction_step_id hr_api_transaction_steps.transaction_step_id%TYPE default null;
3109: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;
3110: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;
3111: ln_trans_step_rows number default 0;

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

3104: lv_result VARCHAR2(100);
3105: li_count INTEGER ;
3106: lv_api_name hr_api_transaction_steps.api_name%type ;
3107: ln_ovn hr_api_transaction_steps.object_version_number%TYPE;
3108: ln_transaction_step_id hr_api_transaction_steps.transaction_step_id%TYPE default null;
3109: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;
3110: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;
3111: ln_trans_step_rows number default 0;
3112: lv_activity_name wf_item_activity_statuses_v.activity_name%TYPE;

Line 3125: FROM hr_api_transaction_steps

3121: c_item_type in wf_items.item_type%type
3122: ,c_item_key in wf_items.item_key%type
3123: ) IS
3124: SELECT transaction_step_id
3125: FROM hr_api_transaction_steps
3126: WHERE item_type = c_item_type
3127: AND item_key = c_item_key
3128: --AND api_name = 'HR_PAY_RATE_SS.process_api_java';
3129: AND api_name = 'HR_PAY_RATE_SS.PROCESS_API';

Line 6023: p_transaction_step_id IN hr_api_transaction_steps.transaction_step_id%type,

6019: END get_txn_details_for_review;
6020: --End of GSP changes
6021:
6022: PROCEDURE PROCESS_API (
6023: p_transaction_step_id IN hr_api_transaction_steps.transaction_step_id%type,
6024: p_effective_date in varchar2,
6025: p_validate IN boolean
6026: ) IS
6027:

Line 6610: from hr_api_transaction_steps

6606: l_proc varchar2(200) := g_package || 'delete_transaction_step';
6607: l_transaction_step_id number;
6608: cursor c1(p_transaction_id number) is
6609: select transaction_step_id
6610: from hr_api_transaction_steps
6611: where transaction_id = p_transaction_id
6612: and api_name = 'HR_PAY_RATE_SS.PROCESS_API';
6613: BEGIN
6614: hr_utility.set_location(' Entering:' || l_proc,5);