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.11.12020000.3 2013/02/10 20:55:25 vegajula ship $*/
3:
4: --------------------------------------------------------------------------------------------------
5:

Line 2: /* $Header: PO_Mass_Update_PO_PVT.plb 120.11.12020000.3 2013/02/10 20:55:25 vegajula ship $*/

1: PACKAGE BODY PO_Mass_Update_PO_PVT AS
2: /* $Header: PO_Mass_Update_PO_PVT.plb 120.11.12020000.3 2013/02/10 20:55:25 vegajula ship $*/
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 931: AND por.agent_id = PO_MASS_UPDATE_PO_PVT.get_old_personid

927: FROM po_headers poh,
928: po_releases por,
929: po_document_types_vl pdt
930: WHERE poh.po_header_id = por.po_header_id
931: AND por.agent_id = PO_MASS_UPDATE_PO_PVT.get_old_personid
932: AND pdt.document_type_code = ''RELEASE''
933: AND pdt.document_subtype = por.release_type
934: AND Nvl(por.authorization_status,''INCOMPLETE'') IN (''APPROVED'',''REQUIRES REAPPROVAL'',''INCOMPLETE'',''REJECTED'',''IN PROCESS'',''PRE-APPROVED'')
935: AND Nvl(por.cancel_flag,''N'') = ''N''

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

937:
938:
939: IF p_document_type IS NOT NULL AND p_document_type <> 'ALL' THEN --
940:
941: stmt_rel := stmt_rel || ' AND ((PO_MASS_UPDATE_PO_PVT.get_document_type = ''PLANNED'' and por.release_type = ''SCHEDULED'')
942:
943: OR (por.release_type = Nvl(PO_MASS_UPDATE_PO_PVT.get_document_type,por.release_type)))';
944:
945: END IF;

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

939: IF p_document_type IS NOT NULL AND p_document_type <> 'ALL' THEN --
940:
941: stmt_rel := stmt_rel || ' AND ((PO_MASS_UPDATE_PO_PVT.get_document_type = ''PLANNED'' and por.release_type = ''SCHEDULED'')
942:
943: OR (por.release_type = Nvl(PO_MASS_UPDATE_PO_PVT.get_document_type,por.release_type)))';
944:
945: END IF;
946:
947:

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

952: stmt_rel := stmt_rel || ' AND 1 = 1 ';
953:
954: ELSIF p_document_no_from IS NOT NULL AND p_document_no_to IS NULL THEN
955:
956: 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)';
957:
958: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
959:
960: 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 960: 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)';

956: 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)';
957:
958: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
959:
960: 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)';
961:
962: ELSE
963:
964: stmt_rel := stmt_rel || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL )

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

962: ELSE
963:
964: stmt_rel := stmt_rel || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL )
965:
966: BETWEEN to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_from) AND to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_to)';
967:
968: END IF;
969:
970: ELSE

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

974: stmt_rel := stmt_rel || ' AND 1 = 1 ';
975:
976: ELSIF p_document_no_from IS NOT NULL AND p_document_no_to IS NULL THEN
977:
978: stmt_rel := stmt_rel || ' AND POH.SEGMENT1 >= PO_MASS_UPDATE_PO_PVT.get_document_no_from';
979:
980: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
981:
982: stmt_rel := stmt_rel || ' AND POH.SEGMENT1 <= PO_MASS_UPDATE_PO_PVT.get_document_no_to';

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

978: stmt_rel := stmt_rel || ' AND POH.SEGMENT1 >= PO_MASS_UPDATE_PO_PVT.get_document_no_from';
979:
980: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
981:
982: stmt_rel := stmt_rel || ' AND POH.SEGMENT1 <= PO_MASS_UPDATE_PO_PVT.get_document_no_to';
983:
984: ELSE
985:
986: 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 986: 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';

