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_REQ_PVT dependencies on PO_MASS_UPDATE_REQ_PVT

Line 1: PACKAGE BODY PO_Mass_Update_Req_PVT AS

1: PACKAGE BODY PO_Mass_Update_Req_PVT AS
2: /* $Header: PO_Mass_Update_Req_PVT.plb 120.7 2008/04/24 06:21:10 rakchakr noship $*/
3:
4: --------------------------------------------------------------------------------------------------
5:

Line 2: /* $Header: PO_Mass_Update_Req_PVT.plb 120.7 2008/04/24 06:21:10 rakchakr noship $*/

1: PACKAGE BODY PO_Mass_Update_Req_PVT AS
2: /* $Header: PO_Mass_Update_Req_PVT.plb 120.7 2008/04/24 06:21:10 rakchakr noship $*/
3:
4: --------------------------------------------------------------------------------------------------
5:
6: -- Call is made such that the sql file POXMUR.sql calls the procedure

Line 8: -- PO_Mass_Update_Req_GRP.Update_Persons calls the procedure PO_Mass_Update_Req_PVT.DO_Update

4: --------------------------------------------------------------------------------------------------
5:
6: -- Call is made such that the sql file POXMUR.sql calls the procedure
7: -- PO_Mass_Update_Req_GRP.Update_Persons
8: -- PO_Mass_Update_Req_GRP.Update_Persons calls the procedure PO_Mass_Update_Req_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_Req_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_Req_PVT';
15: g_log_head CONSTANT VARCHAR2(1000) := 'po.plsql.' || g_pkg_name || '.';
16:
17: TYPE g_req IS REF CURSOR;
18:

Line 458: WHERE por.preparer_id = PO_MASS_UPDATE_REQ_PVT.get_old_personid

454: por.wf_item_type,
455: por.wf_item_key
456: FROM po_requisition_headers por,
457: po_document_types_vl pdt
458: WHERE por.preparer_id = PO_MASS_UPDATE_REQ_PVT.get_old_personid
459: AND pdt.document_type_code IN (''REQUISITION'')
460: AND pdt.document_subtype = por.type_lookup_code
461: AND Nvl(por.authorization_status,''INCOMPLETE'') IN (''APPROVED'',''REQUIRES REAPPROVAL'',''INCOMPLETE'',''REJECTED'',''IN PROCESS'',''PRE-APPROVED'',''RETURNED'')
462: AND Nvl(por.cancel_flag,''N'') = ''N''';

Line 466: stmt_req := stmt_req || ' AND por.type_lookup_code = PO_MASS_UPDATE_REQ_PVT.get_document_type';

462: AND Nvl(por.cancel_flag,''N'') = ''N''';
463:
464: IF p_document_type IS NOT NULL AND p_document_type <> 'ALL' THEN --
465:
466: stmt_req := stmt_req || ' AND por.type_lookup_code = PO_MASS_UPDATE_REQ_PVT.get_document_type';
467: END IF;
468:
469:
470: IF ( req_num_type = 'NUMERIC' ) THEN

Line 478: stmt_req := stmt_req || ' AND DECODE ( RTRIM ( POR.SEGMENT1,''0123456789'' ), NULL, To_Number ( POR.SEGMENT1 ) , NULL ) >= to_number(PO_MASS_UPDATE_REQ_PVT.get_document_no_from)';

474: stmt_req := stmt_req || ' AND 1 = 1 ';
475:
476: ELSIF p_document_no_from IS NOT NULL AND p_document_no_to IS NULL THEN
477:
478: stmt_req := stmt_req || ' AND DECODE ( RTRIM ( POR.SEGMENT1,''0123456789'' ), NULL, To_Number ( POR.SEGMENT1 ) , NULL ) >= to_number(PO_MASS_UPDATE_REQ_PVT.get_document_no_from)';
479:
480: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
481:
482: stmt_req := stmt_req || ' AND DECODE ( RTRIM ( POR.SEGMENT1,''0123456789'' ), NULL, To_Number ( POR.SEGMENT1 ) , NULL ) <= to_number(PO_MASS_UPDATE_REQ_PVT.get_document_no_to)';

Line 482: stmt_req := stmt_req || ' AND DECODE ( RTRIM ( POR.SEGMENT1,''0123456789'' ), NULL, To_Number ( POR.SEGMENT1 ) , NULL ) <= to_number(PO_MASS_UPDATE_REQ_PVT.get_document_no_to)';

