APPS.JAI_OM_WDD_TRIGGER_PKG dependencies on JAI_WSH_DEL_DETAILS_GT

Line 501: FROM jai_wsh_del_details_gt

497: --Added cursor by JMEENA for bug#6731913
498: CURSOR cur_tot_shipped_quantity (cp_delivery_detail_id IN NUMBER)
499: IS
500: SELECT sum ( shipped_quantity)
501: FROM jai_wsh_del_details_gt
502: WHERE delivery_detail_id = cp_delivery_detail_id
503: OR split_from_delivery_detail_id = cp_delivery_detail_id;
504: v_tot_lc_shipped_qty NUMBER;
505: ln_cnt NUMBER;

Line 721: table JAI_WSH_DEL_DETAILS_GT is created.

717:
718: 19. 25-JUN-2009 JMEENA for bug#6731913
719: Issue: INDIA LOCAL: SHIP CONFIRM GIVES LC MATCH ERROR EVEN AFTER MATCHING IS DONE
720: Fix: The fix inlvoves a lot of modification in the code. A new procedure ARU_T4 and temp
721: table JAI_WSH_DEL_DETAILS_GT is created.
722: This table gets populated when the shipped_quantity gets updated. Then when the released Quantity changes to 'C'
723: the shipped quantity is calculated from this temp table. Then finally the table gets flushed after all the
724: records are processed.
725: Commented LC Matching code in procedure ARU_T3 as it exists in ARU_T2.

Line 1106: Update jai_wsh_del_details_gt

1102: ; return ;
1103: END IF;
1104: END IF;
1105:
1106: Update jai_wsh_del_details_gt
1107: set processed_flag = 'Y'
1108: where delivery_detail_id = pr_new.delivery_detail_id;
1109: --End bug#6731913
1110:

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

1145: || End of bug 4566002
1146: */
1147: --Added below code by JMEENA for bug#6731913
1148: IF NVL(v_check_lc_order,'N') = 'Y' THEN
1149: select count(1) into ln_unprocessed_recs from jai_wsh_del_details_gt
1150: where processed_flag = 'N'
1151: --modified for bug#6443738
1152: AND (delivery_detail_id = nvl(pr_new.SPLIT_FROM_DELIVERY_DETAIL_ID,pr_new.delivery_detail_id )
1153: OR split_from_delivery_detail_id = nvl(pr_new.SPLIT_FROM_DELIVERY_DETAIL_ID,pr_new.delivery_detail_id));

Line 1156: delete jai_wsh_del_details_gt

1152: AND (delivery_detail_id = nvl(pr_new.SPLIT_FROM_DELIVERY_DETAIL_ID,pr_new.delivery_detail_id )
1153: OR split_from_delivery_detail_id = nvl(pr_new.SPLIT_FROM_DELIVERY_DETAIL_ID,pr_new.delivery_detail_id));
1154:
1155: IF ln_unprocessed_recs = 0 THEN
1156: delete jai_wsh_del_details_gt
1157: where processed_flag = 'Y'
1158: --modified for bug#6443738
1159: and (delivery_detail_id = nvl(pr_new.SPLIT_FROM_DELIVERY_DETAIL_ID,pr_new.delivery_detail_id )
1160: OR split_from_delivery_detail_id = nvl(pr_new.SPLIT_FROM_DELIVERY_DETAIL_ID,pr_new.delivery_detail_id));

Line 3587: from jai_wsh_del_details_gt

3583:
3584: IF nvl(pr_new.SHIPPED_QUANTITY,0) <> nvl(pr_old.SHIPPED_QUANTITY,0) THEN
3585:
3586: Select count(delivery_detail_id) into ln_cnt
3587: from jai_wsh_del_details_gt
3588: Where delivery_detail_id = pr_new.delivery_detail_id;
3589:
3590: IF nvl(ln_cnt,0) > 0 THEN
3591: Update jai_wsh_del_details_gt

Line 3591: Update jai_wsh_del_details_gt

3587: from jai_wsh_del_details_gt
3588: Where delivery_detail_id = pr_new.delivery_detail_id;
3589:
3590: IF nvl(ln_cnt,0) > 0 THEN
3591: Update jai_wsh_del_details_gt
3592: set shipped_quantity = pr_new.shipped_quantity
3593: where delivery_detail_id = pr_new.delivery_detail_id;
3594:
3595: ELSE

Line 3596: Insert into jai_wsh_del_details_gt(

3592: set shipped_quantity = pr_new.shipped_quantity
3593: where delivery_detail_id = pr_new.delivery_detail_id;
3594:
3595: ELSE
3596: Insert into jai_wsh_del_details_gt(
3597: delivery_detail_id,
3598: organization_id ,
3599: inventory_item_id,
3600: source_header_type_id,