eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_CONTAINER_PVT dependencies on WMS_DATA_TYPE_DEFINITIONS_PUB

Line 251: p_lpn_table IN WMS_Data_Type_Definitions_PUB.LPNTableType

247: -- ----------------------------------------------------------------------------------
248: -- ----------------------------------------------------------------------------------
249:
250: PROCEDURE To_LPNBulkRecType (
251: p_lpn_table IN WMS_Data_Type_Definitions_PUB.LPNTableType
252: , p_table_first IN NUMBER
253: , p_table_last IN NUMBER
254: , p_record_last IN NUMBER
255: , x_lpn_bulk_rec IN OUT NOCOPY LPNBulkRecType

Line 327: p_lpn_table IN WMS_Data_Type_Definitions_PUB.LPNTableType

323: -- ----------------------------------------------------------------------------------
324: -- ----------------------------------------------------------------------------------
325:
326: FUNCTION To_LPNBulkRecType (
327: p_lpn_table IN WMS_Data_Type_Definitions_PUB.LPNTableType
328: )
329: RETURN LPNBulkRecType
330: IS
331: l_lpn_bulk_rec LPNBulkRecType;

Line 345: p_lpn_record IN WMS_Data_Type_Definitions_PUB.LPNRecordType

341: RETURN l_lpn_bulk_rec;
342: END To_LPNBulkRecType;
343:
344: FUNCTION To_DeliveryDetailsRecType (
345: p_lpn_record IN WMS_Data_Type_Definitions_PUB.LPNRecordType
346: )
347: RETURN WSH_Glbl_Var_Strct_GRP.Delivery_Details_Rec_Type IS
348:
349: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 448: , p_old_lpn IN WMS_Data_Type_Definitions_PUB.LPNRecordType

444: -- ----------------------------------------------------------------------------------
445:
446: PROCEDURE Calc_Vol_Change (
447: p_debug IN NUMBER
448: , p_old_lpn IN WMS_Data_Type_Definitions_PUB.LPNRecordType
449: , p_new_lpn IN WMS_Data_Type_Definitions_PUB.LPNRecordType
450: , p_volume_change OUT NOCOPY NUMBER
451: , p_volume_uom_change OUT NOCOPY VARCHAR2
452: ) IS

Line 449: , p_new_lpn IN WMS_Data_Type_Definitions_PUB.LPNRecordType

445:
446: PROCEDURE Calc_Vol_Change (
447: p_debug IN NUMBER
448: , p_old_lpn IN WMS_Data_Type_Definitions_PUB.LPNRecordType
449: , p_new_lpn IN WMS_Data_Type_Definitions_PUB.LPNRecordType
450: , p_volume_change OUT NOCOPY NUMBER
451: , p_volume_uom_change OUT NOCOPY VARCHAR2
452: ) IS
453: l_api_name CONSTANT VARCHAR2(30) := 'Calc_Vol_Change';

Line 770: , p_lpn_table IN OUT NOCOPY WMS_Data_Type_Definitions_PUB.LPNTableType

766: , x_return_status OUT NOCOPY VARCHAR2
767: , x_msg_count OUT NOCOPY NUMBER
768: , x_msg_data OUT NOCOPY VARCHAR2
769: , p_caller IN VARCHAR2
770: , p_lpn_table IN OUT NOCOPY WMS_Data_Type_Definitions_PUB.LPNTableType
771: ) IS
772: l_api_name CONSTANT VARCHAR2(30) := 'Create_LPNs';
773: l_api_version CONSTANT NUMBER := 1.0;
774: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 1186: , p_lpn_attributes IN WMS_Data_Type_Definitions_PUB.LPNRecordType

