eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_NEGOTIATIONS4_PVT dependencies on PO_REQ_SPLIT_LINES_GT

Line 5: po_req_split_lines_gt.auction_header_id%type INDEX BY BINARY_INTEGER;

1: PACKAGE BODY PO_NEGOTIATIONS4_PVT AS
2: /* $Header: POXVNG4B.pls 120.12.12000000.2 2007/05/04 00:05:37 lswamy ship $ */
3:
4: TYPE auction_header_id_tbl_type is TABLE OF
5: po_req_split_lines_gt.auction_header_id%type INDEX BY BINARY_INTEGER;
6: TYPE bid_number_tbl_type is TABLE OF
7: po_req_split_lines_gt.bid_number%type INDEX BY BINARY_INTEGER;
8: TYPE bid_line_number_tbl_type is TABLE OF
9: po_req_split_lines_gt.bid_line_number%type INDEX BY BINARY_INTEGER;

Line 7: po_req_split_lines_gt.bid_number%type INDEX BY BINARY_INTEGER;

3:
4: TYPE auction_header_id_tbl_type is TABLE OF
5: po_req_split_lines_gt.auction_header_id%type INDEX BY BINARY_INTEGER;
6: TYPE bid_number_tbl_type is TABLE OF
7: po_req_split_lines_gt.bid_number%type INDEX BY BINARY_INTEGER;
8: TYPE bid_line_number_tbl_type is TABLE OF
9: po_req_split_lines_gt.bid_line_number%type INDEX BY BINARY_INTEGER;
10: TYPE requisition_header_id_tbl_type is TABLE OF
11: po_req_split_lines_gt.requisition_header_id%type INDEX BY BINARY_INTEGER;

Line 9: po_req_split_lines_gt.bid_line_number%type INDEX BY BINARY_INTEGER;

5: po_req_split_lines_gt.auction_header_id%type INDEX BY BINARY_INTEGER;
6: TYPE bid_number_tbl_type is TABLE OF
7: po_req_split_lines_gt.bid_number%type INDEX BY BINARY_INTEGER;
8: TYPE bid_line_number_tbl_type is TABLE OF
9: po_req_split_lines_gt.bid_line_number%type INDEX BY BINARY_INTEGER;
10: TYPE requisition_header_id_tbl_type is TABLE OF
11: po_req_split_lines_gt.requisition_header_id%type INDEX BY BINARY_INTEGER;
12: TYPE requisition_line_id_tbl_type is TABLE OF
13: po_req_split_lines_gt.requisition_line_id%type INDEX BY BINARY_INTEGER;

Line 11: po_req_split_lines_gt.requisition_header_id%type INDEX BY BINARY_INTEGER;

7: po_req_split_lines_gt.bid_number%type INDEX BY BINARY_INTEGER;
8: TYPE bid_line_number_tbl_type is TABLE OF
9: po_req_split_lines_gt.bid_line_number%type INDEX BY BINARY_INTEGER;
10: TYPE requisition_header_id_tbl_type is TABLE OF
11: po_req_split_lines_gt.requisition_header_id%type INDEX BY BINARY_INTEGER;
12: TYPE requisition_line_id_tbl_type is TABLE OF
13: po_req_split_lines_gt.requisition_line_id%type INDEX BY BINARY_INTEGER;
14: TYPE allocated_qty_tbl_type is TABLE OF
15: po_req_split_lines_gt.allocated_qty%type INDEX BY BINARY_INTEGER;

Line 13: po_req_split_lines_gt.requisition_line_id%type INDEX BY BINARY_INTEGER;

9: po_req_split_lines_gt.bid_line_number%type INDEX BY BINARY_INTEGER;
10: TYPE requisition_header_id_tbl_type is TABLE OF
11: po_req_split_lines_gt.requisition_header_id%type INDEX BY BINARY_INTEGER;
12: TYPE requisition_line_id_tbl_type is TABLE OF
13: po_req_split_lines_gt.requisition_line_id%type INDEX BY BINARY_INTEGER;
14: TYPE allocated_qty_tbl_type is TABLE OF
15: po_req_split_lines_gt.allocated_qty%type INDEX BY BINARY_INTEGER;
16: TYPE new_req_line_id_tbl_type is TABLE OF
17: po_req_split_lines_gt.new_req_line_id%type INDEX BY BINARY_INTEGER;