982: stmt_rel := stmt_rel || ' AND POH.SEGMENT1 <= PO_MASS_UPDATE_PO_PVT.get_document_no_to';
983:
984: ELSE
985:
986: 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';
987:
988: END IF;
989:
990:

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

997: stmt_rel := stmt_rel || ' AND 1 = 1 ';
998:
999: ELSIF p_date_from IS NOT NULL AND p_date_to IS NULL THEN
1000:
1001: stmt_rel := stmt_rel || ' AND POR.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)';
1002:
1003: ELSIF p_date_from IS NULL AND p_date_to IS NOT NULL THEN
1004:
1005: stmt_rel := stmt_rel || ' AND POR.creation_date <= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)';

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

1001: stmt_rel := stmt_rel || ' AND POR.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)';
1002:
1003: ELSIF p_date_from IS NULL AND p_date_to IS NOT NULL THEN
1004:
1005: stmt_rel := stmt_rel || ' AND POR.creation_date <= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)';
1006:
1007: ELSE
1008:
1009: stmt_rel := stmt_rel || ' AND POR.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)

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

1005: stmt_rel := stmt_rel || ' AND POR.creation_date <= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)';
1006:
1007: ELSE
1008:
1009: stmt_rel := stmt_rel || ' AND POR.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)
1010: AND POR.creation_date < Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)+1';
1011:
1012: END IF;
1013:

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

1006:
1007: ELSE
1008:
1009: stmt_rel := stmt_rel || ' AND POR.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)
1010: AND POR.creation_date < Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)+1';
1011:
1012: END IF;
1013:
1014:

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

1013:
1014:
1015: IF p_supplier_id IS NOT NULL THEN
1016:
1017: stmt_rel := stmt_rel || ' AND POH.vendor_id = PO_MASS_UPDATE_PO_PVT.get_supplier_id';
1018:
1019: END IF;
1020:
1021:

Line 1452: AND wfn.recipient_role = PO_Mass_Update_PO_PVT.get_old_username

1448: AND wfa.item_type = poh.wf_item_type
1449: AND wfa.item_key = poh.wf_item_key
1450: AND wfn.status NOT IN (''CLOSED'',''CANCELED'')
1451: AND Nvl(poh.authorization_status,''INCOMPLETE'') IN (''IN PROCESS'',''PRE-APPROVED'')
1452: AND wfn.recipient_role = PO_Mass_Update_PO_PVT.get_old_username
1453: AND pdt.document_type_code in (''PO'',''PA'')
1454: AND pdt.document_subtype = poh.type_lookup_code';
1455:
1456:

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

1455:
1456:
1457: IF p_document_type IS NOT NULL AND p_document_type <> 'ALL' THEN --
1458:
1459: stmt_po := stmt_po || ' AND poh.type_lookup_code = PO_MASS_UPDATE_PO_PVT.get_document_type';
1460:
1461: END IF;
1462:
1463:

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

1468: stmt_po := stmt_po || ' AND 1 = 1 ';
1469:
1470: ELSIF p_document_no_from IS NOT NULL AND p_document_no_to IS NULL THEN
1471:
1472: 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)';
1473:
1474: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
1475:
1476: 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 1476: 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)';

1472: 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)';
1473:
1474: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
1475:
1476: 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)';
1477:
1478: ELSE
1479:
1480: stmt_po := stmt_po || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL )

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

1478: ELSE
1479:
1480: stmt_po := stmt_po || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL )
1481:
1482: BETWEEN to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_from) AND to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_to)';
1483:
1484: END IF;
1485:
1486: ELSE

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

1490: stmt_po := stmt_po || ' AND 1 = 1 ';
1491:
1492: ELSIF p_document_no_from IS NOT NULL AND p_document_no_to IS NULL THEN
1493:
1494: stmt_po := stmt_po || ' AND POH.SEGMENT1 >= PO_MASS_UPDATE_PO_PVT.get_document_no_from';
1495:
1496: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
1497:
1498: stmt_po := stmt_po || ' AND POH.SEGMENT1 <= PO_MASS_UPDATE_PO_PVT.get_document_no_to';

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