1182: , p_lpn_suffix IN VARCHAR2
1183: , p_starting_number IN NUMBER
1184: , p_total_lpn_length IN NUMBER
1185: , p_ucc_128_suffix_flag IN VARCHAR2
1186: , p_lpn_attributes IN WMS_Data_Type_Definitions_PUB.LPNRecordType
1187: , p_serial_ranges IN WMS_Data_Type_Definitions_PUB.SerialRangeTableType
1188: , x_created_lpns OUT NOCOPY WMS_Data_Type_Definitions_PUB.LPNTableType
1189: ) IS
1190:

Line 1187: , p_serial_ranges IN WMS_Data_Type_Definitions_PUB.SerialRangeTableType

1183: , p_starting_number IN NUMBER
1184: , p_total_lpn_length IN NUMBER
1185: , p_ucc_128_suffix_flag IN VARCHAR2
1186: , p_lpn_attributes IN WMS_Data_Type_Definitions_PUB.LPNRecordType
1187: , p_serial_ranges IN WMS_Data_Type_Definitions_PUB.SerialRangeTableType
1188: , x_created_lpns OUT NOCOPY WMS_Data_Type_Definitions_PUB.LPNTableType
1189: ) IS
1190:
1191: BEGIN

Line 1188: , x_created_lpns OUT NOCOPY WMS_Data_Type_Definitions_PUB.LPNTableType

1184: , p_total_lpn_length IN NUMBER
1185: , p_ucc_128_suffix_flag IN VARCHAR2
1186: , p_lpn_attributes IN WMS_Data_Type_Definitions_PUB.LPNRecordType
1187: , p_serial_ranges IN WMS_Data_Type_Definitions_PUB.SerialRangeTableType
1188: , x_created_lpns OUT NOCOPY WMS_Data_Type_Definitions_PUB.LPNTableType
1189: ) IS
1190:
1191: BEGIN
1192: Auto_Create_LPNs (

Line 1263: , p_lpn_attributes IN WMS_Data_Type_Definitions_PUB.LPNRecordType

1259: , p_lpn_suffix IN VARCHAR2
1260: , p_starting_number IN NUMBER
1261: , p_total_lpn_length IN NUMBER
1262: , p_ucc_128_suffix_flag IN VARCHAR2
1263: , p_lpn_attributes IN WMS_Data_Type_Definitions_PUB.LPNRecordType
1264: , p_serial_ranges IN WMS_Data_Type_Definitions_PUB.SerialRangeTableType
1265: , x_created_lpns OUT NOCOPY WMS_Data_Type_Definitions_PUB.LPNTableType
1266: , p_client_code IN VARCHAR2 -- Adding for LSP, bug 9087971
1267: ) IS

Line 1264: , p_serial_ranges IN WMS_Data_Type_Definitions_PUB.SerialRangeTableType

1260: , p_starting_number IN NUMBER
1261: , p_total_lpn_length IN NUMBER
1262: , p_ucc_128_suffix_flag IN VARCHAR2
1263: , p_lpn_attributes IN WMS_Data_Type_Definitions_PUB.LPNRecordType
1264: , p_serial_ranges IN WMS_Data_Type_Definitions_PUB.SerialRangeTableType
1265: , x_created_lpns OUT NOCOPY WMS_Data_Type_Definitions_PUB.LPNTableType
1266: , p_client_code IN VARCHAR2 -- Adding for LSP, bug 9087971
1267: ) IS
1268: l_api_name CONSTANT VARCHAR2(30) := 'Auto_Create_LPNs New';

Line 1265: , x_created_lpns OUT NOCOPY WMS_Data_Type_Definitions_PUB.LPNTableType

1261: , p_total_lpn_length IN NUMBER
1262: , p_ucc_128_suffix_flag IN VARCHAR2
1263: , p_lpn_attributes IN WMS_Data_Type_Definitions_PUB.LPNRecordType
1264: , p_serial_ranges IN WMS_Data_Type_Definitions_PUB.SerialRangeTableType
1265: , x_created_lpns OUT NOCOPY WMS_Data_Type_Definitions_PUB.LPNTableType
1266: , p_client_code IN VARCHAR2 -- Adding for LSP, bug 9087971
1267: ) IS
1268: l_api_name CONSTANT VARCHAR2(30) := 'Auto_Create_LPNs New';
1269: l_api_version CONSTANT NUMBER := 1.0;

