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_UPDATE_PO_PVT dependencies on PO_MASS_UPDATE_PO_PVT

Line 1: PACKAGE BODY PO_Mass_Update_PO_PVT AS

1: PACKAGE BODY PO_Mass_Update_PO_PVT AS
2: /* $Header: PO_Mass_Update_PO_PVT.plb 120.9 2008/04/24 06:20:35 rakchakr noship $*/
3:
4: --------------------------------------------------------------------------------------------------
5:

Line 2: /* $Header: PO_Mass_Update_PO_PVT.plb 120.9 2008/04/24 06:20:35 rakchakr noship $*/

1: PACKAGE BODY PO_Mass_Update_PO_PVT AS
2: /* $Header: PO_Mass_Update_PO_PVT.plb 120.9 2008/04/24 06:20:35 rakchakr noship $*/
3:
4: --------------------------------------------------------------------------------------------------
5:
6: -- Call is made such that the sql file POXMUB.sql calls the procedure

Line 8: -- PO_Mass_Update_PO_GRP.Update_Persons calls the procedure PO_Mass_Update_PO_PVT.DO_Update

4: --------------------------------------------------------------------------------------------------
5:
6: -- Call is made such that the sql file POXMUB.sql calls the procedure
7: -- PO_Mass_Update_PO_GRP.Update_Persons
8: -- PO_Mass_Update_PO_GRP.Update_Persons calls the procedure PO_Mass_Update_PO_PVT.DO_Update
9:
10: --------------------------------------------------------------------------------------------------
11:
12: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;

Line 14: g_pkg_name CONSTANT VARCHAR2(100) := 'PO_Mass_Update_PO_PVT';

10: --------------------------------------------------------------------------------------------------
11:
12: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
13: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
14: g_pkg_name CONSTANT VARCHAR2(100) := 'PO_Mass_Update_PO_PVT';
15: g_log_head CONSTANT VARCHAR2(1000) := 'po.plsql.' || g_pkg_name || '.';
16:
17: TYPE g_po IS REF CURSOR;
18:

Line 527: WHERE poh.agent_id = PO_MASS_UPDATE_PO_PVT.get_old_personid

523: poh.revision_num,
524: Nvl(poh.conterms_exist_flag, ''N'')
525: FROM po_headers poh,
526: po_document_types_vl pdt
527: WHERE poh.agent_id = PO_MASS_UPDATE_PO_PVT.get_old_personid
528: AND pdt.document_type_code IN (''PO'',''PA'')
529: AND pdt.document_subtype = poh.type_lookup_code
530: AND Nvl(poh.authorization_status,''INCOMPLETE'') IN (''APPROVED'',''REQUIRES REAPPROVAL'',''INCOMPLETE'',''REJECTED'',''IN PROCESS'',''PRE-APPROVED'')
531: AND Nvl(poh.cancel_flag,''N'') = ''N''

Line 536: stmt_po := stmt_po || ' AND poh.type_lookup_code = PO_MASS_UPDATE_PO_PVT.get_document_type';

532: AND Nvl(poh.frozen_flag,''N'') = ''N'' ';
533:
534: IF p_document_type IS NOT NULL AND p_document_type <> 'ALL' THEN --
535:
536: stmt_po := stmt_po || ' AND poh.type_lookup_code = PO_MASS_UPDATE_PO_PVT.get_document_type';
537:
538: END IF;
539:
540: IF ( po_num_type = 'NUMERIC' ) THEN

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

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

Line 552: stmt_po := stmt_po || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL ) <= to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_to ||) ';

548: stmt_po := stmt_po || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL ) >= to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_from) ';
549:
550: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
551:
552: stmt_po := stmt_po || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL ) <= to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_to ||) ';
553:
554: ELSE
555:
556: stmt_po := stmt_po || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL )

Line 558: BETWEEN to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_from) AND to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_to) ';

554: ELSE
555:
556: stmt_po := stmt_po || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL )
557:
558: BETWEEN to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_from) AND to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_to) ';
559:
560: END IF;
561:
562: ELSE

Line 570: stmt_po := stmt_po || ' AND POH.SEGMENT1 >= PO_MASS_UPDATE_PO_PVT.get_document_no_from';

566: stmt_po := stmt_po || ' AND 1 = 1 ';
567:
568: ELSIF p_document_no_from IS NOT NULL AND p_document_no_to IS NULL THEN
569:
570: stmt_po := stmt_po || ' AND POH.SEGMENT1 >= PO_MASS_UPDATE_PO_PVT.get_document_no_from';
571:
572: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
573:
574: stmt_po := stmt_po || ' AND POH.SEGMENT1 <= PO_MASS_UPDATE_PO_PVT.get_document_no_to';

Line 574: stmt_po := stmt_po || ' AND POH.SEGMENT1 <= PO_MASS_UPDATE_PO_PVT.get_document_no_to';

570: stmt_po := stmt_po || ' AND POH.SEGMENT1 >= PO_MASS_UPDATE_PO_PVT.get_document_no_from';
571:
572: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
573:
574: stmt_po := stmt_po || ' AND POH.SEGMENT1 <= PO_MASS_UPDATE_PO_PVT.get_document_no_to';
575:
576: ELSE
577:
578: stmt_po := stmt_po || ' AND POH.SEGMENT1 BETWEEN PO_MASS_UPDATE_PO_PVT.get_document_no_from AND PO_MASS_UPDATE_PO_PVT.get_document_no_to';

