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_MASS_CLOSE_PO_PVT dependencies on PO_MASS_CLOSE_PO_PVT

Line 1: PACKAGE BODY PO_Mass_Close_PO_PVT AS

1: PACKAGE BODY PO_Mass_Close_PO_PVT AS
2: /* $Header: PO_Mass_Close_PO_PVT.plb 120.12.12020000.3 2013/02/10 13:42:53 vegajula ship $*/
3:
4: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
5: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;

Line 2: /* $Header: PO_Mass_Close_PO_PVT.plb 120.12.12020000.3 2013/02/10 13:42:53 vegajula ship $*/

1: PACKAGE BODY PO_Mass_Close_PO_PVT AS
2: /* $Header: PO_Mass_Close_PO_PVT.plb 120.12.12020000.3 2013/02/10 13:42:53 vegajula ship $*/
3:
4: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
5: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
6: g_pkg_name CONSTANT VARCHAR2(100) := 'PO_Mass_Close_PO_PVT';

Line 6: g_pkg_name CONSTANT VARCHAR2(100) := 'PO_Mass_Close_PO_PVT';

2: /* $Header: PO_Mass_Close_PO_PVT.plb 120.12.12020000.3 2013/02/10 13:42:53 vegajula ship $*/
3:
4: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
5: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
6: g_pkg_name CONSTANT VARCHAR2(100) := 'PO_Mass_Close_PO_PVT';
7: g_log_head CONSTANT VARCHAR2(1000) := 'po.plsql.' || g_pkg_name || '.';
8:
9: TYPE g_close_po IS REF CURSOR;
10:

Line 247: stmt_po := stmt_po || ' AND poh.type_lookup_code = PO_Mass_Close_PO_PVT.get_document_type';

243: END IF;
244:
245: IF p_document_type IS NOT NULL AND p_document_type <> 'ALL' THEN --
246:
247: stmt_po := stmt_po || ' AND poh.type_lookup_code = PO_Mass_Close_PO_PVT.get_document_type';
248: END IF;
249:
250: IF ( po_num_type = 'NUMERIC' ) THEN
251:

Line 262: stmt_po := stmt_po || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL ) >= to_number(PO_Mass_Close_PO_PVT.get_document_no_from)';

258: END IF;
259:
260: ELSIF p_document_no_from IS NOT NULL AND p_document_no_to IS NULL THEN
261:
262: stmt_po := stmt_po || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL ) >= to_number(PO_Mass_Close_PO_PVT.get_document_no_from)';
263:
264: IF(stmt_pa IS NOT NULL ) Then
265: stmt_pa := stmt_pa || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL ) >= to_number(PO_Mass_Close_PO_PVT.get_document_no_from)';
266: END IF;

Line 265: stmt_pa := stmt_pa || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL ) >= to_number(PO_Mass_Close_PO_PVT.get_document_no_from)';

261:
262: stmt_po := stmt_po || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL ) >= to_number(PO_Mass_Close_PO_PVT.get_document_no_from)';
263:
264: IF(stmt_pa IS NOT NULL ) Then
265: stmt_pa := stmt_pa || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL ) >= to_number(PO_Mass_Close_PO_PVT.get_document_no_from)';
266: END IF;
267:
268:
269: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN

Line 271: stmt_po := stmt_po || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL ) <= to_number(PO_Mass_Close_PO_PVT.g_document_no_to)';

267:
268:
269: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
270:
271: stmt_po := stmt_po || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL ) <= to_number(PO_Mass_Close_PO_PVT.g_document_no_to)';
272:
273: IF(stmt_pa IS NOT NULL ) Then
274: stmt_pa := stmt_pa || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL ) <= to_number(PO_Mass_Close_PO_PVT.g_document_no_to)';
275: END IF;

Line 274: stmt_pa := stmt_pa || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL ) <= to_number(PO_Mass_Close_PO_PVT.g_document_no_to)';

270:
271: stmt_po := stmt_po || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL ) <= to_number(PO_Mass_Close_PO_PVT.g_document_no_to)';
272:
273: IF(stmt_pa IS NOT NULL ) Then
274: stmt_pa := stmt_pa || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL ) <= to_number(PO_Mass_Close_PO_PVT.g_document_no_to)';
275: END IF;
276: ELSE
277:
278: stmt_po := stmt_po || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL )

