41: -------------------------------------------------------------------------
42: PROCEDURE need_by_date(
43: p_id_tbl IN po_tbl_number,
44: p_purchase_basis_tbl IN po_tbl_varchar30,
45: p_need_by_date_tbl IN po_tbl_date,
46: x_results IN OUT NOCOPY po_validation_results_type,
47: x_result_type OUT NOCOPY VARCHAR2)
48: IS
49: d_mod CONSTANT VARCHAR2(100) := d_need_by_date;
92: -------------------------------------------------------------------------
93: PROCEDURE promised_date(
94: p_id_tbl IN po_tbl_number,
95: p_purchase_basis_tbl IN po_tbl_varchar30,
96: p_promised_date_tbl IN po_tbl_date,
97: x_results IN OUT NOCOPY po_validation_results_type,
98: x_result_type OUT NOCOPY VARCHAR2)
99: IS
100: d_mod CONSTANT VARCHAR2(100) := d_promised_date;
739: -- validate price break attributes
740: -------------------------------------------------------------------------
741: PROCEDURE price_break_attributes(
742: p_id_tbl IN po_tbl_number,
743: p_from_date_tbl IN po_tbl_date,
744: p_to_date_tbl IN po_tbl_date,
745: p_quantity_tbl IN po_tbl_number,
746: p_ship_to_org_id_tbl IN po_tbl_number,
747: p_ship_to_location_id_tbl IN po_tbl_number,
740: -------------------------------------------------------------------------
741: PROCEDURE price_break_attributes(
742: p_id_tbl IN po_tbl_number,
743: p_from_date_tbl IN po_tbl_date,
744: p_to_date_tbl IN po_tbl_date,
745: p_quantity_tbl IN po_tbl_number,
746: p_ship_to_org_id_tbl IN po_tbl_number,
747: p_ship_to_location_id_tbl IN po_tbl_number,
748: x_results IN OUT NOCOPY po_validation_results_type,
798: -- validate_effective_dates
799: -------------------------------------------------------------------------
800: PROCEDURE effective_dates(
801: p_id_tbl IN po_tbl_number,
802: p_line_expiration_date_tbl IN po_tbl_date,
803: p_to_date_tbl IN po_tbl_date,
804: p_from_date_tbl IN po_tbl_date,
805: p_header_start_date_tbl IN po_tbl_date,
806: p_header_end_date_tbl IN po_tbl_date,
799: -------------------------------------------------------------------------
800: PROCEDURE effective_dates(
801: p_id_tbl IN po_tbl_number,
802: p_line_expiration_date_tbl IN po_tbl_date,
803: p_to_date_tbl IN po_tbl_date,
804: p_from_date_tbl IN po_tbl_date,
805: p_header_start_date_tbl IN po_tbl_date,
806: p_header_end_date_tbl IN po_tbl_date,
807: p_price_break_lookup_code_tbl IN PO_TBL_VARCHAR30, -- bug5016163
800: PROCEDURE effective_dates(
801: p_id_tbl IN po_tbl_number,
802: p_line_expiration_date_tbl IN po_tbl_date,
803: p_to_date_tbl IN po_tbl_date,
804: p_from_date_tbl IN po_tbl_date,
805: p_header_start_date_tbl IN po_tbl_date,
806: p_header_end_date_tbl IN po_tbl_date,
807: p_price_break_lookup_code_tbl IN PO_TBL_VARCHAR30, -- bug5016163
808: x_results IN OUT NOCOPY po_validation_results_type,
801: p_id_tbl IN po_tbl_number,
802: p_line_expiration_date_tbl IN po_tbl_date,
803: p_to_date_tbl IN po_tbl_date,
804: p_from_date_tbl IN po_tbl_date,
805: p_header_start_date_tbl IN po_tbl_date,
806: p_header_end_date_tbl IN po_tbl_date,
807: p_price_break_lookup_code_tbl IN PO_TBL_VARCHAR30, -- bug5016163
808: x_results IN OUT NOCOPY po_validation_results_type,
809: x_result_type OUT NOCOPY VARCHAR2)
802: p_line_expiration_date_tbl IN po_tbl_date,
803: p_to_date_tbl IN po_tbl_date,
804: p_from_date_tbl IN po_tbl_date,
805: p_header_start_date_tbl IN po_tbl_date,
806: p_header_end_date_tbl IN po_tbl_date,
807: p_price_break_lookup_code_tbl IN PO_TBL_VARCHAR30, -- bug5016163
808: x_results IN OUT NOCOPY po_validation_results_type,
809: x_result_type OUT NOCOPY VARCHAR2)
810: IS
1569: PROCEDURE tax_name(
1570: p_id_tbl IN po_tbl_number,
1571: p_tax_name_tbl IN po_tbl_varchar30,
1572: p_tax_code_id_tbl IN po_tbl_number,
1573: p_need_by_date_tbl IN po_tbl_date,
1574: p_allow_tax_code_override IN VARCHAR2,
1575: p_operating_unit IN NUMBER,
1576: x_result_set_id IN OUT NOCOPY NUMBER,
1577: x_result_type OUT NOCOPY VARCHAR2)