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 STANDARD

Line 77: c_doc_type_standard CONSTANT VARCHAR2(30) := 'STANDARD';

73: c_parameter_YES CONSTANT VARCHAR2(1) := PO_CORE_S.g_parameter_YES;
74: c_parameter_NO CONSTANT VARCHAR2(1) := PO_CORE_S.g_parameter_NO;
75:
76: c_doc_type_blanket CONSTANT VARCHAR2(30) := 'BLANKET';
77: c_doc_type_standard CONSTANT VARCHAR2(30) := 'STANDARD';
78: c_doc_type_quotation CONSTANT VARCHAR2(30) := 'QUOTATION';
79:
80:
81: /**

Line 253: c_start_date_standard CONSTANT VARCHAR2(30) := 'C_START_DATE_STANDARD';

249: c_line_num CONSTANT VARCHAR2(30) := 'C_LINE_NUM';
250: c_po_line_id CONSTANT VARCHAR2(30) := 'C_PO_LINE_ID';
251: c_line_type_id CONSTANT VARCHAR2(30) := 'C_LINE_TYPE_ID';
252: c_price_type_lookup_code CONSTANT VARCHAR2(30) := 'C_PRICE_TYPE_LOOKUP_CODE';
253: c_start_date_standard CONSTANT VARCHAR2(30) := 'C_START_DATE_STANDARD';
254: c_item_id_standard CONSTANT VARCHAR2(30) := 'C_ITEM_ID_STANDARD';
255: c_quantity_standard CONSTANT VARCHAR2(30) := 'C_QUANTITY_STANDARD';
256: c_amount_standard CONSTANT VARCHAR2(30) := 'C_AMOUNT_STANDARD';
257: c_price_break_lookup_code CONSTANT VARCHAR2(30) := 'C_PRICE_BREAK_LOOKUP_CODE';

Line 254: c_item_id_standard CONSTANT VARCHAR2(30) := 'C_ITEM_ID_STANDARD';

250: c_po_line_id CONSTANT VARCHAR2(30) := 'C_PO_LINE_ID';
251: c_line_type_id CONSTANT VARCHAR2(30) := 'C_LINE_TYPE_ID';
252: c_price_type_lookup_code CONSTANT VARCHAR2(30) := 'C_PRICE_TYPE_LOOKUP_CODE';
253: c_start_date_standard CONSTANT VARCHAR2(30) := 'C_START_DATE_STANDARD';
254: c_item_id_standard CONSTANT VARCHAR2(30) := 'C_ITEM_ID_STANDARD';
255: c_quantity_standard CONSTANT VARCHAR2(30) := 'C_QUANTITY_STANDARD';
256: c_amount_standard CONSTANT VARCHAR2(30) := 'C_AMOUNT_STANDARD';
257: c_price_break_lookup_code CONSTANT VARCHAR2(30) := 'C_PRICE_BREAK_LOOKUP_CODE';
258: c_not_to_exceed_price CONSTANT VARCHAR2(30) := 'C_NOT_TO_EXCEED_PRICE';

Line 255: c_quantity_standard CONSTANT VARCHAR2(30) := 'C_QUANTITY_STANDARD';

251: c_line_type_id CONSTANT VARCHAR2(30) := 'C_LINE_TYPE_ID';
252: c_price_type_lookup_code CONSTANT VARCHAR2(30) := 'C_PRICE_TYPE_LOOKUP_CODE';
253: c_start_date_standard CONSTANT VARCHAR2(30) := 'C_START_DATE_STANDARD';
254: c_item_id_standard CONSTANT VARCHAR2(30) := 'C_ITEM_ID_STANDARD';
255: c_quantity_standard CONSTANT VARCHAR2(30) := 'C_QUANTITY_STANDARD';
256: c_amount_standard CONSTANT VARCHAR2(30) := 'C_AMOUNT_STANDARD';
257: c_price_break_lookup_code CONSTANT VARCHAR2(30) := 'C_PRICE_BREAK_LOOKUP_CODE';
258: c_not_to_exceed_price CONSTANT VARCHAR2(30) := 'C_NOT_TO_EXCEED_PRICE';
259: c_release_num_null CONSTANT VARCHAR2(30) := 'C_RELEASE_NUM_NULL';

Line 256: c_amount_standard CONSTANT VARCHAR2(30) := 'C_AMOUNT_STANDARD';

252: c_price_type_lookup_code CONSTANT VARCHAR2(30) := 'C_PRICE_TYPE_LOOKUP_CODE';
253: c_start_date_standard CONSTANT VARCHAR2(30) := 'C_START_DATE_STANDARD';
254: c_item_id_standard CONSTANT VARCHAR2(30) := 'C_ITEM_ID_STANDARD';
255: c_quantity_standard CONSTANT VARCHAR2(30) := 'C_QUANTITY_STANDARD';
256: c_amount_standard CONSTANT VARCHAR2(30) := 'C_AMOUNT_STANDARD';
257: c_price_break_lookup_code CONSTANT VARCHAR2(30) := 'C_PRICE_BREAK_LOOKUP_CODE';
258: c_not_to_exceed_price CONSTANT VARCHAR2(30) := 'C_NOT_TO_EXCEED_PRICE';
259: c_release_num_null CONSTANT VARCHAR2(30) := 'C_RELEASE_NUM_NULL';
260: c_po_release_id_null CONSTANT VARCHAR2(30) := 'C_PO_RELEASE_ID_NULL';

Line 321: c_shipment_type_standard CONSTANT VARCHAR2(30) := 'C_SHIPMENT_TYPE_STANDARD';

317: ------------------------------------------------------------------
318: c_shipment_need_by_date CONSTANT VARCHAR2(30) := 'C_SHIPMENT_NEED_BY_DATE';
319: c_shipment_promised_date CONSTANT VARCHAR2(30) := 'C_SHIPMENT_PROMISED_DATE';
320: c_shipment_type_blanket CONSTANT VARCHAR2(30) := 'C_SHIPMENT_TYPE_BLANKET';
321: c_shipment_type_standard CONSTANT VARCHAR2(30) := 'C_SHIPMENT_TYPE_STANDARD';
322: c_shipment_type_quotation CONSTANT VARCHAR2(30) := 'C_SHIPMENT_TYPE_QUOTATION';
323: c_shipment_num CONSTANT VARCHAR2(30) := 'C_SHIPMENT_NUM';
324: c_shipment_quantity CONSTANT VARCHAR2(30) := 'C_SHIPMENT_QUANTITY';
325: c_shipment_price_override CONSTANT VARCHAR2(30) := 'C_SHIPMENT_PRICE_OVERRIDE';

Line 891: -- PDOI Set Definitions for Standard PO

887:
888:
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,

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 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 907: c_start_date_standard,

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,
909: c_quantity_standard,
910: c_amount_standard,
911: c_ip_category_id_null,

Line 908: c_item_id_standard,

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,
909: c_quantity_standard,
910: c_amount_standard,
911: c_ip_category_id_null,
912: c_line_secondary_uom,

Line 909: c_quantity_standard,

905: c_capital_expense_flag,
906: c_not_to_exceed_price,
907: c_start_date_standard,
908: c_item_id_standard,
909: c_quantity_standard,
910: c_amount_standard,
911: c_ip_category_id_null,
912: c_line_secondary_uom,
913: c_line_preferred_grade,

Line 910: c_amount_standard,

906: c_not_to_exceed_price,
907: c_start_date_standard,
908: c_item_id_standard,
909: c_quantity_standard,
910: c_amount_standard,
911: c_ip_category_id_null,
912: c_line_secondary_uom,
913: c_line_preferred_grade,
914: c_line_style_related_info,

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 920: c_shipment_type_standard,

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,
924: c_invoice_close_tolerance,

Line 1986: -- validate type_lookup_code not null and equal to BLANKET, STANDARD or QUOTATION.

1982: x_results => x_results,
1983: x_result_type => l_result_type);
1984:
1985: WHEN c_type_lookup_code THEN
1986: -- validate type_lookup_code not null and equal to BLANKET, STANDARD or QUOTATION.
1987: PO_VAL_HEADERS2.type_lookup_code(p_id_tbl => p_headers.interface_id,
1988: p_type_lookup_code_tbl => p_headers.type_lookup_code,
1989: x_results => x_results,
1990: x_result_type => l_result_type);

Line 2756: -- This method is called only for Standard PO and quotation documents

2752: -------------------------------------------------------------------------
2753: WHEN c_over_tolerance_error_flag THEN
2754: -- The lookup code specified in over_tolerance_error_flag with the lookup type
2755: -- 'RECEIVING CONTROL LEVEL' has to exist in po_lookup_codes and still active.
2756: -- This method is called only for Standard PO and quotation documents
2757: PO_VAL_LINES2.over_tolerance_err_flag(p_id_tbl => p_lines.interface_id,
2758: p_over_tolerance_err_flag_tbl => p_lines.over_tolerance_error_flag,
2759: x_result_set_id => l_result_set_id,
2760: x_result_type => l_result_type);

Line 2794: -- If purchase basis is not 'TEMP LABOR' or document type is not STANDARD,

2790: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
2791: x_results => x_results,
2792: x_result_type => l_result_type);
2793: WHEN c_contractor_name THEN
2794: -- If purchase basis is not 'TEMP LABOR' or document type is not STANDARD,
2795: -- contractor first name and last name fields should be empty
2796: PO_VAL_LINES2.contractor_name(p_id_tbl => p_lines.interface_id,
2797: p_doc_type => l_doc_type,
2798: p_purchase_basis_tbl => p_lines.purchase_basis,

Line 2979: WHEN c_start_date_standard THEN

2975: PO_VAL_LINES2.price_type_lookup_code(p_id_tbl => p_lines.interface_id,
2976: p_price_type_lookup_code_tbl => p_lines.price_type_lookup_code,
2977: x_result_set_id => l_result_set_id,
2978: x_result_type => l_result_type);
2979: WHEN c_start_date_standard THEN
2980: -- Start date is required for Standard PO with purchase basis 'TEMP LABOR'
2981: -- Expiration date if provided should be later than the start date
2982: -- If purchase basis is not 'TEMP LABOR', start_date and expiration_date have to be null
2983: PO_VAL_LINES2.start_date_standard(p_id_tbl => p_lines.interface_id,

Line 2980: -- Start date is required for Standard PO with purchase basis 'TEMP LABOR'

2976: p_price_type_lookup_code_tbl => p_lines.price_type_lookup_code,
2977: x_result_set_id => l_result_set_id,
2978: x_result_type => l_result_type);
2979: WHEN c_start_date_standard THEN
2980: -- Start date is required for Standard PO with purchase basis 'TEMP LABOR'
2981: -- Expiration date if provided should be later than the start date
2982: -- If purchase basis is not 'TEMP LABOR', start_date and expiration_date have to be null
2983: PO_VAL_LINES2.start_date_standard(p_id_tbl => p_lines.interface_id,
2984: p_start_date_tbl => p_lines.start_date,

Line 2983: PO_VAL_LINES2.start_date_standard(p_id_tbl => p_lines.interface_id,

2979: WHEN c_start_date_standard THEN
2980: -- Start date is required for Standard PO with purchase basis 'TEMP LABOR'
2981: -- Expiration date if provided should be later than the start date
2982: -- If purchase basis is not 'TEMP LABOR', start_date and expiration_date have to be null
2983: PO_VAL_LINES2.start_date_standard(p_id_tbl => p_lines.interface_id,
2984: p_start_date_tbl => p_lines.start_date,
2985: p_expiration_date_tbl => p_lines.expiration_date,
2986: p_purchase_basis_tbl => p_lines.purchase_basis,
2987: x_results => x_results,

Line 2989: WHEN c_item_id_standard THEN

2985: p_expiration_date_tbl => p_lines.expiration_date,
2986: p_purchase_basis_tbl => p_lines.purchase_basis,
2987: x_results => x_results,
2988: x_result_type => l_result_type);
2989: WHEN c_item_id_standard THEN
2990: -- If order_type_lookup_code is not 'RATE' or 'FIXED PRICE', and item_id is not null, then bom_item_type cannot be 1 or 2.
2991: PO_VAL_LINES2.item_id_standard(p_id_tbl => p_lines.interface_id,
2992: p_item_id_tbl => p_lines.item_id,
2993: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,

Line 2991: PO_VAL_LINES2.item_id_standard(p_id_tbl => p_lines.interface_id,

2987: x_results => x_results,
2988: x_result_type => l_result_type);
2989: WHEN c_item_id_standard THEN
2990: -- If order_type_lookup_code is not 'RATE' or 'FIXED PRICE', and item_id is not null, then bom_item_type cannot be 1 or 2.
2991: PO_VAL_LINES2.item_id_standard(p_id_tbl => p_lines.interface_id,
2992: p_item_id_tbl => p_lines.item_id,
2993: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
2994: p_inventory_org_id => l_inventory_org_id,
2995: x_result_set_id => l_result_set_id,

Line 2997: WHEN c_quantity_standard THEN

2993: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
2994: p_inventory_org_id => l_inventory_org_id,
2995: x_result_set_id => l_result_set_id,
2996: x_result_type => l_result_type);
2997: WHEN c_quantity_standard THEN
2998: -- Quantity cannot be zero for SPO
2999: -- And qiantity cannot be empty for SPO if order type is QUANTITY/AMOUNT
3000: PO_VAL_LINES2.quantity_standard(p_id_tbl => p_lines.interface_id,
3001: p_quantity_tbl => p_lines.quantity,

Line 3000: PO_VAL_LINES2.quantity_standard(p_id_tbl => p_lines.interface_id,

2996: x_result_type => l_result_type);
2997: WHEN c_quantity_standard THEN
2998: -- Quantity cannot be zero for SPO
2999: -- And qiantity cannot be empty for SPO if order type is QUANTITY/AMOUNT
3000: PO_VAL_LINES2.quantity_standard(p_id_tbl => p_lines.interface_id,
3001: p_quantity_tbl => p_lines.quantity,
3002: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
3003: x_results => x_results,
3004: x_result_type => l_result_type);

Line 3005: WHEN c_amount_standard THEN

3001: p_quantity_tbl => p_lines.quantity,
3002: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
3003: x_results => x_results,
3004: x_result_type => l_result_type);
3005: WHEN c_amount_standard THEN
3006: -- If order_type_lookup_code is 'FIXED PRICE' or 'RATE', amount cannot be null
3007: PO_VAL_LINES2.amount_standard(p_id_tbl => p_lines.interface_id,
3008: p_amount_tbl => p_lines.amount,
3009: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,

Line 3007: PO_VAL_LINES2.amount_standard(p_id_tbl => p_lines.interface_id,

3003: x_results => x_results,
3004: x_result_type => l_result_type);
3005: WHEN c_amount_standard THEN
3006: -- If order_type_lookup_code is 'FIXED PRICE' or 'RATE', amount cannot be null
3007: PO_VAL_LINES2.amount_standard(p_id_tbl => p_lines.interface_id,
3008: p_amount_tbl => p_lines.amount,
3009: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
3010: x_results => x_results,
3011: x_result_type => l_result_type);

Line 3688: WHEN c_shipment_type_standard THEN

3684: p_shipment_type_tbl => p_line_locations.shipment_type,
3685: p_doc_type => c_doc_type_blanket,
3686: x_results => x_results,
3687: x_result_type => l_result_type);
3688: WHEN c_shipment_type_standard THEN
3689: -- validate shipment type
3690: PO_VAL_SHIPMENTS2.shipment_type(p_id_tbl => p_line_locations.interface_id,
3691: p_shipment_type_tbl => p_line_locations.shipment_type,
3692: p_doc_type => c_doc_type_standard,

Line 3692: p_doc_type => c_doc_type_standard,

3688: WHEN c_shipment_type_standard THEN
3689: -- validate shipment type
3690: PO_VAL_SHIPMENTS2.shipment_type(p_id_tbl => p_line_locations.interface_id,
3691: p_shipment_type_tbl => p_line_locations.shipment_type,
3692: p_doc_type => c_doc_type_standard,
3693: x_results => x_results,
3694: x_result_type => l_result_type);
3695: WHEN c_shipment_type_quotation THEN
3696: -- validate shipment type

Line 3775: -- If shipment_type is STANDARD and enforce_ship_to_loc_code is not equal

3771: p_qty_rcv_exception_code_tbl => p_line_locations.qty_rcv_exception_code,
3772: x_result_set_id => l_result_set_id,
3773: x_result_type => l_result_type);
3774: WHEN c_enforce_ship_to_loc_code THEN
3775: -- If shipment_type is STANDARD and enforce_ship_to_loc_code is not equal
3776: -- to NONE, REJECT or WARNING
3777: PO_VAL_SHIPMENTS2.enforce_ship_to_loc_code(p_id_tbl => p_line_locations.interface_id,
3778: p_enforce_ship_to_loc_code_tbl => p_line_locations.enforce_ship_to_location_code,
3779: p_shipment_type_tbl => p_line_locations.shipment_type,

Line 3783: -- If shipment_type is STANDARD and allow_sub_receipts_flag is not equal

3779: p_shipment_type_tbl => p_line_locations.shipment_type,
3780: x_results => x_results,
3781: x_result_type => l_result_type);
3782: WHEN c_allow_sub_receipts_flag THEN
3783: -- If shipment_type is STANDARD and allow_sub_receipts_flag is not equal
3784: -- to NONE, REJECT or WARNING
3785: PO_VAL_SHIPMENTS2.allow_sub_receipts_flag(p_id_tbl => p_line_locations.interface_id,
3786: p_shipment_type_tbl => p_line_locations.shipment_type,
3787: p_allow_sub_receipts_flag_tbl => p_line_locations.allow_substitute_receipts_flag,

Line 3791: -- If shipment_type is STANDARD and days_early_receipt_allowed is not null

3787: p_allow_sub_receipts_flag_tbl => p_line_locations.allow_substitute_receipts_flag,
3788: x_results => x_results,
3789: x_result_type => l_result_type);
3790: WHEN c_days_early_receipt_allowed THEN
3791: -- If shipment_type is STANDARD and days_early_receipt_allowed is not null
3792: -- and less than zero.
3793: PO_VAL_SHIPMENTS2.days_early_receipt_allowed(p_id_tbl => p_line_locations.interface_id,
3794: p_shipment_type_tbl => p_line_locations.shipment_type,
3795: p_days_early_rcpt_allowed_tbl => p_line_locations.days_early_receipt_allowed,

Line 3799: -- If shipment_type is STANDARD and receipt_days_expection_code is not null

3795: p_days_early_rcpt_allowed_tbl => p_line_locations.days_early_receipt_allowed,
3796: x_results => x_results,
3797: x_result_type => l_result_type);
3798: WHEN c_receipt_days_exception_code THEN
3799: -- If shipment_type is STANDARD and receipt_days_expection_code is not null
3800: -- and not 'NONE', 'REJECT' not 'WARNING'
3801: PO_VAL_SHIPMENTS2.receipt_days_exception_code(p_id_tbl => p_line_locations.interface_id,
3802: p_shipment_type_tbl => p_line_locations.shipment_type,
3803: p_rcpt_days_exception_code_tbl => p_line_locations.receipt_days_exception_code,

Line 3807: -- If shipment_type is STANDARD and invoice_close_tolerance is not null

3803: p_rcpt_days_exception_code_tbl => p_line_locations.receipt_days_exception_code,
3804: x_results => x_results,
3805: x_result_type => l_result_type);
3806: WHEN c_invoice_close_tolerance THEN
3807: -- If shipment_type is STANDARD and invoice_close_tolerance is not null
3808: -- and less than or equal to zero or greater than or equal to 100.
3809: PO_VAL_SHIPMENTS2.invoice_close_tolerance(p_id_tbl => p_line_locations.interface_id,
3810: p_shipment_type_tbl => p_line_locations.shipment_type,
3811: p_invoice_close_tolerance_tbl => p_line_locations.invoice_close_tolerance,

Line 3815: -- If shipment_type is STANDARD and receive_close_tolerance is not null

3811: p_invoice_close_tolerance_tbl => p_line_locations.invoice_close_tolerance,
3812: x_results => x_results,
3813: x_result_type => l_result_type);
3814: WHEN c_receive_close_tolerance THEN
3815: -- If shipment_type is STANDARD and receive_close_tolerance is not null
3816: -- and less than or equal to zero or greater than or equal to 100.
3817: PO_VAL_SHIPMENTS2.receive_close_tolerance(p_id_tbl => p_line_locations.interface_id,
3818: p_shipment_type_tbl => p_line_locations.shipment_type,
3819: p_receive_close_tolerance_tbl => p_line_locations.receive_close_tolerance,

Line 5515: WHEN c_doc_type_standard THEN

5511: CASE p_doc_type
5512: WHEN c_doc_type_blanket THEN
5513: l_validation_set :=
5514: l_validation_set MULTISET UNION DISTINCT c_pdoi_header_blanket_vs;
5515: WHEN c_doc_type_standard THEN
5516: l_validation_set :=
5517: l_validation_set MULTISET UNION DISTINCT c_pdoi_header_standard_vs;
5518: WHEN c_doc_type_quotation THEN
5519: l_validation_set :=

Line 5517: l_validation_set MULTISET UNION DISTINCT c_pdoi_header_standard_vs;

5513: l_validation_set :=
5514: l_validation_set MULTISET UNION DISTINCT c_pdoi_header_blanket_vs;
5515: WHEN c_doc_type_standard THEN
5516: l_validation_set :=
5517: l_validation_set MULTISET UNION DISTINCT c_pdoi_header_standard_vs;
5518: WHEN c_doc_type_quotation THEN
5519: l_validation_set :=
5520: l_validation_set MULTISET UNION DISTINCT c_pdoi_header_quotation_vs;
5521: ELSE

Line 5537: WHEN c_doc_type_standard THEN

5533: CASE p_doc_type
5534: WHEN c_doc_type_blanket THEN
5535: l_validation_set :=
5536: l_validation_set MULTISET UNION DISTINCT c_pdoi_line_blanket_vs;
5537: WHEN c_doc_type_standard THEN
5538: l_validation_set :=
5539: l_validation_set MULTISET UNION DISTINCT c_pdoi_line_standard_vs;
5540: WHEN c_doc_type_quotation THEN
5541: l_validation_set :=

Line 5539: l_validation_set MULTISET UNION DISTINCT c_pdoi_line_standard_vs;

5535: l_validation_set :=
5536: l_validation_set MULTISET UNION DISTINCT c_pdoi_line_blanket_vs;
5537: WHEN c_doc_type_standard THEN
5538: l_validation_set :=
5539: l_validation_set MULTISET UNION DISTINCT c_pdoi_line_standard_vs;
5540: WHEN c_doc_type_quotation THEN
5541: l_validation_set :=
5542: l_validation_set MULTISET UNION DISTINCT c_pdoi_line_quotation_vs;
5543: ELSE

Line 5577: WHEN c_doc_type_standard THEN

5573: CASE p_doc_type
5574: WHEN c_doc_type_blanket THEN
5575: l_validation_set :=
5576: l_validation_set MULTISET UNION DISTINCT c_pdoi_line_loc_blanket_vs;
5577: WHEN c_doc_type_standard THEN
5578: l_validation_set :=
5579: l_validation_set MULTISET UNION DISTINCT c_pdoi_line_loc_standard_vs;
5580: WHEN c_doc_type_quotation THEN
5581: l_validation_set :=

Line 5579: l_validation_set MULTISET UNION DISTINCT c_pdoi_line_loc_standard_vs;

5575: l_validation_set :=
5576: l_validation_set MULTISET UNION DISTINCT c_pdoi_line_loc_blanket_vs;
5577: WHEN c_doc_type_standard THEN
5578: l_validation_set :=
5579: l_validation_set MULTISET UNION DISTINCT c_pdoi_line_loc_standard_vs;
5580: WHEN c_doc_type_quotation THEN
5581: l_validation_set :=
5582: l_validation_set MULTISET UNION DISTINCT c_pdoi_line_loc_quotation_vs;
5583: ELSE