DBA Data[Home] [Help]

APPS.HXC_APP_PERIOD_SUMMARY_PKG dependencies on HXC_APP_PERIOD_SUMMARY

Line 1: package hxc_app_period_summary_pkg AUTHID CURRENT_USER as

1: package hxc_app_period_summary_pkg AUTHID CURRENT_USER as
2: /* $Header: hxcapsum.pkh 120.0 2005/05/29 04:54:59 appldev 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 hxc_app_period_summary_pkg AUTHID CURRENT_USER as
2: /* $Header: hxcapsum.pkh 120.0 2005/05/29 04:54:59 appldev 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.pkh 120.0 2005/05/29 04:54:59 appldev 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: );

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: );
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: );
24:
25: procedure insert_summary_row

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: );
24:
25: procedure insert_summary_row
26: (p_app_period_id in hxc_time_building_blocks.time_building_block_id%type

Line 27: ,p_approval_item_type in hxc_app_period_summary.approval_item_type%type

23: );
24:
25: procedure insert_summary_row
26: (p_app_period_id in hxc_time_building_blocks.time_building_block_id%type
27: ,p_approval_item_type in hxc_app_period_summary.approval_item_type%type
28: ,p_approval_process_name in hxc_app_period_summary.approval_process_name%type
29: ,p_approval_item_key in hxc_app_period_summary.approval_item_key%type);
30:
31: procedure update_summary_row(p_app_period_id in hxc_time_building_blocks.time_building_block_id%type

Line 28: ,p_approval_process_name in hxc_app_period_summary.approval_process_name%type

24:
25: procedure insert_summary_row
26: (p_app_period_id in hxc_time_building_blocks.time_building_block_id%type
27: ,p_approval_item_type in hxc_app_period_summary.approval_item_type%type
28: ,p_approval_process_name in hxc_app_period_summary.approval_process_name%type
29: ,p_approval_item_key in hxc_app_period_summary.approval_item_key%type);
30:
31: procedure update_summary_row(p_app_period_id in hxc_time_building_blocks.time_building_block_id%type
32: ,p_approval_item_type in hxc_app_period_summary.approval_item_type%type

Line 29: ,p_approval_item_key in hxc_app_period_summary.approval_item_key%type);

25: procedure insert_summary_row
26: (p_app_period_id in hxc_time_building_blocks.time_building_block_id%type
27: ,p_approval_item_type in hxc_app_period_summary.approval_item_type%type
28: ,p_approval_process_name in hxc_app_period_summary.approval_process_name%type
29: ,p_approval_item_key in hxc_app_period_summary.approval_item_key%type);
30:
31: procedure update_summary_row(p_app_period_id in hxc_time_building_blocks.time_building_block_id%type
32: ,p_approval_item_type in hxc_app_period_summary.approval_item_type%type
33: ,p_approval_process_name in hxc_app_period_summary.approval_process_name%type

Line 32: ,p_approval_item_type in hxc_app_period_summary.approval_item_type%type

28: ,p_approval_process_name in hxc_app_period_summary.approval_process_name%type
29: ,p_approval_item_key in hxc_app_period_summary.approval_item_key%type);
30:
31: procedure update_summary_row(p_app_period_id in hxc_time_building_blocks.time_building_block_id%type
32: ,p_approval_item_type in hxc_app_period_summary.approval_item_type%type
33: ,p_approval_process_name in hxc_app_period_summary.approval_process_name%type
34: ,p_approval_item_key in hxc_app_period_summary.approval_item_key%type
35: ) ;
36:

Line 33: ,p_approval_process_name in hxc_app_period_summary.approval_process_name%type

29: ,p_approval_item_key in hxc_app_period_summary.approval_item_key%type);
30:
31: procedure update_summary_row(p_app_period_id in hxc_time_building_blocks.time_building_block_id%type
32: ,p_approval_item_type in hxc_app_period_summary.approval_item_type%type
33: ,p_approval_process_name in hxc_app_period_summary.approval_process_name%type
34: ,p_approval_item_key in hxc_app_period_summary.approval_item_key%type
35: ) ;
36:
37:

Line 34: ,p_approval_item_key in hxc_app_period_summary.approval_item_key%type

30:
31: procedure update_summary_row(p_app_period_id in hxc_time_building_blocks.time_building_block_id%type
32: ,p_approval_item_type in hxc_app_period_summary.approval_item_type%type
33: ,p_approval_process_name in hxc_app_period_summary.approval_process_name%type
34: ,p_approval_item_key in hxc_app_period_summary.approval_item_key%type
35: ) ;
36:
37:
38: procedure delete_summary_row(p_app_period_id in hxc_time_building_blocks.time_building_block_id%type);

Line 40: end hxc_app_period_summary_pkg;

36:
37:
38: procedure delete_summary_row(p_app_period_id in hxc_time_building_blocks.time_building_block_id%type);
39:
40: end hxc_app_period_summary_pkg;