478: stmt_req := stmt_req || ' AND DECODE ( RTRIM ( POR.SEGMENT1,''0123456789'' ), NULL, To_Number ( POR.SEGMENT1 ) , NULL ) >= to_number(PO_MASS_UPDATE_REQ_PVT.get_document_no_from)';
479:
480: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
481:
482: stmt_req := stmt_req || ' AND DECODE ( RTRIM ( POR.SEGMENT1,''0123456789'' ), NULL, To_Number ( POR.SEGMENT1 ) , NULL ) <= to_number(PO_MASS_UPDATE_REQ_PVT.get_document_no_to)';
483:
484: ELSE
485:
486: stmt_req := stmt_req || ' AND DECODE ( RTRIM ( POR.SEGMENT1,''0123456789'' ), NULL, To_Number ( POR.SEGMENT1 ) , NULL )

Line 488: BETWEEN to_number(PO_MASS_UPDATE_REQ_PVT.get_document_no_from) AND to_number(PO_MASS_UPDATE_REQ_PVT.get_document_no_to )';

484: ELSE
485:
486: stmt_req := stmt_req || ' AND DECODE ( RTRIM ( POR.SEGMENT1,''0123456789'' ), NULL, To_Number ( POR.SEGMENT1 ) , NULL )
487:
488: BETWEEN to_number(PO_MASS_UPDATE_REQ_PVT.get_document_no_from) AND to_number(PO_MASS_UPDATE_REQ_PVT.get_document_no_to )';
489:
490: END IF;
491:
492: ELSE

Line 500: stmt_req := stmt_req || ' AND POR.SEGMENT1 >= PO_MASS_UPDATE_REQ_PVT.get_document_no_from';

496: stmt_req := stmt_req || ' AND 1 = 1 ';
497:
498: ELSIF p_document_no_from IS NOT NULL AND p_document_no_to IS NULL THEN
499:
500: stmt_req := stmt_req || ' AND POR.SEGMENT1 >= PO_MASS_UPDATE_REQ_PVT.get_document_no_from';
501:
502: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
503:
504: stmt_req := stmt_req || ' AND POR.SEGMENT1 <= PO_MASS_UPDATE_REQ_PVT.get_document_no_to';

Line 504: stmt_req := stmt_req || ' AND POR.SEGMENT1 <= PO_MASS_UPDATE_REQ_PVT.get_document_no_to';

500: stmt_req := stmt_req || ' AND POR.SEGMENT1 >= PO_MASS_UPDATE_REQ_PVT.get_document_no_from';
501:
502: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
503:
504: stmt_req := stmt_req || ' AND POR.SEGMENT1 <= PO_MASS_UPDATE_REQ_PVT.get_document_no_to';
505:
506: ELSE
507:
508: stmt_req := stmt_req || ' AND POR.SEGMENT1 BETWEEN PO_MASS_UPDATE_REQ_PVT.get_document_no_from AND PO_MASS_UPDATE_REQ_PVT.get_document_no_to';

Line 508: stmt_req := stmt_req || ' AND POR.SEGMENT1 BETWEEN PO_MASS_UPDATE_REQ_PVT.get_document_no_from AND PO_MASS_UPDATE_REQ_PVT.get_document_no_to';

504: stmt_req := stmt_req || ' AND POR.SEGMENT1 <= PO_MASS_UPDATE_REQ_PVT.get_document_no_to';
505:
506: ELSE
507:
508: stmt_req := stmt_req || ' AND POR.SEGMENT1 BETWEEN PO_MASS_UPDATE_REQ_PVT.get_document_no_from AND PO_MASS_UPDATE_REQ_PVT.get_document_no_to';
509:
510: END IF;
511:
512: END IF; /* req_num_type = 'NUMERIC' */

Line 522: stmt_req := stmt_req || ' AND POR.creation_date >= Trunc(PO_MASS_UPDATE_REQ_PVT.get_date_from)';

