DBA Data[Home] [Help]

APPS.HXT_HXC_RETRIEVAL_PROCESS dependencies on HXC_SELF_SERVICE_TIME_DEPOSIT

Line 6: g_messages hxc_self_service_time_deposit.message_table;

2: /* $Header: hxthcrtp.pkh 120.4.12020000.1 2012/06/27 09:55:44 appldev ship $ */
3:
4: --
5: g_full_name VARCHAR2(240);
6: g_messages hxc_self_service_time_deposit.message_table;
7: --
8: g_otm_messages hxc_self_service_time_deposit.message_table;
9:
10: -- Bug 7557568

Line 8: g_otm_messages hxc_self_service_time_deposit.message_table;

4: --
5: g_full_name VARCHAR2(240);
6: g_messages hxc_self_service_time_deposit.message_table;
7: --
8: g_otm_messages hxc_self_service_time_deposit.message_table;
9:
10: -- Bug 7557568
11: -- Added the following record type to process deleted details.
12: TYPE DETAIL_REC IS RECORD

Line 35: (p_time_building_blocks IN hxc_self_service_time_deposit.timecard_info

31: g_an_id VARCHARTAB;
32: g_alias_id NUMBER;
33:
34: PROCEDURE synchronize_deletes_in_otlr
35: (p_time_building_blocks IN hxc_self_service_time_deposit.timecard_info
36: ,p_time_att_info IN hxc_self_Service_time_deposit.app_attributes_info
37: ,p_messages IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.MESSAGE_TABLE
38: ,p_timecard_source IN VARCHAR -- added for 5137310
39: );

Line 36: ,p_time_att_info IN hxc_self_Service_time_deposit.app_attributes_info

32: g_alias_id NUMBER;
33:
34: PROCEDURE synchronize_deletes_in_otlr
35: (p_time_building_blocks IN hxc_self_service_time_deposit.timecard_info
36: ,p_time_att_info IN hxc_self_Service_time_deposit.app_attributes_info
37: ,p_messages IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.MESSAGE_TABLE
38: ,p_timecard_source IN VARCHAR -- added for 5137310
39: );
40:

Line 37: ,p_messages IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.MESSAGE_TABLE

33:
34: PROCEDURE synchronize_deletes_in_otlr
35: (p_time_building_blocks IN hxc_self_service_time_deposit.timecard_info
36: ,p_time_att_info IN hxc_self_Service_time_deposit.app_attributes_info
37: ,p_messages IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.MESSAGE_TABLE
38: ,p_timecard_source IN VARCHAR -- added for 5137310
39: );
40:
41: PROCEDURE otm_validate_process

Line 49: ,p_time_building_blocks IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info

45: ,p_messages IN OUT NOCOPY VARCHAR2);
46: --
47: PROCEDURE validate_timecard
48: (p_operation IN VARCHAR2
49: ,p_time_building_blocks IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info
50: ,p_time_attributes IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.app_attributes_info
51: ,p_messages IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.MESSAGE_TABLE);
52: --
53: Procedure otlr_validation_required

Line 50: ,p_time_attributes IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.app_attributes_info

46: --
47: PROCEDURE validate_timecard
48: (p_operation IN VARCHAR2
49: ,p_time_building_blocks IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info
50: ,p_time_attributes IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.app_attributes_info
51: ,p_messages IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.MESSAGE_TABLE);
52: --
53: Procedure otlr_validation_required
54: (p_operation in varchar2

Line 51: ,p_messages IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.MESSAGE_TABLE);

47: PROCEDURE validate_timecard
48: (p_operation IN VARCHAR2
49: ,p_time_building_blocks IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info
50: ,p_time_attributes IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.app_attributes_info
51: ,p_messages IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.MESSAGE_TABLE);
52: --
53: Procedure otlr_validation_required
54: (p_operation in varchar2
55: ,p_otm_explosion in varchar2

Line 60: ,p_time_building_blocks in hxc_self_service_time_deposit.timecard_info

56: ,p_otm_rtr_id in number
57: ,p_app_set_id in number
58: ,p_timecard_id in number
59: ,p_timecard_ovn in number
60: ,p_time_building_blocks in hxc_self_service_time_deposit.timecard_info
61: ,p_time_att_info in hxc_self_Service_time_deposit.app_attributes_info
62: ,p_messages in out nocopy hxc_self_service_time_deposit.message_table
63: );
64: --

Line 61: ,p_time_att_info in hxc_self_Service_time_deposit.app_attributes_info

