DBA Data[Home] [Help]

APPS.HXC_TIME_APPROVAL_INFO dependencies on HXC_TIME_RECIPIENTS

Line 87: p_application_name in hxc_time_recipients.name%type

83: function get_app_approval_status
84: (p_resource_id in hxc_app_period_summary.resource_id%type,
85: p_start_time in hxc_app_period_summary.start_time%type,
86: p_stop_time in hxc_app_period_summary.stop_time%type,
87: p_application_name in hxc_time_recipients.name%type
88: )
89: return hxc_app_period_summary.approval_status%type;
90:
91: function get_app_approval_status

Line 95: p_application_name in hxc_time_recipients.name%type,

91: function get_app_approval_status
92: (p_resource_id in hxc_app_period_summary.resource_id%type,
93: p_start_time in hxc_app_period_summary.start_time%type,
94: p_stop_time in hxc_app_period_summary.stop_time%type,
95: p_application_name in hxc_time_recipients.name%type,
96: p_time_category_name in hxc_time_categories.time_category_name%type
97: )
98: return hxc_app_period_summary.approval_status%type;
99:

Line 108: p_application_name in hxc_time_recipients.name%type

104: function get_app_creation_date
105: (p_resource_id in hxc_app_period_summary.resource_id%type,
106: p_start_time in hxc_app_period_summary.start_time%type,
107: p_stop_time in hxc_app_period_summary.stop_time%type,
108: p_application_name in hxc_time_recipients.name%type
109: )
110: return hxc_app_period_summary.creation_date%type;
111:
112: function get_app_creation_date

Line 116: p_application_name in hxc_time_recipients.name%type,

112: function get_app_creation_date
113: (p_resource_id in hxc_app_period_summary.resource_id%type,
114: p_start_time in hxc_app_period_summary.start_time%type,
115: p_stop_time in hxc_app_period_summary.stop_time%type,
116: p_application_name in hxc_time_recipients.name%type,
117: p_time_category_name in hxc_time_categories.time_category_name%type
118: )
119: return hxc_app_period_summary.creation_date%type;
120:

Line 129: p_application_name in hxc_time_recipients.name%type

125: function get_app_approver
126: (p_resource_id in hxc_app_period_summary.resource_id%type,
127: p_start_time in hxc_app_period_summary.start_time%type,
128: p_stop_time in hxc_app_period_summary.stop_time%type,
129: p_application_name in hxc_time_recipients.name%type
130: )
131: return varchar2;
132:
133: function get_app_approver

Line 137: p_application_name in hxc_time_recipients.name%type,

133: function get_app_approver
134: (p_resource_id in hxc_app_period_summary.resource_id%type,
135: p_start_time in hxc_app_period_summary.start_time%type,
136: p_stop_time in hxc_app_period_summary.stop_time%type,
137: p_application_name in hxc_time_recipients.name%type,
138: p_time_category_name in hxc_time_categories.time_category_name%type
139: )
140: return varchar2;
141: