APPS.JAI_PO_OSP_PKG dependencies on JAI_PO_OSP_LINES_S

Line 211: SELECT JAI_PO_OSP_LINES_S.NEXTVAL

207: FROM dual;
208:
209: --******************FETCHING LINE ID FROM SEQUENCE************
210: CURSOR c_line_id IS
211: SELECT JAI_PO_OSP_LINES_S.NEXTVAL
212: FROM dual;
213: --*****************OSP RETURN DAYS****************************
214: CURSOR c_osp_days(cp_org_id NUMBER) IS
215: SELECT osp_return_days, osp_excise_percent

Line 837: UPDATE JAI_PO_OSP_LINES set dispatched_qty = dispatched_qty - i_rec.despatch_qty

833: THEN
834:
835: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','1.2 Before Update ');
836:
837: UPDATE JAI_PO_OSP_LINES set dispatched_qty = dispatched_qty - i_rec.despatch_qty
838: where form_id = i_rec.primary_form_id
839: and item_id = i_rec.item_id
840: and po_line_id = i_rec.po_line_id;
841:

Line 1199: JAI_PO_OSP_LINES_S.nextval,

1195: BAL_PARENT_ITEM_QTY,
1196: SOURCE_CODE
1197: ) VALUES(
1198: v_form_id,
1199: JAI_PO_OSP_LINES_S.nextval,
1200: v_po_line,
1201: v_po_dist,
1202: v_item_id,
1203: v_wip_entity,