Line 578: stmt_po := stmt_po || ' AND POH.SEGMENT1 BETWEEN PO_MASS_UPDATE_PO_PVT.get_document_no_from AND PO_MASS_UPDATE_PO_PVT.get_document_no_to';

574: stmt_po := stmt_po || ' AND POH.SEGMENT1 <= PO_MASS_UPDATE_PO_PVT.get_document_no_to';
575:
576: ELSE
577:
578: stmt_po := stmt_po || ' AND POH.SEGMENT1 BETWEEN PO_MASS_UPDATE_PO_PVT.get_document_no_from AND PO_MASS_UPDATE_PO_PVT.get_document_no_to';
579:
580: END IF;
581:
582: END IF; /* End of po_num_type = 'NUMERIC' */

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

588: stmt_po := stmt_po || ' AND 1 = 1 ';
589:
590: ELSIF p_date_from IS NOT NULL AND p_date_to IS NULL THEN
591:
592: stmt_po := stmt_po || ' AND POH.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)';
593:
594: ELSIF p_date_from IS NULL AND p_date_to IS NOT NULL THEN
595:
596: stmt_po := stmt_po || ' AND POH.creation_date <= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)';

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

592: stmt_po := stmt_po || ' AND POH.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)';
593:
594: ELSIF p_date_from IS NULL AND p_date_to IS NOT NULL THEN
595:
596: stmt_po := stmt_po || ' AND POH.creation_date <= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)';
597:
598: ELSE
599: stmt_po := stmt_po || ' AND POH.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)
600: AND POH.creation_date < Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)+1';

Line 599: stmt_po := stmt_po || ' AND POH.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)

595:
596: stmt_po := stmt_po || ' AND POH.creation_date <= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)';
597:
598: ELSE
599: stmt_po := stmt_po || ' AND POH.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)
600: AND POH.creation_date < Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)+1';
601:
602: END IF;
603:

Line 600: AND POH.creation_date < Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)+1';

596: stmt_po := stmt_po || ' AND POH.creation_date <= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)';
597:
598: ELSE
599: stmt_po := stmt_po || ' AND POH.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)
600: AND POH.creation_date < Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)+1';
601:
602: END IF;
603:
604:

Line 607: stmt_po := stmt_po || ' AND POH.vendor_id = PO_MASS_UPDATE_PO_PVT.get_supplier_id';

603:
604:
605: IF p_supplier_id IS NOT NULL THEN
606:
607: stmt_po := stmt_po || ' AND POH.vendor_id = PO_MASS_UPDATE_PO_PVT.get_supplier_id';
608:
609: END IF;
610:
611: IF p_include_close_po = 'YES' THEN

Line 875: AND por.agent_id = PO_MASS_UPDATE_PO_PVT.get_old_personid

871: FROM po_headers poh,
872: po_releases por,
873: po_document_types_vl pdt
874: WHERE poh.po_header_id = por.po_header_id
875: AND por.agent_id = PO_MASS_UPDATE_PO_PVT.get_old_personid
876: AND pdt.document_type_code = ''RELEASE''
877: AND pdt.document_subtype = por.release_type
878: AND Nvl(por.authorization_status,''INCOMPLETE'') IN (''APPROVED'',''REQUIRES REAPPROVAL'',''INCOMPLETE'',''REJECTED'',''IN PROCESS'',''PRE-APPROVED'')
879: AND Nvl(por.cancel_flag,''N'') = ''N''

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

881:
882:
883: IF p_document_type IS NOT NULL AND p_document_type <> 'ALL' THEN --
884:
885: stmt_rel := stmt_rel || ' AND ((PO_MASS_UPDATE_PO_PVT.get_document_type = ''PLANNED'' and por.release_type = ''SCHEDULED'')
886:
887: OR (por.release_type = Nvl(PO_MASS_UPDATE_PO_PVT.get_document_type,por.release_type)))';
888:
889: END IF;

Line 887: OR (por.release_type = Nvl(PO_MASS_UPDATE_PO_PVT.get_document_type,por.release_type)))';

883: IF p_document_type IS NOT NULL AND p_document_type <> 'ALL' THEN --
884:
885: stmt_rel := stmt_rel || ' AND ((PO_MASS_UPDATE_PO_PVT.get_document_type = ''PLANNED'' and por.release_type = ''SCHEDULED'')
886:
887: OR (por.release_type = Nvl(PO_MASS_UPDATE_PO_PVT.get_document_type,por.release_type)))';
888:
889: END IF;
890:
891:

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

896: stmt_rel := stmt_rel || ' AND 1 = 1 ';
897:
898: ELSIF p_document_no_from IS NOT NULL AND p_document_no_to IS NULL THEN
899:
900: stmt_rel := stmt_rel || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL ) >= to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_from)';
901:
902: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
903:
904: stmt_rel := stmt_rel || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL ) <= to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_to)';

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

900: stmt_rel := stmt_rel || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL ) >= to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_from)';
901:
902: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
903:
904: stmt_rel := stmt_rel || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL ) <= to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_to)';
905:
906: ELSE
907:
908: stmt_rel := stmt_rel || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL )

Line 910: BETWEEN to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_from) AND to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_to)';