1494: stmt_po := stmt_po || ' AND POH.SEGMENT1 >= PO_MASS_UPDATE_PO_PVT.get_document_no_from';
1495:
1496: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
1497:
1498: stmt_po := stmt_po || ' AND POH.SEGMENT1 <= PO_MASS_UPDATE_PO_PVT.get_document_no_to';
1499:
1500: ELSE
1501:
1502: 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 1502: 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';

1498: stmt_po := stmt_po || ' AND POH.SEGMENT1 <= PO_MASS_UPDATE_PO_PVT.get_document_no_to';
1499:
1500: ELSE
1501:
1502: 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';
1503:
1504: END IF;
1505:
1506: END IF; /* End of po_num_type = 'NUMERIC' */

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

1512: stmt_po := stmt_po || ' AND 1 = 1 ';
1513:
1514: ELSIF p_date_from IS NOT NULL AND p_date_to IS NULL THEN
1515:
1516: stmt_po := stmt_po || ' AND POH.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)';
1517:
1518: ELSIF p_date_from IS NULL AND p_date_to IS NOT NULL THEN
1519:
1520: stmt_po := stmt_po || ' AND POH.creation_date <= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)';

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

1516: stmt_po := stmt_po || ' AND POH.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)';
1517:
1518: ELSIF p_date_from IS NULL AND p_date_to IS NOT NULL THEN
1519:
1520: stmt_po := stmt_po || ' AND POH.creation_date <= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)';
1521:
1522: ELSE
1523:
1524: stmt_po := stmt_po || ' AND POH.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)

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

1520: stmt_po := stmt_po || ' AND POH.creation_date <= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)';
1521:
1522: ELSE
1523:
1524: stmt_po := stmt_po || ' AND POH.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)
1525: AND POH.creation_date < Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)+1';
1526:
1527: END IF;
1528:

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

1521:
1522: ELSE
1523:
1524: stmt_po := stmt_po || ' AND POH.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)
1525: AND POH.creation_date < Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)+1';
1526:
1527: END IF;
1528:
1529:

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

1528:
1529:
1530: IF p_supplier_id IS NOT NULL THEN
1531:
1532: stmt_po := stmt_po || ' AND POH.vendor_id = PO_MASS_UPDATE_PO_PVT.get_supplier_id';
1533:
1534: END IF;
1535:
1536: IF p_include_close_po = 'YES' THEN

Line 1654: AND recipient_role = PO_Mass_Update_PO_PVT.get_old_username

1650: AND wfa.item_type = por.wf_item_type
1651: AND wfa.item_key = por.wf_item_key
1652: AND wfn.status NOT IN (''CLOSED'',''CANCELED'')
1653: AND Nvl(por.authorization_status,''INCOMPLETE'') IN (''IN PROCESS'',''PRE-APPROVED'')
1654: AND recipient_role = PO_Mass_Update_PO_PVT.get_old_username
1655: AND por.po_header_id = poh.po_header_id
1656: AND pdt.document_type_code = ''RELEASE''
1657: AND pdt.document_subtype = por.release_type';
1658:

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

1658:
1659:
1660: IF p_document_type IS NOT NULL AND p_document_type <> 'ALL' THEN --
1661:
1662: stmt_rel := stmt_rel || ' AND ((PO_MASS_UPDATE_PO_PVT.get_document_type = ''PLANNED'' and por.release_type = ''SCHEDULED'')
1663:
1664: OR (por.release_type = Nvl(PO_MASS_UPDATE_PO_PVT.get_document_type,por.release_type)))';
1665:
1666: END IF;

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

