[Home] [Help]
128: AND hao.organization_id = cost_center.organization_id
129: AND trunc(sysdate) between hao.date_from and nvl(hao.date_to,trunc(sysdate))
130: AND trunc(sysdate) between pap.effective_start_date and pap.effective_end_date
131: /* Excluding pending approvals */
132: AND not exists (select 'e' from hr_api_transaction_steps s, hr_api_transactions t
133: where s.api_name = 'HR_CCMGR_SS.PROCESS_API'
134: --Bug 3034218: Exclude current process, include v5 pending status RO, ROS and YS
135: and s.transaction_id = t.transaction_id and status IN ('YS', 'Y','RO','ROS')
136: and t.item_key <> itemKey
136: and t.item_key <> itemKey
137: --BUG 3648732
138: and exists
139: (
140: SELECT NULL FROM hr_api_transaction_values v
141: WHERE s.transaction_step_id+0 = v.transaction_step_id
142: AND v.name = 'P_ORGANIZATION_ID'
143: AND v.number_value = hao.organization_id
144: )
355: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;
356: lv_activity_name wf_item_activity_statuses_v.activity_name%TYPE;
357: ln_trans_step_rows number default 0;
358: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;
359: ln_ovn hr_api_transaction_steps.object_version_number%TYPE;
360: ln_term_flag BOOLEAN DEFAULT FALSE;
361: l_proc constant varchar2(1000) := g_package || ' Create_transaction';
362: BEGIN
363: hr_utility.set_location('Entering'|| l_proc,5);
558: */
559:
560: -- Assignment Security
561: IF(l_assignment_security_profile <> 'TRUE') then
562: l_supervisor_assignment_id := hr_api.g_number;
563: ELSE
564: l_supervisor_assignment_id
565: := p_supervisor_assignment_id;
566: END IF;
881:
882: IS
883:
884: ln_transaction_step_id NUMBER;
885: ln_transaction_id hr_api_transactions.transaction_id%TYPE;
886: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;
887: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;
888: ln_trans_step_rows NUMBER ;
889: lv_activity_name wf_item_activity_statuses_v.activity_name%type ;
1151: */
1152:
1153: PROCEDURE process_api (
1154: p_transaction_step_id IN
1155: hr_api_transaction_steps.transaction_step_id%type,
1156: p_validate BOOLEAN default FALSE,
1157: p_effective_date IN varchar2 default null) IS
1158:
1159: lv_item_type VARCHAR2(100);
1612: hr_utility.trace('IN (if p_save_for_later = SAVE)'|| l_proc);
1613: FOR I IN 1 ..p_manager_details_tab.count LOOP
1614: -- Assignment Security
1615: IF(l_assignment_security_profile <> 'TRUE') then
1616: l_supervisor_assignment_id := hr_api.g_number;
1617: ELSE
1618: l_supervisor_assignment_id
1619: := p_manager_details_tab(I).supervisor_assignment_id;
1620: END IF;