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.7.12010000.2 2008/08/05 08:24:24 rramasam 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.7.12010000.2 2008/08/05 08:24:24 rramasam ship $*/

1: PACKAGE BODY PO_Mass_Close_PO_PVT AS
2: /* $Header: PO_Mass_Close_PO_PVT.plb 120.7.12010000.2 2008/08/05 08:24:24 rramasam 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.7.12010000.2 2008/08/05 08:24:24 rramasam 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 240: stmt_po := stmt_po || ' AND poh.type_lookup_code = PO_Mass_Close_PO_PVT.get_document_type';

236: END IF;
237:
238: IF p_document_type IS NOT NULL AND p_document_type <> 'ALL' THEN --
239:
240: stmt_po := stmt_po || ' AND poh.type_lookup_code = PO_Mass_Close_PO_PVT.get_document_type';
241: END IF;
242:
243: IF ( po_num_type = 'NUMERIC' ) THEN
244:

Line 251: 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)';

247: stmt_po := stmt_po || ' AND 1 = 1 ';
248:
249: ELSIF p_document_no_from IS NOT NULL AND p_document_no_to IS NULL THEN
250:
251: 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)';
252:
253: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
254:
255: 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)';

Line 255: 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)';

251: 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)';
252:
253: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
254:
255: 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)';
256:
257: ELSE
258:
259: stmt_po := stmt_po || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL )

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

257: ELSE
258:
259: stmt_po := stmt_po || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL )
260:
261: BETWEEN to_number(PO_Mass_Close_PO_PVT.get_document_no_from) AND to_number(PO_Mass_Close_PO_PVT.get_document_no_to)';
262:
263: END IF;
264:
265: ELSE

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

269: stmt_po := stmt_po || ' AND 1 = 1 ';
270:
271: ELSIF p_document_no_from IS NOT NULL AND p_document_no_to IS NULL THEN
272:
273: stmt_po := stmt_po || ' AND POH.SEGMENT1 >= PO_Mass_Close_PO_PVT.get_document_no_from';
274:
275: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
276:
277: stmt_po := stmt_po || ' AND POH.SEGMENT1 <= PO_Mass_Close_PO_PVT.get_document_no_to';

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

273: stmt_po := stmt_po || ' AND POH.SEGMENT1 >= PO_Mass_Close_PO_PVT.get_document_no_from';
274:
275: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
276:
277: stmt_po := stmt_po || ' AND POH.SEGMENT1 <= PO_Mass_Close_PO_PVT.get_document_no_to';
278:
279: ELSE
280:
281: 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';

Line 281: 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';

277: stmt_po := stmt_po || ' AND POH.SEGMENT1 <= PO_Mass_Close_PO_PVT.get_document_no_to';
278:
279: ELSE
280:
281: 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';
282:
283: END IF;
284:
285: END IF; /* po_num_type = 'NUMERIC' */

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

291: stmt_po := stmt_po || ' AND 1 = 1 ';
292:
293: ELSIF p_date_from IS NOT NULL AND p_date_to IS NULL THEN
294:
295: stmt_po := stmt_po || ' AND POH.creation_date >= Trunc(PO_Mass_Close_PO_PVT.get_date_from)';
296:
297: ELSIF p_date_from IS NULL AND p_date_to IS NOT NULL THEN
298:
299: stmt_po := stmt_po || ' AND POH.creation_date <= Trunc(PO_Mass_Close_PO_PVT.get_date_to)';

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

295: stmt_po := stmt_po || ' AND POH.creation_date >= Trunc(PO_Mass_Close_PO_PVT.get_date_from)';
296:
297: ELSIF p_date_from IS NULL AND p_date_to IS NOT NULL THEN
298:
299: stmt_po := stmt_po || ' AND POH.creation_date <= Trunc(PO_Mass_Close_PO_PVT.get_date_to)';
300:
301: ELSE
302: stmt_po := stmt_po || ' AND POH.creation_date >= Trunc(PO_Mass_Close_PO_PVT.get_date_from)
303: AND POH.creation_date < Trunc(PO_Mass_Close_PO_PVT.get_date_to)+1';

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

