APPS.HXC_TC_AP_LINKS_PKG dependencies on HXC_TC_AP_LINKS

Line 1: package body hxc_tc_ap_links_pkg as

1: package body hxc_tc_ap_links_pkg as
2: /* $Header: hxctalsum.pkb 115.1 2004/06/08 17:50:51 arundell noship $ */
3:
4:
5: procedure insert_summary_row(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type

Line 10: insert into hxc_tc_ap_links

6: ,p_application_period_id in hxc_time_building_blocks.time_building_block_id%type) is
7:
8: begin
9:
10: insert into hxc_tc_ap_links
11: (timecard_id
12: ,application_period_id
13: )
14: values

Line 27: delete from hxc_tc_ap_links

23:
24:
25: begin
26:
27: delete from hxc_tc_ap_links
28: where timecard_id = p_timecard_id
29: and application_period_id = p_application_period_id;
30:
31: end delete_summary_row;

Line 38: delete from hxc_tc_ap_links where timecard_id = p_timecard_id;

34: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type) is
35:
36: begin
37:
38: delete from hxc_tc_ap_links where timecard_id = p_timecard_id;
39:
40: end remove_timecard_links;
41:
42: procedure create_timecard_links

Line 100: (p_application_period_id in hxc_tc_ap_links.application_period_id%type) is

96:
97: end create_timecard_links;
98:
99: procedure remove_app_period_links
100: (p_application_period_id in hxc_tc_ap_links.application_period_id%type) is
101:
102: Begin
103:
104: delete from hxc_tc_ap_links

Line 104: delete from hxc_tc_ap_links

100: (p_application_period_id in hxc_tc_ap_links.application_period_id%type) is
101:
102: Begin
103:
104: delete from hxc_tc_ap_links
105: where application_period_id = p_application_period_id;
106:
107: End remove_app_period_links;
108:

Line 111: (p_application_period_id in hxc_tc_ap_links.application_period_id%type) is

107: End remove_app_period_links;
108:
109:
110: procedure create_app_period_links
111: (p_application_period_id in hxc_tc_ap_links.application_period_id%type) is
112:
113: cursor c_app_period_info(p_id in hxc_time_building_blocks.time_building_block_id%type) is
114: select resource_id
115: ,start_time

Line 162: end hxc_tc_ap_links_pkg;

158: close c_app_period_info;
159:
160: end create_app_period_links;
161:
162: end hxc_tc_ap_links_pkg;