Line 1279: l_lpn_tab WMS_Data_Type_Definitions_PUB.LPNTableType;

1275: l_from_user CONSTANT NUMBER := 1;
1276: l_from_db_seq CONSTANT NUMBER := 2;
1277: l_from_org CONSTANT NUMBER := 3;
1278: l_from_client CONSTANT NUMBER := 4;
1279: l_lpn_tab WMS_Data_Type_Definitions_PUB.LPNTableType;
1280: l_serial_rec WMS_Data_Type_Definitions_PUB.SerialRangeRecordType;
1281:
1282: -- Local copies of input params that may need update from defaults
1283: l_quantity NUMBER := p_quantity ;

Line 1280: l_serial_rec WMS_Data_Type_Definitions_PUB.SerialRangeRecordType;

1276: l_from_db_seq CONSTANT NUMBER := 2;
1277: l_from_org CONSTANT NUMBER := 3;
1278: l_from_client CONSTANT NUMBER := 4;
1279: l_lpn_tab WMS_Data_Type_Definitions_PUB.LPNTableType;
1280: l_serial_rec WMS_Data_Type_Definitions_PUB.SerialRangeRecordType;
1281:
1282: -- Local copies of input params that may need update from defaults
1283: l_quantity NUMBER := p_quantity ;
1284: l_lpn_prefix VARCHAR2(50) := p_lpn_prefix;

Line 1773: , p_lpn_table IN WMS_Data_Type_Definitions_PUB.LPNTableType

1769: , x_return_status OUT NOCOPY VARCHAR2
1770: , x_msg_count OUT NOCOPY NUMBER
1771: , x_msg_data OUT NOCOPY VARCHAR2
1772: , p_caller IN VARCHAR2
1773: , p_lpn_table IN WMS_Data_Type_Definitions_PUB.LPNTableType
1774: ) IS
1775: l_api_name CONSTANT VARCHAR2(30) := 'Modify_LPNs';
1776: l_api_version CONSTANT NUMBER := 1.0;
1777: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 1928: l_lpn_ids WMS_Data_Type_Definitions_PUB.NumberTableType;

1924: l_wsh_unpack_lpn_id_tbl wsh_util_core.id_tab_type;
1925: l_wsh_delete_lpn_id_tbl wsh_util_core.id_tab_type;
1926:
1927: -- Variables used to store LPN information
1928: l_lpn_ids WMS_Data_Type_Definitions_PUB.NumberTableType;
1929: l_outer_lpn_ids WMS_Data_Type_Definitions_PUB.NumberTableType;
1930:
1931: l_lpn_tab_i NUMBER;
1932: l_tmp_i NUMBER;

Line 1929: l_outer_lpn_ids WMS_Data_Type_Definitions_PUB.NumberTableType;

1925: l_wsh_delete_lpn_id_tbl wsh_util_core.id_tab_type;
1926:
1927: -- Variables used to store LPN information
1928: l_lpn_ids WMS_Data_Type_Definitions_PUB.NumberTableType;
1929: l_outer_lpn_ids WMS_Data_Type_Definitions_PUB.NumberTableType;
1930:
1931: l_lpn_tab_i NUMBER;
1932: l_tmp_i NUMBER;
1933: l_dummy_num NUMBER;

Line 1935: l_tmp_new WMS_Data_Type_Definitions_PUB.LPNRecordType;

1931: l_lpn_tab_i NUMBER;
1932: l_tmp_i NUMBER;
1933: l_dummy_num NUMBER;
1934:
1935: l_tmp_new WMS_Data_Type_Definitions_PUB.LPNRecordType;
1936: l_tmp_old WMS_Data_Type_Definitions_PUB.LPNRecordType;
1937: l_new WMS_Data_Type_Definitions_PUB.LPNRecordType;
1938: l_old WMS_Data_Type_Definitions_PUB.LPNRecordType;
1939: l_lpns WMS_Data_Type_Definitions_PUB.LPNTableType;