Line 15: po_req_split_lines_gt.allocated_qty%type INDEX BY BINARY_INTEGER;

11: po_req_split_lines_gt.requisition_header_id%type INDEX BY BINARY_INTEGER;
12: TYPE requisition_line_id_tbl_type is TABLE OF
13: po_req_split_lines_gt.requisition_line_id%type INDEX BY BINARY_INTEGER;
14: TYPE allocated_qty_tbl_type is TABLE OF
15: po_req_split_lines_gt.allocated_qty%type INDEX BY BINARY_INTEGER;
16: TYPE new_req_line_id_tbl_type is TABLE OF
17: po_req_split_lines_gt.new_req_line_id%type INDEX BY BINARY_INTEGER;
18: TYPE new_line_num_tbl_type is TABLE OF
19: po_req_split_lines_gt.new_line_num%type INDEX BY BINARY_INTEGER;

Line 17: po_req_split_lines_gt.new_req_line_id%type INDEX BY BINARY_INTEGER;

13: po_req_split_lines_gt.requisition_line_id%type INDEX BY BINARY_INTEGER;
14: TYPE allocated_qty_tbl_type is TABLE OF
15: po_req_split_lines_gt.allocated_qty%type INDEX BY BINARY_INTEGER;
16: TYPE new_req_line_id_tbl_type is TABLE OF
17: po_req_split_lines_gt.new_req_line_id%type INDEX BY BINARY_INTEGER;
18: TYPE new_line_num_tbl_type is TABLE OF
19: po_req_split_lines_gt.new_line_num%type INDEX BY BINARY_INTEGER;
20: TYPE totallc_req_line_qty_tbl_type is TABLE OF
21: po_req_split_lines_gt.total_alloc_req_line_qty%type INDEX BY BINARY_INTEGER;

Line 19: po_req_split_lines_gt.new_line_num%type INDEX BY BINARY_INTEGER;

15: po_req_split_lines_gt.allocated_qty%type INDEX BY BINARY_INTEGER;
16: TYPE new_req_line_id_tbl_type is TABLE OF
17: po_req_split_lines_gt.new_req_line_id%type INDEX BY BINARY_INTEGER;
18: TYPE new_line_num_tbl_type is TABLE OF
19: po_req_split_lines_gt.new_line_num%type INDEX BY BINARY_INTEGER;
20: TYPE totallc_req_line_qty_tbl_type is TABLE OF
21: po_req_split_lines_gt.total_alloc_req_line_qty%type INDEX BY BINARY_INTEGER;
22: TYPE requisition_line_qty_tbl_type is TABLE OF
23: po_req_split_lines_gt.requisition_line_qty%type INDEX BY BINARY_INTEGER;

Line 21: po_req_split_lines_gt.total_alloc_req_line_qty%type INDEX BY BINARY_INTEGER;

17: po_req_split_lines_gt.new_req_line_id%type INDEX BY BINARY_INTEGER;
18: TYPE new_line_num_tbl_type is TABLE OF
19: po_req_split_lines_gt.new_line_num%type INDEX BY BINARY_INTEGER;
20: TYPE totallc_req_line_qty_tbl_type is TABLE OF
21: po_req_split_lines_gt.total_alloc_req_line_qty%type INDEX BY BINARY_INTEGER;
22: TYPE requisition_line_qty_tbl_type is TABLE OF
23: po_req_split_lines_gt.requisition_line_qty%type INDEX BY BINARY_INTEGER;
24: TYPE min_bid_number_tbl_type is TABLE OF
25: po_req_split_lines_gt.min_bid_number%type INDEX BY BINARY_INTEGER;

Line 23: po_req_split_lines_gt.requisition_line_qty%type INDEX BY BINARY_INTEGER;

19: po_req_split_lines_gt.new_line_num%type INDEX BY BINARY_INTEGER;
20: TYPE totallc_req_line_qty_tbl_type is TABLE OF
21: po_req_split_lines_gt.total_alloc_req_line_qty%type INDEX BY BINARY_INTEGER;
22: TYPE requisition_line_qty_tbl_type is TABLE OF
23: po_req_split_lines_gt.requisition_line_qty%type INDEX BY BINARY_INTEGER;
24: TYPE min_bid_number_tbl_type is TABLE OF
25: po_req_split_lines_gt.min_bid_number%type INDEX BY BINARY_INTEGER;
26: TYPE record_status_tbl_type is TABLE OF
27: po_req_split_lines_gt.record_status%type INDEX BY BINARY_INTEGER;

Line 25: po_req_split_lines_gt.min_bid_number%type INDEX BY BINARY_INTEGER;

21: po_req_split_lines_gt.total_alloc_req_line_qty%type INDEX BY BINARY_INTEGER;
22: TYPE requisition_line_qty_tbl_type is TABLE OF
23: po_req_split_lines_gt.requisition_line_qty%type INDEX BY BINARY_INTEGER;
24: TYPE min_bid_number_tbl_type is TABLE OF
25: po_req_split_lines_gt.min_bid_number%type INDEX BY BINARY_INTEGER;
26: TYPE record_status_tbl_type is TABLE OF
27: po_req_split_lines_gt.record_status%type INDEX BY BINARY_INTEGER;
28: TYPE row_id_tbl_type is TABLE OF rowid INDEX BY BINARY_INTEGER;
29: TYPE min_dist_id_tbl_type is TABLE OF

Line 27: po_req_split_lines_gt.record_status%type INDEX BY BINARY_INTEGER;

23: po_req_split_lines_gt.requisition_line_qty%type INDEX BY BINARY_INTEGER;
24: TYPE min_bid_number_tbl_type is TABLE OF
25: po_req_split_lines_gt.min_bid_number%type INDEX BY BINARY_INTEGER;
26: TYPE record_status_tbl_type is TABLE OF
27: po_req_split_lines_gt.record_status%type INDEX BY BINARY_INTEGER;
28: TYPE row_id_tbl_type is TABLE OF rowid INDEX BY BINARY_INTEGER;
29: TYPE min_dist_id_tbl_type is TABLE OF
30: po_req_distributions.distribution_id%type INDEX BY BINARY_INTEGER;
31: TYPE org_id_tbl_type is TABLE OF

Line 88: FROM po_req_split_lines_gt prs

84: new_line_num_dbg_tbl,
85: totalloc_req_line_qty_dbg_tbl,
86: min_bid_number_dbg_tbl,
87: record_status_dbg_tbl
88: FROM po_req_split_lines_gt prs
89: ORDER BY prs.requisition_header_id,prs.requisition_line_id;
90:
91: FOR l_dbg_index in 1.. requisition_line_id_dbg_tbl.COUNT loop
92: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 130: * Possible values for PO_REQ_SPLIT_LINES_GT.record_status:

126: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
127: * x_msg_count returns count of messages in the stack.
128: * x_msg_data returns message only if 1 message.
129: *
130: * Possible values for PO_REQ_SPLIT_LINES_GT.record_status:
131: * 'S' - Split;
132: * 'N' - New Line(for the remainder which will go back to pool);
133: * 'C' - Cancelled, finally closed, withdrawn, and Req lines with 0 quantity;
134: * 'E' - Equal Allocation;

Line 204: po_req_split_lines_gt prs

200: -- transaction control happens.
201: CURSOR LockReqLines_Cursor IS
202: SELECT prl.requisition_line_id,quantity
203: FROM po_requisition_lines_all prl, --
204: po_req_split_lines_gt prs
205: WHERE prl.requisition_line_id = prs.requisition_line_id
206: FOR UPDATE OF prl.quantity NOWAIT;
207:
208: old_requisition_header_id po_req_split_lines_gt.requisition_header_id%type:=0;

Line 208: old_requisition_header_id po_req_split_lines_gt.requisition_header_id%type:=0;

204: po_req_split_lines_gt prs
205: WHERE prl.requisition_line_id = prs.requisition_line_id
206: FOR UPDATE OF prl.quantity NOWAIT;
207:
208: old_requisition_header_id po_req_split_lines_gt.requisition_header_id%type:=0;
209: l_serial_num number;
210: l_line_num_index number;
211: l_req_encumbrance_flag financials_system_parameters.req_encumbrance_flag%type;
212:

Line 249: FROM po_req_split_lines_gt prs;

