APPS.WMS_CARTNZN_PUB dependencies on WMS_PACKAGING_HIST

Line 186: -- wms_packaging_hist on every insert

182:
183: api_table inv_rcv_common_apis.trans_rec_tb_tp;
184:
185: -- This value is incremented and inserted into sequence_id of the table
186: -- wms_packaging_hist on every insert
187: --sequence_id NUMBER := 1;
188:
189: -- Keeps track of what level we are currently cartonizing
190: pack_level NUMBER := 0;

Line 1612: WMS_PACKAGING_HIST

1608: content_volume_uom_code,
1609: Decode(tare_weight_uom_code,NULL,0,nvl(tare_weight,0)),
1610: tare_weight_uom_code
1611: FROM
1612: WMS_PACKAGING_HIST
1613: WHERE
1614: PARENT_PACKAGE_id = p_package_id;
1615: BEGIN
1616: if (g_trace_on = 1) then log_event(' Entered get label attributes for package:'||p_package_id); END IF;

Line 1657: WMS_PACKAGING_HIST

1653: parent_item_id
1654: INTO
1655: x_inventory_item_id
1656: FROM
1657: WMS_PACKAGING_HIST
1658: WHERE
1659: PARENT_PACKAGE_id = p_package_id
1660: AND rownum < 2;
1661:

Line 1956: FROM WMS_PACKAGING_HIST

1952: RETURN cache_pkg_item_id;
1953: ELSE
1954: SELECT PARENT_ITEM_ID
1955: INTO l_ret
1956: FROM WMS_PACKAGING_HIST
1957: WHERE
1958: PARENT_PACKAGE_id = p_PACKAGE_id
1959: AND rownum < 2;
1960:

Line 2221: INSERT INTO WMS_PACKAGING_HIST

2217: log_event('gross weight '||l_gross_weight);
2218: log_event('content_volume '||l_content_volume);
2219: END IF;
2220:
2221: INSERT INTO WMS_PACKAGING_HIST
2222: (
2223: organization_id,
2224: header_id,
2225: sequence_id,

Line 2299: INSERT INTO WMS_PACKAGING_HIST

2295: x_tare_weight_uom_code => l_tare_weight_uom_code
2296: );
2297:
2298:
2299: INSERT INTO WMS_PACKAGING_HIST
2300: (organization_id,
2301: header_id,
2302: sequence_id,
2303: pack_level,

Line 2374: INSERT INTO WMS_PACKAGING_HIST

2370: );
2371:
2372:
2373:
2374: INSERT INTO WMS_PACKAGING_HIST
2375: (organization_id,
2376: header_id,
2377: sequence_id,
2378: pack_level,

Line 2481: SELECT wms_packaging_hist_s.nextVal into

2477: l_package_sequence NUMBER;
2478: BEGIN
2479:
2480: if (g_trace_on = 1) then log_event(' In get next package id'); END IF;
2481: SELECT wms_packaging_hist_s.nextVal into
2482: l_package_sequence FROM dual;
2483:
2484: RETURN l_package_sequence;
2485:

Line 2499: wms_packaging_hist wph

2495: wph.parent_lpn_id,
2496: Decode(wph.tare_weight_uom_code,NULL,0,Nvl(wph.tare_weight,0)) tare_weight,
2497: wph.tare_weight_uom_code
2498: FROM
2499: wms_packaging_hist wph
2500: WHERE
2501: header_id = p_header_id AND
2502: organization_id = p_organization_id AND
2503: parent_lpn_id IS NOT NULL

Line 2822: FROM wms_packaging_hist

2818:
2819:
2820: BEGIN
2821: SELECT parent_lpn_id INTO par_lpn_id
2822: FROM wms_packaging_hist
2823: WHERE
2824: parent_package_id = cart_id AND
2825: header_id = p_header_id AND
2826: ROWNUM < 2;

Line 2876: UPDATE WMS_PACKAGING_HIST

2872:
2873: if (g_trace_on = 1) then log_event('updated wms_cartonization_temp for temp id '||orig_temp_id); END IF;
2874:
2875:
2876: UPDATE WMS_PACKAGING_HIST
2877: SET parent_lpn_id = v_lpn_id_out
2878: --parent_package_id = NULL
2879: WHERE
2880: parent_package_id = cart_id;

Line 2882: if (g_trace_on = 1) then log_event('updated WMS_PACKAGING_HIST for package_id '||cart_id); END IF;

2878: --parent_package_id = NULL
2879: WHERE
2880: parent_package_id = cart_id;
2881:
2882: if (g_trace_on = 1) then log_event('updated WMS_PACKAGING_HIST for package_id '||cart_id); END IF;
2883:
2884:
2885:
2886: END IF; -- l_return_status <> fnd_api.g_ret_sts_success

Line 2908: UPDATE wms_packaging_hist

2904: END IF;
2905:
2906: if (g_trace_on = 1) then log_event('updating packaging history'); END IF;
2907:
2908: UPDATE wms_packaging_hist
2909: SET parent_package_id = NULL
2910: WHERE
2911: parent_lpn_id IS NOT NULL AND
2912: parent_package_id IS NOT NULL AND