Line 1936: l_tmp_old WMS_Data_Type_Definitions_PUB.LPNRecordType;

1932: l_tmp_i NUMBER;
1933: l_dummy_num NUMBER;
1934:
1935: l_tmp_new WMS_Data_Type_Definitions_PUB.LPNRecordType;
1936: l_tmp_old WMS_Data_Type_Definitions_PUB.LPNRecordType;
1937: l_new WMS_Data_Type_Definitions_PUB.LPNRecordType;
1938: l_old WMS_Data_Type_Definitions_PUB.LPNRecordType;
1939: l_lpns WMS_Data_Type_Definitions_PUB.LPNTableType;
1940: l_outer_lpns WMS_Data_Type_Definitions_PUB.LPNTableType;

Line 1937: l_new WMS_Data_Type_Definitions_PUB.LPNRecordType;

1933: l_dummy_num NUMBER;
1934:
1935: l_tmp_new WMS_Data_Type_Definitions_PUB.LPNRecordType;
1936: l_tmp_old WMS_Data_Type_Definitions_PUB.LPNRecordType;
1937: l_new WMS_Data_Type_Definitions_PUB.LPNRecordType;
1938: l_old WMS_Data_Type_Definitions_PUB.LPNRecordType;
1939: l_lpns WMS_Data_Type_Definitions_PUB.LPNTableType;
1940: l_outer_lpns WMS_Data_Type_Definitions_PUB.LPNTableType;
1941: l_lpn_bulk_rec LPNBulkRecType;

Line 1938: l_old WMS_Data_Type_Definitions_PUB.LPNRecordType;

1934:
1935: l_tmp_new WMS_Data_Type_Definitions_PUB.LPNRecordType;
1936: l_tmp_old WMS_Data_Type_Definitions_PUB.LPNRecordType;
1937: l_new WMS_Data_Type_Definitions_PUB.LPNRecordType;
1938: l_old WMS_Data_Type_Definitions_PUB.LPNRecordType;
1939: l_lpns WMS_Data_Type_Definitions_PUB.LPNTableType;
1940: l_outer_lpns WMS_Data_Type_Definitions_PUB.LPNTableType;
1941: l_lpn_bulk_rec LPNBulkRecType;
1942:

Line 1939: l_lpns WMS_Data_Type_Definitions_PUB.LPNTableType;

1935: l_tmp_new WMS_Data_Type_Definitions_PUB.LPNRecordType;
1936: l_tmp_old WMS_Data_Type_Definitions_PUB.LPNRecordType;
1937: l_new WMS_Data_Type_Definitions_PUB.LPNRecordType;
1938: l_old WMS_Data_Type_Definitions_PUB.LPNRecordType;
1939: l_lpns WMS_Data_Type_Definitions_PUB.LPNTableType;
1940: l_outer_lpns WMS_Data_Type_Definitions_PUB.LPNTableType;
1941: l_lpn_bulk_rec LPNBulkRecType;
1942:
1943: -- Temp variables needed for wt/vol calculation

Line 1940: l_outer_lpns WMS_Data_Type_Definitions_PUB.LPNTableType;

1936: l_tmp_old WMS_Data_Type_Definitions_PUB.LPNRecordType;
1937: l_new WMS_Data_Type_Definitions_PUB.LPNRecordType;
1938: l_old WMS_Data_Type_Definitions_PUB.LPNRecordType;
1939: l_lpns WMS_Data_Type_Definitions_PUB.LPNTableType;
1940: l_outer_lpns WMS_Data_Type_Definitions_PUB.LPNTableType;
1941: l_lpn_bulk_rec LPNBulkRecType;
1942:
1943: -- Temp variables needed for wt/vol calculation
1944: l_change_in_gross_weight NUMBER;