245: -- Cursor to find requisition_header_id's of all
246: -- requisition lines being processed
247: CURSOR req_header_id_csr IS
248: SELECT DISTINCT prs.requisition_header_id
249: FROM po_req_split_lines_gt prs;
250:
251: BEGIN
252:
253: l_progress :='000';

Line 305: 'before update po_req_split_lines_gt for quantity and

301: l_progress :='030';
302: l_module := G_MODULE_PREFIX||l_api_name||'.'||'030'||'.';
303: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
304: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
305: 'before update po_req_split_lines_gt for quantity and
306: status ');
307: END IF;
308:
309: --bug# 2729465 mark finally closed lines also with a status 'C'

Line 313: UPDATE po_req_split_lines_gt prs

309: --bug# 2729465 mark finally closed lines also with a status 'C'
310: --Code impact is minimal when all these lines to be discarded are marked
311: --with a single status.
312: --Also removed an unnecessary join using requisition_header_id
313: UPDATE po_req_split_lines_gt prs
314: SET (prs.requisition_line_qty,
315: prs.record_status)=
316: (SELECT quantity,
317: --decode(cancel_flag,'Y','C',null)

Line 328: 'after update po_req_split_lines_gt for quantity and

324: l_progress :='031';
325: l_module := G_MODULE_PREFIX||l_api_name||'.'||'031'||'.';
326: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
327: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
328: 'after update po_req_split_lines_gt for quantity and
329: status; updated '||sql%rowcount||' rows');
330: END IF;
331:
332:

Line 341: 'Exception: update po_req_split_lines_gt for

337: l_progress , sqlcode);
338: FND_MSG_PUB.Add;
339: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
340: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module,
341: 'Exception: update po_req_split_lines_gt for
342: quantity and status ');
343: END IF;
344: RAISE;
345:

Line 364: 'before update po_req_split_lines_gt for withdrawn lines');

360: l_progress :='035';
361: l_module := G_MODULE_PREFIX||l_api_name||'.'||'035'||'.';
362: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
363: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
364: 'before update po_req_split_lines_gt for withdrawn lines');
365: END IF;
366:
367: -- SQL What:update the withdrawn lines in the temp table as 'C'
368: -- SQL Why :These lines are not processed.

Line 369: UPDATE po_req_split_lines_gt prs

365: END IF;
366:
367: -- SQL What:update the withdrawn lines in the temp table as 'C'
368: -- SQL Why :These lines are not processed.
369: UPDATE po_req_split_lines_gt prs
370: SET prs.record_status='C'
371: WHERE NOT EXISTS
372: (SELECT requisition_line_id
373: FROM po_requisition_lines_all prl --

Line 381: 'after update po_req_split_lines_gt for withdrawn lines;

377: l_progress :='036';
378: l_module := G_MODULE_PREFIX||l_api_name||'.'||'036'||'.';
379: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
380: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
381: 'after update po_req_split_lines_gt for withdrawn lines;
382: updated '||sql%rowcount||' rows');
383: END IF;
384:
385: EXCEPTION

Line 393: 'Exception: update po_req_split_lines_gt for

389: l_progress , sqlcode);
390: FND_MSG_PUB.Add;
391: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
392: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module,
393: 'Exception: update po_req_split_lines_gt for
394: withdrawn lines ');
395: END IF;
396: RAISE;
397:

Line 412: 'before update po_req_split_lines_gt for Services lines');

408: l_progress :='037';
409: l_module := G_MODULE_PREFIX||l_api_name||'.'||'037'||'.';
410: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
411: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
412: 'before update po_req_split_lines_gt for Services lines');
413: END IF;
414:
415: -- SQL What: Update Services Lines in the Global Temp Table as 'T'.
416: -- SQL Why : Services Lines are bypassed during the splitting.

Line 418: UPDATE po_req_split_lines_gt PRS

414:
415: -- SQL What: Update Services Lines in the Global Temp Table as 'T'.
416: -- SQL Why : Services Lines are bypassed during the splitting.
417: --
418: UPDATE po_req_split_lines_gt PRS
419: SET ( PRS.record_status
420: , PRS.new_req_line_id ) = ( SELECT 'T'
421: , PRL.requisition_line_id
422: FROM po_requisition_lines_all PRL

Line 436: 'after update po_req_split_lines_gt for Services lines;

432: l_progress :='038';
433: l_module := G_MODULE_PREFIX||l_api_name||'.'||'038'||'.';
434: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
435: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
436: 'after update po_req_split_lines_gt for Services lines;
437: updated '||sql%rowcount||' rows');
438: END IF;
439:
440: EXCEPTION

Line 446: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module, 'Exception: update po_req_split_lines_gt for Services lines');