Line 280: BETWEEN to_number(PO_Mass_Close_PO_PVT.get_document_no_from) AND to_number(PO_Mass_Close_PO_PVT.get_document_no_to)';

276: ELSE
277:
278: stmt_po := stmt_po || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL )
279:
280: BETWEEN to_number(PO_Mass_Close_PO_PVT.get_document_no_from) AND to_number(PO_Mass_Close_PO_PVT.get_document_no_to)';
281:
282: IF(stmt_pa IS NOT NULL ) Then
283: stmt_pa := stmt_pa || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL )
284:

Line 285: BETWEEN to_number(PO_Mass_Close_PO_PVT.get_document_no_from) AND to_number(PO_Mass_Close_PO_PVT.get_document_no_to)';

281:
282: IF(stmt_pa IS NOT NULL ) Then
283: stmt_pa := stmt_pa || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL )
284:
285: BETWEEN to_number(PO_Mass_Close_PO_PVT.get_document_no_from) AND to_number(PO_Mass_Close_PO_PVT.get_document_no_to)';
286: END IF;
287: END IF;
288:
289: ELSE

Line 301: stmt_po := stmt_po || ' AND POH.SEGMENT1 >= PO_Mass_Close_PO_PVT.get_document_no_from';

297: END IF;
298:
299: ELSIF p_document_no_from IS NOT NULL AND p_document_no_to IS NULL THEN
300:
301: stmt_po := stmt_po || ' AND POH.SEGMENT1 >= PO_Mass_Close_PO_PVT.get_document_no_from';
302: IF(stmt_pa IS NOT NULL ) Then
303: stmt_pa := stmt_pa || ' AND POH.SEGMENT1 >= PO_Mass_Close_PO_PVT.get_document_no_from';
304: END IF;
305:

Line 303: stmt_pa := stmt_pa || ' AND POH.SEGMENT1 >= PO_Mass_Close_PO_PVT.get_document_no_from';

299: ELSIF p_document_no_from IS NOT NULL AND p_document_no_to IS NULL THEN
300:
301: stmt_po := stmt_po || ' AND POH.SEGMENT1 >= PO_Mass_Close_PO_PVT.get_document_no_from';
302: IF(stmt_pa IS NOT NULL ) Then
303: stmt_pa := stmt_pa || ' AND POH.SEGMENT1 >= PO_Mass_Close_PO_PVT.get_document_no_from';
304: END IF;
305:
306: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
307:

Line 308: stmt_po := stmt_po || ' AND POH.SEGMENT1 <= PO_Mass_Close_PO_PVT.get_document_no_to';

304: END IF;
305:
306: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
307:
308: stmt_po := stmt_po || ' AND POH.SEGMENT1 <= PO_Mass_Close_PO_PVT.get_document_no_to';
309: IF(stmt_pa IS NOT NULL ) Then
310: stmt_pa := stmt_pa || ' AND POH.SEGMENT1 <= PO_Mass_Close_PO_PVT.get_document_no_to';
311: END IF;
312:

Line 310: stmt_pa := stmt_pa || ' AND POH.SEGMENT1 <= PO_Mass_Close_PO_PVT.get_document_no_to';

306: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
307:
308: stmt_po := stmt_po || ' AND POH.SEGMENT1 <= PO_Mass_Close_PO_PVT.get_document_no_to';
309: IF(stmt_pa IS NOT NULL ) Then
310: stmt_pa := stmt_pa || ' AND POH.SEGMENT1 <= PO_Mass_Close_PO_PVT.get_document_no_to';
311: END IF;
312:
313: ELSE
314:

Line 315: stmt_po := stmt_po || ' AND POH.SEGMENT1 BETWEEN PO_Mass_Close_PO_PVT.get_document_no_from AND PO_Mass_Close_PO_PVT.get_document_no_to';

