APPS.JAI_OM_WDD_PROCESSING_PKG dependencies on JAI_WSH_DEL_DETAILS_GT

Line 205: FROM jai_wsh_del_details_gt

201:
202: CURSOR cur_tot_shipped_quantity (cp_delivery_detail_id IN NUMBER)
203: IS
204: SELECT sum ( shipped_quantity)
205: FROM jai_wsh_del_details_gt
206: WHERE delivery_detail_id = cp_delivery_detail_id
207: OR split_from_delivery_detail_id = cp_delivery_detail_id;
208: v_tot_lc_shipped_qty NUMBER;
209: ln_unprocessed_recs NUMBER;

Line 343: Update jai_wsh_del_details_gt

339: return ;
340: END IF;
341: END IF;
342:
343: Update jai_wsh_del_details_gt
344: set processed_flag = 'Y'
345: where delivery_detail_id = pr_new.delivery_detail_id;
346:
347: open c_order_line;

Line 366: select count(1) into ln_unprocessed_recs from jai_wsh_del_details_gt

362: END IF;
363: END IF;
364:
365: IF NVL(v_check_lc_order,'N') = 'Y' THEN
366: select count(1) into ln_unprocessed_recs from jai_wsh_del_details_gt
367: where processed_flag = 'N'
368: AND (delivery_detail_id = nvl(pr_new.SPLIT_FROM_DELIVERY_DETAIL_ID,pr_new.delivery_detail_id )
369: OR split_from_delivery_detail_id = nvl(pr_new.SPLIT_FROM_DELIVERY_DETAIL_ID,pr_new.delivery_detail_id));
370:

Line 372: delete jai_wsh_del_details_gt

368: AND (delivery_detail_id = nvl(pr_new.SPLIT_FROM_DELIVERY_DETAIL_ID,pr_new.delivery_detail_id )
369: OR split_from_delivery_detail_id = nvl(pr_new.SPLIT_FROM_DELIVERY_DETAIL_ID,pr_new.delivery_detail_id));
370:
371: IF ln_unprocessed_recs = 0 THEN
372: delete jai_wsh_del_details_gt
373: where processed_flag = 'Y'
374: and (delivery_detail_id = nvl(pr_new.SPLIT_FROM_DELIVERY_DETAIL_ID,pr_new.delivery_detail_id )
375: OR split_from_delivery_detail_id = nvl(pr_new.SPLIT_FROM_DELIVERY_DETAIL_ID,pr_new.delivery_detail_id));
376:

Line 2656: from jai_wsh_del_details_gt

2652:
2653: IF NVL(v_check_lc_order,'N') = 'Y' THEN
2654:
2655: Select count(delivery_detail_id) into ln_cnt
2656: from jai_wsh_del_details_gt
2657: Where delivery_detail_id = pr_new.delivery_detail_id;
2658:
2659: IF nvl(ln_cnt,0) > 0 THEN
2660: Update jai_wsh_del_details_gt

Line 2660: Update jai_wsh_del_details_gt

2656: from jai_wsh_del_details_gt
2657: Where delivery_detail_id = pr_new.delivery_detail_id;
2658:
2659: IF nvl(ln_cnt,0) > 0 THEN
2660: Update jai_wsh_del_details_gt
2661: set shipped_quantity = pr_new.shipped_quantity
2662: where delivery_detail_id = pr_new.delivery_detail_id;
2663:
2664: ELSE

Line 2665: INSERT INTO jai_wsh_del_details_gt( delivery_detail_id,

2661: set shipped_quantity = pr_new.shipped_quantity
2662: where delivery_detail_id = pr_new.delivery_detail_id;
2663:
2664: ELSE
2665: INSERT INTO jai_wsh_del_details_gt( delivery_detail_id,
2666: organization_id ,
2667: inventory_item_id,
2668: source_header_type_id,
2669: shipped_quantity,