906: ELSE
907:
908: stmt_rel := stmt_rel || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL )
909:
910: BETWEEN to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_from) AND to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_to)';
911:
912: END IF;
913:
914: ELSE

Line 922: stmt_rel := stmt_rel || ' AND POH.SEGMENT1 >= PO_MASS_UPDATE_PO_PVT.get_document_no_from';

918: stmt_rel := stmt_rel || ' AND 1 = 1 ';
919:
920: ELSIF p_document_no_from IS NOT NULL AND p_document_no_to IS NULL THEN
921:
922: stmt_rel := stmt_rel || ' AND POH.SEGMENT1 >= PO_MASS_UPDATE_PO_PVT.get_document_no_from';
923:
924: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
925:
926: stmt_rel := stmt_rel || ' AND POH.SEGMENT1 <= PO_MASS_UPDATE_PO_PVT.get_document_no_to';

Line 926: stmt_rel := stmt_rel || ' AND POH.SEGMENT1 <= PO_MASS_UPDATE_PO_PVT.get_document_no_to';

922: stmt_rel := stmt_rel || ' AND POH.SEGMENT1 >= PO_MASS_UPDATE_PO_PVT.get_document_no_from';
923:
924: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
925:
926: stmt_rel := stmt_rel || ' AND POH.SEGMENT1 <= PO_MASS_UPDATE_PO_PVT.get_document_no_to';
927:
928: ELSE
929:
930: stmt_rel := stmt_rel || ' AND POH.SEGMENT1 BETWEEN PO_MASS_UPDATE_PO_PVT.get_document_no_from AND PO_MASS_UPDATE_PO_PVT.get_document_no_to';

Line 930: stmt_rel := stmt_rel || ' AND POH.SEGMENT1 BETWEEN PO_MASS_UPDATE_PO_PVT.get_document_no_from AND PO_MASS_UPDATE_PO_PVT.get_document_no_to';

926: stmt_rel := stmt_rel || ' AND POH.SEGMENT1 <= PO_MASS_UPDATE_PO_PVT.get_document_no_to';
927:
928: ELSE
929:
930: stmt_rel := stmt_rel || ' AND POH.SEGMENT1 BETWEEN PO_MASS_UPDATE_PO_PVT.get_document_no_from AND PO_MASS_UPDATE_PO_PVT.get_document_no_to';
931:
932: END IF;
933:
934:

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

941: stmt_rel := stmt_rel || ' AND 1 = 1 ';
942:
943: ELSIF p_date_from IS NOT NULL AND p_date_to IS NULL THEN
944:
945: stmt_rel := stmt_rel || ' AND POR.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)';
946:
947: ELSIF p_date_from IS NULL AND p_date_to IS NOT NULL THEN
948:
949: stmt_rel := stmt_rel || ' AND POR.creation_date <= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)';

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

945: stmt_rel := stmt_rel || ' AND POR.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)';
946:
947: ELSIF p_date_from IS NULL AND p_date_to IS NOT NULL THEN
948:
949: stmt_rel := stmt_rel || ' AND POR.creation_date <= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)';
950:
951: ELSE
952:
953: stmt_rel := stmt_rel || ' AND POR.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)

Line 953: stmt_rel := stmt_rel || ' AND POR.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)

949: stmt_rel := stmt_rel || ' AND POR.creation_date <= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)';
950:
951: ELSE
952:
953: stmt_rel := stmt_rel || ' AND POR.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)
954: AND POR.creation_date < Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)+1';
955:
956: END IF;
957:

Line 954: AND POR.creation_date < Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)+1';

950:
951: ELSE
952:
953: stmt_rel := stmt_rel || ' AND POR.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)
954: AND POR.creation_date < Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)+1';
955:
956: END IF;
957:
958:

Line 961: stmt_rel := stmt_rel || ' AND POH.vendor_id = PO_MASS_UPDATE_PO_PVT.get_supplier_id';

957:
958:
959: IF p_supplier_id IS NOT NULL THEN
960:
961: stmt_rel := stmt_rel || ' AND POH.vendor_id = PO_MASS_UPDATE_PO_PVT.get_supplier_id';
962:
963: END IF;
964:
965:

Line 1379: AND wfn.recipient_role = PO_Mass_Update_PO_PVT.get_old_username

1375: AND wfa.item_type = poh.wf_item_type
1376: AND wfa.item_key = poh.wf_item_key
1377: AND wfn.status NOT IN (''CLOSED'',''CANCELED'')
1378: AND Nvl(poh.authorization_status,''INCOMPLETE'') IN (''IN PROCESS'',''PRE-APPROVED'')
1379: AND wfn.recipient_role = PO_Mass_Update_PO_PVT.get_old_username
1380: AND pdt.document_type_code in (''PO'',''PA'')
1381: AND pdt.document_subtype = poh.type_lookup_code';
1382:
1383:

Line 1386: stmt_po := stmt_po || ' AND poh.type_lookup_code = PO_MASS_UPDATE_PO_PVT.get_document_type';

1382:
1383:
1384: IF p_document_type IS NOT NULL AND p_document_type <> 'ALL' THEN --
1385:
1386: stmt_po := stmt_po || ' AND poh.type_lookup_code = PO_MASS_UPDATE_PO_PVT.get_document_type';
1387:
1388: END IF;
1389:
1390:

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