298:
299: stmt_po := stmt_po || ' AND POH.creation_date <= Trunc(PO_Mass_Close_PO_PVT.get_date_to)';
300:
301: ELSE
302: stmt_po := stmt_po || ' AND POH.creation_date >= Trunc(PO_Mass_Close_PO_PVT.get_date_from)
303: AND POH.creation_date < Trunc(PO_Mass_Close_PO_PVT.get_date_to)+1';
304:
305: END IF;
306:

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

299: stmt_po := stmt_po || ' AND POH.creation_date <= Trunc(PO_Mass_Close_PO_PVT.get_date_to)';
300:
301: ELSE
302: stmt_po := stmt_po || ' AND POH.creation_date >= Trunc(PO_Mass_Close_PO_PVT.get_date_from)
303: AND POH.creation_date < Trunc(PO_Mass_Close_PO_PVT.get_date_to)+1';
304:
305: END IF;
306:
307: IF p_supplier_id IS NOT NULL THEN

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

305: END IF;
306:
307: IF p_supplier_id IS NOT NULL THEN
308:
309: stmt_po := stmt_po || ' AND POH.vendor_id = PO_Mass_Close_PO_PVT.get_supplier_id';
310:
311: END IF;
312:
313: stmt_po := stmt_po || ' ORDER BY PO_Number';

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

446: AND ( Nvl(pod.encumbered_flag,''N'') = ''Y'' OR Nvl(pod.encumbered_flag,''N'') = ''N'')';
447:
448: IF p_document_type IS NOT NULL AND p_document_type <> 'ALL' THEN --
449:
450: stmt_rel := stmt_rel || 'AND ((PO_Mass_Close_PO_PVT.get_document_type = ''PLANNED'' and por.release_type = ''SCHEDULED'')
451:
452: OR (por.release_type = Nvl(PO_Mass_Close_PO_PVT.get_document_type,por.release_type)))';
453:
454: END IF;

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

448: IF p_document_type IS NOT NULL AND p_document_type <> 'ALL' THEN --
449:
450: stmt_rel := stmt_rel || 'AND ((PO_Mass_Close_PO_PVT.get_document_type = ''PLANNED'' and por.release_type = ''SCHEDULED'')
451:
452: OR (por.release_type = Nvl(PO_Mass_Close_PO_PVT.get_document_type,por.release_type)))';
453:
454: END IF;
455:
456: IF ( po_num_type = 'NUMERIC' ) THEN

Line 464: 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)';

460: stmt_rel := stmt_rel || ' AND 1 = 1 ';
461:
462: ELSIF p_document_no_from IS NOT NULL AND p_document_no_to IS NULL THEN
463:
464: 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)';
465:
466: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
467:
468: 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 468: 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)';

464: 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)';
465:
466: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
467:
468: 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)';
469:
470: ELSE
471:
472: stmt_rel := stmt_rel || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POR.SEGMENT1 ) , NULL )

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

470: ELSE
471:
472: stmt_rel := stmt_rel || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POR.SEGMENT1 ) , NULL )
473:
474: BETWEEN to_number(PO_Mass_Close_PO_PVT.get_document_no_from) AND to_number(PO_Mass_Close_PO_PVT.get_document_no_to)';
475:
476: END IF;
477:
478: ELSE

Line 486: stmt_rel := stmt_rel || ' AND POH.SEGMENT1 >= PO_Mass_Close_PO_PVT.get_document_no_from';

482: stmt_rel := stmt_rel || ' AND 1 = 1 ';
483:
484: ELSIF p_document_no_from IS NOT NULL AND p_document_no_to IS NULL THEN
485:
486: stmt_rel := stmt_rel || ' AND POH.SEGMENT1 >= PO_Mass_Close_PO_PVT.get_document_no_from';
487:
488: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
489:
490: stmt_rel := stmt_rel || ' AND POH.SEGMENT1 <= PO_Mass_Close_PO_PVT.get_document_no_to';