518: stmt_req := stmt_req || ' AND 1 = 1 ';
519:
520: ELSIF p_date_from IS NOT NULL AND p_date_to IS NULL THEN
521:
522: stmt_req := stmt_req || ' AND POR.creation_date >= Trunc(PO_MASS_UPDATE_REQ_PVT.get_date_from)';
523:
524: ELSIF p_date_from IS NULL AND p_date_to IS NOT NULL THEN
525:
526: stmt_req := stmt_req || ' AND POR.creation_date <= Trunc(PO_MASS_UPDATE_REQ_PVT.get_date_to)';

Line 526: stmt_req := stmt_req || ' AND POR.creation_date <= Trunc(PO_MASS_UPDATE_REQ_PVT.get_date_to)';

522: stmt_req := stmt_req || ' AND POR.creation_date >= Trunc(PO_MASS_UPDATE_REQ_PVT.get_date_from)';
523:
524: ELSIF p_date_from IS NULL AND p_date_to IS NOT NULL THEN
525:
526: stmt_req := stmt_req || ' AND POR.creation_date <= Trunc(PO_MASS_UPDATE_REQ_PVT.get_date_to)';
527:
528: ELSE
529: stmt_req := stmt_req || ' AND POR.creation_date >= Trunc(PO_MASS_UPDATE_REQ_PVT.get_date_from)
530: AND POR.creation_date < Trunc(PO_MASS_UPDATE_REQ_PVT.get_date_to)+1';

Line 529: stmt_req := stmt_req || ' AND POR.creation_date >= Trunc(PO_MASS_UPDATE_REQ_PVT.get_date_from)

525:
526: stmt_req := stmt_req || ' AND POR.creation_date <= Trunc(PO_MASS_UPDATE_REQ_PVT.get_date_to)';
527:
528: ELSE
529: stmt_req := stmt_req || ' AND POR.creation_date >= Trunc(PO_MASS_UPDATE_REQ_PVT.get_date_from)
530: AND POR.creation_date < Trunc(PO_MASS_UPDATE_REQ_PVT.get_date_to)+1';
531:
532: END IF;
533:

Line 530: AND POR.creation_date < Trunc(PO_MASS_UPDATE_REQ_PVT.get_date_to)+1';

526: stmt_req := stmt_req || ' AND POR.creation_date <= Trunc(PO_MASS_UPDATE_REQ_PVT.get_date_to)';
527:
528: ELSE
529: stmt_req := stmt_req || ' AND POR.creation_date >= Trunc(PO_MASS_UPDATE_REQ_PVT.get_date_from)
530: AND POR.creation_date < Trunc(PO_MASS_UPDATE_REQ_PVT.get_date_to)+1';
531:
532: END IF;
533:
534: stmt_req := stmt_req || ' ORDER BY por.segment1';

Line 896: AND wfn.recipient_role = PO_Mass_Update_Req_PVT.get_old_username

892: AND wfa.item_type = por.wf_item_type
893: AND wfa.item_key = por.wf_item_key
894: AND wfn.status NOT IN (''CLOSED'',''CANCELED'')
895: AND Nvl(por.authorization_status,''INCOMPLETE'') IN (''IN PROCESS'',''PRE-APPROVED'')
896: AND wfn.recipient_role = PO_Mass_Update_Req_PVT.get_old_username
897: AND pdt.document_type_code in (''REQUISITION'')
898: AND pdt.document_subtype = por.type_lookup_code';
899:
900: IF p_document_type IS NOT NULL AND p_document_type <> 'ALL' THEN --

Line 902: stmt_req := stmt_req || ' AND por.type_lookup_code = PO_Mass_Update_Req_PVT.get_document_type';

898: AND pdt.document_subtype = por.type_lookup_code';
899:
900: IF p_document_type IS NOT NULL AND p_document_type <> 'ALL' THEN --
901:
902: stmt_req := stmt_req || ' AND por.type_lookup_code = PO_Mass_Update_Req_PVT.get_document_type';
903: END IF;
904:
905: IF ( req_num_type = 'NUMERIC' ) THEN
906:

Line 913: stmt_req := stmt_req || ' AND DECODE ( RTRIM ( POR.SEGMENT1,''0123456789'' ), NULL, To_Number ( POR.SEGMENT1 ) , NULL ) >= to_number(PO_Mass_Update_Req_PVT.get_document_no_from)';

