APPS.HR_ITL_BUS dependencies on HR_KI_INTEGRATIONS

Line 79: -- hr_ki_integrations table.

75: -- {Start Of Comments}
76: --
77: -- Description:
78: -- This procedure ensures that parent integration_id exists in
79: -- hr_ki_integrations table.
80: -- Pre Conditions:
81: -- g_old_rec has been populated with details of the values currently in
82: -- the database.
83: --

Line 88: -- Processing continues if integration_id exist in hr_ki_integrations table

84: -- In Arguments:
85: -- p_integration_id
86: --
87: -- Post Success:
88: -- Processing continues if integration_id exist in hr_ki_integrations table
89: --
90: -- Post Failure:
91: -- An application error is raised if id does not exist in hr_ki_integrations
92: --

Line 91: -- An application error is raised if id does not exist in hr_ki_integrations

87: -- Post Success:
88: -- Processing continues if integration_id exist in hr_ki_integrations table
89: --
90: -- Post Failure:
91: -- An application error is raised if id does not exist in hr_ki_integrations
92: --
93: -- {End Of Comments}
94: -- ----------------------------------------------------------------------------
95:

Line 104: -- Cursor to check if there is an entry in hr_ki_integrations

100: )
101: is
102: -- Declare cursors and local variables
103: --
104: -- Cursor to check if there is an entry in hr_ki_integrations
105: l_proc varchar2(72) := g_package || 'chk_integration_id';
106: l_name varchar2(1);
107:
108:

Line 113: hr_ki_integrations

109: CURSOR csr_id is
110: select
111: null
112: From
113: hr_ki_integrations
114: where
115: integration_id = p_integration_id;
116:
117: Begin

Line 137: (p_associated_column1 => 'HR_KI_INTEGRATIONS_TL.INTEGRATION_ID'

133:
134: Exception
135: when app_exception.application_exception then
136: IF hr_multi_message.exception_add
137: (p_associated_column1 => 'HR_KI_INTEGRATIONS_TL.INTEGRATION_ID'
138: ) THEN
139: hr_utility.set_location(' Leaving:'|| l_proc,30);
140: raise;
141: END IF;

Line 182: from hr_ki_integrations_tl

178: l_proc varchar2(72) := g_package || 'CHK_SERVICE_NAME';
179: l_name varchar2(1);
180: cursor csr_name is
181: select null
182: from hr_ki_integrations_tl
183: where
184: integration_id <> p_integration_id
185: and service_name = p_service_name
186: and partner_name=p_partner_name

Line 233: (p_associated_column1 => 'HR_KI_INTEGRATIONS_TL.SERVICE_NAME'

229: hr_utility.set_location(' Leaving:'||l_proc,50);
230: exception
231: when app_exception.application_exception then
232: if hr_multi_message.exception_add
233: (p_associated_column1 => 'HR_KI_INTEGRATIONS_TL.SERVICE_NAME'
234: )then
235: hr_utility.set_location(' Leaving:'||l_proc, 60);
236: raise;
237: end if;