[Home] [Help]
616: -- Validation Sets.
617: ---------------------------------------------------------------
618:
619: -- Validation set for HTML Orders headers.
620: c_html_order_header_vs CONSTANT PO_TBL_VARCHAR2000 :=
621: PO_TBL_VARCHAR2000(
622: -- Bug# 4779226 remove c_warn_supplier_on_hold from header check
623: c_rate_gt_zero
624: , c_rate_combination_valid
617: ---------------------------------------------------------------
618:
619: -- Validation set for HTML Orders headers.
620: c_html_order_header_vs CONSTANT PO_TBL_VARCHAR2000 :=
621: PO_TBL_VARCHAR2000(
622: -- Bug# 4779226 remove c_warn_supplier_on_hold from header check
623: c_rate_gt_zero
624: , c_rate_combination_valid
625: , c_doc_num_chars_valid
633: , c_validate_mod_number --
634: );
635:
636: -- Validation set for HTML Orders lines.
637: c_html_order_line_vs CONSTANT PO_TBL_VARCHAR2000 :=
638: PO_TBL_VARCHAR2000(
639: c_amt_agreed_ge_zero
640: , c_min_rel_amt_ge_zero
641: , c_line_qty_gt_zero
634: );
635:
636: -- Validation set for HTML Orders lines.
637: c_html_order_line_vs CONSTANT PO_TBL_VARCHAR2000 :=
638: PO_TBL_VARCHAR2000(
639: c_amt_agreed_ge_zero
640: , c_min_rel_amt_ge_zero
641: , c_line_qty_gt_zero
642: , c_line_qty_ge_qty_exec --
692: , c_validate_exhibit_name -- Elins project
693: );
694:
695: -- Validation set for HTML Order price differentials.
696: c_html_order_price_diff_vs CONSTANT PO_TBL_VARCHAR2000 :=
697: PO_TBL_VARCHAR2000(
698: c_unique_price_diff_num
699: , c_price_diff_num_gt_zero
700: , c_unique_price_type
693: );
694:
695: -- Validation set for HTML Order price differentials.
696: c_html_order_price_diff_vs CONSTANT PO_TBL_VARCHAR2000 :=
697: PO_TBL_VARCHAR2000(
698: c_unique_price_diff_num
699: , c_price_diff_num_gt_zero
700: , c_unique_price_type
701: , c_mul_ge_zero
706:
707: -- Validation set for HTML Orders shipments.
708: -- ECO 4503425: Removed the planned item null date check as this
709: -- has been moved to submission checks
710: c_html_order_shipment_vs CONSTANT PO_TBL_VARCHAR2000 :=
711: PO_TBL_VARCHAR2000(
712: c_days_early_gte_zero
713: , c_days_late_gte_zero
714: , c_rcv_close_tol_within_range
707: -- Validation set for HTML Orders shipments.
708: -- ECO 4503425: Removed the planned item null date check as this
709: -- has been moved to submission checks
710: c_html_order_shipment_vs CONSTANT PO_TBL_VARCHAR2000 :=
711: PO_TBL_VARCHAR2000(
712: c_days_early_gte_zero
713: , c_days_late_gte_zero
714: , c_rcv_close_tol_within_range
715: , c_over_rcpt_tol_within_range
735: , c_complex_price_or_gt_zero
736: );
737:
738: -- Validation set for HTML Orders distributions.
739: c_html_order_distribution_vs CONSTANT PO_TBL_VARCHAR2000 :=
740: PO_TBL_VARCHAR2000(
741: c_dist_num_unique
742: , c_dist_num_gt_zero
743: -- < Bug:13503748 : Encumbrance ER Edit without unreserve>--
736: );
737:
738: -- Validation set for HTML Orders distributions.
739: c_html_order_distribution_vs CONSTANT PO_TBL_VARCHAR2000 :=
740: PO_TBL_VARCHAR2000(
741: c_dist_num_unique
742: , c_dist_num_gt_zero
743: -- < Bug:13503748 : Encumbrance ER Edit without unreserve>--
744: --, c_dist_qty_gt_zero
764: , c_par_dist_value_increased -- PAR Project
765: );
766:
767: -- Validation set for HTML Agreement headers.
768: c_html_agmt_header_vs CONSTANT PO_TBL_VARCHAR2000 :=
769: PO_TBL_VARCHAR2000(
770: -- Bug# 4779226 remove c_warn_supplier_on_hold from header check
771: c_rate_gt_zero
772: , c_rate_combination_valid
765: );
766:
767: -- Validation set for HTML Agreement headers.
768: c_html_agmt_header_vs CONSTANT PO_TBL_VARCHAR2000 :=
769: PO_TBL_VARCHAR2000(
770: -- Bug# 4779226 remove c_warn_supplier_on_hold from header check
771: c_rate_gt_zero
772: , c_rate_combination_valid
773: , c_fax_email_address_valid
799: , c_validate_mod_number --
800: );
801:
802: -- Validation set for HTML Agreement lines.
803: c_html_agmt_line_vs CONSTANT PO_TBL_VARCHAR2000 :=
804: PO_TBL_VARCHAR2000(
805: c_line_num_gt_zero
806: , c_line_num_unique
807: , c_item_id_not_null
800: );
801:
802: -- Validation set for HTML Agreement lines.
803: c_html_agmt_line_vs CONSTANT PO_TBL_VARCHAR2000 :=
804: PO_TBL_VARCHAR2000(
805: c_line_num_gt_zero
806: , c_line_num_unique
807: , c_item_id_not_null
808: , c_unit_price_ge_zero
836: , c_validate_exhibit_name -- Elins project
837: );
838:
839: -- Validation set for HTML Agreement GA org assignments.
840: c_html_agmt_ga_org_assign_vs CONSTANT PO_TBL_VARCHAR2000 :=
841: PO_TBL_VARCHAR2000(
842: c_assign_purch_org_not_null
843: , c_assign_vendor_site_not_null
844: );
837: );
838:
839: -- Validation set for HTML Agreement GA org assignments.
840: c_html_agmt_ga_org_assign_vs CONSTANT PO_TBL_VARCHAR2000 :=
841: PO_TBL_VARCHAR2000(
842: c_assign_purch_org_not_null
843: , c_assign_vendor_site_not_null
844: );
845:
843: , c_assign_vendor_site_not_null
844: );
845:
846: -- Validation set for HTML Agreement notification controls.
847: c_html_agmt_notif_ctrl_vs CONSTANT PO_TBL_VARCHAR2000 :=
848: PO_TBL_VARCHAR2000(
849: c_notif_start_date_le_end_date
850: , c_notif_percent_le_one_hundred
851: , c_notif_amount_gt_zero
844: );
845:
846: -- Validation set for HTML Agreement notification controls.
847: c_html_agmt_notif_ctrl_vs CONSTANT PO_TBL_VARCHAR2000 :=
848: PO_TBL_VARCHAR2000(
849: c_notif_start_date_le_end_date
850: , c_notif_percent_le_one_hundred
851: , c_notif_amount_gt_zero
852: , c_notif_amount_not_null
853: , c_notif_start_date_not_null
854: );
855:
856: -- Validation set for HTML Agreement price differentials.
857: c_html_agmt_price_diff_vs CONSTANT PO_TBL_VARCHAR2000 :=
858: PO_TBL_VARCHAR2000(
859: c_unique_price_diff_num
860: , c_price_diff_num_gt_zero
861: , c_unique_price_type
854: );
855:
856: -- Validation set for HTML Agreement price differentials.
857: c_html_agmt_price_diff_vs CONSTANT PO_TBL_VARCHAR2000 :=
858: PO_TBL_VARCHAR2000(
859: c_unique_price_diff_num
860: , c_price_diff_num_gt_zero
861: , c_unique_price_type
862: , c_max_mul_ge_zero
864: , c_min_mul_ge_zero
865: );
866:
867: -- Validation set for HTML Agreement price breaks.
868: c_html_agmt_price_break_vs CONSTANT PO_TBL_VARCHAR2000 :=
869: PO_TBL_VARCHAR2000(
870: c_ship_num_gt_zero
871: , c_ship_num_unique_check
872: , c_at_least_one_required_field
865: );
866:
867: -- Validation set for HTML Agreement price breaks.
868: c_html_agmt_price_break_vs CONSTANT PO_TBL_VARCHAR2000 :=
869: PO_TBL_VARCHAR2000(
870: c_ship_num_gt_zero
871: , c_ship_num_unique_check
872: , c_at_least_one_required_field
873: , c_price_discount_in_percent
882: , c_break_end_le_blanket_end
883: );
884:
885: -- Validation set for HTML Agreement distributions.
886: c_html_agmt_distribution_vs CONSTANT PO_TBL_VARCHAR2000 :=
887: PO_TBL_VARCHAR2000(
888: c_amount_to_encumber_ge_zero
889: , c_budget_account_id_not_null
890: , c_gl_enc_date_not_null_open
883: );
884:
885: -- Validation set for HTML Agreement distributions.
886: c_html_agmt_distribution_vs CONSTANT PO_TBL_VARCHAR2000 :=
887: PO_TBL_VARCHAR2000(
888: c_amount_to_encumber_ge_zero
889: , c_budget_account_id_not_null
890: , c_gl_enc_date_not_null_open
891: , c_unencum_amt_le_amt_to_encum
891: , c_unencum_amt_le_amt_to_encum
892: );
893:
894: -- Used to validate that a change to the unit price is allowed.
895: c_allow_unit_price_change_vs CONSTANT PO_TBL_VARCHAR2000 :=
896: PO_TBL_VARCHAR2000(
897: c_no_dists_reserved
898: , c_accruals_allow_update
899: , c_no_timecards_exist
892: );
893:
894: -- Used to validate that a change to the unit price is allowed.
895: c_allow_unit_price_change_vs CONSTANT PO_TBL_VARCHAR2000 :=
896: PO_TBL_VARCHAR2000(
897: c_no_dists_reserved
898: , c_accruals_allow_update
899: , c_no_timecards_exist
900: , c_no_pending_receipts
903: --, c_warn_amt_based_notif_ctrls
904: );
905:
906: -- Validation set for HTML Price Adjustments
907: c_html_price_adjustments_vs CONSTANT PO_TBL_VARCHAR2000 :=
908: PO_TBL_VARCHAR2000(
909: c_change_reason_code_not_null
910: , c_change_reason_text_not_null
911: );
904: );
905:
906: -- Validation set for HTML Price Adjustments
907: c_html_price_adjustments_vs CONSTANT PO_TBL_VARCHAR2000 :=
908: PO_TBL_VARCHAR2000(
909: c_change_reason_code_not_null
910: , c_change_reason_text_not_null
911: );
912:
912:
913: ----------------------------------------------------------------------------
914: -- PDOI Validation Common Set Definitions
915: ----------------------------------------------------------------------------
916: c_pdoi_header_common_vs CONSTANT po_tbl_varchar2000
917: := po_tbl_varchar2000(c_po_header_id,
918: c_end_date,
919: c_type_lookup_code,
920: c_revision_num,
913: ----------------------------------------------------------------------------
914: -- PDOI Validation Common Set Definitions
915: ----------------------------------------------------------------------------
916: c_pdoi_header_common_vs CONSTANT po_tbl_varchar2000
917: := po_tbl_varchar2000(c_po_header_id,
918: c_end_date,
919: c_type_lookup_code,
920: c_revision_num,
921: c_document_num,
940: c_shipping_control,
941: c_approval_status,
942: c_acceptance_required_flag);
943:
944: c_pdoi_line_common_vs CONSTANT po_tbl_varchar2000
945: := po_tbl_varchar2000(c_release_num_null,
946: c_po_release_id_null,
947: c_closed_date_null,
948: c_contractor_name,
941: c_approval_status,
942: c_acceptance_required_flag);
943:
944: c_pdoi_line_common_vs CONSTANT po_tbl_varchar2000
945: := po_tbl_varchar2000(c_release_num_null,
946: c_po_release_id_null,
947: c_closed_date_null,
948: c_contractor_name,
949: c_order_type_lookup_code,
967: c_po_line_id,
968: c_price_type_lookup_code,
969: c_line_secondary_quantity);
970:
971: c_pdoi_line_update_vs CONSTANT po_tbl_varchar2000
972: := po_tbl_varchar2000(c_uom_update,
973: c_unit_price_update,
974: c_amount_update, -- bug 5258790
975: c_item_desc_update,
968: c_price_type_lookup_code,
969: c_line_secondary_quantity);
970:
971: c_pdoi_line_update_vs CONSTANT po_tbl_varchar2000
972: := po_tbl_varchar2000(c_uom_update,
973: c_unit_price_update,
974: c_amount_update, -- bug 5258790
975: c_item_desc_update,
976: c_ip_category_id_update,
976: c_ip_category_id_update,
977: c_category_id_update);
978:
979:
980: c_pdoi_line_loc_common_vs CONSTANT po_tbl_varchar2000
981: := po_tbl_varchar2000(c_shipment_need_by_date,
982: c_shipment_quantity,
983: c_shipment_price_override,
984: c_shipment_price_discount,
977: c_category_id_update);
978:
979:
980: c_pdoi_line_loc_common_vs CONSTANT po_tbl_varchar2000
981: := po_tbl_varchar2000(c_shipment_need_by_date,
982: c_shipment_quantity,
983: c_shipment_price_override,
984: c_shipment_price_discount,
985: c_ship_to_organization_id,
987: c_shipment_num,
988: c_line_loc_secondary_quantity,
989: c_tax_name);
990:
991: c_pdoi_dist_common_vs CONSTANT po_tbl_varchar2000
992: := po_tbl_varchar2000(c_dist_amount_ordered,
993: c_dist_quantity_ordered,
994: c_dist_destination_org_id,
995: c_dist_deliver_to_location_id,
988: c_line_loc_secondary_quantity,
989: c_tax_name);
990:
991: c_pdoi_dist_common_vs CONSTANT po_tbl_varchar2000
992: := po_tbl_varchar2000(c_dist_amount_ordered,
993: c_dist_quantity_ordered,
994: c_dist_destination_org_id,
995: c_dist_deliver_to_location_id,
996: c_dist_deliver_to_person_id,
1008: c_ACRN_value_valid, -- ACRN proj
1009: c_partial_funded_flag); -- CLM Partial Funding Changes
1010:
1011:
1012: c_pdoi_price_diff_common_vs CONSTANT po_tbl_varchar2000
1013: := po_tbl_varchar2000(c_price_type,
1014: c_multiple_price_diff,
1015: c_entity_type,
1016: c_multiplier,
1009: c_partial_funded_flag); -- CLM Partial Funding Changes
1010:
1011:
1012: c_pdoi_price_diff_common_vs CONSTANT po_tbl_varchar2000
1013: := po_tbl_varchar2000(c_price_type,
1014: c_multiple_price_diff,
1015: c_entity_type,
1016: c_multiplier,
1017: c_min_multiplier,
1020:
1021: ----------------------------------------------------------------------------
1022: -- PDOI Set Definitions for Blanket PO
1023: ----------------------------------------------------------------------------
1024: c_pdoi_header_blanket_vs CONSTANT po_tbl_varchar2000
1025: := po_tbl_varchar2000(c_confirming_order_flag,
1026: c_acceptance_due_date,
1027: c_amount_agreed,
1028: c_amount_limit,
1021: ----------------------------------------------------------------------------
1022: -- PDOI Set Definitions for Blanket PO
1023: ----------------------------------------------------------------------------
1024: c_pdoi_header_blanket_vs CONSTANT po_tbl_varchar2000
1025: := po_tbl_varchar2000(c_confirming_order_flag,
1026: c_acceptance_due_date,
1027: c_amount_agreed,
1028: c_amount_limit,
1029: c_firm_status_lookup_header,
1034: c_amount_to_encumber,
1035: c_style_id);
1036:
1037:
1038: c_pdoi_line_blanket_vs CONSTANT po_tbl_varchar2000
1039: := po_tbl_varchar2000(c_global_agreement_flag,
1040: c_capital_expense_flag,
1041: c_price_break_lookup_code,
1042: c_not_to_exceed_price,
1035: c_style_id);
1036:
1037:
1038: c_pdoi_line_blanket_vs CONSTANT po_tbl_varchar2000
1039: := po_tbl_varchar2000(c_global_agreement_flag,
1040: c_capital_expense_flag,
1041: c_price_break_lookup_code,
1042: c_not_to_exceed_price,
1043: c_amount_blanket,
1048: c_line_preferred_grade,
1049: c_line_style_related_info,
1050: c_negotiated_by_preparer);
1051:
1052: c_pdoi_line_blanket_update_vs CONSTANT po_tbl_varchar2000
1053: := po_tbl_varchar2000(c_negotiated_by_prep_update);
1054:
1055:
1056: c_pdoi_line_loc_blanket_vs CONSTANT po_tbl_varchar2000
1049: c_line_style_related_info,
1050: c_negotiated_by_preparer);
1051:
1052: c_pdoi_line_blanket_update_vs CONSTANT po_tbl_varchar2000
1053: := po_tbl_varchar2000(c_negotiated_by_prep_update);
1054:
1055:
1056: c_pdoi_line_loc_blanket_vs CONSTANT po_tbl_varchar2000
1057: := po_tbl_varchar2000(c_shipment_effective_dates,
1052: c_pdoi_line_blanket_update_vs CONSTANT po_tbl_varchar2000
1053: := po_tbl_varchar2000(c_negotiated_by_prep_update);
1054:
1055:
1056: c_pdoi_line_loc_blanket_vs CONSTANT po_tbl_varchar2000
1057: := po_tbl_varchar2000(c_shipment_effective_dates,
1058: c_shipment_type_blanket,
1059: c_at_least_one_required_field,
1060: c_need_by_date_null,
1053: := po_tbl_varchar2000(c_negotiated_by_prep_update);
1054:
1055:
1056: c_pdoi_line_loc_blanket_vs CONSTANT po_tbl_varchar2000
1057: := po_tbl_varchar2000(c_shipment_effective_dates,
1058: c_shipment_type_blanket,
1059: c_at_least_one_required_field,
1060: c_need_by_date_null,
1061: c_firm_flag_null,
1083:
1084: ----------------------------------------------------------------------------
1085: -- PDOI Set Definitions for Standard PO
1086: ----------------------------------------------------------------------------
1087: c_pdoi_header_standard_vs CONSTANT po_tbl_varchar2000
1088: := po_tbl_varchar2000(c_confirming_order_flag,
1089: c_acceptance_due_date,
1090: c_firm_status_lookup_header,
1091: c_cancel_flag,
1084: ----------------------------------------------------------------------------
1085: -- PDOI Set Definitions for Standard PO
1086: ----------------------------------------------------------------------------
1087: c_pdoi_header_standard_vs CONSTANT po_tbl_varchar2000
1088: := po_tbl_varchar2000(c_confirming_order_flag,
1089: c_acceptance_due_date,
1090: c_firm_status_lookup_header,
1091: c_cancel_flag,
1092: c_closed_code,
1093: c_print_count,
1094: c_frozen_flag,
1095: c_style_id);
1096:
1097: c_pdoi_line_standard_vs CONSTANT po_tbl_varchar2000
1098: := po_tbl_varchar2000(c_over_tolerance_error_flag,
1099: c_capital_expense_flag,
1100: c_not_to_exceed_price,
1101: c_start_date_standard,
1094: c_frozen_flag,
1095: c_style_id);
1096:
1097: c_pdoi_line_standard_vs CONSTANT po_tbl_varchar2000
1098: := po_tbl_varchar2000(c_over_tolerance_error_flag,
1099: c_capital_expense_flag,
1100: c_not_to_exceed_price,
1101: c_start_date_standard,
1102: c_item_id_standard,
1119: c_pdoi_complex_po_att_check
1120: --
1121: );
1122:
1123: c_pdoi_line_loc_standard_vs CONSTANT po_tbl_varchar2000
1124: := po_tbl_varchar2000(c_enforce_ship_to_loc_code,
1125: c_shipment_type_standard,
1126: c_allow_sub_receipts_flag,
1127: c_days_early_receipt_allowed,
1120: --
1121: );
1122:
1123: c_pdoi_line_loc_standard_vs CONSTANT po_tbl_varchar2000
1124: := po_tbl_varchar2000(c_enforce_ship_to_loc_code,
1125: c_shipment_type_standard,
1126: c_allow_sub_receipts_flag,
1127: c_days_early_receipt_allowed,
1128: c_receipt_days_exception_code,
1143:
1144: ----------------------------------------------------------------------------
1145: -- PDOI Set Definitions for Quotation
1146: ----------------------------------------------------------------------------
1147: c_pdoi_header_quotation_vs CONSTANT po_tbl_varchar2000
1148: := po_tbl_varchar2000(c_quote_warning_delay,
1149: c_approval_required_flag);
1150:
1151: c_pdoi_line_quotation_vs CONSTANT po_tbl_varchar2000
1144: ----------------------------------------------------------------------------
1145: -- PDOI Set Definitions for Quotation
1146: ----------------------------------------------------------------------------
1147: c_pdoi_header_quotation_vs CONSTANT po_tbl_varchar2000
1148: := po_tbl_varchar2000(c_quote_warning_delay,
1149: c_approval_required_flag);
1150:
1151: c_pdoi_line_quotation_vs CONSTANT po_tbl_varchar2000
1152: := po_tbl_varchar2000(c_over_tolerance_error_flag,
1147: c_pdoi_header_quotation_vs CONSTANT po_tbl_varchar2000
1148: := po_tbl_varchar2000(c_quote_warning_delay,
1149: c_approval_required_flag);
1150:
1151: c_pdoi_line_quotation_vs CONSTANT po_tbl_varchar2000
1152: := po_tbl_varchar2000(c_over_tolerance_error_flag,
1153: c_allow_price_override_null ,
1154: c_negotiated_by_preparer_null,
1155: c_capital_expense_flag_null,
1148: := po_tbl_varchar2000(c_quote_warning_delay,
1149: c_approval_required_flag);
1150:
1151: c_pdoi_line_quotation_vs CONSTANT po_tbl_varchar2000
1152: := po_tbl_varchar2000(c_over_tolerance_error_flag,
1153: c_allow_price_override_null ,
1154: c_negotiated_by_preparer_null,
1155: c_capital_expense_flag_null,
1156: c_min_release_amount_null,
1158: c_committed_amount_null,
1159: c_ip_category_id,
1160: c_negotiated_by_preparer_null);
1161:
1162: c_pdoi_line_loc_quotation_vs CONSTANT po_tbl_varchar2000
1163: := po_tbl_varchar2000(c_qty_rcv_exception_code,
1164: c_shipment_type_quotation,
1165: c_fob_lookup_code_line_loc,
1166: c_freight_terms_line_loc,
1159: c_ip_category_id,
1160: c_negotiated_by_preparer_null);
1161:
1162: c_pdoi_line_loc_quotation_vs CONSTANT po_tbl_varchar2000
1163: := po_tbl_varchar2000(c_qty_rcv_exception_code,
1164: c_shipment_type_quotation,
1165: c_fob_lookup_code_line_loc,
1166: c_freight_terms_line_loc,
1167: c_freight_carrier_line_loc,
1181: ----------------------------------------------------------------------------
1182: -- CLM PDOI Common Set Definitions
1183: ----------------------------------------------------------------------------
1184:
1185: c_clm_pdoi_header_common_vs CONSTANT po_tbl_varchar2000
1186: := po_tbl_varchar2000(c_print_form_format_valid,
1187: c_validate_source_idv,
1188: c_validate_award_admin,
1189: c_validate_contract_officer,
1182: -- CLM PDOI Common Set Definitions
1183: ----------------------------------------------------------------------------
1184:
1185: c_clm_pdoi_header_common_vs CONSTANT po_tbl_varchar2000
1186: := po_tbl_varchar2000(c_print_form_format_valid,
1187: c_validate_source_idv,
1188: c_validate_award_admin,
1189: c_validate_contract_officer,
1190: c_validate_umbrella_program_id,
1193: c_validate_idv_style_id,
1194: c_validate_po_idv_vendor_id,
1195: c_val_po_idv_vendor_site_id);
1196:
1197: c_clm_pdoi_line_common_vs CONSTANT po_tbl_varchar2000
1198: := po_tbl_varchar2000(c_pdoi_clin_slin_structure,
1199: c_validate_contract_type,
1200: c_validate_cost_constraint,
1201: --c_check_contract_num_and_ver,
1194: c_validate_po_idv_vendor_id,
1195: c_val_po_idv_vendor_site_id);
1196:
1197: c_clm_pdoi_line_common_vs CONSTANT po_tbl_varchar2000
1198: := po_tbl_varchar2000(c_pdoi_clin_slin_structure,
1199: c_validate_contract_type,
1200: c_validate_cost_constraint,
1201: --c_check_contract_num_and_ver,
1202: c_validate_option_indicator,
1211: c_option_fm_date_le_ex_date,
1212: c_idv_reference_equal_check,
1213: c_validate_clm_line_type_id);
1214:
1215: c_clm_pdoi_dist_common_vs CONSTANT po_tbl_varchar2000
1216: := po_tbl_varchar2000(c_pdoi_check_clin_slin_funding,
1217: c_validate_clm_defence_funding,
1218: c_validate_option_distribution);
1219:
1212: c_idv_reference_equal_check,
1213: c_validate_clm_line_type_id);
1214:
1215: c_clm_pdoi_dist_common_vs CONSTANT po_tbl_varchar2000
1216: := po_tbl_varchar2000(c_pdoi_check_clin_slin_funding,
1217: c_validate_clm_defence_funding,
1218: c_validate_option_distribution);
1219:
1220:
1221: ----------------------------------------------------------------------------
1222: -- Validation Set Definitions for Modification Merge
1223: ----------------------------------------------------------------------------
1224:
1225: c_mod_sync_shipment_vs CONSTANT PO_TBL_VARCHAR2000 :=
1226: PO_TBL_VARCHAR2000(
1227: c_ship_qty_ge_qty_exec
1228: , c_ship_amt_ge_amt_exec);
1229:
1222: -- Validation Set Definitions for Modification Merge
1223: ----------------------------------------------------------------------------
1224:
1225: c_mod_sync_shipment_vs CONSTANT PO_TBL_VARCHAR2000 :=
1226: PO_TBL_VARCHAR2000(
1227: c_ship_qty_ge_qty_exec
1228: , c_ship_amt_ge_amt_exec);
1229:
1230: c_mod_sync_distribution_vs CONSTANT PO_TBL_VARCHAR2000 :=
1226: PO_TBL_VARCHAR2000(
1227: c_ship_qty_ge_qty_exec
1228: , c_ship_amt_ge_amt_exec);
1229:
1230: c_mod_sync_distribution_vs CONSTANT PO_TBL_VARCHAR2000 :=
1231: PO_TBL_VARCHAR2000(
1232: c_dist_qty_ge_qty_exec
1233: , c_dist_amt_ge_amt_exec);
1234:
1227: c_ship_qty_ge_qty_exec
1228: , c_ship_amt_ge_amt_exec);
1229:
1230: c_mod_sync_distribution_vs CONSTANT PO_TBL_VARCHAR2000 :=
1231: PO_TBL_VARCHAR2000(
1232: c_dist_qty_ge_qty_exec
1233: , c_dist_amt_ge_amt_exec);
1234:
1235:
1236: --UCA Project - CLMR4 Changes Begin
1237: ------------------------------------------------------------------------------
1238: --PO LINE UCAs Validation Set Defintion
1239: ------------------------------------------------------------------------------
1240: c_html_order_line_ucas_vs CONSTANT PO_TBL_VARCHAR2000 :=
1241: PO_TBL_VARCHAR2000(
1242: c_lgl_le_nte,
1243: c_undef_amt_le_nte,
1244: c_undef_amt_le_line_amt,
1237: ------------------------------------------------------------------------------
1238: --PO LINE UCAs Validation Set Defintion
1239: ------------------------------------------------------------------------------
1240: c_html_order_line_ucas_vs CONSTANT PO_TBL_VARCHAR2000 :=
1241: PO_TBL_VARCHAR2000(
1242: c_lgl_le_nte,
1243: c_undef_amt_le_nte,
1244: c_undef_amt_le_line_amt,
1245: c_undef_amt_gt_zero,
1410: , p_message_application_tbl IN PO_TBL_VARCHAR30
1411: , p_message_name_tbl IN PO_TBL_VARCHAR30
1412: , p_column_name_tbl IN PO_TBL_VARCHAR30
1413: , p_token1_name_tbl IN PO_TBL_VARCHAR30
1414: , p_token1_value_tbl IN PO_TBL_VARCHAR2000
1415: , p_token2_name_tbl IN PO_TBL_VARCHAR30
1416: , p_token2_value_tbl IN PO_TBL_VARCHAR2000
1417: , p_token3_name_tbl IN PO_TBL_VARCHAR30
1418: , p_token3_value_tbl IN PO_TBL_VARCHAR2000
1412: , p_column_name_tbl IN PO_TBL_VARCHAR30
1413: , p_token1_name_tbl IN PO_TBL_VARCHAR30
1414: , p_token1_value_tbl IN PO_TBL_VARCHAR2000
1415: , p_token2_name_tbl IN PO_TBL_VARCHAR30
1416: , p_token2_value_tbl IN PO_TBL_VARCHAR2000
1417: , p_token3_name_tbl IN PO_TBL_VARCHAR30
1418: , p_token3_value_tbl IN PO_TBL_VARCHAR2000
1419: , p_token4_name_tbl IN PO_TBL_VARCHAR30
1420: , p_token4_value_tbl IN PO_TBL_VARCHAR2000
1414: , p_token1_value_tbl IN PO_TBL_VARCHAR2000
1415: , p_token2_name_tbl IN PO_TBL_VARCHAR30
1416: , p_token2_value_tbl IN PO_TBL_VARCHAR2000
1417: , p_token3_name_tbl IN PO_TBL_VARCHAR30
1418: , p_token3_value_tbl IN PO_TBL_VARCHAR2000
1419: , p_token4_name_tbl IN PO_TBL_VARCHAR30
1420: , p_token4_value_tbl IN PO_TBL_VARCHAR2000
1421: , p_token5_name_tbl IN PO_TBL_VARCHAR30
1422: , p_token5_value_tbl IN PO_TBL_VARCHAR2000
1416: , p_token2_value_tbl IN PO_TBL_VARCHAR2000
1417: , p_token3_name_tbl IN PO_TBL_VARCHAR30
1418: , p_token3_value_tbl IN PO_TBL_VARCHAR2000
1419: , p_token4_name_tbl IN PO_TBL_VARCHAR30
1420: , p_token4_value_tbl IN PO_TBL_VARCHAR2000
1421: , p_token5_name_tbl IN PO_TBL_VARCHAR30
1422: , p_token5_value_tbl IN PO_TBL_VARCHAR2000
1423: , p_token6_name_tbl IN PO_TBL_VARCHAR30
1424: , p_token6_value_tbl IN PO_TBL_VARCHAR2000
1418: , p_token3_value_tbl IN PO_TBL_VARCHAR2000
1419: , p_token4_name_tbl IN PO_TBL_VARCHAR30
1420: , p_token4_value_tbl IN PO_TBL_VARCHAR2000
1421: , p_token5_name_tbl IN PO_TBL_VARCHAR30
1422: , p_token5_value_tbl IN PO_TBL_VARCHAR2000
1423: , p_token6_name_tbl IN PO_TBL_VARCHAR30
1424: , p_token6_value_tbl IN PO_TBL_VARCHAR2000
1425: )
1426: IS
1420: , p_token4_value_tbl IN PO_TBL_VARCHAR2000
1421: , p_token5_name_tbl IN PO_TBL_VARCHAR30
1422: , p_token5_value_tbl IN PO_TBL_VARCHAR2000
1423: , p_token6_name_tbl IN PO_TBL_VARCHAR30
1424: , p_token6_value_tbl IN PO_TBL_VARCHAR2000
1425: )
1426: IS
1427: PRAGMA AUTONOMOUS_TRANSACTION;
1428: d_mod CONSTANT VARCHAR2(100) := D_commit_validation_results_au;
1601: l_message_application_tbl PO_TBL_VARCHAR30;
1602: l_message_name_tbl PO_TBL_VARCHAR30;
1603: l_column_name_tbl PO_TBL_VARCHAR30;
1604: l_token1_name_tbl PO_TBL_VARCHAR30;
1605: l_token1_value_tbl PO_TBL_VARCHAR2000;
1606: l_token2_name_tbl PO_TBL_VARCHAR30;
1607: l_token2_value_tbl PO_TBL_VARCHAR2000;
1608: l_token3_name_tbl PO_TBL_VARCHAR30;
1609: l_token3_value_tbl PO_TBL_VARCHAR2000;
1603: l_column_name_tbl PO_TBL_VARCHAR30;
1604: l_token1_name_tbl PO_TBL_VARCHAR30;
1605: l_token1_value_tbl PO_TBL_VARCHAR2000;
1606: l_token2_name_tbl PO_TBL_VARCHAR30;
1607: l_token2_value_tbl PO_TBL_VARCHAR2000;
1608: l_token3_name_tbl PO_TBL_VARCHAR30;
1609: l_token3_value_tbl PO_TBL_VARCHAR2000;
1610: l_token4_name_tbl PO_TBL_VARCHAR30;
1611: l_token4_value_tbl PO_TBL_VARCHAR2000;
1605: l_token1_value_tbl PO_TBL_VARCHAR2000;
1606: l_token2_name_tbl PO_TBL_VARCHAR30;
1607: l_token2_value_tbl PO_TBL_VARCHAR2000;
1608: l_token3_name_tbl PO_TBL_VARCHAR30;
1609: l_token3_value_tbl PO_TBL_VARCHAR2000;
1610: l_token4_name_tbl PO_TBL_VARCHAR30;
1611: l_token4_value_tbl PO_TBL_VARCHAR2000;
1612: l_token5_name_tbl PO_TBL_VARCHAR30;
1613: l_token5_value_tbl PO_TBL_VARCHAR2000;
1607: l_token2_value_tbl PO_TBL_VARCHAR2000;
1608: l_token3_name_tbl PO_TBL_VARCHAR30;
1609: l_token3_value_tbl PO_TBL_VARCHAR2000;
1610: l_token4_name_tbl PO_TBL_VARCHAR30;
1611: l_token4_value_tbl PO_TBL_VARCHAR2000;
1612: l_token5_name_tbl PO_TBL_VARCHAR30;
1613: l_token5_value_tbl PO_TBL_VARCHAR2000;
1614: l_token6_name_tbl PO_TBL_VARCHAR30;
1615: l_token6_value_tbl PO_TBL_VARCHAR2000;
1609: l_token3_value_tbl PO_TBL_VARCHAR2000;
1610: l_token4_name_tbl PO_TBL_VARCHAR30;
1611: l_token4_value_tbl PO_TBL_VARCHAR2000;
1612: l_token5_name_tbl PO_TBL_VARCHAR30;
1613: l_token5_value_tbl PO_TBL_VARCHAR2000;
1614: l_token6_name_tbl PO_TBL_VARCHAR30;
1615: l_token6_value_tbl PO_TBL_VARCHAR2000;
1616:
1617: BEGIN
1611: l_token4_value_tbl PO_TBL_VARCHAR2000;
1612: l_token5_name_tbl PO_TBL_VARCHAR30;
1613: l_token5_value_tbl PO_TBL_VARCHAR2000;
1614: l_token6_name_tbl PO_TBL_VARCHAR30;
1615: l_token6_value_tbl PO_TBL_VARCHAR2000;
1616:
1617: BEGIN
1618:
1619: IF PO_LOG.d_proc THEN
1898: -- but may be turned into a worse result
1899: -- (ERROR will not become SUCCESS, but WARNING may become ERROR).
1900: ----------------------------------------------------------------------------
1901: PROCEDURE validate_set(
1902: p_validation_set IN PO_TBL_VARCHAR2000
1903: , p_headers IN PO_HEADERS_VAL_TYPE DEFAULT NULL
1904: , p_lines IN PO_LINES_VAL_TYPE DEFAULT NULL
1905: , p_line_locations IN PO_LINE_LOCATIONS_VAL_TYPE DEFAULT NULL
1906: , p_distributions IN PO_DISTRIBUTIONS_VAL_TYPE DEFAULT NULL
1911: , p_po_line_ucas IN PO_LINE_UCAS_VAL_TYPE DEFAULT NULL --UCA Project
1912: , p_autocommit_results_flag IN VARCHAR2 DEFAULT NULL
1913: , p_calling_program IN VARCHAR2 DEFAULT NULL
1914: , p_stopping_result_type IN VARCHAR2 DEFAULT NULL
1915: , p_parameter_name_tbl IN PO_TBL_VARCHAR2000 DEFAULT NULL
1916: , p_parameter_value_tbl IN PO_TBL_VARCHAR2000 DEFAULT NULL
1917: , x_result_type IN OUT NOCOPY VARCHAR2
1918: , x_result_set_id IN OUT NOCOPY NUMBER
1919: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1912: , p_autocommit_results_flag IN VARCHAR2 DEFAULT NULL
1913: , p_calling_program IN VARCHAR2 DEFAULT NULL
1914: , p_stopping_result_type IN VARCHAR2 DEFAULT NULL
1915: , p_parameter_name_tbl IN PO_TBL_VARCHAR2000 DEFAULT NULL
1916: , p_parameter_value_tbl IN PO_TBL_VARCHAR2000 DEFAULT NULL
1917: , x_result_type IN OUT NOCOPY VARCHAR2
1918: , x_result_set_id IN OUT NOCOPY NUMBER
1919: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1920: )
6177: --x_results
6178: -- The results of the validation cycle.
6179: ----------------------------------------------------------------------------
6180: PROCEDURE validate_set(
6181: p_validation_set IN PO_TBL_VARCHAR2000
6182: , p_headers IN PO_HEADERS_VAL_TYPE DEFAULT NULL
6183: , p_lines IN PO_LINES_VAL_TYPE DEFAULT NULL
6184: , p_line_locations IN PO_LINE_LOCATIONS_VAL_TYPE DEFAULT NULL
6185: , p_distributions IN PO_DISTRIBUTIONS_VAL_TYPE DEFAULT NULL
6189: , p_price_adjustments IN PO_PRICE_ADJS_VAL_TYPE DEFAULT NULL --Enhanced Pricing
6190: , p_po_line_ucas IN PO_LINE_UCAS_VAL_TYPE DEFAULT NULL --UCA Project
6191: , p_calling_program IN VARCHAR2 DEFAULT NULL
6192: , p_stopping_result_type IN VARCHAR2 DEFAULT NULL
6193: , p_parameter_name_tbl IN PO_TBL_VARCHAR2000 DEFAULT NULL
6194: , p_parameter_value_tbl IN PO_TBL_VARCHAR2000 DEFAULT NULL
6195: , x_result_type IN OUT NOCOPY VARCHAR2
6196: , x_results OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
6197: )
6190: , p_po_line_ucas IN PO_LINE_UCAS_VAL_TYPE DEFAULT NULL --UCA Project
6191: , p_calling_program IN VARCHAR2 DEFAULT NULL
6192: , p_stopping_result_type IN VARCHAR2 DEFAULT NULL
6193: , p_parameter_name_tbl IN PO_TBL_VARCHAR2000 DEFAULT NULL
6194: , p_parameter_value_tbl IN PO_TBL_VARCHAR2000 DEFAULT NULL
6195: , x_result_type IN OUT NOCOPY VARCHAR2
6196: , x_results OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
6197: )
6198: IS
6434: )
6435: IS
6436: d_mod CONSTANT VARCHAR2(100) := D_validate_html_order;
6437: d_position NUMBER := 0;
6438: l_validation_set PO_TBL_VARCHAR2000;
6439: BEGIN
6440:
6441: IF PO_LOG.d_proc THEN
6442: PO_LOG.proc_begin(d_mod);
6443: END IF;
6444:
6445: d_position := 1;
6446:
6447: l_validation_set := PO_TBL_VARCHAR2000();
6448:
6449: IF (p_headers IS NOT NULL) THEN
6450: d_position := 10;
6451: l_validation_set :=
6540: )
6541: IS
6542: d_mod CONSTANT VARCHAR2(100) := D_validate_html_agreement;
6543: d_position NUMBER := 0;
6544: l_validation_set PO_TBL_VARCHAR2000;
6545: BEGIN
6546:
6547: IF PO_LOG.d_proc THEN
6548: PO_LOG.proc_begin(d_mod);
6549: END IF;
6550:
6551: d_position := 1;
6552:
6553: l_validation_set := PO_TBL_VARCHAR2000();
6554:
6555: IF (p_headers IS NOT NULL) THEN
6556: d_position := 10;
6557: l_validation_set :=
6671: p_distributions IN PO_DISTRIBUTIONS_VAL_TYPE DEFAULT NULL,
6672: p_price_differentials IN PO_PRICE_DIFF_VAL_TYPE DEFAULT NULL,
6673: p_doc_type IN VARCHAR2 DEFAULT NULL,
6674: p_action IN VARCHAR2 DEFAULT 'CREATE',
6675: p_parameter_name_tbl IN PO_TBL_VARCHAR2000 DEFAULT NULL,
6676: p_parameter_value_tbl IN PO_TBL_VARCHAR2000 DEFAULT NULL,
6677: x_result_type OUT NOCOPY VARCHAR2,
6678: x_results OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
6679: )
6672: p_price_differentials IN PO_PRICE_DIFF_VAL_TYPE DEFAULT NULL,
6673: p_doc_type IN VARCHAR2 DEFAULT NULL,
6674: p_action IN VARCHAR2 DEFAULT 'CREATE',
6675: p_parameter_name_tbl IN PO_TBL_VARCHAR2000 DEFAULT NULL,
6676: p_parameter_value_tbl IN PO_TBL_VARCHAR2000 DEFAULT NULL,
6677: x_result_type OUT NOCOPY VARCHAR2,
6678: x_results OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
6679: )
6680: IS
6680: IS
6681:
6682: d_mod CONSTANT VARCHAR2(100) := D_validate_pdoi;
6683: d_position NUMBER := 0;
6684: l_validation_set PO_TBL_VARCHAR2000;
6685:
6686: BEGIN
6687:
6688: IF PO_LOG.d_proc THEN
6691: END IF;
6692:
6693: d_position := 1;
6694:
6695: l_validation_set := PO_TBL_VARCHAR2000();
6696:
6697: IF (p_headers IS NOT NULL AND p_lines IS NULL AND p_line_locations IS NULL AND
6698: p_distributions IS NULL AND p_price_differentials IS NULL) THEN
6699: d_position := 10;
6887: ) IS
6888:
6889: d_mod CONSTANT VARCHAR2(100) := D_validate_modification_sync;
6890: d_position NUMBER := 0;
6891: l_validation_set PO_TBL_VARCHAR2000;
6892: BEGIN
6893:
6894: IF PO_LOG.d_proc THEN
6895: PO_LOG.proc_begin(d_mod);
6896: END IF;
6897:
6898: d_position := 1;
6899:
6900: l_validation_set := PO_TBL_VARCHAR2000();
6901:
6902: IF (p_line_locations IS NOT NULL) THEN
6903: d_position := 30;
6904: l_validation_set :=
6952: , p_position IN NUMBER
6953: , p_result_set_id IN NUMBER
6954: )
6955: IS
6956: l_rowid_tbl PO_TBL_VARCHAR2000;
6957: BEGIN
6958: IF PO_LOG.d_stmt THEN
6959: SELECT VR.rowid
6960: BULK COLLECT INTO l_rowid_tbl