DBA Data[Home] [Help]

APPS.HR_PROCESS_CONTACT_SS dependencies on HR_PROCESS_CONTACT_SS

Line 1: PACKAGE BODY HR_PROCESS_CONTACT_SS AS

1: PACKAGE BODY HR_PROCESS_CONTACT_SS AS
2: /* $Header: hrconwrs.pkb 120.5.12000000.4 2007/05/17 09:08:25 rachakra ship $*/
3: --
4: -- Package scope global variables.
5: --

Line 6: g_package varchar2(30) := 'HR_PROCESS_CONTACT_SS';

2: /* $Header: hrconwrs.pkb 120.5.12000000.4 2007/05/17 09:08:25 rachakra ship $*/
3: --
4: -- Package scope global variables.
5: --
6: g_package varchar2(30) := 'HR_PROCESS_CONTACT_SS';
7: g_data_error exception;
8: g_no_changes exception;
9: -- g_date_format constant varchar2(10):='RRRR/MM/DD';
10:

Line 1788: l_basic_details_changed := hr_process_contact_ss.is_rec_changed(

1784: --
1785: -- Bug 3469145 : Not passing p_primary_contact_flag value as it contains data respective to
1786: -- the Emergency relationship and here all the data belong to the other relationship.
1787:
1788: l_basic_details_changed := hr_process_contact_ss.is_rec_changed(
1789: p_effective_date => p_cont_effective_date
1790: ,p_contact_relationship_id => l_contact_relationship_id
1791: ,p_contact_type => p_contact_type
1792: ,p_comments => p_ctr_comments

Line 3868: hr_utility.set_location('Leaving hr_process_contact_ss.update_contact_relationship', 80);

3864: ,p_transaction_step_id => l_transaction_step_id
3865: ,p_api_name => g_package || '.PROCESS_API'
3866: ,p_transaction_data => l_transaction_table);
3867: --
3868: hr_utility.set_location('Leaving hr_process_contact_ss.update_contact_relationship', 80);
3869:
3870: END IF;
3871: --
3872: -- 9999 set out variables here. Do we need to set anyway.

Line 6730: and hats.api_name = 'HR_PROCESS_CONTACT_SS.PROCESS_CREATE_CONTACT_API'

6726: from hr_api_transaction_steps hats,
6727: hr_api_transaction_values hatv
6728: where hats.item_type = p_item_type
6729: and hats.item_key = p_item_key
6730: and hats.api_name = 'HR_PROCESS_CONTACT_SS.PROCESS_CREATE_CONTACT_API'
6731: and hats.transaction_step_id = hatv.transaction_step_id
6732: and hatv.varchar2_value = 'Y'
6733: and hatv.name = upper('p_primary_contact_flag');
6734:

Line 6736: 'HR_PROCESS_CONTACT_SS.create_contact_tt : Check if primary contact already added in previous step : '||l_primary_contact_added, 2146328);

6732: and hatv.varchar2_value = 'Y'
6733: and hatv.name = upper('p_primary_contact_flag');
6734:
6735: hr_utility.set_location(
6736: 'HR_PROCESS_CONTACT_SS.create_contact_tt : Check if primary contact already added in previous step : '||l_primary_contact_added, 2146328);
6737:
6738: EXCEPTION
6739: WHEN others THEN
6740: null;

Line 11611: -- hr_utility.set_location('Entering hr_process_contact_ss.process_api', 100);

11607: --- bug 5894873
11608:
11609: BEGIN
11610: --
11611: -- hr_utility.set_location('Entering hr_process_contact_ss.process_api', 100);
11612: hr_utility.set_location('Entering:'||l_proc, 5);
11613: --
11614: SAVEPOINT update_cont_relationship;
11615:

Line 11633: hr_utility.set_location('Leaving hr_process_contact_ss.process_api', 100);

11629: -- SFL changes
11630: ,p_effective_date => p_effective_date
11631: );
11632: --
11633: hr_utility.set_location('Leaving hr_process_contact_ss.process_api', 100);
11634: return;
11635: --
11636: -- end if;
11637: else -- l_process_section is not 'DELETE_CONTACTS'

Line 14700: hr_utility.set_location('Rollback hr_process_contact_ss.process_api', 100);

14696: END IF;
14697:
14698: --
14699: IF p_validate THEN
14700: hr_utility.set_location('Rollback hr_process_contact_ss.process_api', 100);
14701: ROLLBACK TO update_cont_relationship;
14702: END IF;
14703: --
14704: -- bug# 2080032

Line 14707: hr_utility.set_location('Leaving hr_process_contact_ss.process_api', 100);

14703: --
14704: -- bug# 2080032
14705: end if; -- l_process_section = 'DELETE_CONTACTS'
14706:
14707: hr_utility.set_location('Leaving hr_process_contact_ss.process_api', 100);
14708: --
14709: EXCEPTION
14710: WHEN hr_utility.hr_error THEN
14711: hr_utility.set_location('Exception: WHEN hr_utility.hr_error THEN'||l_proc,555);

Line 14775: hr_process_contact_ss.g_is_address_updated := true;

14771: if (l_cov_date_start < l_cont_start_date) then
14772: open csr_address(p_contact_person_id,l_cont_start_date);
14773: fetch csr_address into l_dummy;
14774: if csr_address%found then
14775: hr_process_contact_ss.g_is_address_updated := true;
14776: end if;
14777: close csr_address;
14778: end if;
14779: end if;

Line 16900: END HR_PROCESS_CONTACT_SS;

16896: end validate_primary_cont_flag;
16897:
16898: --
16899:
16900: END HR_PROCESS_CONTACT_SS;