442: WHEN OTHERS THEN
443: po_message_s.sql_error('Exception of Split_requisitionLines()', l_progress , sqlcode);
444: FND_MSG_PUB.Add;
445: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
446: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module, 'Exception: update po_req_split_lines_gt for Services lines');
447: END IF;
448: RAISE;
449:
450: END;

Line 475: FROM po_req_split_lines_gt

471: BULK COLLECT INTO
472: requisition_line_id_tbl,
473: total_alloc_req_line_qty_tbl,
474: min_bid_number_tbl
475: FROM po_req_split_lines_gt
476: WHERE nvl(record_status,'NOVAL') NOT IN ('C','T') --
477: GROUP BY requisition_line_id;
478:
479: l_progress :='041';

Line 510: 'before updating po_req_split_lines_gt with sum of

506: l_progress :='050';
507: l_module := G_MODULE_PREFIX||l_api_name||'.'||'050'||'.';
508: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
509: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
510: 'before updating po_req_split_lines_gt with sum of
511: allocated_qty and min of bid_number etc..
512: ');
513: END IF;
514:

Line 521: UPDATE po_req_split_lines_gt

517: -- SQL Why :This is required later in the process.
518: -- especially to help bulk processing.
519:
520: FORALL qty_rollup_index in 1.. requisition_line_id_tbl.COUNT
521: UPDATE po_req_split_lines_gt
522: SET min_bid_number= min_bid_number_tbl(qty_rollup_index),
523: total_alloc_req_line_qty=
524: total_alloc_req_line_qty_tbl(qty_rollup_index),
525: record_status =decode(nvl(allocated_qty,0),requisition_line_qty,

Line 538: 'after updating po_req_split_lines_gt with sum of

534: l_progress :='051';
535: l_module := G_MODULE_PREFIX||l_api_name||'.'||'050'||'.';
536: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
537: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
538: 'after updating po_req_split_lines_gt with sum of
539: allocated_qty and min of bid_number etc..; updated '
540: || sql%rowcount ||' rows');
541: END IF;
542:

Line 552: 'Exception: updating po_req_split_lines_gt with sum of

548: l_progress , sqlcode);
549: FND_MSG_PUB.Add;
550: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
551: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module,
552: 'Exception: updating po_req_split_lines_gt with sum of
553: allocated_qty and min of bid_number etc.. ');
554: END IF;
555: RAISE;
556:

Line 567: po_req_split_lines_gt ');

563: l_module := G_MODULE_PREFIX||l_api_name||'.'||'060'||'.';
564: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
565: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
566: 'before inserting remainder req lines into
567: po_req_split_lines_gt ');
568: END IF;
569:
570: -- SQL What: Make entry for the new remainder req lines in the temp table
571: -- ( which are not consumed or Services Lines )

Line 574: INSERT INTO po_req_split_lines_gt