909: stmt_req := stmt_req || ' AND 1 = 1 ';
910:
911: ELSIF p_document_no_from IS NOT NULL AND p_document_no_to IS NULL THEN
912:
913: stmt_req := stmt_req || ' AND DECODE ( RTRIM ( POR.SEGMENT1,''0123456789'' ), NULL, To_Number ( POR.SEGMENT1 ) , NULL ) >= to_number(PO_Mass_Update_Req_PVT.get_document_no_from)';
914:
915: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
916:
917: stmt_req := stmt_req || ' AND DECODE ( RTRIM ( POR.SEGMENT1,''0123456789'' ), NULL, To_Number ( POR.SEGMENT1 ) , NULL ) <= to_number(PO_Mass_Update_Req_PVT.get_document_no_to)';

Line 917: stmt_req := stmt_req || ' AND DECODE ( RTRIM ( POR.SEGMENT1,''0123456789'' ), NULL, To_Number ( POR.SEGMENT1 ) , NULL ) <= to_number(PO_Mass_Update_Req_PVT.get_document_no_to)';

913: stmt_req := stmt_req || ' AND DECODE ( RTRIM ( POR.SEGMENT1,''0123456789'' ), NULL, To_Number ( POR.SEGMENT1 ) , NULL ) >= to_number(PO_Mass_Update_Req_PVT.get_document_no_from)';
914:
915: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
916:
917: stmt_req := stmt_req || ' AND DECODE ( RTRIM ( POR.SEGMENT1,''0123456789'' ), NULL, To_Number ( POR.SEGMENT1 ) , NULL ) <= to_number(PO_Mass_Update_Req_PVT.get_document_no_to)';
918:
919: ELSE
920:
921: stmt_req := stmt_req || ' AND DECODE ( RTRIM ( POR.SEGMENT1,''0123456789'' ), NULL, To_Number ( POR.SEGMENT1 ) , NULL )

Line 923: BETWEEN to_number(PO_Mass_Update_Req_PVT.get_document_no_from) AND to_number(PO_Mass_Update_Req_PVT.get_document_no_to ||)';

919: ELSE
920:
921: stmt_req := stmt_req || ' AND DECODE ( RTRIM ( POR.SEGMENT1,''0123456789'' ), NULL, To_Number ( POR.SEGMENT1 ) , NULL )
922:
923: BETWEEN to_number(PO_Mass_Update_Req_PVT.get_document_no_from) AND to_number(PO_Mass_Update_Req_PVT.get_document_no_to ||)';
924:
925: END IF;
926:
927: ELSE

Line 935: stmt_req := stmt_req || ' AND POR.SEGMENT1 >= PO_Mass_Update_Req_PVT.get_document_no_from';

931: stmt_req := stmt_req || ' AND 1 = 1 ';
932:
933: ELSIF p_document_no_from IS NOT NULL AND p_document_no_to IS NULL THEN
934:
935: stmt_req := stmt_req || ' AND POR.SEGMENT1 >= PO_Mass_Update_Req_PVT.get_document_no_from';
936:
937: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
938:
939: stmt_req := stmt_req || ' AND POR.SEGMENT1 <= PO_Mass_Update_Req_PVT.get_document_no_to';

Line 939: stmt_req := stmt_req || ' AND POR.SEGMENT1 <= PO_Mass_Update_Req_PVT.get_document_no_to';

935: stmt_req := stmt_req || ' AND POR.SEGMENT1 >= PO_Mass_Update_Req_PVT.get_document_no_from';
936:
937: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
938:
939: stmt_req := stmt_req || ' AND POR.SEGMENT1 <= PO_Mass_Update_Req_PVT.get_document_no_to';
940:
941: ELSE
942:
943: stmt_req := stmt_req || ' AND POR.SEGMENT1 BETWEEN PO_Mass_Update_Req_PVT.get_document_no_from AND PO_Mass_Update_Req_PVT.get_document_no_to';

Line 943: stmt_req := stmt_req || ' AND POR.SEGMENT1 BETWEEN PO_Mass_Update_Req_PVT.get_document_no_from AND PO_Mass_Update_Req_PVT.get_document_no_to';

939: stmt_req := stmt_req || ' AND POR.SEGMENT1 <= PO_Mass_Update_Req_PVT.get_document_no_to';
940:
941: ELSE
942:
943: stmt_req := stmt_req || ' AND POR.SEGMENT1 BETWEEN PO_Mass_Update_Req_PVT.get_document_no_from AND PO_Mass_Update_Req_PVT.get_document_no_to';
944:
945: END IF;
946:
947: END IF; /* req_num_type = 'NUMERIC' */