311: END IF;
312:
313: ELSE
314:
315: stmt_po := stmt_po || ' AND POH.SEGMENT1 BETWEEN PO_Mass_Close_PO_PVT.get_document_no_from AND PO_Mass_Close_PO_PVT.get_document_no_to';
316: IF(stmt_pa IS NOT NULL ) Then
317: stmt_pa := stmt_pa || ' AND POH.SEGMENT1 BETWEEN PO_Mass_Close_PO_PVT.get_document_no_from AND PO_Mass_Close_PO_PVT.get_document_no_to';
318: END IF;
319:

Line 317: stmt_pa := stmt_pa || ' AND POH.SEGMENT1 BETWEEN PO_Mass_Close_PO_PVT.get_document_no_from AND PO_Mass_Close_PO_PVT.get_document_no_to';

313: ELSE
314:
315: stmt_po := stmt_po || ' AND POH.SEGMENT1 BETWEEN PO_Mass_Close_PO_PVT.get_document_no_from AND PO_Mass_Close_PO_PVT.get_document_no_to';
316: IF(stmt_pa IS NOT NULL ) Then
317: stmt_pa := stmt_pa || ' AND POH.SEGMENT1 BETWEEN PO_Mass_Close_PO_PVT.get_document_no_from AND PO_Mass_Close_PO_PVT.get_document_no_to';
318: END IF;
319:
320: END IF;
321:

Line 336: stmt_po := stmt_po || ' AND POH.creation_date >= Trunc(PO_Mass_Close_PO_PVT.get_date_from)';

332: END IF;
333:
334: ELSIF p_date_from IS NOT NULL AND p_date_to IS NULL THEN
335:
336: stmt_po := stmt_po || ' AND POH.creation_date >= Trunc(PO_Mass_Close_PO_PVT.get_date_from)';
337:
338: IF(stmt_pa IS NOT NULL ) Then
339: stmt_pa := stmt_pa || ' AND POH.creation_date >= Trunc(PO_Mass_Close_PO_PVT.get_date_from)';
340: END IF;

Line 339: stmt_pa := stmt_pa || ' AND POH.creation_date >= Trunc(PO_Mass_Close_PO_PVT.get_date_from)';

335:
336: stmt_po := stmt_po || ' AND POH.creation_date >= Trunc(PO_Mass_Close_PO_PVT.get_date_from)';
337:
338: IF(stmt_pa IS NOT NULL ) Then
339: stmt_pa := stmt_pa || ' AND POH.creation_date >= Trunc(PO_Mass_Close_PO_PVT.get_date_from)';
340: END IF;
341:
342: ELSIF p_date_from IS NULL AND p_date_to IS NOT NULL THEN
343:

Line 344: stmt_po := stmt_po || ' AND POH.creation_date <= Trunc(PO_Mass_Close_PO_PVT.get_date_to)';

340: END IF;
341:
342: ELSIF p_date_from IS NULL AND p_date_to IS NOT NULL THEN
343:
344: stmt_po := stmt_po || ' AND POH.creation_date <= Trunc(PO_Mass_Close_PO_PVT.get_date_to)';
345:
346: IF(stmt_pa IS NOT NULL ) Then
347: stmt_pa := stmt_pa || ' AND POH.creation_date <= Trunc(PO_Mass_Close_PO_PVT.get_date_to)';
348: END IF;

Line 347: stmt_pa := stmt_pa || ' AND POH.creation_date <= Trunc(PO_Mass_Close_PO_PVT.get_date_to)';

343:
344: stmt_po := stmt_po || ' AND POH.creation_date <= Trunc(PO_Mass_Close_PO_PVT.get_date_to)';
345:
346: IF(stmt_pa IS NOT NULL ) Then
347: stmt_pa := stmt_pa || ' AND POH.creation_date <= Trunc(PO_Mass_Close_PO_PVT.get_date_to)';
348: END IF;
349:
350: ELSE
351: stmt_po := stmt_po || ' AND POH.creation_date >= Trunc(PO_Mass_Close_PO_PVT.get_date_from)

Line 351: stmt_po := stmt_po || ' AND POH.creation_date >= Trunc(PO_Mass_Close_PO_PVT.get_date_from)