Line 3968: l_lpn_att_rec WMS_Data_Type_Definitions_PUB.LPNRecordType;

3964: l_lpn_prefix VARCHAR2(50);
3965: l_lpn_suffix VARCHAR2(50);
3966: l_wms_org_flag BOOLEAN;
3967:
3968: l_lpn_att_rec WMS_Data_Type_Definitions_PUB.LPNRecordType;
3969: l_serial_tbl WMS_Data_Type_Definitions_PUB.SerialRangeTableType;
3970: l_gen_lpn_tbl WMS_Data_Type_Definitions_PUB.LPNTableType;
3971:
3972: BEGIN

Line 3969: l_serial_tbl WMS_Data_Type_Definitions_PUB.SerialRangeTableType;

3965: l_lpn_suffix VARCHAR2(50);
3966: l_wms_org_flag BOOLEAN;
3967:
3968: l_lpn_att_rec WMS_Data_Type_Definitions_PUB.LPNRecordType;
3969: l_serial_tbl WMS_Data_Type_Definitions_PUB.SerialRangeTableType;
3970: l_gen_lpn_tbl WMS_Data_Type_Definitions_PUB.LPNTableType;
3971:
3972: BEGIN
3973: IF (l_debug = 1) THEN

Line 3970: l_gen_lpn_tbl WMS_Data_Type_Definitions_PUB.LPNTableType;

3966: l_wms_org_flag BOOLEAN;
3967:
3968: l_lpn_att_rec WMS_Data_Type_Definitions_PUB.LPNRecordType;
3969: l_serial_tbl WMS_Data_Type_Definitions_PUB.SerialRangeTableType;
3970: l_gen_lpn_tbl WMS_Data_Type_Definitions_PUB.LPNTableType;
3971:
3972: BEGIN
3973: IF (l_debug = 1) THEN
3974: mdebug('Generate_LPN_CP Entered '|| g_pkg_version, 1);

Line 4188: l_lpn_att_rec WMS_Data_Type_Definitions_PUB.LPNRecordType;

4184: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4185: l_progress VARCHAR2(10) := '0';
4186:
4187: l_ucc_128_suffix_flag VARCHAR2(1);
4188: l_lpn_att_rec WMS_Data_Type_Definitions_PUB.LPNRecordType;
4189: l_serial_tbl WMS_Data_Type_Definitions_PUB.SerialRangeTableType;
4190: l_gen_lpn_tbl WMS_Data_Type_Definitions_PUB.LPNTableType;
4191: l_lpn_bulk_rec LPNBulkRecType;
4192:

Line 4189: l_serial_tbl WMS_Data_Type_Definitions_PUB.SerialRangeTableType;

4185: l_progress VARCHAR2(10) := '0';
4186:
4187: l_ucc_128_suffix_flag VARCHAR2(1);
4188: l_lpn_att_rec WMS_Data_Type_Definitions_PUB.LPNRecordType;
4189: l_serial_tbl WMS_Data_Type_Definitions_PUB.SerialRangeTableType;
4190: l_gen_lpn_tbl WMS_Data_Type_Definitions_PUB.LPNTableType;
4191: l_lpn_bulk_rec LPNBulkRecType;
4192:
4193: BEGIN

Line 4190: l_gen_lpn_tbl WMS_Data_Type_Definitions_PUB.LPNTableType;

4186:
4187: l_ucc_128_suffix_flag VARCHAR2(1);
4188: l_lpn_att_rec WMS_Data_Type_Definitions_PUB.LPNRecordType;
4189: l_serial_tbl WMS_Data_Type_Definitions_PUB.SerialRangeTableType;
4190: l_gen_lpn_tbl WMS_Data_Type_Definitions_PUB.LPNTableType;
4191: l_lpn_bulk_rec LPNBulkRecType;
4192:
4193: BEGIN
4194: SAVEPOINT GENERATE_LPN_PVT;