Line 490: stmt_rel := stmt_rel || ' AND POH.SEGMENT1 <= PO_Mass_Close_PO_PVT.get_document_no_to';

486: stmt_rel := stmt_rel || ' AND POH.SEGMENT1 >= PO_Mass_Close_PO_PVT.get_document_no_from';
487:
488: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
489:
490: stmt_rel := stmt_rel || ' AND POH.SEGMENT1 <= PO_Mass_Close_PO_PVT.get_document_no_to';
491:
492: ELSE
493:
494: stmt_rel := stmt_rel || ' AND POH.SEGMENT1 BETWEEN PO_Mass_Close_PO_PVT.get_document_no_from AND PO_Mass_Close_PO_PVT.get_document_no_to'; --

Line 494: stmt_rel := stmt_rel || ' AND POH.SEGMENT1 BETWEEN PO_Mass_Close_PO_PVT.get_document_no_from AND PO_Mass_Close_PO_PVT.get_document_no_to'; --

490: stmt_rel := stmt_rel || ' AND POH.SEGMENT1 <= PO_Mass_Close_PO_PVT.get_document_no_to';
491:
492: ELSE
493:
494: stmt_rel := stmt_rel || ' AND POH.SEGMENT1 BETWEEN PO_Mass_Close_PO_PVT.get_document_no_from AND PO_Mass_Close_PO_PVT.get_document_no_to'; --
495:
496: END IF;
497:
498: END IF; /* po_num_type = 'NUMERIC' */

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

504: stmt_rel := stmt_rel || ' AND 1 = 1 ';
505:
506: ELSIF p_date_from IS NOT NULL AND p_date_to IS NULL THEN
507:
508: stmt_rel := stmt_rel || ' AND POR.creation_date >= Trunc(PO_Mass_Close_PO_PVT.get_date_from)';
509:
510: ELSIF p_date_from IS NULL AND p_date_to IS NOT NULL THEN
511:
512: stmt_rel := stmt_rel || ' AND POR.creation_date <= Trunc(PO_Mass_Close_PO_PVT.get_date_to)';

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

508: stmt_rel := stmt_rel || ' AND POR.creation_date >= Trunc(PO_Mass_Close_PO_PVT.get_date_from)';
509:
510: ELSIF p_date_from IS NULL AND p_date_to IS NOT NULL THEN
511:
512: stmt_rel := stmt_rel || ' AND POR.creation_date <= Trunc(PO_Mass_Close_PO_PVT.get_date_to)';
513:
514: ELSE
515:
516: stmt_rel := stmt_rel || ' AND POR.creation_date >= Trunc(PO_Mass_Close_PO_PVT.get_date_from)

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

512: stmt_rel := stmt_rel || ' AND POR.creation_date <= Trunc(PO_Mass_Close_PO_PVT.get_date_to)';
513:
514: ELSE
515:
516: stmt_rel := stmt_rel || ' AND POR.creation_date >= Trunc(PO_Mass_Close_PO_PVT.get_date_from)
517: AND POR.creation_date < Trunc(PO_Mass_Close_PO_PVT.get_date_to)+1';
518:
519: END IF;
520:

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

513:
514: ELSE
515:
516: stmt_rel := stmt_rel || ' AND POR.creation_date >= Trunc(PO_Mass_Close_PO_PVT.get_date_from)
517: AND POR.creation_date < Trunc(PO_Mass_Close_PO_PVT.get_date_to)+1';
518:
519: END IF;
520:
521: IF p_supplier_id IS NOT NULL THEN

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

519: END IF;
520:
521: IF p_supplier_id IS NOT NULL THEN
522:
523: stmt_rel := stmt_rel || ' AND POH.vendor_id = PO_Mass_Close_PO_PVT.get_supplier_id';
524:
525: END IF;
526:
527: stmt_rel := stmt_rel || ' ORDER BY poh.segment1,por.release_num';

Line 847: END PO_Mass_Close_PO_PVT;

843: RETURN g_supplier_id;
844: END;
845:
846:
847: END PO_Mass_Close_PO_PVT;