PACKAGE: APPS.WSH_DELIVERY_DETAILS_UTILITIES

Source

1 PACKAGE WSH_DELIVERY_DETAILS_UTILITIES as
2 /* $Header: WSHDDUTS.pls 120.0.12000000.1 2007/01/16 05:44:06 appldev ship $ */
3 
4 TYPE porcessed_flag_tbl IS TABLE OF VARCHAR2(1)
5   INDEX BY BINARY_INTEGER;
6 
7 
8 
9 TYPE  delivery_assignment_rec_type IS RECORD (
10    delivery_detail_id              wsh_delivery_details.delivery_detail_id%type,
11    delivery_id                     wsh_new_deliveries.delivery_id%type);
12 
13 TYPE delivery_assignment_rec_tbl IS TABLE OF delivery_assignment_rec_type
14   INDEX BY BINARY_INTEGER;
15 
16 PROCEDURE Append_to_Deliveries(
17           p_delivery_detail_tbl     IN  WSH_UTIL_CORE.Id_Tab_Type,
18           p_append_flag             IN  VARCHAR2 DEFAULT NULL,
19           p_group_by_header         IN  VARCHAR2 DEFAULT NULL,
20           p_commit                  IN  VARCHAR2 DEFAULT FND_API.G_FALSE,
21           p_lock_rows               IN  VARCHAR2 DEFAULT FND_API.G_FALSE,
22           p_check_fte_compatibility IN  VARCHAR2 DEFAULT FND_API.G_FALSE,
23           x_appended_det_tbl        OUT NOCOPY WSH_DELIVERY_DETAILS_UTILITIES.delivery_assignment_rec_tbl,
24           x_unappended_det_tbl      OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
25           x_appended_del_tbl        OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
26           x_return_status           OUT NOCOPY VARCHAR2);
27 
28 
29 END WSH_DELIVERY_DETAILS_UTILITIES;