Line 4356: l_lpn_tbl WMS_Data_Type_Definitions_PUB.LPNTableType;

4352: l_api_name CONSTANT VARCHAR2(30) := 'Associate_LPN';
4353: l_api_version CONSTANT NUMBER := 1.0;
4354: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4355:
4356: l_lpn_tbl WMS_Data_Type_Definitions_PUB.LPNTableType;
4357: BEGIN
4358: -- Standard Start of API savepoint
4359: SAVEPOINT ASSOCIATE_LPN_PVT;
4360:

Line 4483: l_lpn_tbl WMS_Data_Type_Definitions_PUB.LPNTableType;

4479: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4480: l_progress VARCHAR2(10) := '0';
4481: l_msgdata VARCHAR2(1000);
4482:
4483: l_lpn_tbl WMS_Data_Type_Definitions_PUB.LPNTableType;
4484:
4485: BEGIN
4486: -- Standard Start of API savepoint
4487: SAVEPOINT CREATE_LPN_PVT;

Line 4635: l_lpn_tbl WMS_Data_Type_Definitions_PUB.LPNTableType;

4631: l_wsh_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;
4632: l_wsh_defaults WSH_GLBL_VAR_STRCT_GRP.dd_default_parameters_rec_type;
4633: l_wsh_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;
4634:
4635: l_lpn_tbl WMS_Data_Type_Definitions_PUB.LPNTableType;
4636: l_new WMS_Data_Type_Definitions_PUB.LPNRecordType;
4637: l_cont_new WMS_Data_Type_Definitions_PUB.LPNRecordType;
4638:
4639: l_tmp_bulk_lpns LPNBulkRecType;

Line 4636: l_new WMS_Data_Type_Definitions_PUB.LPNRecordType;

4632: l_wsh_defaults WSH_GLBL_VAR_STRCT_GRP.dd_default_parameters_rec_type;
4633: l_wsh_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;
4634:
4635: l_lpn_tbl WMS_Data_Type_Definitions_PUB.LPNTableType;
4636: l_new WMS_Data_Type_Definitions_PUB.LPNRecordType;
4637: l_cont_new WMS_Data_Type_Definitions_PUB.LPNRecordType;
4638:
4639: l_tmp_bulk_lpns LPNBulkRecType;
4640: l_tmp_i NUMBER;

Line 4637: l_cont_new WMS_Data_Type_Definitions_PUB.LPNRecordType;

4633: l_wsh_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;
4634:
4635: l_lpn_tbl WMS_Data_Type_Definitions_PUB.LPNTableType;
4636: l_new WMS_Data_Type_Definitions_PUB.LPNRecordType;
4637: l_cont_new WMS_Data_Type_Definitions_PUB.LPNRecordType;
4638:
4639: l_tmp_bulk_lpns LPNBulkRecType;
4640: l_tmp_i NUMBER;
4641:

Line 6434: l_lpn_table WMS_Data_Type_Definitions_PUB.LPNTableType;

6430: ) IS
6431: l_api_name CONSTANT VARCHAR2(30) := 'Modify_LPN';
6432: l_api_version CONSTANT NUMBER := 1.0;
6433:
6434: l_lpn_table WMS_Data_Type_Definitions_PUB.LPNTableType;
6435:
6436: BEGIN
6437:
6438: l_lpn_table(1).lpn_id := p_lpn.lpn_id;

Line 6535: l_lpn WMS_Data_Type_Definitions_PUB.LPNTableType;

6531: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6532: l_progress VARCHAR2(10) := '0';
6533: l_msgdata VARCHAR2(1000);
6534:
6535: l_lpn WMS_Data_Type_Definitions_PUB.LPNTableType;
6536:
6537: BEGIN
6538: -- Standard Start of API savepoint
6539: SAVEPOINT MODIFY_LPN_WRAPPER_PVT;