1660: IF p_document_type IS NOT NULL AND p_document_type <> 'ALL' THEN --
1661:
1662: stmt_rel := stmt_rel || ' AND ((PO_MASS_UPDATE_PO_PVT.get_document_type = ''PLANNED'' and por.release_type = ''SCHEDULED'')
1663:
1664: OR (por.release_type = Nvl(PO_MASS_UPDATE_PO_PVT.get_document_type,por.release_type)))';
1665:
1666: END IF;
1667:
1668: IF ( po_num_type = 'NUMERIC' ) THEN

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

1672: stmt_rel := stmt_rel || ' AND 1 = 1 ';
1673:
1674: ELSIF p_document_no_from IS NOT NULL AND p_document_no_to IS NULL THEN
1675:
1676: 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)';
1677:
1678: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
1679:
1680: 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 1680: 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)';

1676: 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)';
1677:
1678: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
1679:
1680: 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)';
1681:
1682: ELSE
1683:
1684: stmt_rel := stmt_rel || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL )

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

1682: ELSE
1683:
1684: stmt_rel := stmt_rel || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL )
1685:
1686: BETWEEN to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_from) AND to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_to)';
1687:
1688: END IF;
1689:
1690: ELSE

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

1694: stmt_rel := stmt_rel || ' AND 1 = 1 ';
1695:
1696: ELSIF p_document_no_from IS NOT NULL AND p_document_no_to IS NULL THEN
1697:
1698: stmt_rel := stmt_rel || ' AND POH.SEGMENT1 >= PO_MASS_UPDATE_PO_PVT.get_document_no_from';
1699:
1700: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
1701:
1702: stmt_rel := stmt_rel || ' AND POH.SEGMENT1 <= PO_MASS_UPDATE_PO_PVT.get_document_no_to';

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

1698: stmt_rel := stmt_rel || ' AND POH.SEGMENT1 >= PO_MASS_UPDATE_PO_PVT.get_document_no_from';
1699:
1700: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
1701:
1702: stmt_rel := stmt_rel || ' AND POH.SEGMENT1 <= PO_MASS_UPDATE_PO_PVT.get_document_no_to';
1703:
1704: ELSE
1705:
1706: 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 1706: 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';

1702: stmt_rel := stmt_rel || ' AND POH.SEGMENT1 <= PO_MASS_UPDATE_PO_PVT.get_document_no_to';
1703:
1704: ELSE
1705:
1706: 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';
1707:
1708: END IF;
1709:
1710: END IF; /* End of po_num_type = 'NUMERIC' */

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

1716: stmt_rel := stmt_rel || ' AND 1 = 1 ';
1717:
1718: ELSIF p_date_from IS NOT NULL AND p_date_to IS NULL THEN
1719:
1720: stmt_rel := stmt_rel || ' AND POR.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)';
1721:
1722: ELSIF p_date_from IS NULL AND p_date_to IS NOT NULL THEN
1723:
1724: stmt_rel := stmt_rel || ' AND POR.creation_date <= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)';

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

1720: stmt_rel := stmt_rel || ' AND POR.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)';
1721:
1722: ELSIF p_date_from IS NULL AND p_date_to IS NOT NULL THEN
1723:
1724: stmt_rel := stmt_rel || ' AND POR.creation_date <= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)';
1725:
1726: ELSE
1727:
1728: stmt_rel := stmt_rel || ' AND POR.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)

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

1724: stmt_rel := stmt_rel || ' AND POR.creation_date <= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)';
1725:
1726: ELSE
1727:
1728: stmt_rel := stmt_rel || ' AND POR.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)
1729: AND POR.creation_date < Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)+1';
1730:
1731: END IF;
1732:

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

1725:
1726: ELSE
1727:
1728: stmt_rel := stmt_rel || ' AND POR.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)
1729: AND POR.creation_date < Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)+1';
1730:
1731: END IF;
1732:
1733: IF p_supplier_id IS NOT NULL THEN

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

