DBA Data[Home] [Help]

APPS.FTE_TP_GRP dependencies on WSH_FTE_TP_INTEGRATION

Line 313: x_cm_info_rec OUT NOCOPY WSH_FTE_TP_INTEGRATION.cm_info_rec_type,

309: --
310:
311: PROCEDURE lookup_cm_info (
312: p_trip_id IN NUMBER,
313: x_cm_info_rec OUT NOCOPY WSH_FTE_TP_INTEGRATION.cm_info_rec_type,
314: x_return_status OUT NOCOPY VARCHAR2)
315: IS
316: --
317: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'lookup_cm_info';

Line 649: x_plan_trip_moves IN OUT NOCOPY WSH_FTE_TP_INTEGRATION.plan_trip_move_tab_type,

645:
646: PROCEDURE map_moves(
647: x_context IN OUT NOCOPY WSH_TP_RELEASE_INT.context_rec_type,
648: x_plan_trips IN OUT NOCOPY WSH_TP_RELEASE_INT.plan_trip_tab_type,
649: x_plan_trip_moves IN OUT NOCOPY WSH_FTE_TP_INTEGRATION.plan_trip_move_tab_type,
650: x_plan_moves IN OUT NOCOPY WSH_FTE_TP_INTEGRATION.plan_move_tab_type,
651: x_obsoleted_trip_moves IN OUT NOCOPY WSH_FTE_TP_INTEGRATION.obsoleted_trip_move_tab_type,
652: x_errors_tab IN OUT NOCOPY WSH_TP_RELEASE_INT.interface_errors_tab_type,
653: x_return_status OUT NOCOPY VARCHAR2

Line 650: x_plan_moves IN OUT NOCOPY WSH_FTE_TP_INTEGRATION.plan_move_tab_type,

646: PROCEDURE map_moves(
647: x_context IN OUT NOCOPY WSH_TP_RELEASE_INT.context_rec_type,
648: x_plan_trips IN OUT NOCOPY WSH_TP_RELEASE_INT.plan_trip_tab_type,
649: x_plan_trip_moves IN OUT NOCOPY WSH_FTE_TP_INTEGRATION.plan_trip_move_tab_type,
650: x_plan_moves IN OUT NOCOPY WSH_FTE_TP_INTEGRATION.plan_move_tab_type,
651: x_obsoleted_trip_moves IN OUT NOCOPY WSH_FTE_TP_INTEGRATION.obsoleted_trip_move_tab_type,
652: x_errors_tab IN OUT NOCOPY WSH_TP_RELEASE_INT.interface_errors_tab_type,
653: x_return_status OUT NOCOPY VARCHAR2
654: )

Line 651: x_obsoleted_trip_moves IN OUT NOCOPY WSH_FTE_TP_INTEGRATION.obsoleted_trip_move_tab_type,

647: x_context IN OUT NOCOPY WSH_TP_RELEASE_INT.context_rec_type,
648: x_plan_trips IN OUT NOCOPY WSH_TP_RELEASE_INT.plan_trip_tab_type,
649: x_plan_trip_moves IN OUT NOCOPY WSH_FTE_TP_INTEGRATION.plan_trip_move_tab_type,
650: x_plan_moves IN OUT NOCOPY WSH_FTE_TP_INTEGRATION.plan_move_tab_type,
651: x_obsoleted_trip_moves IN OUT NOCOPY WSH_FTE_TP_INTEGRATION.obsoleted_trip_move_tab_type,
652: x_errors_tab IN OUT NOCOPY WSH_TP_RELEASE_INT.interface_errors_tab_type,
653: x_return_status OUT NOCOPY VARCHAR2
654: )
655: IS

Line 717: l_unmapped_trip_moves WSH_FTE_TP_INTEGRATION.obsoleted_trip_move_tab_type;