347: stmt_pa := stmt_pa || ' AND POH.creation_date <= Trunc(PO_Mass_Close_PO_PVT.get_date_to)';
348: END IF;
349:
350: ELSE
351: stmt_po := stmt_po || ' AND POH.creation_date >= Trunc(PO_Mass_Close_PO_PVT.get_date_from)
352: AND POH.creation_date < Trunc(PO_Mass_Close_PO_PVT.get_date_to)+1';
353:
354: IF(stmt_pa IS NOT NULL ) Then
355: stmt_pa := stmt_pa || ' AND POH.creation_date >= Trunc(PO_Mass_Close_PO_PVT.get_date_from)

Line 352: AND POH.creation_date < Trunc(PO_Mass_Close_PO_PVT.get_date_to)+1';

348: END IF;
349:
350: ELSE
351: stmt_po := stmt_po || ' AND POH.creation_date >= Trunc(PO_Mass_Close_PO_PVT.get_date_from)
352: AND POH.creation_date < Trunc(PO_Mass_Close_PO_PVT.get_date_to)+1';
353:
354: IF(stmt_pa IS NOT NULL ) Then
355: stmt_pa := stmt_pa || ' AND POH.creation_date >= Trunc(PO_Mass_Close_PO_PVT.get_date_from)
356: AND POH.creation_date < Trunc(PO_Mass_Close_PO_PVT.get_date_to)+1';

Line 355: stmt_pa := stmt_pa || ' AND POH.creation_date >= Trunc(PO_Mass_Close_PO_PVT.get_date_from)

351: stmt_po := stmt_po || ' AND POH.creation_date >= Trunc(PO_Mass_Close_PO_PVT.get_date_from)
352: AND POH.creation_date < Trunc(PO_Mass_Close_PO_PVT.get_date_to)+1';
353:
354: IF(stmt_pa IS NOT NULL ) Then
355: stmt_pa := stmt_pa || ' AND POH.creation_date >= Trunc(PO_Mass_Close_PO_PVT.get_date_from)
356: AND POH.creation_date < Trunc(PO_Mass_Close_PO_PVT.get_date_to)+1';
357:
358: END IF;
359:

Line 356: AND POH.creation_date < Trunc(PO_Mass_Close_PO_PVT.get_date_to)+1';

352: AND POH.creation_date < Trunc(PO_Mass_Close_PO_PVT.get_date_to)+1';
353:
354: IF(stmt_pa IS NOT NULL ) Then
355: stmt_pa := stmt_pa || ' AND POH.creation_date >= Trunc(PO_Mass_Close_PO_PVT.get_date_from)
356: AND POH.creation_date < Trunc(PO_Mass_Close_PO_PVT.get_date_to)+1';
357:
358: END IF;
359:
360: END IF;

Line 364: stmt_po := stmt_po || ' AND POH.vendor_id = PO_Mass_Close_PO_PVT.get_supplier_id';

360: END IF;
361:
362: IF p_supplier_id IS NOT NULL THEN
363:
364: stmt_po := stmt_po || ' AND POH.vendor_id = PO_Mass_Close_PO_PVT.get_supplier_id';
365:
366: IF(stmt_pa IS NOT NULL ) Then
367: stmt_pa := stmt_pa || ' AND POH.vendor_id = PO_Mass_Close_PO_PVT.get_supplier_id';
368: END IF;

Line 367: stmt_pa := stmt_pa || ' AND POH.vendor_id = PO_Mass_Close_PO_PVT.get_supplier_id';

363:
364: stmt_po := stmt_po || ' AND POH.vendor_id = PO_Mass_Close_PO_PVT.get_supplier_id';
365:
366: IF(stmt_pa IS NOT NULL ) Then
367: stmt_pa := stmt_pa || ' AND POH.vendor_id = PO_Mass_Close_PO_PVT.get_supplier_id';
368: END IF;
369:
370: END IF;
371:

Line 530: stmt_rel := stmt_rel || 'AND ((PO_Mass_Close_PO_PVT.get_document_type = ''PLANNED'' and por.release_type = ''SCHEDULED'')