Line 957: stmt_req := stmt_req || ' AND POR.creation_date >= Trunc(PO_Mass_Update_Req_PVT.get_date_from)';

953: stmt_req := stmt_req || ' AND 1 = 1 ';
954:
955: ELSIF p_date_from IS NOT NULL AND p_date_to IS NULL THEN
956:
957: stmt_req := stmt_req || ' AND POR.creation_date >= Trunc(PO_Mass_Update_Req_PVT.get_date_from)';
958:
959: ELSIF p_date_from IS NULL AND p_date_to IS NOT NULL THEN
960:
961: stmt_req := stmt_req || ' AND POR.creation_date <= Trunc(PO_Mass_Update_Req_PVT.get_date_to)';

Line 961: stmt_req := stmt_req || ' AND POR.creation_date <= Trunc(PO_Mass_Update_Req_PVT.get_date_to)';

957: stmt_req := stmt_req || ' AND POR.creation_date >= Trunc(PO_Mass_Update_Req_PVT.get_date_from)';
958:
959: ELSIF p_date_from IS NULL AND p_date_to IS NOT NULL THEN
960:
961: stmt_req := stmt_req || ' AND POR.creation_date <= Trunc(PO_Mass_Update_Req_PVT.get_date_to)';
962:
963: ELSE
964: stmt_req := stmt_req || ' AND POR.creation_date >= Trunc(PO_Mass_Update_Req_PVT.get_date_from)
965: AND POR.creation_date < Trunc(PO_Mass_Update_Req_PVT.get_date_to)+1';

Line 964: stmt_req := stmt_req || ' AND POR.creation_date >= Trunc(PO_Mass_Update_Req_PVT.get_date_from)

960:
961: stmt_req := stmt_req || ' AND POR.creation_date <= Trunc(PO_Mass_Update_Req_PVT.get_date_to)';
962:
963: ELSE
964: stmt_req := stmt_req || ' AND POR.creation_date >= Trunc(PO_Mass_Update_Req_PVT.get_date_from)
965: AND POR.creation_date < Trunc(PO_Mass_Update_Req_PVT.get_date_to)+1';
966:
967: END IF;
968:

Line 965: AND POR.creation_date < Trunc(PO_Mass_Update_Req_PVT.get_date_to)+1';

961: stmt_req := stmt_req || ' AND POR.creation_date <= Trunc(PO_Mass_Update_Req_PVT.get_date_to)';
962:
963: ELSE
964: stmt_req := stmt_req || ' AND POR.creation_date >= Trunc(PO_Mass_Update_Req_PVT.get_date_from)
965: AND POR.creation_date < Trunc(PO_Mass_Update_Req_PVT.get_date_to)+1';
966:
967: END IF;
968:
969: stmt_req := stmt_req || ' ORDER BY por.segment1';

Line 1258: WHERE prl.to_person_id = PO_MASS_UPDATE_REQ_PVT.get_old_personid

1254: pdt.type_name
1255: FROM po_requisition_headers por,
1256: po_document_types_vl pdt,
1257: po_requisition_lines_all prl
1258: WHERE prl.to_person_id = PO_MASS_UPDATE_REQ_PVT.get_old_personid
1259: AND por.requisition_header_id = prl.requisition_header_id
1260: AND pdt.document_type_code IN (''REQUISITION'')
1261: AND pdt.document_subtype = por.type_lookup_code
1262: AND Nvl(por.authorization_status,''INCOMPLETE'') IN (''APPROVED'',''REQUIRES REAPPROVAL'',''INCOMPLETE'',''REJECTED'',''IN PROCESS'',''PRE-APPROVED'',''RETURNED'')

Line 1267: stmt_req := stmt_req || ' AND por.type_lookup_code = PO_MASS_UPDATE_REQ_PVT.get_document_type';

