APPS.HR_CCMGR_SS dependencies on HR_CCMGR_SS

Line 1: PACKAGE BODY HR_CCMGR_SS AS

1: PACKAGE BODY HR_CCMGR_SS AS
2: /* $Header: hrccmwrs.pkb 120.1 2006/02/07 14:56:50 snachuri noship $ */
3:
4: -- Global Variables
5: l_trans_tbl hr_transaction_ss.transaction_table;

Line 6: g_package Varchar2(30):='HR_CCMGR_SS';

2: /* $Header: hrccmwrs.pkb 120.1 2006/02/07 14:56:50 snachuri noship $ */
3:
4: -- Global Variables
5: l_trans_tbl hr_transaction_ss.transaction_table;
6: g_package Varchar2(30):='HR_CCMGR_SS';
7: g_api_name Varchar2(30):='HR_CCMGR_SS.PROCESS_API';
8: g_date_format Varchar2(10):='RRRR-MM-DD';
9: g_data_error Exception;
10:

Line 7: g_api_name Varchar2(30):='HR_CCMGR_SS.PROCESS_API';

3:
4: -- Global Variables
5: l_trans_tbl hr_transaction_ss.transaction_table;
6: g_package Varchar2(30):='HR_CCMGR_SS';
7: g_api_name Varchar2(30):='HR_CCMGR_SS.PROCESS_API';
8: g_date_format Varchar2(10):='RRRR-MM-DD';
9: g_data_error Exception;
10:
11: -- Cursors

Line 55: where s.api_name = 'HR_CCMGR_SS.PROCESS_API'

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'
59: and v.number_value = hao.organization_id

Line 182: And ts.api_name = 'HR_CCMGR_SS.PROCESS_API');

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');
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

Line 188: And api_name = 'HR_CCMGR_SS.PROCESS_API';

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';
189: hr_utility.set_location(' Leaving:' || l_proc,20);
190: End delete_trans_steps;
191:
192:

Line 646: End HR_CCMGR_SS;

642: p_status := 'E';
643: hr_utility.set_location(' Leaving:' || l_proc,560);
644: raise;
645: End update_ccmgr_recs;
646: End HR_CCMGR_SS;