DBA Data[Home] [Help]

APPS.HR_SUPERVISOR_SS dependencies on HR_API_TRANSACTION_STEPS

Line 127: AND not exists (select 'e' from hr_api_transaction_steps s, hr_api_transactions t

123: AND hao.organization_id = cost_center.organization_id
124: AND trunc(sysdate) between hao.date_from and nvl(hao.date_to,trunc(sysdate))
125: AND trunc(sysdate) between pap.effective_start_date and pap.effective_end_date
126: /* Excluding pending approvals */
127: AND not exists (select 'e' from hr_api_transaction_steps s, hr_api_transactions t
128: where s.api_name = 'HR_CCMGR_SS.PROCESS_API'
129: --Bug 3034218: Exclude current process, include v5 pending status RO, ROS and YS
130: and s.transaction_id = t.transaction_id and status IN ('YS', 'Y','RO','ROS')
131: and t.item_key <> itemKey

Line 314: ln_ovn hr_api_transaction_steps.object_version_number%TYPE;

310: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;
311: lv_activity_name wf_item_activity_statuses_v.activity_name%TYPE;
312: ln_trans_step_rows number default 0;
313: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;
314: ln_ovn hr_api_transaction_steps.object_version_number%TYPE;
315: ln_term_flag BOOLEAN DEFAULT FALSE;
316: l_proc constant varchar2(1000) := g_package || ' Create_transaction';
317: BEGIN
318: hr_utility.set_location('Entering'|| l_proc,5);

Line 1110: hr_api_transaction_steps.transaction_step_id%type,

1106: */
1107:
1108: PROCEDURE process_api (
1109: p_transaction_step_id IN
1110: hr_api_transaction_steps.transaction_step_id%type,
1111: p_validate BOOLEAN default FALSE,
1112: p_effective_date IN varchar2 default null) IS
1113:
1114: lv_item_type VARCHAR2(100);