DBA Data[Home] [Help]

APPS.FTE_PROCESS_REQUESTS dependencies on FTE_ACS_PKG

Line 240: -- FTE_ACS_PKG.fte_cs_result_rec_type --

236: -- FTE_PROCESS_REQUESTS.fte_source_header_tab --
237: -- p_source_line_tab IN OUT NOCOPY --
238: -- FTE_PROCESS_REQUESTS.fte_source_line_tab --
239: -- x_result_tab OUT NOCOPY --
240: -- FTE_ACS_PKG.fte_cs_result_rec_type --
241: -- x_return_message OUT VARCHAR2 --
242: -- x_return_status OUT VARCHAR2 --
243: -- --
244: -- PARAMETERS (IN OUT): none --

Line 263: x_result_tab OUT NOCOPY FTE_ACS_PKG.fte_cs_result_tab_type,

259: -- --
260: -- -------------------------------------------------------------------------- --
261: PROCEDURE FORMAT_CS_CALL( p_source_header_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_tab,
262: p_source_line_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_tab,
263: x_result_tab OUT NOCOPY FTE_ACS_PKG.fte_cs_result_tab_type,
264: x_return_message OUT NOCOPY VARCHAR2,
265: x_return_status OUT NOCOPY VARCHAR2) IS
266:
267: -- New Header and Result Tab

Line 268: l_cs_input_tab FTE_ACS_PKG.fte_cs_entity_tab_type;

264: x_return_message OUT NOCOPY VARCHAR2,
265: x_return_status OUT NOCOPY VARCHAR2) IS
266:
267: -- New Header and Result Tab
268: l_cs_input_tab FTE_ACS_PKG.fte_cs_entity_tab_type;
269: l_cs_output_tab FTE_ACS_PKG.fte_cs_result_tab_type;
270: l_cs_output_message_tab FTE_ACS_PKG.fte_cs_output_message_tab;
271:
272: l_customer_site_id NUMBER;

Line 269: l_cs_output_tab FTE_ACS_PKG.fte_cs_result_tab_type;

265: x_return_status OUT NOCOPY VARCHAR2) IS
266:
267: -- New Header and Result Tab
268: l_cs_input_tab FTE_ACS_PKG.fte_cs_entity_tab_type;
269: l_cs_output_tab FTE_ACS_PKG.fte_cs_result_tab_type;
270: l_cs_output_message_tab FTE_ACS_PKG.fte_cs_output_message_tab;
271:
272: l_customer_site_id NUMBER;
273: l_customer_id NUMBER;

Line 270: l_cs_output_message_tab FTE_ACS_PKG.fte_cs_output_message_tab;

266:
267: -- New Header and Result Tab
268: l_cs_input_tab FTE_ACS_PKG.fte_cs_entity_tab_type;
269: l_cs_output_tab FTE_ACS_PKG.fte_cs_result_tab_type;
270: l_cs_output_message_tab FTE_ACS_PKG.fte_cs_output_message_tab;
271:
272: l_customer_site_id NUMBER;
273: l_customer_id NUMBER;
274:

Line 393: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_ACS_PKG.START_ACS',WSH_DEBUG_SV.C_PROC_LEVEL);

389: --
390: -- Debug Statements
391: --
392: IF l_debug_on THEN
393: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_ACS_PKG.START_ACS',WSH_DEBUG_SV.C_PROC_LEVEL);
394: END IF;
395: --
396:
397: FTE_ACS_PKG.GET_ROUTING_RESULTS( p_format_cs_tab => l_cs_input_tab,

Line 397: FTE_ACS_PKG.GET_ROUTING_RESULTS( p_format_cs_tab => l_cs_input_tab,

393: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_ACS_PKG.START_ACS',WSH_DEBUG_SV.C_PROC_LEVEL);
394: END IF;
395: --
396:
397: FTE_ACS_PKG.GET_ROUTING_RESULTS( p_format_cs_tab => l_cs_input_tab,
398: p_entity => 'PSEUDO_DLVY',
399: p_messaging_yn => 'Y',
400: p_caller => 'ORDER_MGMT',
401: x_cs_output_tab => l_cs_output_tab,

Line 559: l_result_tab FTE_ACS_PKG.FTE_CS_RESULT_TAB_TYPE;

555: l_result_transit_time_max_tab WSH_NEW_DELIVERY_ACTIONS.TableNumbers;
556: l_ship_method_code_tab WSH_NEW_DELIVERY_ACTIONS.TableVarchar30;
557:
558: --R12 - Routing Rules Engine
559: l_result_tab FTE_ACS_PKG.FTE_CS_RESULT_TAB_TYPE;
560: l_return_message VARCHAR2(2000);
561:
562: CURSOR get_session_id IS
563: SELECT mrp_atp_schedule_temp_s.nextVal