1731: END IF;
1732:
1733: IF p_supplier_id IS NOT NULL THEN
1734:
1735: stmt_rel := stmt_rel || ' AND POH.vendor_id = PO_MASS_UPDATE_PO_PVT.get_supplier_id';
1736:
1737: END IF;
1738:
1739: IF p_include_close_po = 'YES' THEN

Line 2056: WHERE pod.deliver_to_person_id = PO_MASS_UPDATE_PO_PVT.get_old_personid

2052: pod.po_release_id
2053: FROM po_headers poh,
2054: po_document_types_vl pdt,
2055: po_distributions pod
2056: WHERE pod.deliver_to_person_id = PO_MASS_UPDATE_PO_PVT.get_old_personid
2057: AND poh.po_header_id = pod.po_header_id
2058: AND pdt.document_type_code IN (''PO'',''PA'')
2059: AND pdt.document_subtype = poh.type_lookup_code
2060: AND Nvl(poh.authorization_status,''INCOMPLETE'') IN (''APPROVED'',''REQUIRES REAPPROVAL'',''INCOMPLETE'',''REJECTED'',''IN PROCESS'',''PRE-APPROVED'')

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

2062: AND Nvl(poh.frozen_flag,''N'') = ''N''';
2063:
2064: IF p_document_type IS NOT NULL AND p_document_type <> 'ALL' THEN --
2065:
2066: stmt_po := stmt_po || 'AND poh.type_lookup_code = PO_MASS_UPDATE_PO_PVT.get_document_type';
2067:
2068: END IF;
2069:
2070: IF ( po_num_type = 'NUMERIC' ) THEN

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

2074: stmt_po := stmt_po || ' AND 1 = 1 ';
2075:
2076: ELSIF p_document_no_from IS NOT NULL AND p_document_no_to IS NULL THEN
2077:
2078: 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)';
2079:
2080: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
2081:
2082: 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 2082: 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)';

2078: 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)';
2079:
2080: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
2081:
2082: 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)';
2083:
2084: ELSE
2085:
2086: stmt_po := stmt_po || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL )

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

2084: ELSE
2085:
2086: stmt_po := stmt_po || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL )
2087:
2088: BETWEEN to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_from) AND to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_to)';
2089:
2090: END IF;
2091:
2092: ELSE

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

2096: stmt_po := stmt_po || ' AND 1 = 1 ';
2097:
2098: ELSIF p_document_no_from IS NOT NULL AND p_document_no_to IS NULL THEN
2099:
2100: stmt_po := stmt_po || ' AND POH.SEGMENT1 >= PO_MASS_UPDATE_PO_PVT.get_document_no_from';
2101:
2102: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
2103:
2104: stmt_po := stmt_po || ' AND POH.SEGMENT1 <= PO_MASS_UPDATE_PO_PVT.get_document_no_to';

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

2100: stmt_po := stmt_po || ' AND POH.SEGMENT1 >= PO_MASS_UPDATE_PO_PVT.get_document_no_from';
2101:
2102: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
2103:
2104: stmt_po := stmt_po || ' AND POH.SEGMENT1 <= PO_MASS_UPDATE_PO_PVT.get_document_no_to';
2105:
2106: ELSE
2107:
2108: 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 2108: 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';

2104: stmt_po := stmt_po || ' AND POH.SEGMENT1 <= PO_MASS_UPDATE_PO_PVT.get_document_no_to';
2105:
2106: ELSE
2107:
2108: 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';
2109:
2110: END IF;
2111:
2112: END IF; /* End of po_num_type = 'NUMERIC' */

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

2118: stmt_po := stmt_po || ' AND 1 = 1 ';
2119:
2120: ELSIF p_date_from IS NOT NULL AND p_date_to IS NULL THEN
2121:
2122: stmt_po := stmt_po || ' AND POH.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)';
2123:
2124: ELSIF p_date_from IS NULL AND p_date_to IS NOT NULL THEN
2125:
2126: stmt_po := stmt_po || ' AND POH.creation_date <= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)';

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

2122: stmt_po := stmt_po || ' AND POH.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)';
2123:
2124: ELSIF p_date_from IS NULL AND p_date_to IS NOT NULL THEN
2125:
2126: stmt_po := stmt_po || ' AND POH.creation_date <= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)';
2127:
2128: ELSE
2129: stmt_po := stmt_po || ' AND POH.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)
2130: AND POH.creation_date < Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)+1';

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

2125:
2126: stmt_po := stmt_po || ' AND POH.creation_date <= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)';
2127:
2128: ELSE
2129: stmt_po := stmt_po || ' AND POH.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)
2130: AND POH.creation_date < Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)+1';
2131:
2132: END IF;
2133:

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

2126: stmt_po := stmt_po || ' AND POH.creation_date <= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)';
2127:
2128: ELSE
2129: stmt_po := stmt_po || ' AND POH.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)
2130: AND POH.creation_date < Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)+1';
2131:
2132: END IF;
2133:
2134: IF p_supplier_id IS NOT NULL THEN

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

2132: END IF;
2133:
2134: IF p_supplier_id IS NOT NULL THEN
2135:
2136: stmt_po := stmt_po || ' AND POH.vendor_id = PO_MASS_UPDATE_PO_PVT.get_supplier_id';
2137:
2138: END IF;
2139:
2140: IF p_include_close_po = 'YES' THEN

Line 2263: AND pod.deliver_to_person_id = PO_MASS_UPDATE_PO_PVT.get_old_personid

2259: po_distributions_all pod
2260: WHERE por.po_header_id = poh.po_header_id
2261: AND poh.po_header_id = pod.po_header_id
2262: AND pod.po_release_id = por.po_release_id /* Bug 6868589 */
2263: AND pod.deliver_to_person_id = PO_MASS_UPDATE_PO_PVT.get_old_personid
2264: AND pdt.document_type_code =''RELEASE''
2265: AND pdt.document_subtype = por.release_type
2266: AND Nvl(por.authorization_status,''INCOMPLETE'') IN (''APPROVED'',''REQUIRES REAPPROVAL'',''INCOMPLETE'',''REJECTED'',''IN PROCESS'',''PRE-APPROVED'')
2267: AND Nvl(por.cancel_flag,''N'') = ''N''

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

2268: AND Nvl(por.frozen_flag,''N'') = ''N''';
2269:
2270: IF p_document_type IS NOT NULL AND p_document_type <> 'ALL' THEN --
2271:
2272: stmt_rel := stmt_rel || ' AND ((PO_MASS_UPDATE_PO_PVT.get_document_type = ''PLANNED'' and por.release_type = ''SCHEDULED'')
2273:
2274: OR (por.release_type = Nvl(PO_MASS_UPDATE_PO_PVT.get_document_type,por.release_type)))';
2275:
2276: END IF;

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