570: -- SQL What: Make entry for the new remainder req lines in the temp table
571: -- ( which are not consumed or Services Lines )
572: -- SQL Why : These rows stand for the remainder req lines to be created
573: -- in the po_requisition_lines_all table.
574: INSERT INTO po_req_split_lines_gt
575: ( auction_header_id,
576: bid_number,
577: bid_line_number,
578: requisition_header_id,

Line 598: FROM po_req_split_lines_gt

594: NULL,
595: requisition_line_qty,
596: NULL,
597: 'N'
598: FROM po_req_split_lines_gt
599: WHERE total_alloc_req_line_qty < requisition_line_qty
600: AND record_status NOT IN ('I','T') --
601: AND bid_number=min_bid_number;
602:

Line 608: po_req_split_lines_gt inserted '||sql%rowcount||' rows');

604: l_module := G_MODULE_PREFIX||l_api_name||'.'||'060'||'.';
605: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
606: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
607: 'after inserting remainder req lines into
608: po_req_split_lines_gt inserted '||sql%rowcount||' rows');
609: END IF;
610:
611: EXCEPTION
612:

Line 620: po_req_split_lines_gt ');

616: FND_MSG_PUB.Add;
617: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
618: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module,
619: 'Exception: inserting remainder req lines into
620: po_req_split_lines_gt ');
621: END IF;
622: RAISE;
623: END;
624:

Line 644: FROM po_req_split_lines_gt prs

640: SET (bid_number,
641: bid_line_number)=
642: (SELECT prs.bid_number,
643: prs.bid_line_number
644: FROM po_req_split_lines_gt prs
645: WHERE prl.requisition_line_id=prs.requisition_line_id
646: AND prs.record_status IN ('E','T') --
647: )
648: WHERE prl.requisition_line_id in

Line 650: FROM po_req_split_lines_gt prs1

646: AND prs.record_status IN ('E','T') --
647: )
648: WHERE prl.requisition_line_id in
649: (SELECT prs1.requisition_line_id
650: FROM po_req_split_lines_gt prs1
651: WHERE prs1.record_status IN ('E','T') ); --
652:
653: l_progress :='071';
654: l_module := G_MODULE_PREFIX||l_api_name||'.'||'071'||'.';

Line 683: 'before updating po_req_split_lines_gt with max linenum');

679: l_progress :='080';
680: l_module := G_MODULE_PREFIX||l_api_name||'.'||'080'||'.';
681: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
682: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
683: 'before updating po_req_split_lines_gt with max linenum');
684: END IF;
685:
686: --SQL What:update the temp table with the max line number for each
687: -- requisition_header_id

Line 690: UPDATE po_req_split_lines_gt prs

686: --SQL What:update the temp table with the max line number for each
687: -- requisition_header_id
688: --SQL Why :This is required to calculate the line numbers when creating
689: -- the new requisition lines
690: UPDATE po_req_split_lines_gt prs
691: SET prs.new_line_num=
692: (SELECT max(prl.line_num)
693: FROM po_requisition_lines_all prl --
694: WHERE prl.requisition_header_id=prs.requisition_header_id)

Line 701: 'after updating po_req_split_lines_gt with max linenum;

697: l_progress :='081';
698: l_module := G_MODULE_PREFIX||l_api_name||'.'||'081'||'.';
699: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
700: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
701: 'after updating po_req_split_lines_gt with max linenum;
702: Updated '|| sql%rowcount||' rows ');
703: END IF;
704:
705: EXCEPTION

Line 713: 'Exception: updating po_req_split_lines_gt with max

709: l_progress , sqlcode);
710: FND_MSG_PUB.Add;
711: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
712: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module,
713: 'Exception: updating po_req_split_lines_gt with max
714: line num');
715: END IF;
716: RAISE;
717:

Line 752: FROM po_req_split_lines_gt prs

748: bid_number_lnm_tbl,
749: bid_line_number_lnm_tbl,
750: new_line_num_lnm_tbl,
751: row_id_lnm_tbl
752: FROM po_req_split_lines_gt prs
753: WHERE prs.record_status in ('S','N')
754: ORDER BY prs.requisition_header_id,prs.requisition_line_id;
755:
756: l_progress :='091';

Line 847: 'Before: update po_req_split_lines_gt toset new_line_num');

843: l_progress :='110';
844: l_module := G_MODULE_PREFIX||l_api_name||'.'||'110'||'.';
845: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
846: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
847: 'Before: update po_req_split_lines_gt toset new_line_num');
848: END IF;
849:
850: FORALL l_line_num_upd_index in 1.. requisition_line_id_lnm_tbl.COUNT
851: UPDATE po_req_split_lines_gt

Line 851: UPDATE po_req_split_lines_gt

847: 'Before: update po_req_split_lines_gt toset new_line_num');
848: END IF;
849:
850: FORALL l_line_num_upd_index in 1.. requisition_line_id_lnm_tbl.COUNT
851: UPDATE po_req_split_lines_gt
852: SET new_line_num=new_line_num_lnm_tbl(l_line_num_upd_index)
853: WHERE rowid=row_id_lnm_tbl(l_line_num_upd_index);
854: l_progress :='111';
855: l_module := G_MODULE_PREFIX||l_api_name||'.'||'110'||'.';

