APPS.JAI_PO_OSP_PKG dependencies on JAI_PO_OSP_LINES

Line 126: from JAI_PO_OSP_HDRS hdr , JAI_PO_OSP_LINES lines

122: lv_src_pur_ord JAI_PO_OSP_HDRS.SOURCE%type;
123:
124: cursor c_check_57f4_exists is
125: select 1
126: from JAI_PO_OSP_HDRS hdr , JAI_PO_OSP_LINES lines
127: where hdr.form_id = lines.form_id
128: AND hdr.po_header_id = p_po_header_id
129: AND (
130: ( p_called_from = lv_called_po --'PO' /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/

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 615: INSERT INTO JAI_PO_OSP_LINES (

611:
612: END IF; /* outside_operation_uom_type */ --2
613: END IF; /* lv_source_code ='W' */ --1
614:
615: INSERT INTO JAI_PO_OSP_LINES (
616: FORM_ID ,
617: LINE_ID ,
618: PO_LINE_ID ,
619: PO_DISTRIBUTION_ID ,

Line 700: from JAI_PO_OSP_HDRS hdr, JAI_PO_OSP_LINES dtl

696:
697:
698: cursor c_57f4_lines is
699: select hdr.primary_flag, hdr.primary_form_id, dtl.despatch_qty, dtl.po_line_id, dtl.item_id
700: from JAI_PO_OSP_HDRS hdr, JAI_PO_OSP_LINES dtl
701: where hdr.form_id = dtl.form_id
702: and hdr.form_id = p_form_id;
703:
704: begin

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 1050: INSERT INTO JAI_PO_OSP_LINES (

1046: v_primary_form_id -- cbabu for Bug# 2746952
1047: ) RETURNING form_id into v_form_id;
1048:
1049: lv_statement_id := '14';
1050: INSERT INTO JAI_PO_OSP_LINES (
1051: FORM_ID,
1052: LINE_ID,
1053: PO_LINE_ID,
1054: PO_DISTRIBUTION_ID,

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,

Line 1205: FROM JAI_PO_OSP_LINES

1201: -- , ( despatch_qty - NVL(return_qty,0)) / comp_qty_pa balance_qty
1202: , decode( v_match_type, 1, despatch_qty - NVL(return_qty,0), return_qty ) / comp_qty_pa balance_qty
1203: , despatch_qty / comp_qty_pa despatch_parent_item_qty
1204: -- , po_line_id
1205: FROM JAI_PO_OSP_LINES
1206: WHERE form_id = p_form_id
1207: -- AND bal_parent_item_qty > 0
1208: -- 2746952
1209: AND ( ( v_match_type = 1 AND ( despatch_qty - NVL(return_qty,0) ) > 0 )

Line 1349: FROM JAI_PO_OSP_LINES WHERE form_id = pItemId AND po_line_id = p_po_line_id) LOOP

1345: FOR ii IN /* Bug 7028169. Added by Lakshmi Gopalsami
1346: * selected all the values
1347: */
1348: (SELECT *
1349: FROM JAI_PO_OSP_LINES WHERE form_id = pItemId AND po_line_id = p_po_line_id) LOOP
1350: /* Bug 7028169. Added by Lakshmi Gopalsami
1351: * Added logic for initializing the pl/sql table for
1352: * resource unit type
1353: * We need to proportionate the receipt quantity

Line 1753: UPDATE JAI_PO_OSP_LINES

1749: ||', v_return_qty -> '|| v_temp_qty||', v_left_received_qty -> '|| v_left_received_qty
1750: );
1751: END IF;
1752:
1753: UPDATE JAI_PO_OSP_LINES
1754: SET return_qty = round((nvl(return_qty,0) + nvl(v_ret_fact,1) * v_return_qty), 5),
1755: bal_parent_item_qty = v_bal_qty,
1756: last_update_date = sysdate,
1757: last_updated_by = p_last_updated_by,