DBA Data[Home] [Help]

APPS.GML_PO_SYNCH dependencies on PO_LINES_ALL

Line 280: | po_id and return line_num from po_lines all instead of the

276: | |
277: | MODIFICATION HISTORY |
278: | 10/27/97 Kenny Jiang created |
279: | 03/24/00 NC - modified the procedure to accept po_line_id instead of
280: | po_id and return line_num from po_lines all instead of the
281: | max(line_no) from po_ordr_dtl.TAR #12693733.6
282: | (Bug#1249797 base bug#1247332.
283: | 15/05/00 NC - Added code to take care of line numbering for Planned and|
284: | Blanket POS and in case of more than one shipment per |

Line 317: FROM po_lines_all

313:
314: ELSE /* STANDARD */
315: SELECT count(*)
316: INTO v_line_count
317: FROM po_lines_all
318: WHERE po_header_id = v_po_header_id;
319:
320: SELECT count(*)
321: INTO v_shipment_count

Line 328: FROM po_lines_all

324:
325: IF v_line_count = v_shipment_count THEN
326: SELECT line_num
327: INTO v_line_no
328: FROM po_lines_all
329: WHERE po_line_id = v_po_line_id;
330: ELSE
331: SELECT NVL(MAX(line_no),0) +1
332: INTO v_line_no

Line 552: FROM po_lines_all

548: WHERE orgn_code = v_orgn_code;
549:
550: CURSOR line_no_cur IS
551: SELECT line_num
552: FROM po_lines_all
553: WHERE po_line_id = v_line_id;
554:
555: CURSOR shipment_cur IS
556: SELECT shipment_num

Line 1454: CURSOR po_lines_all_cur

1450:
1451: /* END BUG#1731582 */
1452:
1453: /* Uday Phadtare B2085936 */
1454: CURSOR po_lines_all_cur
1455: ( v_ordr_header_id PO_LINE_LOCATIONS_ALL.PO_HEADER_ID%TYPE,
1456: v_line_id PO_LINES_ALL.po_line_id%TYPE) IS
1457: SELECT substrb(item_description,1,70)
1458: FROM po_lines_all

Line 1456: v_line_id PO_LINES_ALL.po_line_id%TYPE) IS

1452:
1453: /* Uday Phadtare B2085936 */
1454: CURSOR po_lines_all_cur
1455: ( v_ordr_header_id PO_LINE_LOCATIONS_ALL.PO_HEADER_ID%TYPE,
1456: v_line_id PO_LINES_ALL.po_line_id%TYPE) IS
1457: SELECT substrb(item_description,1,70)
1458: FROM po_lines_all
1459: WHERE po_header_id = v_ordr_header_id
1460: AND po_line_id = v_line_id;

Line 1458: FROM po_lines_all

1454: CURSOR po_lines_all_cur
1455: ( v_ordr_header_id PO_LINE_LOCATIONS_ALL.PO_HEADER_ID%TYPE,
1456: v_line_id PO_LINES_ALL.po_line_id%TYPE) IS
1457: SELECT substrb(item_description,1,70)
1458: FROM po_lines_all
1459: WHERE po_header_id = v_ordr_header_id
1460: AND po_line_id = v_line_id;
1461:
1462:

Line 2173: OPEN po_lines_all_cur (int_rec.po_header_id, int_rec.po_line_id);

2169: FETCH item_cur INTO v_item_id, v_item_desc,v_item_um1, v_item_um2, v_dualum_ind,v_noninv_ind;
2170: CLOSE item_cur;
2171:
2172: /* Bug 1857224 */
2173: OPEN po_lines_all_cur (int_rec.po_header_id, int_rec.po_line_id);
2174: FETCH po_lines_all_cur INTO v_item_desc;
2175: CLOSE po_lines_all_cur;
2176: /* End Bug 1857224 */
2177:

Line 2174: FETCH po_lines_all_cur INTO v_item_desc;

2170: CLOSE item_cur;
2171:
2172: /* Bug 1857224 */
2173: OPEN po_lines_all_cur (int_rec.po_header_id, int_rec.po_line_id);
2174: FETCH po_lines_all_cur INTO v_item_desc;
2175: CLOSE po_lines_all_cur;
2176: /* End Bug 1857224 */
2177:
2178:

Line 2175: CLOSE po_lines_all_cur;

2171:
2172: /* Bug 1857224 */
2173: OPEN po_lines_all_cur (int_rec.po_header_id, int_rec.po_line_id);
2174: FETCH po_lines_all_cur INTO v_item_desc;
2175: CLOSE po_lines_all_cur;
2176: /* End Bug 1857224 */
2177:
2178:
2179: /*modified int_rec.po_no to v_po_no*/