APPS.HR_CCMGR_SS dependencies on HR_API

Line 53: and not exists (select 'e' from hr_api_transaction_steps s, hr_api_transactions t,

49: and class.org_information_context = 'CLASS'
50: and class.org_information2 = 'Y'
51: and class.organization_id = cm.organization_id)
52: /* Excluding pending approval */
53: and not exists (select 'e' from hr_api_transaction_steps s, hr_api_transactions t,
54: hr_api_transaction_values v
55: where s.api_name = 'HR_CCMGR_SS.PROCESS_API'
56: and s.transaction_id = t.transaction_id and status = 'Y'
57: and s.transaction_step_id = v.transaction_step_id

Line 54: hr_api_transaction_values v

50: and class.org_information2 = 'Y'
51: and class.organization_id = cm.organization_id)
52: /* Excluding pending approval */
53: and not exists (select 'e' from hr_api_transaction_steps s, hr_api_transactions t,
54: hr_api_transaction_values v
55: where s.api_name = 'HR_CCMGR_SS.PROCESS_API'
56: and s.transaction_id = t.transaction_id and status = 'Y'
57: and s.transaction_step_id = v.transaction_step_id
58: and v.name = 'P_ORGANIZATION_ID'

Line 176: Delete From hr_api_transaction_values tv

172: hr_utility.set_location(' Leaving:' || l_proc,10);
173: return;
174: End If;
175:
176: Delete From hr_api_transaction_values tv
177: Where tv.transaction_step_id in (Select ts.transaction_step_id
178: From hr_api_transaction_steps ts
179: Where ts.item_key = itemkey
180: And ts.item_type = itemtype

Line 178: From hr_api_transaction_steps ts

174: End If;
175:
176: Delete From hr_api_transaction_values tv
177: Where tv.transaction_step_id in (Select ts.transaction_step_id
178: From hr_api_transaction_steps ts
179: Where ts.item_key = itemkey
180: And ts.item_type = itemtype
181: And ts.activity_id = actid
182: And ts.api_name = 'HR_CCMGR_SS.PROCESS_API');

Line 184: Delete From hr_api_transaction_steps

180: And ts.item_type = itemtype
181: And ts.activity_id = actid
182: And ts.api_name = 'HR_CCMGR_SS.PROCESS_API');
183: hr_utility.set_location(l_proc,15);
184: Delete From hr_api_transaction_steps
185: Where item_key = itemkey
186: And item_type = itemtype
187: And activity_id = actid
188: And api_name = 'HR_CCMGR_SS.PROCESS_API';

Line 464: Delete From hr_api_transaction_values where transaction_step_id = p_ccmgr_tbl(I).trans_step_id;

460: -- Rolling back unchanged saved step if not Save for later mode.
461: hr_utility.set_location(l_proc ,45);
462: If (p_ccmgr_tbl(I).trans_step_id is not Null) Then
463: hr_utility.set_location(l_proc ,50);
464: Delete From hr_api_transaction_values where transaction_step_id = p_ccmgr_tbl(I).trans_step_id;
465: Delete From hr_api_transaction_steps where transaction_step_id = p_ccmgr_tbl(I).trans_step_id;
466: End If;
467: hr_utility.set_location(l_proc ,55);
468: goto exit_point;

Line 465: Delete From hr_api_transaction_steps where transaction_step_id = p_ccmgr_tbl(I).trans_step_id;

461: hr_utility.set_location(l_proc ,45);
462: If (p_ccmgr_tbl(I).trans_step_id is not Null) Then
463: hr_utility.set_location(l_proc ,50);
464: Delete From hr_api_transaction_values where transaction_step_id = p_ccmgr_tbl(I).trans_step_id;
465: Delete From hr_api_transaction_steps where transaction_step_id = p_ccmgr_tbl(I).trans_step_id;
466: End If;
467: hr_utility.set_location(l_proc ,55);
468: goto exit_point;
469: End If;