1395: stmt_po := stmt_po || ' AND 1 = 1 ';
1396:
1397: ELSIF p_document_no_from IS NOT NULL AND p_document_no_to IS NULL THEN
1398:
1399: stmt_po := stmt_po || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL ) >= to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_from)';
1400:
1401: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
1402:
1403: stmt_po := stmt_po || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL ) <= to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_to)';

Line 1403: stmt_po := stmt_po || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL ) <= to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_to)';

1399: stmt_po := stmt_po || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL ) >= to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_from)';
1400:
1401: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
1402:
1403: stmt_po := stmt_po || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL ) <= to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_to)';
1404:
1405: ELSE
1406:
1407: stmt_po := stmt_po || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL )

Line 1409: BETWEEN to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_from) AND to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_to)';

1405: ELSE
1406:
1407: stmt_po := stmt_po || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL )
1408:
1409: BETWEEN to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_from) AND to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_to)';
1410:
1411: END IF;
1412:
1413: ELSE

Line 1421: stmt_po := stmt_po || ' AND POH.SEGMENT1 >= PO_MASS_UPDATE_PO_PVT.get_document_no_from';

1417: stmt_po := stmt_po || ' AND 1 = 1 ';
1418:
1419: ELSIF p_document_no_from IS NOT NULL AND p_document_no_to IS NULL THEN
1420:
1421: stmt_po := stmt_po || ' AND POH.SEGMENT1 >= PO_MASS_UPDATE_PO_PVT.get_document_no_from';
1422:
1423: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
1424:
1425: stmt_po := stmt_po || ' AND POH.SEGMENT1 <= PO_MASS_UPDATE_PO_PVT.get_document_no_to';

Line 1425: stmt_po := stmt_po || ' AND POH.SEGMENT1 <= PO_MASS_UPDATE_PO_PVT.get_document_no_to';

1421: stmt_po := stmt_po || ' AND POH.SEGMENT1 >= PO_MASS_UPDATE_PO_PVT.get_document_no_from';
1422:
1423: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
1424:
1425: stmt_po := stmt_po || ' AND POH.SEGMENT1 <= PO_MASS_UPDATE_PO_PVT.get_document_no_to';
1426:
1427: ELSE
1428:
1429: stmt_po := stmt_po || ' AND POH.SEGMENT1 BETWEEN PO_MASS_UPDATE_PO_PVT.get_document_no_from AND PO_MASS_UPDATE_PO_PVT.get_document_no_to';

Line 1429: stmt_po := stmt_po || ' AND POH.SEGMENT1 BETWEEN PO_MASS_UPDATE_PO_PVT.get_document_no_from AND PO_MASS_UPDATE_PO_PVT.get_document_no_to';

1425: stmt_po := stmt_po || ' AND POH.SEGMENT1 <= PO_MASS_UPDATE_PO_PVT.get_document_no_to';
1426:
1427: ELSE
1428:
1429: stmt_po := stmt_po || ' AND POH.SEGMENT1 BETWEEN PO_MASS_UPDATE_PO_PVT.get_document_no_from AND PO_MASS_UPDATE_PO_PVT.get_document_no_to';
1430:
1431: END IF;
1432:
1433: END IF; /* End of po_num_type = 'NUMERIC' */

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

1439: stmt_po := stmt_po || ' AND 1 = 1 ';
1440:
1441: ELSIF p_date_from IS NOT NULL AND p_date_to IS NULL THEN
1442:
1443: stmt_po := stmt_po || ' AND POH.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)';
1444:
1445: ELSIF p_date_from IS NULL AND p_date_to IS NOT NULL THEN
1446:
1447: stmt_po := stmt_po || ' AND POH.creation_date <= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)';

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

1443: stmt_po := stmt_po || ' AND POH.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)';
1444:
1445: ELSIF p_date_from IS NULL AND p_date_to IS NOT NULL THEN
1446:
1447: stmt_po := stmt_po || ' AND POH.creation_date <= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)';
1448:
1449: ELSE
1450:
1451: stmt_po := stmt_po || ' AND POH.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)

Line 1451: stmt_po := stmt_po || ' AND POH.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)

1447: stmt_po := stmt_po || ' AND POH.creation_date <= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)';
1448:
1449: ELSE
1450:
1451: stmt_po := stmt_po || ' AND POH.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)
1452: AND POH.creation_date < Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)+1';
1453:
1454: END IF;
1455:

Line 1452: AND POH.creation_date < Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)+1';

1448:
1449: ELSE
1450:
1451: stmt_po := stmt_po || ' AND POH.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)
1452: AND POH.creation_date < Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)+1';
1453:
1454: END IF;
1455:
1456:

Line 1459: stmt_po := stmt_po || ' AND POH.vendor_id = PO_MASS_UPDATE_PO_PVT.get_supplier_id';

1455:
1456:
1457: IF p_supplier_id IS NOT NULL THEN
1458:
1459: stmt_po := stmt_po || ' AND POH.vendor_id = PO_MASS_UPDATE_PO_PVT.get_supplier_id';
1460:
1461: END IF;
1462:
1463: IF p_include_close_po = 'YES' THEN

Line 1581: AND recipient_role = PO_Mass_Update_PO_PVT.get_old_username

