DBA Data[Home] [Help]

APPS.WMS_CONTAINER_GRP dependencies on WMS_DATA_TYPE_DEFINITIONS_PUB

Line 26: , p_gen_lpn_rec IN WMS_Data_Type_Definitions_PUB.AutoCreateLPNRecordType

22: , x_return_status OUT NOCOPY VARCHAR2
23: , x_msg_count OUT NOCOPY NUMBER
24: , x_msg_data OUT NOCOPY VARCHAR2
25: , p_caller IN VARCHAR2
26: , p_gen_lpn_rec IN WMS_Data_Type_Definitions_PUB.AutoCreateLPNRecordType
27: , p_lpn_table OUT NOCOPY WMS_Data_Type_Definitions_PUB.LPNTableType
28: ) IS
29:
30: l_debug number;

Line 27: , p_lpn_table OUT NOCOPY WMS_Data_Type_Definitions_PUB.LPNTableType

23: , x_msg_count OUT NOCOPY NUMBER
24: , x_msg_data OUT NOCOPY VARCHAR2
25: , p_caller IN VARCHAR2
26: , p_gen_lpn_rec IN WMS_Data_Type_Definitions_PUB.AutoCreateLPNRecordType
27: , p_lpn_table OUT NOCOPY WMS_Data_Type_Definitions_PUB.LPNTableType
28: ) IS
29:
30: l_debug number;
31: l_api_name VARCHAR2(20);

Line 35: l_serial_range WMS_Data_Type_Definitions_PUB.SerialRangeTableType;

31: l_api_name VARCHAR2(20);
32:
33: l_msgdata VARCHAR2(1000);
34: l_ucc_128_suffix_flag VARCHAR2(1);
35: l_serial_range WMS_Data_Type_Definitions_PUB.SerialRangeTableType;
36: l_lpn_attr WMS_Data_Type_Definitions_PUB.LPNRecordType;
37:
38: BEGIN
39: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 36: l_lpn_attr WMS_Data_Type_Definitions_PUB.LPNRecordType;

32:
33: l_msgdata VARCHAR2(1000);
34: l_ucc_128_suffix_flag VARCHAR2(1);
35: l_serial_range WMS_Data_Type_Definitions_PUB.SerialRangeTableType;
36: l_lpn_attr WMS_Data_Type_Definitions_PUB.LPNRecordType;
37:
38: BEGIN
39: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
40: l_api_name := 'Auto_Create_LPNs';

Line 139: , p_lpn_table IN OUT NOCOPY WMS_Data_Type_Definitions_PUB.LPNTableType

135: , x_return_status OUT NOCOPY VARCHAR2
136: , x_msg_count OUT NOCOPY NUMBER
137: , x_msg_data OUT NOCOPY VARCHAR2
138: , p_caller IN VARCHAR2
139: , p_lpn_table IN OUT NOCOPY WMS_Data_Type_Definitions_PUB.LPNTableType
140: ) IS
141: BEGIN
142: x_return_status := fnd_api.g_ret_sts_success;
143:

Line 166: , p_lpn_table IN WMS_Data_Type_Definitions_PUB.LPNTableType

162: , x_return_status OUT NOCOPY VARCHAR2
163: , x_msg_count OUT NOCOPY NUMBER
164: , x_msg_data OUT NOCOPY VARCHAR2
165: , p_caller IN VARCHAR2
166: , p_lpn_table IN WMS_Data_Type_Definitions_PUB.LPNTableType
167: ) IS
168: BEGIN
169: x_return_status := fnd_api.g_ret_sts_success;
170:

Line 194: , p_lpn_purge_rec IN OUT NOCOPY WMS_Data_Type_Definitions_PUB.LPNPurgeRecordType

190: , x_msg_count OUT NOCOPY NUMBER
191: , x_msg_data OUT NOCOPY VARCHAR2
192: , p_caller IN VARCHAR2
193: , p_action IN VARCHAR2
194: , p_lpn_purge_rec IN OUT NOCOPY WMS_Data_Type_Definitions_PUB.LPNPurgeRecordType
195: ) IS
196:
197: l_debug number;
198: l_api_name VARCHAR2(20);

Line 199: l_valid_lpns WMS_DATA_TYPE_DEFINITIONS_PUB.NumberTableType;

195: ) IS
196:
197: l_debug number;
198: l_api_name VARCHAR2(20);
199: l_valid_lpns WMS_DATA_TYPE_DEFINITIONS_PUB.NumberTableType;
200: l_purge_count WMS_DATA_TYPE_DEFINITIONS_PUB.NumberTableType;
201: l_msgdata VARCHAR2(1000);
202:
203: BEGIN

Line 200: l_purge_count WMS_DATA_TYPE_DEFINITIONS_PUB.NumberTableType;

196:
197: l_debug number;
198: l_api_name VARCHAR2(20);
199: l_valid_lpns WMS_DATA_TYPE_DEFINITIONS_PUB.NumberTableType;
200: l_purge_count WMS_DATA_TYPE_DEFINITIONS_PUB.NumberTableType;
201: l_msgdata VARCHAR2(1000);
202:
203: BEGIN
204: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);