[Home] [Help]
117: 2)Cursor c_discrete_bill_seq_id (and its use) is removed. Data
118: from the po_dist record will be used instead.
119: 3)Modified the filter condition in the cursor of c_component_rec.
120: 9. 23-Jul-2009 Bug 8678948 AFTER RTV PRIMARY FORM IN APPROVE 57F4 CHALLAN NOT ABLE TO APPROVE THE DISPATCH.
121: issue : The original_qty column is not populated in the table JAI_PO_OSP_LINES in the procedure
122: create_rcv_57f4
123: Fix: populated rtv_qty in the column original_qty
124: ----------------------------------------------------------------------------------------*/
125: /* Added by Ramananda for removal of SQL LITERALs */
180: lv_src_pur_ord JAI_PO_OSP_HDRS.SOURCE%type;
181:
182: cursor c_check_57f4_exists is
183: select 1
184: from JAI_PO_OSP_HDRS hdr , JAI_PO_OSP_LINES lines
185: where hdr.form_id = lines.form_id
186: AND hdr.po_header_id = p_po_header_id
187: AND (
188: ( p_called_from = lv_called_po --'PO' /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
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
722: /*end bug 8220196*/
723: END IF; /* lv_source_code ='W' */ --1
724: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','13 ln_despatch_quantity '||ln_despatch_quantity||' ');
725:
726: INSERT INTO JAI_PO_OSP_LINES (
727: FORM_ID ,
728: LINE_ID ,
729: PO_LINE_ID ,
730: PO_DISTRIBUTION_ID ,
807:
808:
809: cursor c_57f4_lines is
810: select hdr.primary_flag, hdr.primary_form_id, dtl.despatch_qty, dtl.po_line_id, dtl.item_id, dtl.form_id, hdr.form_number -- added from number for 13541366
811: from JAI_PO_OSP_HDRS hdr, JAI_PO_OSP_LINES dtl
812: where hdr.form_id = dtl.form_id
813: and hdr.form_id = p_form_id;
814:
815: begin
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:
1167: v_primary_form_id -- cbabu for Bug# 2746952
1168: ) RETURNING form_id into v_form_id;
1169:
1170: lv_statement_id := '14';
1171: INSERT INTO JAI_PO_OSP_LINES (
1172: FORM_ID,
1173: LINE_ID,
1174: PO_LINE_ID,
1175: PO_DISTRIBUTION_ID,
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,
1324: -- , ( despatch_qty - NVL(return_qty,0)) / comp_qty_pa balance_qty
1325: , decode( v_match_type, 1, despatch_qty - NVL(return_qty,0), return_qty ) / comp_qty_pa balance_qty
1326: , despatch_qty / comp_qty_pa despatch_parent_item_qty
1327: -- , po_line_id
1328: FROM JAI_PO_OSP_LINES
1329: WHERE form_id = p_form_id
1330: -- AND bal_parent_item_qty > 0
1331: -- 2746952
1332: AND ( ( v_match_type = 1 AND ( despatch_qty - NVL(return_qty,0) ) > 0 )
1355:
1356: CURSOR c_pr_form_lines(v_primary_form_id Number)
1357: IS
1358: Select item_uom, source_code
1359: from jai_po_osp_lines
1360: where form_id = v_primary_form_id
1361: and po_line_id = p_po_line_id;
1362:
1363:
1494: FOR ii IN /* Bug 7028169. Added by Lakshmi Gopalsami
1495: * selected all the values
1496: */
1497: (SELECT *
1498: FROM JAI_PO_OSP_LINES WHERE form_id = pItemId AND po_line_id = p_po_line_id) LOOP
1499: /* Bug 7028169. Added by Lakshmi Gopalsami
1500: * Added logic for initializing the pl/sql table for
1501: * resource unit type
1502: * We need to proportionate the receipt quantity
2034: ||', v_return_qty -> '|| v_temp_qty||', v_left_received_qty -> '|| v_left_received_qty
2035: );
2036: END IF;
2037:
2038: UPDATE JAI_PO_OSP_LINES
2039: SET return_qty = round((nvl(return_qty,0) + nvl(v_ret_fact,1) * v_return_qty), 5),
2040: bal_parent_item_qty = v_bal_qty,
2041: last_update_date = sysdate,
2042: last_updated_by = p_last_updated_by,