1577: AND wfa.item_type = por.wf_item_type
1578: AND wfa.item_key = por.wf_item_key
1579: AND wfn.status NOT IN (''CLOSED'',''CANCELED'')
1580: AND Nvl(por.authorization_status,''INCOMPLETE'') IN (''IN PROCESS'',''PRE-APPROVED'')
1581: AND recipient_role = PO_Mass_Update_PO_PVT.get_old_username
1582: AND por.po_header_id = poh.po_header_id
1583: AND pdt.document_type_code = ''RELEASE''
1584: AND pdt.document_subtype = por.release_type';
1585:

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

1585:
1586:
1587: IF p_document_type IS NOT NULL AND p_document_type <> 'ALL' THEN --
1588:
1589: stmt_rel := stmt_rel || ' AND ((PO_MASS_UPDATE_PO_PVT.get_document_type = ''PLANNED'' and por.release_type = ''SCHEDULED'')
1590:
1591: OR (por.release_type = Nvl(PO_MASS_UPDATE_PO_PVT.get_document_type,por.release_type)))';
1592:
1593: END IF;

Line 1591: OR (por.release_type = Nvl(PO_MASS_UPDATE_PO_PVT.get_document_type,por.release_type)))';

1587: IF p_document_type IS NOT NULL AND p_document_type <> 'ALL' THEN --
1588:
1589: stmt_rel := stmt_rel || ' AND ((PO_MASS_UPDATE_PO_PVT.get_document_type = ''PLANNED'' and por.release_type = ''SCHEDULED'')
1590:
1591: OR (por.release_type = Nvl(PO_MASS_UPDATE_PO_PVT.get_document_type,por.release_type)))';
1592:
1593: END IF;
1594:
1595: IF ( po_num_type = 'NUMERIC' ) THEN

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

1599: stmt_rel := stmt_rel || ' AND 1 = 1 ';
1600:
1601: ELSIF p_document_no_from IS NOT NULL AND p_document_no_to IS NULL THEN
1602:
1603: stmt_rel := stmt_rel || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL ) >= to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_from)';
1604:
1605: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
1606:
1607: stmt_rel := stmt_rel || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL ) <= to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_to)';

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

1603: stmt_rel := stmt_rel || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL ) >= to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_from)';
1604:
1605: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
1606:
1607: stmt_rel := stmt_rel || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL ) <= to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_to)';
1608:
1609: ELSE
1610:
1611: stmt_rel := stmt_rel || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL )

Line 1613: BETWEEN to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_from) AND to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_to)';

1609: ELSE
1610:
1611: stmt_rel := stmt_rel || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL )
1612:
1613: BETWEEN to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_from) AND to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_to)';
1614:
1615: END IF;
1616:
1617: ELSE

Line 1625: stmt_rel := stmt_rel || ' AND POH.SEGMENT1 >= PO_MASS_UPDATE_PO_PVT.get_document_no_from';

1621: stmt_rel := stmt_rel || ' AND 1 = 1 ';
1622:
1623: ELSIF p_document_no_from IS NOT NULL AND p_document_no_to IS NULL THEN
1624:
1625: stmt_rel := stmt_rel || ' AND POH.SEGMENT1 >= PO_MASS_UPDATE_PO_PVT.get_document_no_from';
1626:
1627: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
1628:
1629: stmt_rel := stmt_rel || ' AND POH.SEGMENT1 <= PO_MASS_UPDATE_PO_PVT.get_document_no_to';

Line 1629: stmt_rel := stmt_rel || ' AND POH.SEGMENT1 <= PO_MASS_UPDATE_PO_PVT.get_document_no_to';

1625: stmt_rel := stmt_rel || ' AND POH.SEGMENT1 >= PO_MASS_UPDATE_PO_PVT.get_document_no_from';
1626:
1627: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
1628:
1629: stmt_rel := stmt_rel || ' AND POH.SEGMENT1 <= PO_MASS_UPDATE_PO_PVT.get_document_no_to';
1630:
1631: ELSE
1632:
1633: stmt_rel := stmt_rel || ' AND POH.SEGMENT1 BETWEEN PO_MASS_UPDATE_PO_PVT.get_document_no_from AND PO_MASS_UPDATE_PO_PVT.get_document_no_to';

Line 1633: stmt_rel := stmt_rel || ' AND POH.SEGMENT1 BETWEEN PO_MASS_UPDATE_PO_PVT.get_document_no_from AND PO_MASS_UPDATE_PO_PVT.get_document_no_to';

1629: stmt_rel := stmt_rel || ' AND POH.SEGMENT1 <= PO_MASS_UPDATE_PO_PVT.get_document_no_to';
1630:
1631: ELSE
1632:
1633: stmt_rel := stmt_rel || ' AND POH.SEGMENT1 BETWEEN PO_MASS_UPDATE_PO_PVT.get_document_no_from AND PO_MASS_UPDATE_PO_PVT.get_document_no_to';
1634:
1635: END IF;
1636:
1637: END IF; /* End of po_num_type = 'NUMERIC' */

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

1643: stmt_rel := stmt_rel || ' AND 1 = 1 ';
1644:
1645: ELSIF p_date_from IS NOT NULL AND p_date_to IS NULL THEN
1646:
1647: stmt_rel := stmt_rel || ' AND POR.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)';
1648:
1649: ELSIF p_date_from IS NULL AND p_date_to IS NOT NULL THEN
1650:
1651: stmt_rel := stmt_rel || ' AND POR.creation_date <= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)';

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

