APPS.HR_PROCESS_CONTACT_SS dependencies on HR_API_TRANSACTION_VALUES

Line 166: l_name hr_api_transaction_values.name%type;

162: -- declare local variables
163: -- --------------------------------------------------------------------------
164: l_proc varchar2(72) := g_package||'get_varchar2_value';
165: l_insert boolean := false;
166: l_name hr_api_transaction_values.name%type;
167: l_varchar2_value varchar2(1000);
168: --
169: cursor csr_hatv is
170: select hatv.varchar2_value

Line 171: from hr_api_transaction_values hatv

167: l_varchar2_value varchar2(1000);
168: --
169: cursor csr_hatv is
170: select hatv.varchar2_value
171: from hr_api_transaction_values hatv
172: where hatv.transaction_step_id = p_transaction_step_id
173: and hatv.name = l_name;
174: --
175: begin

Line 210: l_name hr_api_transaction_values.name%type;

206: -- declare local variables
207: -- --------------------------------------------------------------------------
208: l_proc varchar2(72) := g_package||'get_number_value';
209: l_insert boolean := false;
210: l_name hr_api_transaction_values.name%type;
211: l_number_value number;
212: --
213: cursor csr_hatv is
214: select hatv.number_value

Line 215: from hr_api_transaction_values hatv

211: l_number_value number;
212: --
213: cursor csr_hatv is
214: select hatv.number_value
215: from hr_api_transaction_values hatv
216: where hatv.transaction_step_id = p_transaction_step_id
217: and hatv.name = l_name;
218: --
219: begin

Line 6796: hr_api_transaction_values hatv

6792: BEGIN
6793: select count(hats.transaction_step_id)
6794: into l_primary_contact_added
6795: from hr_api_transaction_steps hats,
6796: hr_api_transaction_values hatv
6797: where hats.item_type = p_item_type
6798: and hats.item_key = p_item_key
6799: and hats.api_name = 'HR_PROCESS_CONTACT_SS.PROCESS_CREATE_CONTACT_API'
6800: and hats.transaction_step_id = hatv.transaction_step_id