Line 858: 'After: update po_req_split_lines_gt toset new_line_num;

854: l_progress :='111';
855: l_module := G_MODULE_PREFIX||l_api_name||'.'||'110'||'.';
856: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
857: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
858: 'After: update po_req_split_lines_gt toset new_line_num;
859: Updated '||sql%rowcount||' rows');
860: END IF;
861:
862: EXCEPTION

Line 870: 'Exception: update po_req_split_lines_gt to set

866: l_progress , sqlcode);
867: FND_MSG_PUB.Add;
868: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
869: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module,
870: 'Exception: update po_req_split_lines_gt to set
871: new_line_num');
872: END IF;
873: RAISE;
874:

Line 919: FROM po_req_split_lines_gt prs,

915: requisition_line_qty_rslt_tbl,
916: min_bid_number_rslt_tbl,
917: record_status_rslt_tbl,
918: encumbrance_flag_rslt_tbl -- Bug 4723367
919: FROM po_req_split_lines_gt prs,
920: po_requisition_lines_all prl, --
921: financials_system_parameters fsp -- Bug 4723367
922: -- Bug 5467617: Removed the joins to PO_VENDORS and PO_VENDOR_SITES_ALL
923: -- These are not required anymore because they we used to fetch the

Line 1794: po_req_split_lines_gt prs

1790: min_dist_id_round_tbl,
1791: sum_req_line_qty_round_tbl,
1792: req_line_qty_round_tbl
1793: FROM po_req_distributions_all prd, --
1794: po_req_split_lines_gt prs
1795: WHERE prd.requisition_line_id = prs.new_req_line_id
1796: AND prs.record_status in ('S','N')
1797: GROUP BY prd.requisition_line_id;
1798:

Line 2576: FROM po_req_split_lines_gt);

2572: INTO l_req_org_id
2573: FROM po_requisition_headers_all
2574: WHERE requisition_header_id IN
2575: (SELECT DISTINCT requisition_header_id
2576: FROM po_req_split_lines_gt);
2577:
2578: IF G_FND_DEBUG = 'Y' THEN
2579: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2580: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module,

Line 2614: po_req_split_lines_gt prs

2610: SELECT prd.distribution_id
2611: BULK COLLECT INTO
2612: l_before_dist_ids_tbl
2613: FROM po_req_distributions prd,
2614: po_req_split_lines_gt prs
2615: WHERE prd.requisition_line_id = prs.requisition_line_id
2616: AND (prs.bid_number = prs.min_bid_number
2617: OR
2618: -- when called from autocreate req modify bid number

Line 2658: po_req_split_lines_gt prs

2654: SELECT prd.distribution_id
2655: BULK COLLECT INTO
2656: l_after_dist_ids_tbl
2657: FROM po_req_distributions prd,
2658: po_req_split_lines_gt prs
2659: WHERE prd.requisition_line_id = prs.new_req_line_id
2660: AND prs.record_status in ('S','N')
2661: AND nvl(prd.prevent_encumbrance_flag,'N') <> 'Y'
2662: AND nvl(prd.encumbered_flag,'N') ='Y';

Line 2926: FROM po_req_distributions prd, po_req_split_lines_gt prs

2922: BULK COLLECT INTO
2923: sum_new_line_r_tax_tbl,
2924: sum_new_line_nr_tax_tbl,
2925: min_dist_id_tax_tbl
2926: FROM po_req_distributions prd, po_req_split_lines_gt prs
2927: WHERE prd.requisition_line_id = prs.new_req_line_id
2928: AND prs.record_status in ('S','N')
2929: GROUP BY prs.requisition_line_id,
2930: prd.code_combination_id;

Line 2955: FROM po_req_distributions prd, po_req_split_lines_gt prs

2951: BULK COLLECT INTO
2952: req_line_id_tax_tbl,
2953: sum_orig_line_r_tax_tbl,
2954: sum_orig_line_nr_tax_tbl
2955: FROM po_req_distributions prd, po_req_split_lines_gt prs
2956: WHERE prd.requisition_line_id = prs.requisition_line_id
2957: AND (prs.bid_number = prs.min_bid_number OR
2958: -- when called from autocreate req modify bid number would be null
2959: prs.bid_number IS NULL)