526: --end bug 13877857
527:
528: IF p_document_type IS NOT NULL AND p_document_type <> 'ALL' THEN --
529:
530: stmt_rel := stmt_rel || 'AND ((PO_Mass_Close_PO_PVT.get_document_type = ''PLANNED'' and por.release_type = ''SCHEDULED'')
531:
532: OR (por.release_type = Nvl(PO_Mass_Close_PO_PVT.get_document_type,por.release_type)))';
533:
534: END IF;

Line 532: OR (por.release_type = Nvl(PO_Mass_Close_PO_PVT.get_document_type,por.release_type)))';

528: IF p_document_type IS NOT NULL AND p_document_type <> 'ALL' THEN --
529:
530: stmt_rel := stmt_rel || 'AND ((PO_Mass_Close_PO_PVT.get_document_type = ''PLANNED'' and por.release_type = ''SCHEDULED'')
531:
532: OR (por.release_type = Nvl(PO_Mass_Close_PO_PVT.get_document_type,por.release_type)))';
533:
534: END IF;
535:
536: IF ( po_num_type = 'NUMERIC' ) THEN

Line 544: stmt_rel := stmt_rel || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POR.SEGMENT1 ) , NULL ) >= to_number(PO_Mass_Close_PO_PVT.get_document_no_from)';

540: stmt_rel := stmt_rel || ' AND 1 = 1 ';
541:
542: ELSIF p_document_no_from IS NOT NULL AND p_document_no_to IS NULL THEN
543:
544: stmt_rel := stmt_rel || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POR.SEGMENT1 ) , NULL ) >= to_number(PO_Mass_Close_PO_PVT.get_document_no_from)';
545:
546: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
547:
548: stmt_rel := stmt_rel || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POR.SEGMENT1 ) , NULL ) <= to_number(PO_Mass_Close_PO_PVT.get_document_no_to)';

Line 548: stmt_rel := stmt_rel || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POR.SEGMENT1 ) , NULL ) <= to_number(PO_Mass_Close_PO_PVT.get_document_no_to)';

544: stmt_rel := stmt_rel || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POR.SEGMENT1 ) , NULL ) >= to_number(PO_Mass_Close_PO_PVT.get_document_no_from)';
545:
546: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
547:
548: stmt_rel := stmt_rel || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POR.SEGMENT1 ) , NULL ) <= to_number(PO_Mass_Close_PO_PVT.get_document_no_to)';
549:
550: ELSE
551:
552: stmt_rel := stmt_rel || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POR.SEGMENT1 ) , NULL )

Line 554: BETWEEN to_number(PO_Mass_Close_PO_PVT.get_document_no_from) AND to_number(PO_Mass_Close_PO_PVT.get_document_no_to)';

550: ELSE
551:
552: stmt_rel := stmt_rel || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POR.SEGMENT1 ) , NULL )
553:
554: BETWEEN to_number(PO_Mass_Close_PO_PVT.get_document_no_from) AND to_number(PO_Mass_Close_PO_PVT.get_document_no_to)';
555:
556: END IF;
557:
558: ELSE

Line 566: stmt_rel := stmt_rel || ' AND POH.Clm_Document_number >= PO_Mass_Close_PO_PVT.get_document_no_from';

562: stmt_rel := stmt_rel || ' AND 1 = 1 ';
563:
564: ELSIF p_document_no_from IS NOT NULL AND p_document_no_to IS NULL THEN
565:
566: stmt_rel := stmt_rel || ' AND POH.Clm_Document_number >= PO_Mass_Close_PO_PVT.get_document_no_from';
567:
568: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
569:
570: stmt_rel := stmt_rel || ' AND POH.Clm_Document_number <= PO_Mass_Close_PO_PVT.get_document_no_to';

Line 570: stmt_rel := stmt_rel || ' AND POH.Clm_Document_number <= PO_Mass_Close_PO_PVT.get_document_no_to';

566: stmt_rel := stmt_rel || ' AND POH.Clm_Document_number >= PO_Mass_Close_PO_PVT.get_document_no_from';
567:
568: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
569:
570: stmt_rel := stmt_rel || ' AND POH.Clm_Document_number <= PO_Mass_Close_PO_PVT.get_document_no_to';
571:
572: ELSE
573:
574: stmt_rel := stmt_rel || ' AND POH.Clm_Document_number BETWEEN PO_Mass_Close_PO_PVT.get_document_no_from AND PO_Mass_Close_PO_PVT.get_document_no_to'; --