2270: IF p_document_type IS NOT NULL AND p_document_type <> 'ALL' THEN --
2271:
2272: stmt_rel := stmt_rel || ' AND ((PO_MASS_UPDATE_PO_PVT.get_document_type = ''PLANNED'' and por.release_type = ''SCHEDULED'')
2273:
2274: OR (por.release_type = Nvl(PO_MASS_UPDATE_PO_PVT.get_document_type,por.release_type)))';
2275:
2276: END IF;
2277:
2278:

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

2283: stmt_rel := stmt_rel || ' AND 1 = 1 ';
2284:
2285: ELSIF p_document_no_from IS NOT NULL AND p_document_no_to IS NULL THEN
2286:
2287: 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)';
2288:
2289: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
2290:
2291: 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 2291: 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 )';

2287: 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)';
2288:
2289: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
2290:
2291: 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 )';
2292:
2293: ELSE
2294:
2295: stmt_rel := stmt_rel || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL )

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

2293: ELSE
2294:
2295: stmt_rel := stmt_rel || ' AND DECODE ( RTRIM ( POH.SEGMENT1,''0123456789'' ), NULL, To_Number ( POH.SEGMENT1 ) , NULL )
2296:
2297: BETWEEN to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_from) AND to_number(PO_MASS_UPDATE_PO_PVT.get_document_no_to)';
2298:
2299: END IF;
2300:
2301: ELSE

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