1263: AND Nvl(por.cancel_flag,''N'') = ''N''';
1264:
1265: IF p_document_type IS NOT NULL AND p_document_type <> 'ALL' THEN --
1266:
1267: stmt_req := stmt_req || ' AND por.type_lookup_code = PO_MASS_UPDATE_REQ_PVT.get_document_type';
1268: END IF;
1269:
1270: IF ( req_num_type = 'NUMERIC' ) THEN
1271:

Line 1278: stmt_req := stmt_req || ' AND DECODE ( RTRIM ( POR.SEGMENT1,''0123456789'' ), NULL, To_Number ( POR.SEGMENT1 ) , NULL ) >= to_number(PO_MASS_UPDATE_REQ_PVT.get_document_no_from';

1274: stmt_req := stmt_req || ' AND 1 = 1 ';
1275:
1276: ELSIF p_document_no_from IS NOT NULL AND p_document_no_to IS NULL THEN
1277:
1278: stmt_req := stmt_req || ' AND DECODE ( RTRIM ( POR.SEGMENT1,''0123456789'' ), NULL, To_Number ( POR.SEGMENT1 ) , NULL ) >= to_number(PO_MASS_UPDATE_REQ_PVT.get_document_no_from';
1279:
1280: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
1281:
1282: stmt_req := stmt_req || ' AND DECODE ( RTRIM ( POR.SEGMENT1,''0123456789'' ), NULL, To_Number ( POR.SEGMENT1 ) , NULL ) <= to_number(PO_MASS_UPDATE_REQ_PVT.get_document_no_to)';

Line 1282: stmt_req := stmt_req || ' AND DECODE ( RTRIM ( POR.SEGMENT1,''0123456789'' ), NULL, To_Number ( POR.SEGMENT1 ) , NULL ) <= to_number(PO_MASS_UPDATE_REQ_PVT.get_document_no_to)';

1278: stmt_req := stmt_req || ' AND DECODE ( RTRIM ( POR.SEGMENT1,''0123456789'' ), NULL, To_Number ( POR.SEGMENT1 ) , NULL ) >= to_number(PO_MASS_UPDATE_REQ_PVT.get_document_no_from';
1279:
1280: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
1281:
1282: stmt_req := stmt_req || ' AND DECODE ( RTRIM ( POR.SEGMENT1,''0123456789'' ), NULL, To_Number ( POR.SEGMENT1 ) , NULL ) <= to_number(PO_MASS_UPDATE_REQ_PVT.get_document_no_to)';
1283:
1284: ELSE
1285:
1286: stmt_req := stmt_req || ' AND DECODE ( RTRIM ( POR.SEGMENT1,''0123456789'' ), NULL, To_Number ( POR.SEGMENT1 ) , NULL )

Line 1288: BETWEEN to_number(PO_MASS_UPDATE_REQ_PVT.get_document_no_from) AND to_number(PO_MASS_UPDATE_REQ_PVT.get_document_no_to)';

1284: ELSE
1285:
1286: stmt_req := stmt_req || ' AND DECODE ( RTRIM ( POR.SEGMENT1,''0123456789'' ), NULL, To_Number ( POR.SEGMENT1 ) , NULL )
1287:
1288: BETWEEN to_number(PO_MASS_UPDATE_REQ_PVT.get_document_no_from) AND to_number(PO_MASS_UPDATE_REQ_PVT.get_document_no_to)';
1289:
1290: END IF;
1291:
1292: ELSE

Line 1300: stmt_req := stmt_req || ' AND POR.SEGMENT1 >= PO_MASS_UPDATE_REQ_PVT.get_document_no_from';

1296: stmt_req := stmt_req || ' AND 1 = 1 ';
1297:
1298: ELSIF p_document_no_from IS NOT NULL AND p_document_no_to IS NULL THEN
1299:
1300: stmt_req := stmt_req || ' AND POR.SEGMENT1 >= PO_MASS_UPDATE_REQ_PVT.get_document_no_from';
1301:
1302: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
1303:
1304: stmt_req := stmt_req || ' AND POR.SEGMENT1 <= PO_MASS_UPDATE_REQ_PVT.get_document_no_to';

Line 1304: stmt_req := stmt_req || ' AND POR.SEGMENT1 <= PO_MASS_UPDATE_REQ_PVT.get_document_no_to';

1300: stmt_req := stmt_req || ' AND POR.SEGMENT1 >= PO_MASS_UPDATE_REQ_PVT.get_document_no_from';
1301:
1302: ELSIF p_document_no_from IS NULL AND p_document_no_to IS NOT NULL THEN
1303:
1304: stmt_req := stmt_req || ' AND POR.SEGMENT1 <= PO_MASS_UPDATE_REQ_PVT.get_document_no_to';
1305:
1306: ELSE
1307:
1308: stmt_req := stmt_req || ' AND POR.SEGMENT1 BETWEEN PO_MASS_UPDATE_REQ_PVT.get_document_no_from AND PO_MASS_UPDATE_REQ_PVT.get_document_no_to';

Line 1308: stmt_req := stmt_req || ' AND POR.SEGMENT1 BETWEEN PO_MASS_UPDATE_REQ_PVT.get_document_no_from AND PO_MASS_UPDATE_REQ_PVT.get_document_no_to';

1304: stmt_req := stmt_req || ' AND POR.SEGMENT1 <= PO_MASS_UPDATE_REQ_PVT.get_document_no_to';
1305:
1306: ELSE
1307:
1308: stmt_req := stmt_req || ' AND POR.SEGMENT1 BETWEEN PO_MASS_UPDATE_REQ_PVT.get_document_no_from AND PO_MASS_UPDATE_REQ_PVT.get_document_no_to';
1309:
1310: END IF;
1311:
1312: END IF; /* req_num_type = 'NUMERIC' */

Line 1322: stmt_req := stmt_req || ' AND POR.creation_date >= Trunc(PO_MASS_UPDATE_REQ_PVT.get_date_from)';

1318: stmt_req := stmt_req || ' AND 1 = 1 ';
1319:
1320: ELSIF p_date_from IS NOT NULL AND p_date_to IS NULL THEN
1321:
1322: stmt_req := stmt_req || ' AND POR.creation_date >= Trunc(PO_MASS_UPDATE_REQ_PVT.get_date_from)';
1323:
1324: ELSIF p_date_from IS NULL AND p_date_to IS NOT NULL THEN
1325:
1326: stmt_req := stmt_req || ' AND POR.creation_date <= Trunc(PO_MASS_UPDATE_REQ_PVT.get_date_to)';

Line 1326: stmt_req := stmt_req || ' AND POR.creation_date <= Trunc(PO_MASS_UPDATE_REQ_PVT.get_date_to)';

1322: stmt_req := stmt_req || ' AND POR.creation_date >= Trunc(PO_MASS_UPDATE_REQ_PVT.get_date_from)';
1323:
1324: ELSIF p_date_from IS NULL AND p_date_to IS NOT NULL THEN
1325:
1326: stmt_req := stmt_req || ' AND POR.creation_date <= Trunc(PO_MASS_UPDATE_REQ_PVT.get_date_to)';
1327:
1328: ELSE
1329: stmt_req := stmt_req || ' AND POR.creation_date >= Trunc(PO_MASS_UPDATE_REQ_PVT.get_date_from)
1330: AND POR.creation_date < Trunc(PO_MASS_UPDATE_REQ_PVT.get_date_to)+1';

Line 1329: stmt_req := stmt_req || ' AND POR.creation_date >= Trunc(PO_MASS_UPDATE_REQ_PVT.get_date_from)

1325:
1326: stmt_req := stmt_req || ' AND POR.creation_date <= Trunc(PO_MASS_UPDATE_REQ_PVT.get_date_to)';
1327:
1328: ELSE
1329: stmt_req := stmt_req || ' AND POR.creation_date >= Trunc(PO_MASS_UPDATE_REQ_PVT.get_date_from)
1330: AND POR.creation_date < Trunc(PO_MASS_UPDATE_REQ_PVT.get_date_to)+1';
1331:
1332: END IF;
1333:

Line 1330: AND POR.creation_date < Trunc(PO_MASS_UPDATE_REQ_PVT.get_date_to)+1';

1326: stmt_req := stmt_req || ' AND POR.creation_date <= Trunc(PO_MASS_UPDATE_REQ_PVT.get_date_to)';
1327:
1328: ELSE
1329: stmt_req := stmt_req || ' AND POR.creation_date >= Trunc(PO_MASS_UPDATE_REQ_PVT.get_date_from)
1330: AND POR.creation_date < Trunc(PO_MASS_UPDATE_REQ_PVT.get_date_to)+1';
1331:
1332: END IF;
1333:
1334: stmt_req := stmt_req || ' ORDER BY por.segment1';

Line 1815: END PO_Mass_Update_Req_PVT;

1811: BEGIN
1812: RETURN g_old_username;
1813: END;
1814:
1815: END PO_Mass_Update_Req_PVT;