1647: stmt_rel := stmt_rel || ' AND POR.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)';
1648:
1649: ELSIF p_date_from IS NULL AND p_date_to IS NOT NULL THEN
1650:
1651: stmt_rel := stmt_rel || ' AND POR.creation_date <= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)';
1652:
1653: ELSE
1654:
1655: stmt_rel := stmt_rel || ' AND POR.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)

Line 1655: stmt_rel := stmt_rel || ' AND POR.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)

1651: stmt_rel := stmt_rel || ' AND POR.creation_date <= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)';
1652:
1653: ELSE
1654:
1655: stmt_rel := stmt_rel || ' AND POR.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)
1656: AND POR.creation_date < Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)+1';
1657:
1658: END IF;
1659:

Line 1656: AND POR.creation_date < Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)+1';

1652:
1653: ELSE
1654:
1655: stmt_rel := stmt_rel || ' AND POR.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)
1656: AND POR.creation_date < Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)+1';
1657:
1658: END IF;
1659:
1660: IF p_supplier_id IS NOT NULL THEN

Line 1662: stmt_rel := stmt_rel || ' AND POH.vendor_id = PO_MASS_UPDATE_PO_PVT.get_supplier_id';

1658: END IF;
1659:
1660: IF p_supplier_id IS NOT NULL THEN
1661:
1662: stmt_rel := stmt_rel || ' AND POH.vendor_id = PO_MASS_UPDATE_PO_PVT.get_supplier_id';
1663:
1664: END IF;
1665:
1666: IF p_include_close_po = 'YES' THEN

Line 1983: WHERE pod.deliver_to_person_id = PO_MASS_UPDATE_PO_PVT.get_old_personid

1979: pod.po_release_id
1980: FROM po_headers poh,
1981: po_document_types_vl pdt,
1982: po_distributions pod
1983: WHERE pod.deliver_to_person_id = PO_MASS_UPDATE_PO_PVT.get_old_personid
1984: AND poh.po_header_id = pod.po_header_id
1985: AND pdt.document_type_code IN (''PO'',''PA'')
1986: AND pdt.document_subtype = poh.type_lookup_code
1987: AND Nvl(poh.authorization_status,''INCOMPLETE'') IN (''APPROVED'',''REQUIRES REAPPROVAL'',''INCOMPLETE'',''REJECTED'',''IN PROCESS'',''PRE-APPROVED'')

Line 1993: stmt_po := stmt_po || 'AND poh.type_lookup_code = PO_MASS_UPDATE_PO_PVT.get_document_type';