2305: stmt_rel := stmt_rel || ' AND 1 = 1 ';
2306:
2307: ELSIF p_document_no_from IS NOT NULL AND p_document_no_to IS NULL THEN
2308:
2309: stmt_rel := stmt_rel || ' AND POH.SEGMENT1 >= PO_MASS_UPDATE_PO_PVT.get_document_no_from';
2310:
2311: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
2312:
2313: stmt_rel := stmt_rel || ' AND POH.SEGMENT1 <= PO_MASS_UPDATE_PO_PVT.get_document_no_to';

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

2309: stmt_rel := stmt_rel || ' AND POH.SEGMENT1 >= PO_MASS_UPDATE_PO_PVT.get_document_no_from';
2310:
2311: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
2312:
2313: stmt_rel := stmt_rel || ' AND POH.SEGMENT1 <= PO_MASS_UPDATE_PO_PVT.get_document_no_to';
2314:
2315: ELSE
2316:
2317: 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 2317: 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';

2313: stmt_rel := stmt_rel || ' AND POH.SEGMENT1 <= PO_MASS_UPDATE_PO_PVT.get_document_no_to';
2314:
2315: ELSE
2316:
2317: 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';
2318:
2319: END IF;
2320:
2321: END IF; /* End of po_num_type = 'NUMERIC' */

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

2327: stmt_rel := stmt_rel || ' AND 1 = 1 ';
2328:
2329: ELSIF p_date_from IS NOT NULL AND p_date_to IS NULL THEN
2330:
2331: stmt_rel := stmt_rel || ' AND POR.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)';
2332:
2333: ELSIF p_date_from IS NULL AND p_date_to IS NOT NULL THEN
2334:
2335: stmt_rel := stmt_rel || ' AND POR.creation_date <= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)';

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

2331: stmt_rel := stmt_rel || ' AND POR.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)';
2332:
2333: ELSIF p_date_from IS NULL AND p_date_to IS NOT NULL THEN
2334:
2335: stmt_rel := stmt_rel || ' AND POR.creation_date <= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)';
2336:
2337: ELSE
2338:
2339: stmt_rel := stmt_rel || ' AND POR.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)

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

2335: stmt_rel := stmt_rel || ' AND POR.creation_date <= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)';
2336:
2337: ELSE
2338:
2339: stmt_rel := stmt_rel || ' AND POR.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)
2340: AND POR.creation_date < Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)+1';
2341:
2342: END IF;
2343:

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

2336:
2337: ELSE
2338:
2339: stmt_rel := stmt_rel || ' AND POR.creation_date >= Trunc(PO_MASS_UPDATE_PO_PVT.get_date_from)
2340: AND POR.creation_date < Trunc(PO_MASS_UPDATE_PO_PVT.get_date_to)+1';
2341:
2342: END IF;
2343:
2344: IF p_supplier_id IS NOT NULL THEN

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

2342: END IF;
2343:
2344: IF p_supplier_id IS NOT NULL THEN
2345:
2346: stmt_rel := stmt_rel || ' AND POH.vendor_id = PO_MASS_UPDATE_PO_PVT.get_supplier_id';
2347:
2348: END IF;
2349:
2350: IF p_include_close_po = 'YES' THEN

Line 2978: END PO_Mass_Update_PO_PVT;

2974: BEGIN
2975: RETURN g_old_username;
2976: END;
2977:
2978: END PO_Mass_Update_PO_PVT;