713: l_cm_info c_cm_info%ROWTYPE;
714: l_locked VARCHAR2(1);
715: l_return_status VARCHAR2(1);
716:
717: l_unmapped_trip_moves WSH_FTE_TP_INTEGRATION.obsoleted_trip_move_tab_type;
718:
719: l_new_index NUMBER := 0;
720: l_tm_index NUMBER := 0;
721: l_trip_index NUMBER;

Line 1180: x_plan_trip_moves IN OUT NOCOPY WSH_FTE_TP_INTEGRATION.plan_trip_move_tab_type,

1176:
1177: PROCEDURE reconciliate_moves(
1178: x_context IN OUT NOCOPY WSH_TP_RELEASE_INT.context_rec_type,
1179: x_plan_trips IN OUT NOCOPY WSH_TP_RELEASE_INT.plan_trip_tab_type,
1180: x_plan_trip_moves IN OUT NOCOPY WSH_FTE_TP_INTEGRATION.plan_trip_move_tab_type,
1181: x_plan_moves IN OUT NOCOPY WSH_FTE_TP_INTEGRATION.plan_move_tab_type,
1182: x_obsoleted_trip_moves IN OUT NOCOPY WSH_FTE_TP_INTEGRATION.obsoleted_trip_move_tab_type,
1183: x_errors_tab IN OUT NOCOPY WSH_TP_RELEASE_INT.interface_errors_tab_type,
1184: x_return_status OUT NOCOPY VARCHAR2

Line 1181: x_plan_moves IN OUT NOCOPY WSH_FTE_TP_INTEGRATION.plan_move_tab_type,

1177: PROCEDURE reconciliate_moves(
1178: x_context IN OUT NOCOPY WSH_TP_RELEASE_INT.context_rec_type,
1179: x_plan_trips IN OUT NOCOPY WSH_TP_RELEASE_INT.plan_trip_tab_type,
1180: x_plan_trip_moves IN OUT NOCOPY WSH_FTE_TP_INTEGRATION.plan_trip_move_tab_type,
1181: x_plan_moves IN OUT NOCOPY WSH_FTE_TP_INTEGRATION.plan_move_tab_type,
1182: x_obsoleted_trip_moves IN OUT NOCOPY WSH_FTE_TP_INTEGRATION.obsoleted_trip_move_tab_type,
1183: x_errors_tab IN OUT NOCOPY WSH_TP_RELEASE_INT.interface_errors_tab_type,
1184: x_return_status OUT NOCOPY VARCHAR2
1185: )

Line 1182: x_obsoleted_trip_moves IN OUT NOCOPY WSH_FTE_TP_INTEGRATION.obsoleted_trip_move_tab_type,

1178: x_context IN OUT NOCOPY WSH_TP_RELEASE_INT.context_rec_type,
1179: x_plan_trips IN OUT NOCOPY WSH_TP_RELEASE_INT.plan_trip_tab_type,
1180: x_plan_trip_moves IN OUT NOCOPY WSH_FTE_TP_INTEGRATION.plan_trip_move_tab_type,
1181: x_plan_moves IN OUT NOCOPY WSH_FTE_TP_INTEGRATION.plan_move_tab_type,
1182: x_obsoleted_trip_moves IN OUT NOCOPY WSH_FTE_TP_INTEGRATION.obsoleted_trip_move_tab_type,
1183: x_errors_tab IN OUT NOCOPY WSH_TP_RELEASE_INT.interface_errors_tab_type,
1184: x_return_status OUT NOCOPY VARCHAR2
1185: )
1186: IS

Line 1447: x_plan_moves IN OUT NOCOPY WSH_FTE_TP_INTEGRATION.plan_move_tab_type,

1443: --
1444:
1445: PROCEDURE tp_firm_moves(
1446: x_context IN OUT NOCOPY WSH_TP_RELEASE_INT.context_rec_type,
1447: x_plan_moves IN OUT NOCOPY WSH_FTE_TP_INTEGRATION.plan_move_tab_type,
1448: x_errors_tab IN OUT NOCOPY WSH_TP_RELEASE_INT.interface_errors_tab_type,
1449: x_return_status OUT NOCOPY VARCHAR2
1450: )
1451: IS