57: ,p_app_set_id in number
58: ,p_timecard_id in number
59: ,p_timecard_ovn in number
60: ,p_time_building_blocks in hxc_self_service_time_deposit.timecard_info
61: ,p_time_att_info in hxc_self_Service_time_deposit.app_attributes_info
62: ,p_messages in out nocopy hxc_self_service_time_deposit.message_table
63: );
64: --
65: PROCEDURE otlr_review_details(

Line 62: ,p_messages in out nocopy hxc_self_service_time_deposit.message_table

58: ,p_timecard_id in number
59: ,p_timecard_ovn in number
60: ,p_time_building_blocks in hxc_self_service_time_deposit.timecard_info
61: ,p_time_att_info in hxc_self_Service_time_deposit.app_attributes_info
62: ,p_messages in out nocopy hxc_self_service_time_deposit.message_table
63: );
64: --
65: PROCEDURE otlr_review_details(
66: p_time_building_blocks IN HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info

Line 66: p_time_building_blocks IN HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info

62: ,p_messages in out nocopy hxc_self_service_time_deposit.message_table
63: );
64: --
65: PROCEDURE otlr_review_details(
66: p_time_building_blocks IN HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info
67: ,p_time_attributes IN HXC_SELF_SERVICE_TIME_DEPOSIT.app_attributes_info
68: ,p_messages IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.MESSAGE_TABLE
69: ,p_detail_build_blocks IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info
70: ,p_detail_attributes IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.building_block_attribute_info);

Line 67: ,p_time_attributes IN HXC_SELF_SERVICE_TIME_DEPOSIT.app_attributes_info

63: );
64: --
65: PROCEDURE otlr_review_details(
66: p_time_building_blocks IN HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info
67: ,p_time_attributes IN HXC_SELF_SERVICE_TIME_DEPOSIT.app_attributes_info
68: ,p_messages IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.MESSAGE_TABLE
69: ,p_detail_build_blocks IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info
70: ,p_detail_attributes IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.building_block_attribute_info);
71: --

Line 68: ,p_messages IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.MESSAGE_TABLE

64: --
65: PROCEDURE otlr_review_details(
66: p_time_building_blocks IN HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info
67: ,p_time_attributes IN HXC_SELF_SERVICE_TIME_DEPOSIT.app_attributes_info
68: ,p_messages IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.MESSAGE_TABLE
69: ,p_detail_build_blocks IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info
70: ,p_detail_attributes IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.building_block_attribute_info);
71: --
72: FUNCTION build_attributes(

Line 69: ,p_detail_build_blocks IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info

65: PROCEDURE otlr_review_details(
66: p_time_building_blocks IN HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info
67: ,p_time_attributes IN HXC_SELF_SERVICE_TIME_DEPOSIT.app_attributes_info
68: ,p_messages IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.MESSAGE_TABLE
69: ,p_detail_build_blocks IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info
70: ,p_detail_attributes IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.building_block_attribute_info);
71: --
72: FUNCTION build_attributes(
73: p_detail_attributes IN HXC_SELF_SERVICE_TIME_DEPOSIT.app_attributes_info

Line 70: ,p_detail_attributes IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.building_block_attribute_info);

66: p_time_building_blocks IN HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info
67: ,p_time_attributes IN HXC_SELF_SERVICE_TIME_DEPOSIT.app_attributes_info
68: ,p_messages IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.MESSAGE_TABLE
69: ,p_detail_build_blocks IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info
70: ,p_detail_attributes IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.building_block_attribute_info);
71: --
72: FUNCTION build_attributes(
73: p_detail_attributes IN HXC_SELF_SERVICE_TIME_DEPOSIT.app_attributes_info
74: )

Line 73: p_detail_attributes IN HXC_SELF_SERVICE_TIME_DEPOSIT.app_attributes_info

69: ,p_detail_build_blocks IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info
70: ,p_detail_attributes IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.building_block_attribute_info);
71: --
72: FUNCTION build_attributes(
73: p_detail_attributes IN HXC_SELF_SERVICE_TIME_DEPOSIT.app_attributes_info
74: )
75: RETURN HXC_SELF_SERVICE_TIME_DEPOSIT.building_block_attribute_info;
76: --
77:

Line 75: RETURN HXC_SELF_SERVICE_TIME_DEPOSIT.building_block_attribute_info;

71: --
72: FUNCTION build_attributes(
73: p_detail_attributes IN HXC_SELF_SERVICE_TIME_DEPOSIT.app_attributes_info
74: )
75: RETURN HXC_SELF_SERVICE_TIME_DEPOSIT.building_block_attribute_info;
76: --
77:
78: -- Bug 8486310
79: -- Added new procedure to save Alt Name Identifiers.

Line 85: PROCEDURE check_restrict_edit( p_time_building_blocks IN HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info,

81:
82: -- Bug 7557568
83: -- Added the following function to check if a detail is deleted
84: -- after a SAVE.
85: PROCEDURE check_restrict_edit( p_time_building_blocks IN HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info,
86: p_messages IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.message_table );
87:
88:
89:

Line 86: p_messages IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.message_table );

82: -- Bug 7557568
83: -- Added the following function to check if a detail is deleted
84: -- after a SAVE.
85: PROCEDURE check_restrict_edit( p_time_building_blocks IN HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info,
86: p_messages IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.message_table );
87:
88:
89:
90: END hxt_hxc_retrieval_process;