DBA Data[Home] [Help]

APPS.HXC_APP_PERIOD_SUMMARY_API dependencies on HXC_APP_PERIOD_SUMMARY

Line 1: package hxc_app_period_summary_api as

1: package hxc_app_period_summary_api as
2: /* $Header: hxcapsumapi.pkh 120.1.12010000.1 2008/07/28 11:04:43 appldev ship $ */
3:
4: TYPE valid_period_rec IS RECORD (
5: start_time hxc_time_building_blocks.start_time%TYPE

Line 12: (p_application_period_id in hxc_app_period_summary.application_period_id%type

8:
9: TYPE valid_period_tab IS TABLE OF valid_period_rec INDEX BY BINARY_INTEGER;
10:
11: procedure app_period_create
12: (p_application_period_id in hxc_app_period_summary.application_period_id%type
13: ,p_mode in varchar2 default hxc_timecard_summary_pkg.c_normal_mode);
14:
15:
16: procedure app_period_create

Line 17: (p_application_period_id in hxc_app_period_summary.application_period_id%type

13: ,p_mode in varchar2 default hxc_timecard_summary_pkg.c_normal_mode);
14:
15:
16: procedure app_period_create
17: (p_application_period_id in hxc_app_period_summary.application_period_id%type
18: ,p_application_period_ovn in hxc_app_period_summary.application_period_ovn%type
19: ,p_approval_status in hxc_app_period_summary.approval_status%type
20: ,p_time_recipient_id in hxc_app_period_summary.time_recipient_id%type
21: ,p_time_category_id in hxc_app_period_summary.time_category_id%type

Line 18: ,p_application_period_ovn in hxc_app_period_summary.application_period_ovn%type

14:
15:
16: procedure app_period_create
17: (p_application_period_id in hxc_app_period_summary.application_period_id%type
18: ,p_application_period_ovn in hxc_app_period_summary.application_period_ovn%type
19: ,p_approval_status in hxc_app_period_summary.approval_status%type
20: ,p_time_recipient_id in hxc_app_period_summary.time_recipient_id%type
21: ,p_time_category_id in hxc_app_period_summary.time_category_id%type
22: ,p_start_time in hxc_app_period_summary.start_time%type

Line 19: ,p_approval_status in hxc_app_period_summary.approval_status%type

15:
16: procedure app_period_create
17: (p_application_period_id in hxc_app_period_summary.application_period_id%type
18: ,p_application_period_ovn in hxc_app_period_summary.application_period_ovn%type
19: ,p_approval_status in hxc_app_period_summary.approval_status%type
20: ,p_time_recipient_id in hxc_app_period_summary.time_recipient_id%type
21: ,p_time_category_id in hxc_app_period_summary.time_category_id%type
22: ,p_start_time in hxc_app_period_summary.start_time%type
23: ,p_stop_time in hxc_app_period_summary.stop_time%type

Line 20: ,p_time_recipient_id in hxc_app_period_summary.time_recipient_id%type

16: procedure app_period_create
17: (p_application_period_id in hxc_app_period_summary.application_period_id%type
18: ,p_application_period_ovn in hxc_app_period_summary.application_period_ovn%type
19: ,p_approval_status in hxc_app_period_summary.approval_status%type
20: ,p_time_recipient_id in hxc_app_period_summary.time_recipient_id%type
21: ,p_time_category_id in hxc_app_period_summary.time_category_id%type
22: ,p_start_time in hxc_app_period_summary.start_time%type
23: ,p_stop_time in hxc_app_period_summary.stop_time%type
24: ,p_resource_id in hxc_app_period_summary.resource_id%type

Line 21: ,p_time_category_id in hxc_app_period_summary.time_category_id%type

17: (p_application_period_id in hxc_app_period_summary.application_period_id%type
18: ,p_application_period_ovn in hxc_app_period_summary.application_period_ovn%type
19: ,p_approval_status in hxc_app_period_summary.approval_status%type
20: ,p_time_recipient_id in hxc_app_period_summary.time_recipient_id%type
21: ,p_time_category_id in hxc_app_period_summary.time_category_id%type
22: ,p_start_time in hxc_app_period_summary.start_time%type
23: ,p_stop_time in hxc_app_period_summary.stop_time%type
24: ,p_resource_id in hxc_app_period_summary.resource_id%type
25: ,p_recipient_sequence in hxc_app_period_summary.recipient_sequence%type

Line 22: ,p_start_time in hxc_app_period_summary.start_time%type

18: ,p_application_period_ovn in hxc_app_period_summary.application_period_ovn%type
19: ,p_approval_status in hxc_app_period_summary.approval_status%type
20: ,p_time_recipient_id in hxc_app_period_summary.time_recipient_id%type
21: ,p_time_category_id in hxc_app_period_summary.time_category_id%type
22: ,p_start_time in hxc_app_period_summary.start_time%type
23: ,p_stop_time in hxc_app_period_summary.stop_time%type
24: ,p_resource_id in hxc_app_period_summary.resource_id%type
25: ,p_recipient_sequence in hxc_app_period_summary.recipient_sequence%type
26: ,p_category_sequence in hxc_app_period_summary.category_sequence%type

Line 23: ,p_stop_time in hxc_app_period_summary.stop_time%type

19: ,p_approval_status in hxc_app_period_summary.approval_status%type
20: ,p_time_recipient_id in hxc_app_period_summary.time_recipient_id%type
21: ,p_time_category_id in hxc_app_period_summary.time_category_id%type
22: ,p_start_time in hxc_app_period_summary.start_time%type
23: ,p_stop_time in hxc_app_period_summary.stop_time%type
24: ,p_resource_id in hxc_app_period_summary.resource_id%type
25: ,p_recipient_sequence in hxc_app_period_summary.recipient_sequence%type
26: ,p_category_sequence in hxc_app_period_summary.category_sequence%type
27: ,p_creation_date in hxc_app_period_summary.creation_date%type

Line 24: ,p_resource_id in hxc_app_period_summary.resource_id%type

20: ,p_time_recipient_id in hxc_app_period_summary.time_recipient_id%type
21: ,p_time_category_id in hxc_app_period_summary.time_category_id%type
22: ,p_start_time in hxc_app_period_summary.start_time%type
23: ,p_stop_time in hxc_app_period_summary.stop_time%type
24: ,p_resource_id in hxc_app_period_summary.resource_id%type
25: ,p_recipient_sequence in hxc_app_period_summary.recipient_sequence%type
26: ,p_category_sequence in hxc_app_period_summary.category_sequence%type
27: ,p_creation_date in hxc_app_period_summary.creation_date%type
28: ,p_notification_status in hxc_app_period_summary.notification_status%type

Line 25: ,p_recipient_sequence in hxc_app_period_summary.recipient_sequence%type

21: ,p_time_category_id in hxc_app_period_summary.time_category_id%type
22: ,p_start_time in hxc_app_period_summary.start_time%type
23: ,p_stop_time in hxc_app_period_summary.stop_time%type
24: ,p_resource_id in hxc_app_period_summary.resource_id%type
25: ,p_recipient_sequence in hxc_app_period_summary.recipient_sequence%type
26: ,p_category_sequence in hxc_app_period_summary.category_sequence%type
27: ,p_creation_date in hxc_app_period_summary.creation_date%type
28: ,p_notification_status in hxc_app_period_summary.notification_status%type
29: ,p_approver_id in hxc_app_period_summary.approver_id%type

Line 26: ,p_category_sequence in hxc_app_period_summary.category_sequence%type

22: ,p_start_time in hxc_app_period_summary.start_time%type
23: ,p_stop_time in hxc_app_period_summary.stop_time%type
24: ,p_resource_id in hxc_app_period_summary.resource_id%type
25: ,p_recipient_sequence in hxc_app_period_summary.recipient_sequence%type
26: ,p_category_sequence in hxc_app_period_summary.category_sequence%type
27: ,p_creation_date in hxc_app_period_summary.creation_date%type
28: ,p_notification_status in hxc_app_period_summary.notification_status%type
29: ,p_approver_id in hxc_app_period_summary.approver_id%type
30: ,p_approval_comp_id in hxc_app_period_summary.approval_comp_id%type

Line 27: ,p_creation_date in hxc_app_period_summary.creation_date%type

23: ,p_stop_time in hxc_app_period_summary.stop_time%type
24: ,p_resource_id in hxc_app_period_summary.resource_id%type
25: ,p_recipient_sequence in hxc_app_period_summary.recipient_sequence%type
26: ,p_category_sequence in hxc_app_period_summary.category_sequence%type
27: ,p_creation_date in hxc_app_period_summary.creation_date%type
28: ,p_notification_status in hxc_app_period_summary.notification_status%type
29: ,p_approver_id in hxc_app_period_summary.approver_id%type
30: ,p_approval_comp_id in hxc_app_period_summary.approval_comp_id%type
31: ,p_approval_item_key in hxc_app_period_summary.approval_item_key%type default null

Line 28: ,p_notification_status in hxc_app_period_summary.notification_status%type

24: ,p_resource_id in hxc_app_period_summary.resource_id%type
25: ,p_recipient_sequence in hxc_app_period_summary.recipient_sequence%type
26: ,p_category_sequence in hxc_app_period_summary.category_sequence%type
27: ,p_creation_date in hxc_app_period_summary.creation_date%type
28: ,p_notification_status in hxc_app_period_summary.notification_status%type
29: ,p_approver_id in hxc_app_period_summary.approver_id%type
30: ,p_approval_comp_id in hxc_app_period_summary.approval_comp_id%type
31: ,p_approval_item_key in hxc_app_period_summary.approval_item_key%type default null
32: );

Line 29: ,p_approver_id in hxc_app_period_summary.approver_id%type

25: ,p_recipient_sequence in hxc_app_period_summary.recipient_sequence%type
26: ,p_category_sequence in hxc_app_period_summary.category_sequence%type
27: ,p_creation_date in hxc_app_period_summary.creation_date%type
28: ,p_notification_status in hxc_app_period_summary.notification_status%type
29: ,p_approver_id in hxc_app_period_summary.approver_id%type
30: ,p_approval_comp_id in hxc_app_period_summary.approval_comp_id%type
31: ,p_approval_item_key in hxc_app_period_summary.approval_item_key%type default null
32: );
33:

Line 30: ,p_approval_comp_id in hxc_app_period_summary.approval_comp_id%type

26: ,p_category_sequence in hxc_app_period_summary.category_sequence%type
27: ,p_creation_date in hxc_app_period_summary.creation_date%type
28: ,p_notification_status in hxc_app_period_summary.notification_status%type
29: ,p_approver_id in hxc_app_period_summary.approver_id%type
30: ,p_approval_comp_id in hxc_app_period_summary.approval_comp_id%type
31: ,p_approval_item_key in hxc_app_period_summary.approval_item_key%type default null
32: );
33:
34: procedure app_period_delete

Line 31: ,p_approval_item_key in hxc_app_period_summary.approval_item_key%type default null

27: ,p_creation_date in hxc_app_period_summary.creation_date%type
28: ,p_notification_status in hxc_app_period_summary.notification_status%type
29: ,p_approver_id in hxc_app_period_summary.approver_id%type
30: ,p_approval_comp_id in hxc_app_period_summary.approval_comp_id%type
31: ,p_approval_item_key in hxc_app_period_summary.approval_item_key%type default null
32: );
33:
34: procedure app_period_delete
35: (p_application_period_id in hxc_app_period_summary.application_period_id%type);

Line 35: (p_application_period_id in hxc_app_period_summary.application_period_id%type);

31: ,p_approval_item_key in hxc_app_period_summary.approval_item_key%type default null
32: );
33:
34: procedure app_period_delete
35: (p_application_period_id in hxc_app_period_summary.application_period_id%type);
36:
37:
38: PROCEDURE get_valid_periods(
39: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE

Line 47: end hxc_app_period_summary_api;

43: ,p_valid_status IN VARCHAR2
44: ,p_valid_periods OUT NOCOPY valid_period_tab
45: );
46:
47: end hxc_app_period_summary_api;