Line 574: stmt_rel := stmt_rel || ' AND POH.Clm_Document_number BETWEEN PO_Mass_Close_PO_PVT.get_document_no_from AND PO_Mass_Close_PO_PVT.get_document_no_to'; --

570: stmt_rel := stmt_rel || ' AND POH.Clm_Document_number <= PO_Mass_Close_PO_PVT.get_document_no_to';
571:
572: ELSE
573:
574: stmt_rel := stmt_rel || ' AND POH.Clm_Document_number BETWEEN PO_Mass_Close_PO_PVT.get_document_no_from AND PO_Mass_Close_PO_PVT.get_document_no_to'; --
575:
576: END IF;
577:
578: END IF; /* po_num_type = 'NUMERIC' */

Line 588: stmt_rel := stmt_rel || ' AND POR.creation_date >= Trunc(PO_Mass_Close_PO_PVT.get_date_from)';

584: stmt_rel := stmt_rel || ' AND 1 = 1 ';
585:
586: ELSIF p_date_from IS NOT NULL AND p_date_to IS NULL THEN
587:
588: stmt_rel := stmt_rel || ' AND POR.creation_date >= Trunc(PO_Mass_Close_PO_PVT.get_date_from)';
589:
590: ELSIF p_date_from IS NULL AND p_date_to IS NOT NULL THEN
591:
592: stmt_rel := stmt_rel || ' AND POR.creation_date <= Trunc(PO_Mass_Close_PO_PVT.get_date_to)';

Line 592: stmt_rel := stmt_rel || ' AND POR.creation_date <= Trunc(PO_Mass_Close_PO_PVT.get_date_to)';

588: stmt_rel := stmt_rel || ' AND POR.creation_date >= Trunc(PO_Mass_Close_PO_PVT.get_date_from)';
589:
590: ELSIF p_date_from IS NULL AND p_date_to IS NOT NULL THEN
591:
592: stmt_rel := stmt_rel || ' AND POR.creation_date <= Trunc(PO_Mass_Close_PO_PVT.get_date_to)';
593:
594: ELSE
595:
596: stmt_rel := stmt_rel || ' AND POR.creation_date >= Trunc(PO_Mass_Close_PO_PVT.get_date_from)

Line 596: stmt_rel := stmt_rel || ' AND POR.creation_date >= Trunc(PO_Mass_Close_PO_PVT.get_date_from)

592: stmt_rel := stmt_rel || ' AND POR.creation_date <= Trunc(PO_Mass_Close_PO_PVT.get_date_to)';
593:
594: ELSE
595:
596: stmt_rel := stmt_rel || ' AND POR.creation_date >= Trunc(PO_Mass_Close_PO_PVT.get_date_from)
597: AND POR.creation_date < Trunc(PO_Mass_Close_PO_PVT.get_date_to)+1';
598:
599: END IF;
600:

Line 597: AND POR.creation_date < Trunc(PO_Mass_Close_PO_PVT.get_date_to)+1';

593:
594: ELSE
595:
596: stmt_rel := stmt_rel || ' AND POR.creation_date >= Trunc(PO_Mass_Close_PO_PVT.get_date_from)
597: AND POR.creation_date < Trunc(PO_Mass_Close_PO_PVT.get_date_to)+1';
598:
599: END IF;
600:
601: IF p_supplier_id IS NOT NULL THEN

Line 603: stmt_rel := stmt_rel || ' AND POH.vendor_id = PO_Mass_Close_PO_PVT.get_supplier_id';

599: END IF;
600:
601: IF p_supplier_id IS NOT NULL THEN
602:
603: stmt_rel := stmt_rel || ' AND POH.vendor_id = PO_Mass_Close_PO_PVT.get_supplier_id';
604:
605: END IF;
606:
607: stmt_rel := stmt_rel || ' ORDER BY poh.segment1,por.release_num';

Line 927: END PO_Mass_Close_PO_PVT;

923: RETURN g_supplier_id;
924: END;
925:
926:
927: END PO_Mass_Close_PO_PVT;