APPS.HR_H2PI_DOWNLOAD dependencies on HR_H2PI_DATA_FEED_HIST

Line 7: -- Description: Local procedure to insert record into hr_h2pi_data_feed_hist table

3:
4: g_package VARCHAR2(33) := ' hr_h2pi_download.';
5: --
6: -- --------------------------------------------------------------------------------
7: -- Description: Local procedure to insert record into hr_h2pi_data_feed_hist table
8: -- once download a xml file is created and download is completed.
9: -- This table keeps records of all the downloads.
10: --
11: -- --------------------------------------------------------------------------------

Line 27: insert into hr_h2pi_data_feed_hist

23: select name
24: into l_business_group_name
25: from hr_all_organization_units
26: where organization_id = p_bg_id;
27: insert into hr_h2pi_data_feed_hist
28: (start_date,
29: end_date,
30: sequence_number,
31: business_group_id,

Line 42: hr_h2pi_data_feed_hist_s.nextval,

38: program_update_date)
39: values
40: (p_start_date,
41: p_end_date,
42: hr_h2pi_data_feed_hist_s.nextval,
43: p_bg_id,
44: p_client_id,
45: l_business_group_name,
46: 1,