1989: AND Nvl(poh.frozen_flag,''N'') = ''N''';
1990:
1991: IF p_document_type IS NOT NULL AND p_document_type <> 'ALL' THEN --
1992:
1993: stmt_po := stmt_po || 'AND poh.type_lookup_code = PO_MASS_UPDATE_PO_PVT.get_document_type';
1994:
1995: END IF;
1996:
1997: IF ( po_num_type = 'NUMERIC' ) THEN

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

2001: stmt_po := stmt_po || ' AND 1 = 1 ';
2002:
2003: ELSIF p_document_no_from IS NOT NULL AND p_document_no_to IS NULL THEN
2004:
2005: stmt_po := stmt_po || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL ) >= to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_from)';
2006:
2007: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
2008:
2009: stmt_po := stmt_po || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL ) <= to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_to)';

Line 2009: stmt_po := stmt_po || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL ) <= to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_to)';

2005: stmt_po := stmt_po || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL ) >= to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_from)';
2006:
2007: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
2008:
2009: stmt_po := stmt_po || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL ) <= to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_to)';
2010:
2011: ELSE
2012:
2013: stmt_po := stmt_po || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL )

Line 2015: BETWEEN to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_from) AND to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_to)';

2011: ELSE
2012:
2013: stmt_po := stmt_po || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL )
2014:
2015: BETWEEN to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_from) AND to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_to)';
2016:
2017: END IF;
2018:
2019: ELSE

Line 2027: stmt_po := stmt_po || ' AND POH.SEGMENT1 >= PO_MASS_UPDATE_PO_PVT.get_document_no_from';

2023: stmt_po := stmt_po || ' AND 1 = 1 ';
2024:
2025: ELSIF p_document_no_from IS NOT NULL AND p_document_no_to IS NULL THEN
2026:
2027: stmt_po := stmt_po || ' AND POH.SEGMENT1 >= PO_MASS_UPDATE_PO_PVT.get_document_no_from';
2028:
2029: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
2030:
2031: stmt_po := stmt_po || ' AND POH.SEGMENT1 <= PO_MASS_UPDATE_PO_PVT.get_document_no_to';

Line 2031: stmt_po := stmt_po || ' AND POH.SEGMENT1 <= PO_MASS_UPDATE_PO_PVT.get_document_no_to';

2027: stmt_po := stmt_po || ' AND POH.SEGMENT1 >= PO_MASS_UPDATE_PO_PVT.get_document_no_from';
2028:
2029: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
2030:
2031: stmt_po := stmt_po || ' AND POH.SEGMENT1 <= PO_MASS_UPDATE_PO_PVT.get_document_no_to';
2032:
2033: ELSE
2034:
2035: stmt_po := stmt_po || ' AND POH.SEGMENT1 BETWEEN PO_MASS_UPDATE_PO_PVT.get_document_no_from AND PO_MASS_UPDATE_PO_PVT.get_document_no_to';

Line 2035: stmt_po := stmt_po || ' AND POH.SEGMENT1 BETWEEN PO_MASS_UPDATE_PO_PVT.get_document_no_from AND PO_MASS_UPDATE_PO_PVT.get_document_no_to';

2031: stmt_po := stmt_po || ' AND POH.SEGMENT1 <= PO_MASS_UPDATE_PO_PVT.get_document_no_to';
2032:
2033: ELSE
2034:
2035: stmt_po := stmt_po || ' AND POH.SEGMENT1 BETWEEN PO_MASS_UPDATE_PO_PVT.get_document_no_from AND PO_MASS_UPDATE_PO_PVT.get_document_no_to';
2036:
2037: END IF;
2038:
2039: END IF; /* End of po_num_type = 'NUMERIC' */

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

2045: stmt_po := stmt_po || ' AND 1 = 1 ';
2046:
2047: ELSIF p_date_from IS NOT NULL AND p_date_to IS NULL THEN
2048:
2049: stmt_po := stmt_po || ' AND POH.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)';
2050:
2051: ELSIF p_date_from IS NULL AND p_date_to IS NOT NULL THEN
2052:
2053: stmt_po := stmt_po || ' AND POH.creation_date <= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)';

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

2049: stmt_po := stmt_po || ' AND POH.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)';
2050:
2051: ELSIF p_date_from IS NULL AND p_date_to IS NOT NULL THEN
2052:
2053: stmt_po := stmt_po || ' AND POH.creation_date <= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)';
2054:
2055: ELSE
2056: stmt_po := stmt_po || ' AND POH.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)
2057: AND POH.creation_date < Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)+1';

Line 2056: stmt_po := stmt_po || ' AND POH.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)

2052:
2053: stmt_po := stmt_po || ' AND POH.creation_date <= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)';
2054:
2055: ELSE
2056: stmt_po := stmt_po || ' AND POH.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)
2057: AND POH.creation_date < Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)+1';
2058:
2059: END IF;
2060:

Line 2057: AND POH.creation_date < Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)+1';

2053: stmt_po := stmt_po || ' AND POH.creation_date <= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)';
2054:
2055: ELSE
2056: stmt_po := stmt_po || ' AND POH.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)
2057: AND POH.creation_date < Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)+1';
2058:
2059: END IF;
2060:
2061: IF p_supplier_id IS NOT NULL THEN

Line 2063: stmt_po := stmt_po || ' AND POH.vendor_id = PO_MASS_UPDATE_PO_PVT.get_supplier_id';

2059: END IF;
2060:
2061: IF p_supplier_id IS NOT NULL THEN
2062:
2063: stmt_po := stmt_po || ' AND POH.vendor_id = PO_MASS_UPDATE_PO_PVT.get_supplier_id';
2064:
2065: END IF;
2066:
2067: IF p_include_close_po = 'YES' THEN

Line 2190: AND pod.deliver_to_person_id = PO_MASS_UPDATE_PO_PVT.get_old_personid

2186: po_distributions_all pod
2187: WHERE por.po_header_id = poh.po_header_id
2188: AND poh.po_header_id = pod.po_header_id
2189: AND pod.po_release_id = por.po_release_id /* Bug 6868589 */
2190: AND pod.deliver_to_person_id = PO_MASS_UPDATE_PO_PVT.get_old_personid
2191: AND pdt.document_type_code =''RELEASE''
2192: AND pdt.document_subtype = por.release_type
2193: AND Nvl(por.authorization_status,''INCOMPLETE'') IN (''APPROVED'',''REQUIRES REAPPROVAL'',''INCOMPLETE'',''REJECTED'',''IN PROCESS'',''PRE-APPROVED'')
2194: AND Nvl(por.cancel_flag,''N'') = ''N''

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

2195: AND Nvl(por.frozen_flag,''N'') = ''N''';
2196:
2197: IF p_document_type IS NOT NULL AND p_document_type <> 'ALL' THEN --
2198:
2199: stmt_rel := stmt_rel || ' AND ((PO_MASS_UPDATE_PO_PVT.get_document_type = ''PLANNED'' and por.release_type = ''SCHEDULED'')
2200:
2201: OR (por.release_type = Nvl(PO_MASS_UPDATE_PO_PVT.get_document_type,por.release_type)))';
2202:
2203: END IF;

Line 2201: OR (por.release_type = Nvl(PO_MASS_UPDATE_PO_PVT.get_document_type,por.release_type)))';

2197: IF p_document_type IS NOT NULL AND p_document_type <> 'ALL' THEN --
2198:
2199: stmt_rel := stmt_rel || ' AND ((PO_MASS_UPDATE_PO_PVT.get_document_type = ''PLANNED'' and por.release_type = ''SCHEDULED'')
2200:
2201: OR (por.release_type = Nvl(PO_MASS_UPDATE_PO_PVT.get_document_type,por.release_type)))';
2202:
2203: END IF;
2204:
2205:

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

