APPS.HR_TIS_BUS dependencies on HR_KI_INTEGRATIONS

Line 73: -- This procedure ensures integration_id is present in hr_ki_integrations

69: -- ----------------------------------------------------------------------------
70: -- {Start Of Comments}
71: --
72: -- Description:
73: -- This procedure ensures integration_id is present in hr_ki_integrations
74: -- and it is mandatory.
75: -- Pre Conditions:
76: -- g_old_rec has been populated with details of the values currently in
77: -- the database.

Line 96: l_key hr_ki_integrations.integration_id%type;

92: (p_integration_id in number
93: ) IS
94: --
95: l_proc varchar2(72) := g_package || 'chk_integration_id';
96: l_key hr_ki_integrations.integration_id%type;
97: cursor csr_int is
98: select INTEGRATION_ID
99: from hr_ki_integrations
100: where integration_id = p_integration_id;

Line 99: from hr_ki_integrations

95: l_proc varchar2(72) := g_package || 'chk_integration_id';
96: l_key hr_ki_integrations.integration_id%type;
97: cursor csr_int is
98: select INTEGRATION_ID
99: from hr_ki_integrations
100: where integration_id = p_integration_id;
101:
102:
103: --