APPS.WMS_CARTNZN_PUB dependencies on WMS_PACKAGING_HIST

Line 110: -- wms_packaging_hist on every insert

106:
107: api_table inv_rcv_common_apis.trans_rec_tb_tp;
108:
109: -- This value is incremented and inserted into sequence_id of the table
110: -- wms_packaging_hist on every insert
111: --sequence_id NUMBER := 1;
112:
113:
114: dummy_header_id NUMBER := -1;

Line 1519: WMS_PACKAGING_HIST

1515: content_volume_uom_code,
1516: Decode(tare_weight_uom_code,NULL,0,nvl(tare_weight,0)),
1517: tare_weight_uom_code
1518: FROM
1519: WMS_PACKAGING_HIST
1520: WHERE
1521: PARENT_PACKAGE_id = p_package_id;
1522: BEGIN
1523: if (g_trace_on = 1) then log_event(' Entered get label attributes for package:'||p_package_id); END IF;

Line 1564: WMS_PACKAGING_HIST

1560: parent_item_id
1561: INTO
1562: x_inventory_item_id
1563: FROM
1564: WMS_PACKAGING_HIST
1565: WHERE
1566: PARENT_PACKAGE_id = p_package_id
1567: AND rownum < 2;
1568:

Line 1863: FROM WMS_PACKAGING_HIST

1859: RETURN cache_pkg_item_id;
1860: ELSE
1861: SELECT PARENT_ITEM_ID
1862: INTO l_ret
1863: FROM WMS_PACKAGING_HIST
1864: WHERE
1865: PARENT_PACKAGE_id = p_PACKAGE_id
1866: AND rownum < 2;
1867:

Line 2196: INSERT INTO WMS_PACKAGING_HIST

2192: log_event('gross weight '||l_gross_weight);
2193: log_event('content_volume '||l_content_volume);
2194: END IF;
2195:
2196: INSERT INTO WMS_PACKAGING_HIST
2197: (
2198: organization_id,
2199: header_id,
2200: sequence_id,

Line 2274: INSERT INTO WMS_PACKAGING_HIST

2270: x_tare_weight_uom_code => l_tare_weight_uom_code
2271: );
2272:
2273:
2274: INSERT INTO WMS_PACKAGING_HIST
2275: (organization_id,
2276: header_id,
2277: sequence_id,
2278: pack_level,

Line 2349: INSERT INTO WMS_PACKAGING_HIST

2345: );
2346:
2347:
2348:
2349: INSERT INTO WMS_PACKAGING_HIST
2350: (organization_id,
2351: header_id,
2352: sequence_id,
2353: pack_level,

Line 2456: SELECT wms_packaging_hist_s.nextVal into

2452: l_package_sequence NUMBER;
2453: BEGIN
2454:
2455: if (g_trace_on = 1) then log_event(' In get next package id'); END IF;
2456: SELECT wms_packaging_hist_s.nextVal into
2457: l_package_sequence FROM dual;
2458:
2459: RETURN l_package_sequence;
2460:

Line 2474: wms_packaging_hist wph

2470: wph.parent_lpn_id,
2471: Decode(wph.tare_weight_uom_code,NULL,0,Nvl(wph.tare_weight,0)) tare_weight,
2472: wph.tare_weight_uom_code
2473: FROM
2474: wms_packaging_hist wph
2475: WHERE
2476: header_id = p_header_id AND
2477: organization_id = p_organization_id AND
2478: parent_lpn_id IS NOT NULL

Line 2801: FROM wms_packaging_hist

2797:
2798:
2799: BEGIN
2800: SELECT parent_lpn_id INTO par_lpn_id
2801: FROM wms_packaging_hist
2802: WHERE
2803: parent_package_id = cart_id AND
2804: header_id = p_header_id AND
2805: ROWNUM < 2;

Line 2856: UPDATE WMS_PACKAGING_HIST

2852:
2853: if (g_trace_on = 1) then log_event('updated wms_cartonization_temp for temp id '||orig_temp_id); END IF;
2854:
2855:
2856: UPDATE WMS_PACKAGING_HIST
2857: SET parent_lpn_id = v_lpn_id_out
2858: --parent_package_id = NULL
2859: WHERE
2860: parent_package_id = cart_id;

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

2858: --parent_package_id = NULL
2859: WHERE
2860: parent_package_id = cart_id;
2861:
2862: if (g_trace_on = 1) then log_event('updated WMS_PACKAGING_HIST for package_id '||cart_id); END IF;
2863:
2864:
2865:
2866: END IF; -- l_return_status <> fnd_api.g_ret_sts_success

Line 2888: UPDATE wms_packaging_hist

2884: END IF;
2885:
2886: if (g_trace_on = 1) then log_event('updating packaging history'); END IF;
2887:
2888: UPDATE wms_packaging_hist
2889: SET parent_package_id = NULL
2890: WHERE
2891: parent_lpn_id IS NOT NULL AND
2892: parent_package_id IS NOT NULL AND