eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXC_APP_PERIOD_SUMMARY_PKG dependencies on HXC_APP_PERIOD_SUMMARY

Line 1: package body hxc_app_period_summary_pkg as

1: package body hxc_app_period_summary_pkg as
2: /* $Header: hxcapsum.pkb 120.1 2005/06/30 12:11:17 jdupont noship $ */
3:
4: procedure insert_summary_row
5: (p_application_period_id in hxc_app_period_summary.application_period_id%type

Line 5: (p_application_period_id in hxc_app_period_summary.application_period_id%type

1: package body hxc_app_period_summary_pkg as
2: /* $Header: hxcapsum.pkb 120.1 2005/06/30 12:11:17 jdupont noship $ */
3:
4: procedure insert_summary_row
5: (p_application_period_id in hxc_app_period_summary.application_period_id%type
6: ,p_application_period_ovn in hxc_app_period_summary.application_period_ovn%type
7: ,p_approval_status in hxc_app_period_summary.approval_status%type
8: ,p_time_recipient_id in hxc_app_period_summary.time_recipient_id%type
9: ,p_time_category_id in hxc_app_period_summary.time_category_id%type

Line 6: ,p_application_period_ovn in hxc_app_period_summary.application_period_ovn%type

2: /* $Header: hxcapsum.pkb 120.1 2005/06/30 12:11:17 jdupont noship $ */
3:
4: procedure insert_summary_row
5: (p_application_period_id in hxc_app_period_summary.application_period_id%type
6: ,p_application_period_ovn in hxc_app_period_summary.application_period_ovn%type
7: ,p_approval_status in hxc_app_period_summary.approval_status%type
8: ,p_time_recipient_id in hxc_app_period_summary.time_recipient_id%type
9: ,p_time_category_id in hxc_app_period_summary.time_category_id%type
10: ,p_start_time in hxc_app_period_summary.start_time%type

Line 7: ,p_approval_status in hxc_app_period_summary.approval_status%type

3:
4: procedure insert_summary_row
5: (p_application_period_id in hxc_app_period_summary.application_period_id%type
6: ,p_application_period_ovn in hxc_app_period_summary.application_period_ovn%type
7: ,p_approval_status in hxc_app_period_summary.approval_status%type
8: ,p_time_recipient_id in hxc_app_period_summary.time_recipient_id%type
9: ,p_time_category_id in hxc_app_period_summary.time_category_id%type
10: ,p_start_time in hxc_app_period_summary.start_time%type
11: ,p_stop_time in hxc_app_period_summary.stop_time%type

Line 8: ,p_time_recipient_id in hxc_app_period_summary.time_recipient_id%type

4: procedure insert_summary_row
5: (p_application_period_id in hxc_app_period_summary.application_period_id%type
6: ,p_application_period_ovn in hxc_app_period_summary.application_period_ovn%type
7: ,p_approval_status in hxc_app_period_summary.approval_status%type
8: ,p_time_recipient_id in hxc_app_period_summary.time_recipient_id%type
9: ,p_time_category_id in hxc_app_period_summary.time_category_id%type
10: ,p_start_time in hxc_app_period_summary.start_time%type
11: ,p_stop_time in hxc_app_period_summary.stop_time%type
12: ,p_resource_id in hxc_app_period_summary.resource_id%type

Line 9: ,p_time_category_id in hxc_app_period_summary.time_category_id%type

5: (p_application_period_id in hxc_app_period_summary.application_period_id%type
6: ,p_application_period_ovn in hxc_app_period_summary.application_period_ovn%type
7: ,p_approval_status in hxc_app_period_summary.approval_status%type
8: ,p_time_recipient_id in hxc_app_period_summary.time_recipient_id%type
9: ,p_time_category_id in hxc_app_period_summary.time_category_id%type
10: ,p_start_time in hxc_app_period_summary.start_time%type
11: ,p_stop_time in hxc_app_period_summary.stop_time%type
12: ,p_resource_id in hxc_app_period_summary.resource_id%type
13: ,p_recipient_sequence in hxc_app_period_summary.recipient_sequence%type

Line 10: ,p_start_time in hxc_app_period_summary.start_time%type

6: ,p_application_period_ovn in hxc_app_period_summary.application_period_ovn%type
7: ,p_approval_status in hxc_app_period_summary.approval_status%type
8: ,p_time_recipient_id in hxc_app_period_summary.time_recipient_id%type
9: ,p_time_category_id in hxc_app_period_summary.time_category_id%type
10: ,p_start_time in hxc_app_period_summary.start_time%type
11: ,p_stop_time in hxc_app_period_summary.stop_time%type
12: ,p_resource_id in hxc_app_period_summary.resource_id%type
13: ,p_recipient_sequence in hxc_app_period_summary.recipient_sequence%type
14: ,p_category_sequence in hxc_app_period_summary.category_sequence%type

Line 11: ,p_stop_time in hxc_app_period_summary.stop_time%type

7: ,p_approval_status in hxc_app_period_summary.approval_status%type
8: ,p_time_recipient_id in hxc_app_period_summary.time_recipient_id%type
9: ,p_time_category_id in hxc_app_period_summary.time_category_id%type
10: ,p_start_time in hxc_app_period_summary.start_time%type
11: ,p_stop_time in hxc_app_period_summary.stop_time%type
12: ,p_resource_id in hxc_app_period_summary.resource_id%type
13: ,p_recipient_sequence in hxc_app_period_summary.recipient_sequence%type
14: ,p_category_sequence in hxc_app_period_summary.category_sequence%type
15: ,p_creation_date in hxc_app_period_summary.creation_date%type

Line 12: ,p_resource_id in hxc_app_period_summary.resource_id%type

8: ,p_time_recipient_id in hxc_app_period_summary.time_recipient_id%type
9: ,p_time_category_id in hxc_app_period_summary.time_category_id%type
10: ,p_start_time in hxc_app_period_summary.start_time%type
11: ,p_stop_time in hxc_app_period_summary.stop_time%type
12: ,p_resource_id in hxc_app_period_summary.resource_id%type
13: ,p_recipient_sequence in hxc_app_period_summary.recipient_sequence%type
14: ,p_category_sequence in hxc_app_period_summary.category_sequence%type
15: ,p_creation_date in hxc_app_period_summary.creation_date%type
16: ,p_notification_status in hxc_app_period_summary.notification_status%type

Line 13: ,p_recipient_sequence in hxc_app_period_summary.recipient_sequence%type

9: ,p_time_category_id in hxc_app_period_summary.time_category_id%type
10: ,p_start_time in hxc_app_period_summary.start_time%type
11: ,p_stop_time in hxc_app_period_summary.stop_time%type
12: ,p_resource_id in hxc_app_period_summary.resource_id%type
13: ,p_recipient_sequence in hxc_app_period_summary.recipient_sequence%type
14: ,p_category_sequence in hxc_app_period_summary.category_sequence%type
15: ,p_creation_date in hxc_app_period_summary.creation_date%type
16: ,p_notification_status in hxc_app_period_summary.notification_status%type
17: ,p_approver_id in hxc_app_period_summary.approver_id%type

Line 14: ,p_category_sequence in hxc_app_period_summary.category_sequence%type

10: ,p_start_time in hxc_app_period_summary.start_time%type
11: ,p_stop_time in hxc_app_period_summary.stop_time%type
12: ,p_resource_id in hxc_app_period_summary.resource_id%type
13: ,p_recipient_sequence in hxc_app_period_summary.recipient_sequence%type
14: ,p_category_sequence in hxc_app_period_summary.category_sequence%type
15: ,p_creation_date in hxc_app_period_summary.creation_date%type
16: ,p_notification_status in hxc_app_period_summary.notification_status%type
17: ,p_approver_id in hxc_app_period_summary.approver_id%type
18: ,p_approval_comp_id in hxc_app_period_summary.approval_comp_id%type

Line 15: ,p_creation_date in hxc_app_period_summary.creation_date%type

11: ,p_stop_time in hxc_app_period_summary.stop_time%type
12: ,p_resource_id in hxc_app_period_summary.resource_id%type
13: ,p_recipient_sequence in hxc_app_period_summary.recipient_sequence%type
14: ,p_category_sequence in hxc_app_period_summary.category_sequence%type
15: ,p_creation_date in hxc_app_period_summary.creation_date%type
16: ,p_notification_status in hxc_app_period_summary.notification_status%type
17: ,p_approver_id in hxc_app_period_summary.approver_id%type
18: ,p_approval_comp_id in hxc_app_period_summary.approval_comp_id%type
19: ,p_approval_item_type in hxc_app_period_summary.approval_item_type%type

Line 16: ,p_notification_status in hxc_app_period_summary.notification_status%type

12: ,p_resource_id in hxc_app_period_summary.resource_id%type
13: ,p_recipient_sequence in hxc_app_period_summary.recipient_sequence%type
14: ,p_category_sequence in hxc_app_period_summary.category_sequence%type
15: ,p_creation_date in hxc_app_period_summary.creation_date%type
16: ,p_notification_status in hxc_app_period_summary.notification_status%type
17: ,p_approver_id in hxc_app_period_summary.approver_id%type
18: ,p_approval_comp_id in hxc_app_period_summary.approval_comp_id%type
19: ,p_approval_item_type in hxc_app_period_summary.approval_item_type%type
20: ,p_approval_process_name in hxc_app_period_summary.approval_process_name%type

Line 17: ,p_approver_id in hxc_app_period_summary.approver_id%type

13: ,p_recipient_sequence in hxc_app_period_summary.recipient_sequence%type
14: ,p_category_sequence in hxc_app_period_summary.category_sequence%type
15: ,p_creation_date in hxc_app_period_summary.creation_date%type
16: ,p_notification_status in hxc_app_period_summary.notification_status%type
17: ,p_approver_id in hxc_app_period_summary.approver_id%type
18: ,p_approval_comp_id in hxc_app_period_summary.approval_comp_id%type
19: ,p_approval_item_type in hxc_app_period_summary.approval_item_type%type
20: ,p_approval_process_name in hxc_app_period_summary.approval_process_name%type
21: ,p_approval_item_key in hxc_app_period_summary.approval_item_key%type

Line 18: ,p_approval_comp_id in hxc_app_period_summary.approval_comp_id%type

14: ,p_category_sequence in hxc_app_period_summary.category_sequence%type
15: ,p_creation_date in hxc_app_period_summary.creation_date%type
16: ,p_notification_status in hxc_app_period_summary.notification_status%type
17: ,p_approver_id in hxc_app_period_summary.approver_id%type
18: ,p_approval_comp_id in hxc_app_period_summary.approval_comp_id%type
19: ,p_approval_item_type in hxc_app_period_summary.approval_item_type%type
20: ,p_approval_process_name in hxc_app_period_summary.approval_process_name%type
21: ,p_approval_item_key in hxc_app_period_summary.approval_item_key%type
22: ,p_data_set_id in hxc_app_period_summary.data_set_id%type

Line 19: ,p_approval_item_type in hxc_app_period_summary.approval_item_type%type

15: ,p_creation_date in hxc_app_period_summary.creation_date%type
16: ,p_notification_status in hxc_app_period_summary.notification_status%type
17: ,p_approver_id in hxc_app_period_summary.approver_id%type
18: ,p_approval_comp_id in hxc_app_period_summary.approval_comp_id%type
19: ,p_approval_item_type in hxc_app_period_summary.approval_item_type%type
20: ,p_approval_process_name in hxc_app_period_summary.approval_process_name%type
21: ,p_approval_item_key in hxc_app_period_summary.approval_item_key%type
22: ,p_data_set_id in hxc_app_period_summary.data_set_id%type
23: ) is

Line 20: ,p_approval_process_name in hxc_app_period_summary.approval_process_name%type

16: ,p_notification_status in hxc_app_period_summary.notification_status%type
17: ,p_approver_id in hxc_app_period_summary.approver_id%type
18: ,p_approval_comp_id in hxc_app_period_summary.approval_comp_id%type
19: ,p_approval_item_type in hxc_app_period_summary.approval_item_type%type
20: ,p_approval_process_name in hxc_app_period_summary.approval_process_name%type
21: ,p_approval_item_key in hxc_app_period_summary.approval_item_key%type
22: ,p_data_set_id in hxc_app_period_summary.data_set_id%type
23: ) is
24:

Line 21: ,p_approval_item_key in hxc_app_period_summary.approval_item_key%type

17: ,p_approver_id in hxc_app_period_summary.approver_id%type
18: ,p_approval_comp_id in hxc_app_period_summary.approval_comp_id%type
19: ,p_approval_item_type in hxc_app_period_summary.approval_item_type%type
20: ,p_approval_process_name in hxc_app_period_summary.approval_process_name%type
21: ,p_approval_item_key in hxc_app_period_summary.approval_item_key%type
22: ,p_data_set_id in hxc_app_period_summary.data_set_id%type
23: ) is
24:
25: Begin

Line 22: ,p_data_set_id in hxc_app_period_summary.data_set_id%type

18: ,p_approval_comp_id in hxc_app_period_summary.approval_comp_id%type
19: ,p_approval_item_type in hxc_app_period_summary.approval_item_type%type
20: ,p_approval_process_name in hxc_app_period_summary.approval_process_name%type
21: ,p_approval_item_key in hxc_app_period_summary.approval_item_key%type
22: ,p_data_set_id in hxc_app_period_summary.data_set_id%type
23: ) is
24:
25: Begin
26:

Line 27: insert into hxc_app_period_summary

23: ) is
24:
25: Begin
26:
27: insert into hxc_app_period_summary
28: (application_period_id
29: ,application_period_ovn
30: ,approval_status
31: ,time_recipient_id

Line 72: ,p_approval_item_type in hxc_app_period_summary.approval_item_type%type

68: End;
69:
70: procedure insert_summary_row
71: (p_app_period_id in hxc_time_building_blocks.time_building_block_id%type
72: ,p_approval_item_type in hxc_app_period_summary.approval_item_type%type
73: ,p_approval_process_name in hxc_app_period_summary.approval_process_name%type
74: ,p_approval_item_key in hxc_app_period_summary.approval_item_key%type
75: ) is
76:

Line 73: ,p_approval_process_name in hxc_app_period_summary.approval_process_name%type

69:
70: procedure insert_summary_row
71: (p_app_period_id in hxc_time_building_blocks.time_building_block_id%type
72: ,p_approval_item_type in hxc_app_period_summary.approval_item_type%type
73: ,p_approval_process_name in hxc_app_period_summary.approval_process_name%type
74: ,p_approval_item_key in hxc_app_period_summary.approval_item_key%type
75: ) is
76:
77: cursor c_app_period_info(p_id in hxc_time_building_blocks.time_building_block_id%type) is

Line 74: ,p_approval_item_key in hxc_app_period_summary.approval_item_key%type

70: procedure insert_summary_row
71: (p_app_period_id in hxc_time_building_blocks.time_building_block_id%type
72: ,p_approval_item_type in hxc_app_period_summary.approval_item_type%type
73: ,p_approval_process_name in hxc_app_period_summary.approval_process_name%type
74: ,p_approval_item_key in hxc_app_period_summary.approval_item_key%type
75: ) is
76:
77: cursor c_app_period_info(p_id in hxc_time_building_blocks.time_building_block_id%type) is
78: select tbb.time_building_block_id application_period_id

Line 115: insert into hxc_app_period_summary

111: open c_app_period_info(p_app_period_id);
112: fetch c_app_period_info into l_app_summary_row;
113:
114: if(c_app_period_info%found) then
115: insert into hxc_app_period_summary
116: (application_period_id
117: ,application_period_ovn
118: ,approval_status
119: ,time_recipient_id

Line 162: ,p_approval_item_type in hxc_app_period_summary.approval_item_type%type

158:
159: End insert_summary_row;
160:
161: procedure update_summary_row(p_app_period_id in hxc_time_building_blocks.time_building_block_id%type
162: ,p_approval_item_type in hxc_app_period_summary.approval_item_type%type
163: ,p_approval_process_name in hxc_app_period_summary.approval_process_name%type
164: ,p_approval_item_key in hxc_app_period_summary.approval_item_key%type
165: ) is
166:

Line 163: ,p_approval_process_name in hxc_app_period_summary.approval_process_name%type

159: End insert_summary_row;
160:
161: procedure update_summary_row(p_app_period_id in hxc_time_building_blocks.time_building_block_id%type
162: ,p_approval_item_type in hxc_app_period_summary.approval_item_type%type
163: ,p_approval_process_name in hxc_app_period_summary.approval_process_name%type
164: ,p_approval_item_key in hxc_app_period_summary.approval_item_key%type
165: ) is
166:
167: Begin

Line 164: ,p_approval_item_key in hxc_app_period_summary.approval_item_key%type

160:
161: procedure update_summary_row(p_app_period_id in hxc_time_building_blocks.time_building_block_id%type
162: ,p_approval_item_type in hxc_app_period_summary.approval_item_type%type
163: ,p_approval_process_name in hxc_app_period_summary.approval_process_name%type
164: ,p_approval_item_key in hxc_app_period_summary.approval_item_key%type
165: ) is
166:
167: Begin
168:

Line 177: delete from hxc_app_period_summary where application_period_id = p_app_period_id;

173: procedure delete_summary_row(p_app_period_id in hxc_time_building_blocks.time_building_block_id%type) is
174:
175: Begin
176:
177: delete from hxc_app_period_summary where application_period_id = p_app_period_id;
178:
179: Exception
180: When others then
181: FND_MESSAGE.set_name('HXC','HXC_NO_APP_PERIOD_ID');

Line 186: end hxc_app_period_summary_pkg;

182: FND_MESSAGE.raise_error;
183:
184: End delete_summary_row;
185:
186: end hxc_app_period_summary_pkg;