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_VALIDATIONS dependencies on PO_TBL_VARCHAR2000

Line 488: c_html_order_header_vs CONSTANT PO_TBL_VARCHAR2000 :=

484: -- Validation Sets.
485: ---------------------------------------------------------------
486:
487: -- Validation set for HTML Orders headers.
488: c_html_order_header_vs CONSTANT PO_TBL_VARCHAR2000 :=
489: PO_TBL_VARCHAR2000(
490: -- Bug# 4779226 remove c_warn_supplier_on_hold from header check
491: c_rate_gt_zero
492: , c_rate_combination_valid

Line 489: PO_TBL_VARCHAR2000(

485: ---------------------------------------------------------------
486:
487: -- Validation set for HTML Orders headers.
488: c_html_order_header_vs CONSTANT PO_TBL_VARCHAR2000 :=
489: PO_TBL_VARCHAR2000(
490: -- Bug# 4779226 remove c_warn_supplier_on_hold from header check
491: c_rate_gt_zero
492: , c_rate_combination_valid
493: , c_doc_num_chars_valid

Line 502: c_html_order_line_vs CONSTANT PO_TBL_VARCHAR2000 :=

498: , c_segment1_not_null
499: );
500:
501: -- Validation set for HTML Orders lines.
502: c_html_order_line_vs CONSTANT PO_TBL_VARCHAR2000 :=
503: PO_TBL_VARCHAR2000(
504: c_amt_agreed_ge_zero
505: , c_min_rel_amt_ge_zero
506: , c_line_qty_gt_zero

Line 503: PO_TBL_VARCHAR2000(

499: );
500:
501: -- Validation set for HTML Orders lines.
502: c_html_order_line_vs CONSTANT PO_TBL_VARCHAR2000 :=
503: PO_TBL_VARCHAR2000(
504: c_amt_agreed_ge_zero
505: , c_min_rel_amt_ge_zero
506: , c_line_qty_gt_zero
507: , c_line_qty_ge_qty_exec -- : Consolidate rcvd/billed

Line 551: c_html_order_price_diff_vs CONSTANT PO_TBL_VARCHAR2000 :=

547: , c_line_dff_validate -- Bug 7516824
548: );
549:
550: -- Validation set for HTML Order price differentials.
551: c_html_order_price_diff_vs CONSTANT PO_TBL_VARCHAR2000 :=
552: PO_TBL_VARCHAR2000(
553: c_unique_price_diff_num
554: , c_price_diff_num_gt_zero
555: , c_unique_price_type

Line 552: PO_TBL_VARCHAR2000(

548: );
549:
550: -- Validation set for HTML Order price differentials.
551: c_html_order_price_diff_vs CONSTANT PO_TBL_VARCHAR2000 :=
552: PO_TBL_VARCHAR2000(
553: c_unique_price_diff_num
554: , c_price_diff_num_gt_zero
555: , c_unique_price_type
556: , c_mul_ge_zero

Line 565: c_html_order_shipment_vs CONSTANT PO_TBL_VARCHAR2000 :=

561:
562: -- Validation set for HTML Orders shipments.
563: -- ECO 4503425: Removed the planned item null date check as this
564: -- has been moved to submission checks
565: c_html_order_shipment_vs CONSTANT PO_TBL_VARCHAR2000 :=
566: PO_TBL_VARCHAR2000(
567: c_days_early_gte_zero
568: , c_days_late_gte_zero
569: , c_rcv_close_tol_within_range

Line 566: PO_TBL_VARCHAR2000(

562: -- Validation set for HTML Orders shipments.
563: -- ECO 4503425: Removed the planned item null date check as this
564: -- has been moved to submission checks
565: c_html_order_shipment_vs CONSTANT PO_TBL_VARCHAR2000 :=
566: PO_TBL_VARCHAR2000(
567: c_days_early_gte_zero
568: , c_days_late_gte_zero
569: , c_rcv_close_tol_within_range
570: , c_over_rcpt_tol_within_range

Line 592: c_html_order_distribution_vs CONSTANT PO_TBL_VARCHAR2000 :=

588: , c_ship_dff_validate -- Bug 7516824
589: );
590:
591: -- Validation set for HTML Orders distributions.
592: c_html_order_distribution_vs CONSTANT PO_TBL_VARCHAR2000 :=
593: PO_TBL_VARCHAR2000(
594: c_dist_num_unique
595: , c_dist_num_gt_zero
596: , c_dist_qty_gt_zero

Line 593: PO_TBL_VARCHAR2000(

589: );
590:
591: -- Validation set for HTML Orders distributions.
592: c_html_order_distribution_vs CONSTANT PO_TBL_VARCHAR2000 :=
593: PO_TBL_VARCHAR2000(
594: c_dist_num_unique
595: , c_dist_num_gt_zero
596: , c_dist_qty_gt_zero
597: , c_dist_qty_ge_qty_exec -- : Combined billed/rcvd

Line 611: c_html_agmt_header_vs CONSTANT PO_TBL_VARCHAR2000 :=

607: , c_dist_dff_validate -- Bug 7516824
608: );
609:
610: -- Validation set for HTML Agreement headers.
611: c_html_agmt_header_vs CONSTANT PO_TBL_VARCHAR2000 :=
612: PO_TBL_VARCHAR2000(
613: -- Bug# 4779226 remove c_warn_supplier_on_hold from header check
614: c_rate_gt_zero
615: , c_rate_combination_valid

Line 612: PO_TBL_VARCHAR2000(

608: );
609:
610: -- Validation set for HTML Agreement headers.
611: c_html_agmt_header_vs CONSTANT PO_TBL_VARCHAR2000 :=
612: PO_TBL_VARCHAR2000(
613: -- Bug# 4779226 remove c_warn_supplier_on_hold from header check
614: c_rate_gt_zero
615: , c_rate_combination_valid
616: , c_fax_email_address_valid

Line 637: c_html_agmt_line_vs CONSTANT PO_TBL_VARCHAR2000 :=

633: , c_segment1_not_null
634: );
635:
636: -- Validation set for HTML Agreement lines.
637: c_html_agmt_line_vs CONSTANT PO_TBL_VARCHAR2000 :=
638: PO_TBL_VARCHAR2000(
639: c_line_num_gt_zero
640: , c_line_num_unique
641: , c_item_id_not_null

Line 638: PO_TBL_VARCHAR2000(

634: );
635:
636: -- Validation set for HTML Agreement lines.
637: c_html_agmt_line_vs CONSTANT PO_TBL_VARCHAR2000 :=
638: PO_TBL_VARCHAR2000(
639: c_line_num_gt_zero
640: , c_line_num_unique
641: , c_item_id_not_null
642: , c_unit_price_ge_zero

Line 656: c_html_agmt_ga_org_assign_vs CONSTANT PO_TBL_VARCHAR2000 :=

652: , c_line_dff_validate -- Bug 7516824
653: );
654:
655: -- Validation set for HTML Agreement GA org assignments.
656: c_html_agmt_ga_org_assign_vs CONSTANT PO_TBL_VARCHAR2000 :=
657: PO_TBL_VARCHAR2000(
658: c_assign_purch_org_not_null
659: , c_assign_vendor_site_not_null
660: );

Line 657: PO_TBL_VARCHAR2000(

653: );
654:
655: -- Validation set for HTML Agreement GA org assignments.
656: c_html_agmt_ga_org_assign_vs CONSTANT PO_TBL_VARCHAR2000 :=
657: PO_TBL_VARCHAR2000(
658: c_assign_purch_org_not_null
659: , c_assign_vendor_site_not_null
660: );
661:

Line 663: c_html_agmt_notif_ctrl_vs CONSTANT PO_TBL_VARCHAR2000 :=

659: , c_assign_vendor_site_not_null
660: );
661:
662: -- Validation set for HTML Agreement notification controls.
663: c_html_agmt_notif_ctrl_vs CONSTANT PO_TBL_VARCHAR2000 :=
664: PO_TBL_VARCHAR2000(
665: c_notif_start_date_le_end_date
666: , c_notif_percent_le_one_hundred
667: , c_notif_amount_gt_zero

Line 664: PO_TBL_VARCHAR2000(

660: );
661:
662: -- Validation set for HTML Agreement notification controls.
663: c_html_agmt_notif_ctrl_vs CONSTANT PO_TBL_VARCHAR2000 :=
664: PO_TBL_VARCHAR2000(
665: c_notif_start_date_le_end_date
666: , c_notif_percent_le_one_hundred
667: , c_notif_amount_gt_zero
668: , c_notif_amount_not_null

Line 673: c_html_agmt_price_diff_vs CONSTANT PO_TBL_VARCHAR2000 :=

669: , c_notif_start_date_not_null
670: );
671:
672: -- Validation set for HTML Agreement price differentials.
673: c_html_agmt_price_diff_vs CONSTANT PO_TBL_VARCHAR2000 :=
674: PO_TBL_VARCHAR2000(
675: c_unique_price_diff_num
676: , c_price_diff_num_gt_zero
677: , c_unique_price_type

Line 674: PO_TBL_VARCHAR2000(

670: );
671:
672: -- Validation set for HTML Agreement price differentials.
673: c_html_agmt_price_diff_vs CONSTANT PO_TBL_VARCHAR2000 :=
674: PO_TBL_VARCHAR2000(
675: c_unique_price_diff_num
676: , c_price_diff_num_gt_zero
677: , c_unique_price_type
678: , c_max_mul_ge_zero

Line 684: c_html_agmt_price_break_vs CONSTANT PO_TBL_VARCHAR2000 :=

680: , c_min_mul_ge_zero
681: );
682:
683: -- Validation set for HTML Agreement price breaks.
684: c_html_agmt_price_break_vs CONSTANT PO_TBL_VARCHAR2000 :=
685: PO_TBL_VARCHAR2000(
686: c_ship_num_gt_zero
687: , c_ship_num_unique_check
688: , c_at_least_one_required_field

Line 685: PO_TBL_VARCHAR2000(

681: );
682:
683: -- Validation set for HTML Agreement price breaks.
684: c_html_agmt_price_break_vs CONSTANT PO_TBL_VARCHAR2000 :=
685: PO_TBL_VARCHAR2000(
686: c_ship_num_gt_zero
687: , c_ship_num_unique_check
688: , c_at_least_one_required_field
689: , c_price_discount_in_percent

Line 702: c_html_agmt_distribution_vs CONSTANT PO_TBL_VARCHAR2000 :=

698: , c_break_end_le_blanket_end
699: );
700:
701: -- Validation set for HTML Agreement distributions.
702: c_html_agmt_distribution_vs CONSTANT PO_TBL_VARCHAR2000 :=
703: PO_TBL_VARCHAR2000(
704: c_amount_to_encumber_ge_zero
705: , c_budget_account_id_not_null
706: , c_gl_enc_date_not_null_open

Line 703: PO_TBL_VARCHAR2000(

699: );
700:
701: -- Validation set for HTML Agreement distributions.
702: c_html_agmt_distribution_vs CONSTANT PO_TBL_VARCHAR2000 :=
703: PO_TBL_VARCHAR2000(
704: c_amount_to_encumber_ge_zero
705: , c_budget_account_id_not_null
706: , c_gl_enc_date_not_null_open
707: , c_unencum_amt_le_amt_to_encum

Line 711: c_allow_unit_price_change_vs CONSTANT PO_TBL_VARCHAR2000 :=

707: , c_unencum_amt_le_amt_to_encum
708: );
709:
710: -- Used to validate that a change to the unit price is allowed.
711: c_allow_unit_price_change_vs CONSTANT PO_TBL_VARCHAR2000 :=
712: PO_TBL_VARCHAR2000(
713: c_no_dists_reserved
714: , c_accruals_allow_update
715: , c_no_timecards_exist

Line 712: PO_TBL_VARCHAR2000(

708: );
709:
710: -- Used to validate that a change to the unit price is allowed.
711: c_allow_unit_price_change_vs CONSTANT PO_TBL_VARCHAR2000 :=
712: PO_TBL_VARCHAR2000(
713: c_no_dists_reserved
714: , c_accruals_allow_update
715: , c_no_timecards_exist
716: , c_no_pending_receipts

Line 725: c_pdoi_header_common_vs CONSTANT po_tbl_varchar2000

721:
722: ----------------------------------------------------------------------------
723: -- PDOI Validation Common Set Definitions
724: ----------------------------------------------------------------------------
725: c_pdoi_header_common_vs CONSTANT po_tbl_varchar2000
726: := po_tbl_varchar2000(c_po_header_id,
727: c_end_date,
728: c_type_lookup_code,
729: c_revision_num,

Line 726: := po_tbl_varchar2000(c_po_header_id,

722: ----------------------------------------------------------------------------
723: -- PDOI Validation Common Set Definitions
724: ----------------------------------------------------------------------------
725: c_pdoi_header_common_vs CONSTANT po_tbl_varchar2000
726: := po_tbl_varchar2000(c_po_header_id,
727: c_end_date,
728: c_type_lookup_code,
729: c_revision_num,
730: c_document_num,

Line 753: c_pdoi_line_common_vs CONSTANT po_tbl_varchar2000

749: c_shipping_control,
750: c_approval_status,
751: c_acceptance_required_flag);
752:
753: c_pdoi_line_common_vs CONSTANT po_tbl_varchar2000
754: := po_tbl_varchar2000(c_release_num_null,
755: c_po_release_id_null,
756: c_closed_date_null,
757: c_contractor_name,

Line 754: := po_tbl_varchar2000(c_release_num_null,

750: c_approval_status,
751: c_acceptance_required_flag);
752:
753: c_pdoi_line_common_vs CONSTANT po_tbl_varchar2000
754: := po_tbl_varchar2000(c_release_num_null,
755: c_po_release_id_null,
756: c_closed_date_null,
757: c_contractor_name,
758: c_order_type_lookup_code,

Line 780: c_pdoi_line_update_vs CONSTANT po_tbl_varchar2000

776: c_po_line_id,
777: c_price_type_lookup_code,
778: c_line_secondary_quantity);
779:
780: c_pdoi_line_update_vs CONSTANT po_tbl_varchar2000
781: := po_tbl_varchar2000(c_uom_update,
782: c_unit_price_update,
783: c_amount_update, -- bug 5258790
784: c_item_desc_update,

Line 781: := po_tbl_varchar2000(c_uom_update,

777: c_price_type_lookup_code,
778: c_line_secondary_quantity);
779:
780: c_pdoi_line_update_vs CONSTANT po_tbl_varchar2000
781: := po_tbl_varchar2000(c_uom_update,
782: c_unit_price_update,
783: c_amount_update, -- bug 5258790
784: c_item_desc_update,
785: c_ip_category_id_update,

Line 789: c_pdoi_line_loc_common_vs CONSTANT po_tbl_varchar2000

785: c_ip_category_id_update,
786: c_category_id_update);
787:
788:
789: c_pdoi_line_loc_common_vs CONSTANT po_tbl_varchar2000
790: := po_tbl_varchar2000(c_shipment_need_by_date,
791: c_shipment_quantity,
792: c_shipment_price_override,
793: c_shipment_price_discount,

Line 790: := po_tbl_varchar2000(c_shipment_need_by_date,

786: c_category_id_update);
787:
788:
789: c_pdoi_line_loc_common_vs CONSTANT po_tbl_varchar2000
790: := po_tbl_varchar2000(c_shipment_need_by_date,
791: c_shipment_quantity,
792: c_shipment_price_override,
793: c_shipment_price_discount,
794: c_ship_to_organization_id,

Line 800: c_pdoi_dist_common_vs CONSTANT po_tbl_varchar2000

796: c_shipment_num,
797: c_line_loc_secondary_quantity,
798: c_tax_name);
799:
800: c_pdoi_dist_common_vs CONSTANT po_tbl_varchar2000
801: := po_tbl_varchar2000(c_dist_amount_ordered,
802: c_dist_quantity_ordered,
803: c_dist_destination_org_id,
804: c_dist_deliver_to_location_id,

Line 801: := po_tbl_varchar2000(c_dist_amount_ordered,

797: c_line_loc_secondary_quantity,
798: c_tax_name);
799:
800: c_pdoi_dist_common_vs CONSTANT po_tbl_varchar2000
801: := po_tbl_varchar2000(c_dist_amount_ordered,
802: c_dist_quantity_ordered,
803: c_dist_destination_org_id,
804: c_dist_deliver_to_location_id,
805: c_dist_deliver_to_person_id,

Line 818: c_pdoi_price_diff_common_vs CONSTANT po_tbl_varchar2000

814: c_project_acct_context,
815: c_project_info,
816: c_tax_recovery_override_flag);
817:
818: c_pdoi_price_diff_common_vs CONSTANT po_tbl_varchar2000
819: := po_tbl_varchar2000(c_price_type,
820: c_multiple_price_diff,
821: c_entity_type,
822: c_multiplier,

Line 819: := po_tbl_varchar2000(c_price_type,

815: c_project_info,
816: c_tax_recovery_override_flag);
817:
818: c_pdoi_price_diff_common_vs CONSTANT po_tbl_varchar2000
819: := po_tbl_varchar2000(c_price_type,
820: c_multiple_price_diff,
821: c_entity_type,
822: c_multiplier,
823: c_min_multiplier,

Line 830: c_pdoi_header_blanket_vs CONSTANT po_tbl_varchar2000

826:
827: ----------------------------------------------------------------------------
828: -- PDOI Set Definitions for Blanket PO
829: ----------------------------------------------------------------------------
830: c_pdoi_header_blanket_vs CONSTANT po_tbl_varchar2000
831: := po_tbl_varchar2000(c_confirming_order_flag,
832: c_acceptance_due_date,
833: c_amount_agreed,
834: c_amount_limit,

Line 831: := po_tbl_varchar2000(c_confirming_order_flag,

827: ----------------------------------------------------------------------------
828: -- PDOI Set Definitions for Blanket PO
829: ----------------------------------------------------------------------------
830: c_pdoi_header_blanket_vs CONSTANT po_tbl_varchar2000
831: := po_tbl_varchar2000(c_confirming_order_flag,
832: c_acceptance_due_date,
833: c_amount_agreed,
834: c_amount_limit,
835: c_firm_status_lookup_header,

Line 844: c_pdoi_line_blanket_vs CONSTANT po_tbl_varchar2000

840: c_amount_to_encumber,
841: c_style_id);
842:
843:
844: c_pdoi_line_blanket_vs CONSTANT po_tbl_varchar2000
845: := po_tbl_varchar2000(c_global_agreement_flag,
846: c_capital_expense_flag,
847: c_price_break_lookup_code,
848: c_not_to_exceed_price,

Line 845: := po_tbl_varchar2000(c_global_agreement_flag,

841: c_style_id);
842:
843:
844: c_pdoi_line_blanket_vs CONSTANT po_tbl_varchar2000
845: := po_tbl_varchar2000(c_global_agreement_flag,
846: c_capital_expense_flag,
847: c_price_break_lookup_code,
848: c_not_to_exceed_price,
849: c_amount_blanket,

Line 858: c_pdoi_line_blanket_update_vs CONSTANT po_tbl_varchar2000

854: c_line_preferred_grade,
855: c_line_style_related_info,
856: c_negotiated_by_preparer);
857:
858: c_pdoi_line_blanket_update_vs CONSTANT po_tbl_varchar2000
859: := po_tbl_varchar2000(c_negotiated_by_prep_update);
860:
861:
862: c_pdoi_line_loc_blanket_vs CONSTANT po_tbl_varchar2000

Line 859: := po_tbl_varchar2000(c_negotiated_by_prep_update);

855: c_line_style_related_info,
856: c_negotiated_by_preparer);
857:
858: c_pdoi_line_blanket_update_vs CONSTANT po_tbl_varchar2000
859: := po_tbl_varchar2000(c_negotiated_by_prep_update);
860:
861:
862: c_pdoi_line_loc_blanket_vs CONSTANT po_tbl_varchar2000
863: := po_tbl_varchar2000(c_shipment_effective_dates,

Line 862: c_pdoi_line_loc_blanket_vs CONSTANT po_tbl_varchar2000

858: c_pdoi_line_blanket_update_vs CONSTANT po_tbl_varchar2000
859: := po_tbl_varchar2000(c_negotiated_by_prep_update);
860:
861:
862: c_pdoi_line_loc_blanket_vs CONSTANT po_tbl_varchar2000
863: := po_tbl_varchar2000(c_shipment_effective_dates,
864: c_shipment_type_blanket,
865: c_at_least_one_required_field,
866: c_need_by_date_null,

Line 863: := po_tbl_varchar2000(c_shipment_effective_dates,

859: := po_tbl_varchar2000(c_negotiated_by_prep_update);
860:
861:
862: c_pdoi_line_loc_blanket_vs CONSTANT po_tbl_varchar2000
863: := po_tbl_varchar2000(c_shipment_effective_dates,
864: c_shipment_type_blanket,
865: c_at_least_one_required_field,
866: c_need_by_date_null,
867: c_firm_flag_null,

Line 893: c_pdoi_header_standard_vs CONSTANT po_tbl_varchar2000

889:
890: ----------------------------------------------------------------------------
891: -- PDOI Set Definitions for Standard PO
892: ----------------------------------------------------------------------------
893: c_pdoi_header_standard_vs CONSTANT po_tbl_varchar2000
894: := po_tbl_varchar2000(c_confirming_order_flag,
895: c_acceptance_due_date,
896: c_firm_status_lookup_header,
897: c_cancel_flag,

Line 894: := po_tbl_varchar2000(c_confirming_order_flag,

890: ----------------------------------------------------------------------------
891: -- PDOI Set Definitions for Standard PO
892: ----------------------------------------------------------------------------
893: c_pdoi_header_standard_vs CONSTANT po_tbl_varchar2000
894: := po_tbl_varchar2000(c_confirming_order_flag,
895: c_acceptance_due_date,
896: c_firm_status_lookup_header,
897: c_cancel_flag,
898: c_closed_code,

Line 903: c_pdoi_line_standard_vs CONSTANT po_tbl_varchar2000

899: c_print_count,
900: c_frozen_flag,
901: c_style_id);
902:
903: c_pdoi_line_standard_vs CONSTANT po_tbl_varchar2000
904: := po_tbl_varchar2000(c_over_tolerance_error_flag,
905: c_capital_expense_flag,
906: c_not_to_exceed_price,
907: c_start_date_standard,

Line 904: := po_tbl_varchar2000(c_over_tolerance_error_flag,

900: c_frozen_flag,
901: c_style_id);
902:
903: c_pdoi_line_standard_vs CONSTANT po_tbl_varchar2000
904: := po_tbl_varchar2000(c_over_tolerance_error_flag,
905: c_capital_expense_flag,
906: c_not_to_exceed_price,
907: c_start_date_standard,
908: c_item_id_standard,

Line 918: c_pdoi_line_loc_standard_vs CONSTANT po_tbl_varchar2000

914: c_line_style_related_info,
915: c_negotiated_by_preparer);
916:
917:
918: c_pdoi_line_loc_standard_vs CONSTANT po_tbl_varchar2000
919: := po_tbl_varchar2000(c_enforce_ship_to_loc_code,
920: c_shipment_type_standard,
921: c_allow_sub_receipts_flag,
922: c_days_early_receipt_allowed,

Line 919: := po_tbl_varchar2000(c_enforce_ship_to_loc_code,

915: c_negotiated_by_preparer);
916:
917:
918: c_pdoi_line_loc_standard_vs CONSTANT po_tbl_varchar2000
919: := po_tbl_varchar2000(c_enforce_ship_to_loc_code,
920: c_shipment_type_standard,
921: c_allow_sub_receipts_flag,
922: c_days_early_receipt_allowed,
923: c_receipt_days_exception_code,

Line 936: c_pdoi_header_quotation_vs CONSTANT po_tbl_varchar2000

932:
933: ----------------------------------------------------------------------------
934: -- PDOI Set Definitions for Quotation
935: ----------------------------------------------------------------------------
936: c_pdoi_header_quotation_vs CONSTANT po_tbl_varchar2000
937: := po_tbl_varchar2000(c_quote_warning_delay,
938: c_approval_required_flag);
939:
940: c_pdoi_line_quotation_vs CONSTANT po_tbl_varchar2000

Line 937: := po_tbl_varchar2000(c_quote_warning_delay,

933: ----------------------------------------------------------------------------
934: -- PDOI Set Definitions for Quotation
935: ----------------------------------------------------------------------------
936: c_pdoi_header_quotation_vs CONSTANT po_tbl_varchar2000
937: := po_tbl_varchar2000(c_quote_warning_delay,
938: c_approval_required_flag);
939:
940: c_pdoi_line_quotation_vs CONSTANT po_tbl_varchar2000
941: := po_tbl_varchar2000(c_over_tolerance_error_flag,

Line 940: c_pdoi_line_quotation_vs CONSTANT po_tbl_varchar2000

936: c_pdoi_header_quotation_vs CONSTANT po_tbl_varchar2000
937: := po_tbl_varchar2000(c_quote_warning_delay,
938: c_approval_required_flag);
939:
940: c_pdoi_line_quotation_vs CONSTANT po_tbl_varchar2000
941: := po_tbl_varchar2000(c_over_tolerance_error_flag,
942: c_allow_price_override_null ,
943: c_negotiated_by_preparer_null,
944: c_capital_expense_flag_null,

Line 941: := po_tbl_varchar2000(c_over_tolerance_error_flag,

937: := po_tbl_varchar2000(c_quote_warning_delay,
938: c_approval_required_flag);
939:
940: c_pdoi_line_quotation_vs CONSTANT po_tbl_varchar2000
941: := po_tbl_varchar2000(c_over_tolerance_error_flag,
942: c_allow_price_override_null ,
943: c_negotiated_by_preparer_null,
944: c_capital_expense_flag_null,
945: c_min_release_amount_null,

Line 951: c_pdoi_line_loc_quotation_vs CONSTANT po_tbl_varchar2000

947: c_committed_amount_null,
948: c_ip_category_id,
949: c_negotiated_by_preparer_null);
950:
951: c_pdoi_line_loc_quotation_vs CONSTANT po_tbl_varchar2000
952: := po_tbl_varchar2000(c_qty_rcv_exception_code,
953: c_shipment_type_quotation,
954: c_fob_lookup_code_line_loc,
955: c_freight_terms_line_loc,

Line 952: := po_tbl_varchar2000(c_qty_rcv_exception_code,

948: c_ip_category_id,
949: c_negotiated_by_preparer_null);
950:
951: c_pdoi_line_loc_quotation_vs CONSTANT po_tbl_varchar2000
952: := po_tbl_varchar2000(c_qty_rcv_exception_code,
953: c_shipment_type_quotation,
954: c_fob_lookup_code_line_loc,
955: c_freight_terms_line_loc,
956: c_freight_carrier_line_loc,

Line 1131: , p_token1_value_tbl IN PO_TBL_VARCHAR2000

1127: , p_message_application_tbl IN PO_TBL_VARCHAR30
1128: , p_message_name_tbl IN PO_TBL_VARCHAR30
1129: , p_column_name_tbl IN PO_TBL_VARCHAR30
1130: , p_token1_name_tbl IN PO_TBL_VARCHAR30
1131: , p_token1_value_tbl IN PO_TBL_VARCHAR2000
1132: , p_token2_name_tbl IN PO_TBL_VARCHAR30
1133: , p_token2_value_tbl IN PO_TBL_VARCHAR2000
1134: , p_token3_name_tbl IN PO_TBL_VARCHAR30
1135: , p_token3_value_tbl IN PO_TBL_VARCHAR2000

Line 1133: , p_token2_value_tbl IN PO_TBL_VARCHAR2000

1129: , p_column_name_tbl IN PO_TBL_VARCHAR30
1130: , p_token1_name_tbl IN PO_TBL_VARCHAR30
1131: , p_token1_value_tbl IN PO_TBL_VARCHAR2000
1132: , p_token2_name_tbl IN PO_TBL_VARCHAR30
1133: , p_token2_value_tbl IN PO_TBL_VARCHAR2000
1134: , p_token3_name_tbl IN PO_TBL_VARCHAR30
1135: , p_token3_value_tbl IN PO_TBL_VARCHAR2000
1136: , p_token4_name_tbl IN PO_TBL_VARCHAR30
1137: , p_token4_value_tbl IN PO_TBL_VARCHAR2000

Line 1135: , p_token3_value_tbl IN PO_TBL_VARCHAR2000

1131: , p_token1_value_tbl IN PO_TBL_VARCHAR2000
1132: , p_token2_name_tbl IN PO_TBL_VARCHAR30
1133: , p_token2_value_tbl IN PO_TBL_VARCHAR2000
1134: , p_token3_name_tbl IN PO_TBL_VARCHAR30
1135: , p_token3_value_tbl IN PO_TBL_VARCHAR2000
1136: , p_token4_name_tbl IN PO_TBL_VARCHAR30
1137: , p_token4_value_tbl IN PO_TBL_VARCHAR2000
1138: , p_token5_name_tbl IN PO_TBL_VARCHAR30
1139: , p_token5_value_tbl IN PO_TBL_VARCHAR2000

Line 1137: , p_token4_value_tbl IN PO_TBL_VARCHAR2000

1133: , p_token2_value_tbl IN PO_TBL_VARCHAR2000
1134: , p_token3_name_tbl IN PO_TBL_VARCHAR30
1135: , p_token3_value_tbl IN PO_TBL_VARCHAR2000
1136: , p_token4_name_tbl IN PO_TBL_VARCHAR30
1137: , p_token4_value_tbl IN PO_TBL_VARCHAR2000
1138: , p_token5_name_tbl IN PO_TBL_VARCHAR30
1139: , p_token5_value_tbl IN PO_TBL_VARCHAR2000
1140: , p_token6_name_tbl IN PO_TBL_VARCHAR30
1141: , p_token6_value_tbl IN PO_TBL_VARCHAR2000

Line 1139: , p_token5_value_tbl IN PO_TBL_VARCHAR2000

1135: , p_token3_value_tbl IN PO_TBL_VARCHAR2000
1136: , p_token4_name_tbl IN PO_TBL_VARCHAR30
1137: , p_token4_value_tbl IN PO_TBL_VARCHAR2000
1138: , p_token5_name_tbl IN PO_TBL_VARCHAR30
1139: , p_token5_value_tbl IN PO_TBL_VARCHAR2000
1140: , p_token6_name_tbl IN PO_TBL_VARCHAR30
1141: , p_token6_value_tbl IN PO_TBL_VARCHAR2000
1142: )
1143: IS

Line 1141: , p_token6_value_tbl IN PO_TBL_VARCHAR2000

1137: , p_token4_value_tbl IN PO_TBL_VARCHAR2000
1138: , p_token5_name_tbl IN PO_TBL_VARCHAR30
1139: , p_token5_value_tbl IN PO_TBL_VARCHAR2000
1140: , p_token6_name_tbl IN PO_TBL_VARCHAR30
1141: , p_token6_value_tbl IN PO_TBL_VARCHAR2000
1142: )
1143: IS
1144: PRAGMA AUTONOMOUS_TRANSACTION;
1145: d_mod CONSTANT VARCHAR2(100) := D_commit_validation_results_au;

Line 1322: l_token1_value_tbl PO_TBL_VARCHAR2000;

1318: l_message_application_tbl PO_TBL_VARCHAR30;
1319: l_message_name_tbl PO_TBL_VARCHAR30;
1320: l_column_name_tbl PO_TBL_VARCHAR30;
1321: l_token1_name_tbl PO_TBL_VARCHAR30;
1322: l_token1_value_tbl PO_TBL_VARCHAR2000;
1323: l_token2_name_tbl PO_TBL_VARCHAR30;
1324: l_token2_value_tbl PO_TBL_VARCHAR2000;
1325: l_token3_name_tbl PO_TBL_VARCHAR30;
1326: l_token3_value_tbl PO_TBL_VARCHAR2000;

Line 1324: l_token2_value_tbl PO_TBL_VARCHAR2000;

1320: l_column_name_tbl PO_TBL_VARCHAR30;
1321: l_token1_name_tbl PO_TBL_VARCHAR30;
1322: l_token1_value_tbl PO_TBL_VARCHAR2000;
1323: l_token2_name_tbl PO_TBL_VARCHAR30;
1324: l_token2_value_tbl PO_TBL_VARCHAR2000;
1325: l_token3_name_tbl PO_TBL_VARCHAR30;
1326: l_token3_value_tbl PO_TBL_VARCHAR2000;
1327: l_token4_name_tbl PO_TBL_VARCHAR30;
1328: l_token4_value_tbl PO_TBL_VARCHAR2000;

Line 1326: l_token3_value_tbl PO_TBL_VARCHAR2000;

1322: l_token1_value_tbl PO_TBL_VARCHAR2000;
1323: l_token2_name_tbl PO_TBL_VARCHAR30;
1324: l_token2_value_tbl PO_TBL_VARCHAR2000;
1325: l_token3_name_tbl PO_TBL_VARCHAR30;
1326: l_token3_value_tbl PO_TBL_VARCHAR2000;
1327: l_token4_name_tbl PO_TBL_VARCHAR30;
1328: l_token4_value_tbl PO_TBL_VARCHAR2000;
1329: l_token5_name_tbl PO_TBL_VARCHAR30;
1330: l_token5_value_tbl PO_TBL_VARCHAR2000;

Line 1328: l_token4_value_tbl PO_TBL_VARCHAR2000;

1324: l_token2_value_tbl PO_TBL_VARCHAR2000;
1325: l_token3_name_tbl PO_TBL_VARCHAR30;
1326: l_token3_value_tbl PO_TBL_VARCHAR2000;
1327: l_token4_name_tbl PO_TBL_VARCHAR30;
1328: l_token4_value_tbl PO_TBL_VARCHAR2000;
1329: l_token5_name_tbl PO_TBL_VARCHAR30;
1330: l_token5_value_tbl PO_TBL_VARCHAR2000;
1331: l_token6_name_tbl PO_TBL_VARCHAR30;
1332: l_token6_value_tbl PO_TBL_VARCHAR2000;

Line 1330: l_token5_value_tbl PO_TBL_VARCHAR2000;

1326: l_token3_value_tbl PO_TBL_VARCHAR2000;
1327: l_token4_name_tbl PO_TBL_VARCHAR30;
1328: l_token4_value_tbl PO_TBL_VARCHAR2000;
1329: l_token5_name_tbl PO_TBL_VARCHAR30;
1330: l_token5_value_tbl PO_TBL_VARCHAR2000;
1331: l_token6_name_tbl PO_TBL_VARCHAR30;
1332: l_token6_value_tbl PO_TBL_VARCHAR2000;
1333:
1334: BEGIN

Line 1332: l_token6_value_tbl PO_TBL_VARCHAR2000;

1328: l_token4_value_tbl PO_TBL_VARCHAR2000;
1329: l_token5_name_tbl PO_TBL_VARCHAR30;
1330: l_token5_value_tbl PO_TBL_VARCHAR2000;
1331: l_token6_name_tbl PO_TBL_VARCHAR30;
1332: l_token6_value_tbl PO_TBL_VARCHAR2000;
1333:
1334: BEGIN
1335:
1336: IF PO_LOG.d_proc THEN

Line 1619: p_validation_set IN PO_TBL_VARCHAR2000

1615: -- but may be turned into a worse result
1616: -- (ERROR will not become SUCCESS, but WARNING may become ERROR).
1617: ----------------------------------------------------------------------------
1618: PROCEDURE validate_set(
1619: p_validation_set IN PO_TBL_VARCHAR2000
1620: , p_headers IN PO_HEADERS_VAL_TYPE DEFAULT NULL
1621: , p_lines IN PO_LINES_VAL_TYPE DEFAULT NULL
1622: , p_line_locations IN PO_LINE_LOCATIONS_VAL_TYPE DEFAULT NULL
1623: , p_distributions IN PO_DISTRIBUTIONS_VAL_TYPE DEFAULT NULL

Line 1630: , p_parameter_name_tbl IN PO_TBL_VARCHAR2000 DEFAULT NULL

1626: , p_notification_controls IN PO_NOTIFICATION_CTRL_VAL_TYPE DEFAULT NULL
1627: , p_autocommit_results_flag IN VARCHAR2 DEFAULT NULL
1628: , p_calling_program IN VARCHAR2 DEFAULT NULL
1629: , p_stopping_result_type IN VARCHAR2 DEFAULT NULL
1630: , p_parameter_name_tbl IN PO_TBL_VARCHAR2000 DEFAULT NULL
1631: , p_parameter_value_tbl IN PO_TBL_VARCHAR2000 DEFAULT NULL
1632: , x_result_type IN OUT NOCOPY VARCHAR2
1633: , x_result_set_id IN OUT NOCOPY NUMBER
1634: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 1631: , p_parameter_value_tbl IN PO_TBL_VARCHAR2000 DEFAULT NULL

1627: , p_autocommit_results_flag IN VARCHAR2 DEFAULT NULL
1628: , p_calling_program IN VARCHAR2 DEFAULT NULL
1629: , p_stopping_result_type IN VARCHAR2 DEFAULT NULL
1630: , p_parameter_name_tbl IN PO_TBL_VARCHAR2000 DEFAULT NULL
1631: , p_parameter_value_tbl IN PO_TBL_VARCHAR2000 DEFAULT NULL
1632: , x_result_type IN OUT NOCOPY VARCHAR2
1633: , x_result_set_id IN OUT NOCOPY NUMBER
1634: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1635: )

Line 5026: p_validation_set IN PO_TBL_VARCHAR2000

5022: --x_results
5023: -- The results of the validation cycle.
5024: ----------------------------------------------------------------------------
5025: PROCEDURE validate_set(
5026: p_validation_set IN PO_TBL_VARCHAR2000
5027: , p_headers IN PO_HEADERS_VAL_TYPE DEFAULT NULL
5028: , p_lines IN PO_LINES_VAL_TYPE DEFAULT NULL
5029: , p_line_locations IN PO_LINE_LOCATIONS_VAL_TYPE DEFAULT NULL
5030: , p_distributions IN PO_DISTRIBUTIONS_VAL_TYPE DEFAULT NULL

Line 5036: , p_parameter_name_tbl IN PO_TBL_VARCHAR2000 DEFAULT NULL

5032: , p_ga_org_assignments IN PO_GA_ORG_ASSIGN_VAL_TYPE DEFAULT NULL
5033: , p_notification_controls IN PO_NOTIFICATION_CTRL_VAL_TYPE DEFAULT NULL
5034: , p_calling_program IN VARCHAR2 DEFAULT NULL
5035: , p_stopping_result_type IN VARCHAR2 DEFAULT NULL
5036: , p_parameter_name_tbl IN PO_TBL_VARCHAR2000 DEFAULT NULL
5037: , p_parameter_value_tbl IN PO_TBL_VARCHAR2000 DEFAULT NULL
5038: , x_result_type IN OUT NOCOPY VARCHAR2
5039: , x_results OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
5040: )

Line 5037: , p_parameter_value_tbl IN PO_TBL_VARCHAR2000 DEFAULT NULL

5033: , p_notification_controls IN PO_NOTIFICATION_CTRL_VAL_TYPE DEFAULT NULL
5034: , p_calling_program IN VARCHAR2 DEFAULT NULL
5035: , p_stopping_result_type IN VARCHAR2 DEFAULT NULL
5036: , p_parameter_name_tbl IN PO_TBL_VARCHAR2000 DEFAULT NULL
5037: , p_parameter_value_tbl IN PO_TBL_VARCHAR2000 DEFAULT NULL
5038: , x_result_type IN OUT NOCOPY VARCHAR2
5039: , x_results OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
5040: )
5041: IS

Line 5272: l_validation_set PO_TBL_VARCHAR2000;

5268: )
5269: IS
5270: d_mod CONSTANT VARCHAR2(100) := D_validate_html_order;
5271: d_position NUMBER := 0;
5272: l_validation_set PO_TBL_VARCHAR2000;
5273: BEGIN
5274:
5275: IF PO_LOG.d_proc THEN
5276: PO_LOG.proc_begin(d_mod);

Line 5281: l_validation_set := PO_TBL_VARCHAR2000();

5277: END IF;
5278:
5279: d_position := 1;
5280:
5281: l_validation_set := PO_TBL_VARCHAR2000();
5282:
5283: IF (p_headers IS NOT NULL) THEN
5284: d_position := 10;
5285: l_validation_set :=

Line 5361: l_validation_set PO_TBL_VARCHAR2000;

5357: )
5358: IS
5359: d_mod CONSTANT VARCHAR2(100) := D_validate_html_agreement;
5360: d_position NUMBER := 0;
5361: l_validation_set PO_TBL_VARCHAR2000;
5362: BEGIN
5363:
5364: IF PO_LOG.d_proc THEN
5365: PO_LOG.proc_begin(d_mod);

Line 5370: l_validation_set := PO_TBL_VARCHAR2000();

5366: END IF;
5367:
5368: d_position := 1;
5369:
5370: l_validation_set := PO_TBL_VARCHAR2000();
5371:
5372: IF (p_headers IS NOT NULL) THEN
5373: d_position := 10;
5374: l_validation_set :=

Line 5483: p_parameter_name_tbl IN PO_TBL_VARCHAR2000 DEFAULT NULL,

5479: p_distributions IN PO_DISTRIBUTIONS_VAL_TYPE DEFAULT NULL,
5480: p_price_differentials IN PO_PRICE_DIFF_VAL_TYPE DEFAULT NULL,
5481: p_doc_type IN VARCHAR2 DEFAULT NULL,
5482: p_action IN VARCHAR2 DEFAULT 'CREATE',
5483: p_parameter_name_tbl IN PO_TBL_VARCHAR2000 DEFAULT NULL,
5484: p_parameter_value_tbl IN PO_TBL_VARCHAR2000 DEFAULT NULL,
5485: x_result_type OUT NOCOPY VARCHAR2,
5486: x_results OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
5487: )

Line 5484: p_parameter_value_tbl IN PO_TBL_VARCHAR2000 DEFAULT NULL,

5480: p_price_differentials IN PO_PRICE_DIFF_VAL_TYPE DEFAULT NULL,
5481: p_doc_type IN VARCHAR2 DEFAULT NULL,
5482: p_action IN VARCHAR2 DEFAULT 'CREATE',
5483: p_parameter_name_tbl IN PO_TBL_VARCHAR2000 DEFAULT NULL,
5484: p_parameter_value_tbl IN PO_TBL_VARCHAR2000 DEFAULT NULL,
5485: x_result_type OUT NOCOPY VARCHAR2,
5486: x_results OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
5487: )
5488: IS

Line 5492: l_validation_set PO_TBL_VARCHAR2000;

5488: IS
5489:
5490: d_mod CONSTANT VARCHAR2(100) := D_validate_pdoi;
5491: d_position NUMBER := 0;
5492: l_validation_set PO_TBL_VARCHAR2000;
5493:
5494: BEGIN
5495:
5496: IF PO_LOG.d_proc THEN

Line 5503: l_validation_set := PO_TBL_VARCHAR2000();

5499: END IF;
5500:
5501: d_position := 1;
5502:
5503: l_validation_set := PO_TBL_VARCHAR2000();
5504:
5505: IF (p_headers IS NOT NULL AND p_lines IS NULL AND p_line_locations IS NULL AND
5506: p_distributions IS NULL AND p_price_differentials IS NULL) THEN
5507: d_position := 10;

Line 5653: l_rowid_tbl PO_TBL_VARCHAR2000;

5649: , p_position IN NUMBER
5650: , p_result_set_id IN NUMBER
5651: )
5652: IS
5653: l_rowid_tbl PO_TBL_VARCHAR2000;
5654: BEGIN
5655: IF PO_LOG.d_stmt THEN
5656: SELECT VR.rowid
5657: BULK COLLECT INTO l_rowid_tbl