APPS.JAI_PO_OSP_PKG dependencies on JAI_PO_OSP_LINES_S

Line 153: SELECT JAI_PO_OSP_LINES_S.NEXTVAL

149: FROM dual;
150:
151: --******************FETCHING LINE ID FROM SEQUENCE************
152: CURSOR c_line_id IS
153: SELECT JAI_PO_OSP_LINES_S.NEXTVAL
154: FROM dual;
155: --*****************OSP RETURN DAYS****************************
156: CURSOR c_osp_days(cp_org_id NUMBER) IS
157: SELECT osp_return_days, osp_excise_percent

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

715:
716:
717: FOR i_rec in c_57f4_lines LOOP
718: IF nvl(i_rec.primary_flag,'N') = 'N' THEN
719: UPDATE JAI_PO_OSP_LINES set dispatched_qty = dispatched_qty - i_rec.despatch_qty
720: where form_id = i_rec.primary_form_id
721: and item_id = i_rec.item_id
722: and po_line_id = i_rec.po_line_id;
723: END IF;

Line 1077: JAI_PO_OSP_LINES_S.nextval,

1073: BAL_PARENT_ITEM_QTY,
1074: SOURCE_CODE
1075: ) VALUES(
1076: v_form_id,
1077: JAI_PO_OSP_LINES_S.nextval,
1078: v_po_line,
1079: v_po_dist,
1080: v_item_id,
1081: v_wip_entity,