APPS.JAI_OM_WDD_PROCESSING_PKG dependencies on JAI_OM_LC_MATCHINGS

Line 126: JAI_OM_LC_MATCHINGS

122: IS
123: SELECT
124: sum(qty_matched)
125: FROM
126: JAI_OM_LC_MATCHINGS
127: WHERE
128: order_header_id = pr_new.source_header_id AND
129: delivery_detail_id = cp_delivery_detail_id AND
130: release_flag is null;

Line 143: from JAI_OM_LC_MATCHINGS

139: where line_id = pr_new.source_line_id;
140:
141: cursor c_lc_mtch_dlry_line is
142: select order_line_id
143: from JAI_OM_LC_MATCHINGS
144: where delivery_detail_id = v_delivery_detail_id;
145: r_order_line c_order_line%rowtype;
146: r_lc_mtch_dlry_line c_lc_mtch_dlry_line%rowtype;
147:

Line 356: update JAI_OM_LC_MATCHINGS

352: open c_lc_mtch_dlry_line;
353: fetch c_lc_mtch_dlry_line into r_lc_mtch_dlry_line;
354: close c_lc_mtch_dlry_line;
355: if pr_new.source_line_id <> r_lc_mtch_dlry_line.order_line_id then
356: update JAI_OM_LC_MATCHINGS
357: set order_line_id = pr_new.source_line_id
358: where delivery_detail_id = v_delivery_detail_id
359: and release_flag is null;
360: end if;