APPS.HR_LEG_INSTALLATION_PKG dependencies on HR_LEGISLATION_INSTALLATIONS

Line 36: INSERT INTO hr_legislation_installations

32: p_last_update_login varchar2,
33: p_last_update_date date,
34: p_last_updated_by varchar2) is
35: begin
36: INSERT INTO hr_legislation_installations
37: (application_short_name,
38: legislation_code,
39: status,
40: action,

Line 61: WHERE not exists (select 1 from hr_legislation_installations

57: p_last_update_login,
58: p_last_update_date,
59: p_last_updated_by
60: from dual
61: WHERE not exists (select 1 from hr_legislation_installations
62: where application_short_name=p_application_short_name
63: and nvl(p_legislation_code,'x')=nvl(legislation_code,'x'));
64: end;
65:

Line 77: UPDATE hr_legislation_installations

73: p_last_update_date date,
74: p_last_updated_by varchar2) is
75: begin
76:
77: UPDATE hr_legislation_installations
78: SET status=p_status,
79: action=p_action,
80: created_by=p_created_by,
81: creation_date=p_creation_date,

Line 100: from hr_legislation_installations

96: rows_processed integer;
97: begin
98: select view_name
99: into l_view_name
100: from hr_legislation_installations
101: where application_short_name=p_product
102: and nvl(p_legislation,'x')=nvl(legislation_code,'x');
103:
104:

Line 136: from hr_legislation_installations

132: begin
133:
134: select view_name
135: into l_view_name
136: from hr_legislation_installations
137: where application_short_name=p_product
138: and nvl(p_legislation,'x')=nvl(legislation_code,'x');
139:
140: statem := 'CREATE OR REPLACE FORCE VIEW ' || l_view_name ||'(product_implemented) AS SELECT ''product_implemented'' from dual';

Line 210: from hr_legislation_installations

206:
207: procedure set_existing_data is
208: cursor installed_data is
209: select application_short_name,legislation_code
210: from hr_legislation_installations
211: where status='I' ;
212: begin
213: for installed_leg in installed_data loop
214: create_view(installed_leg.application_short_name,installed_leg.legislation_code);