2210: stmt_rel := stmt_rel || ' AND 1 = 1 ';
2211:
2212: ELSIF p_document_no_from IS NOT NULL AND p_document_no_to IS NULL THEN
2213:
2214: stmt_rel := stmt_rel || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL ) >= to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_from)';
2215:
2216: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
2217:
2218: stmt_rel := stmt_rel || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL ) <= to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_to )';

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

2214: stmt_rel := stmt_rel || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL ) >= to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_from)';
2215:
2216: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
2217:
2218: stmt_rel := stmt_rel || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL ) <= to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_to )';
2219:
2220: ELSE
2221:
2222: stmt_rel := stmt_rel || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL )

Line 2224: BETWEEN to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_from) AND to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_to)';

2220: ELSE
2221:
2222: stmt_rel := stmt_rel || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL )
2223:
2224: BETWEEN to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_from) AND to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_to)';
2225:
2226: END IF;
2227:
2228: ELSE

Line 2236: stmt_rel := stmt_rel || ' AND POH.SEGMENT1 >= PO_MASS_UPDATE_PO_PVT.get_document_no_from';

2232: stmt_rel := stmt_rel || ' AND 1 = 1 ';
2233:
2234: ELSIF p_document_no_from IS NOT NULL AND p_document_no_to IS NULL THEN
2235:
2236: stmt_rel := stmt_rel || ' AND POH.SEGMENT1 >= PO_MASS_UPDATE_PO_PVT.get_document_no_from';
2237:
2238: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
2239:
2240: stmt_rel := stmt_rel || ' AND POH.SEGMENT1 <= PO_MASS_UPDATE_PO_PVT.get_document_no_to';

Line 2240: stmt_rel := stmt_rel || ' AND POH.SEGMENT1 <= PO_MASS_UPDATE_PO_PVT.get_document_no_to';

2236: stmt_rel := stmt_rel || ' AND POH.SEGMENT1 >= PO_MASS_UPDATE_PO_PVT.get_document_no_from';
2237:
2238: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
2239:
2240: stmt_rel := stmt_rel || ' AND POH.SEGMENT1 <= PO_MASS_UPDATE_PO_PVT.get_document_no_to';
2241:
2242: ELSE
2243:
2244: stmt_rel := stmt_rel || ' AND POH.SEGMENT1 BETWEEN PO_MASS_UPDATE_PO_PVT.get_document_no_from AND PO_MASS_UPDATE_PO_PVT.get_document_no_to';

Line 2244: stmt_rel := stmt_rel || ' AND POH.SEGMENT1 BETWEEN PO_MASS_UPDATE_PO_PVT.get_document_no_from AND PO_MASS_UPDATE_PO_PVT.get_document_no_to';

2240: stmt_rel := stmt_rel || ' AND POH.SEGMENT1 <= PO_MASS_UPDATE_PO_PVT.get_document_no_to';
2241:
2242: ELSE
2243:
2244: stmt_rel := stmt_rel || ' AND POH.SEGMENT1 BETWEEN PO_MASS_UPDATE_PO_PVT.get_document_no_from AND PO_MASS_UPDATE_PO_PVT.get_document_no_to';
2245:
2246: END IF;
2247:
2248: END IF; /* End of po_num_type = 'NUMERIC' */

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

2254: stmt_rel := stmt_rel || ' AND 1 = 1 ';
2255:
2256: ELSIF p_date_from IS NOT NULL AND p_date_to IS NULL THEN
2257:
2258: stmt_rel := stmt_rel || ' AND POR.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)';
2259:
2260: ELSIF p_date_from IS NULL AND p_date_to IS NOT NULL THEN
2261:
2262: stmt_rel := stmt_rel || ' AND POR.creation_date <= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)';

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

2258: stmt_rel := stmt_rel || ' AND POR.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)';
2259:
2260: ELSIF p_date_from IS NULL AND p_date_to IS NOT NULL THEN
2261:
2262: stmt_rel := stmt_rel || ' AND POR.creation_date <= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)';
2263:
2264: ELSE
2265:
2266: stmt_rel := stmt_rel || ' AND POR.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)

Line 2266: stmt_rel := stmt_rel || ' AND POR.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)

2262: stmt_rel := stmt_rel || ' AND POR.creation_date <= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)';
2263:
2264: ELSE
2265:
2266: stmt_rel := stmt_rel || ' AND POR.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)
2267: AND POR.creation_date < Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)+1';
2268:
2269: END IF;
2270:

Line 2267: AND POR.creation_date < Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)+1';

2263:
2264: ELSE
2265:
2266: stmt_rel := stmt_rel || ' AND POR.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)
2267: AND POR.creation_date < Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)+1';
2268:
2269: END IF;
2270:
2271: IF p_supplier_id IS NOT NULL THEN

Line 2273: stmt_rel := stmt_rel || ' AND POH.vendor_id = PO_MASS_UPDATE_PO_PVT.get_supplier_id';

2269: END IF;
2270:
2271: IF p_supplier_id IS NOT NULL THEN
2272:
2273: stmt_rel := stmt_rel || ' AND POH.vendor_id = PO_MASS_UPDATE_PO_PVT.get_supplier_id';
2274:
2275: END IF;
2276:
2277: IF p_include_close_po = 'YES' THEN

Line 2857: END PO_Mass_Update_PO_PVT;

2853: BEGIN
2854: RETURN g_old_username;
2855: END;
2856:
2857: END PO_Mass_Update_PO_PVT;