[Home] [Help]
441: p_dest_type_code_tbl IN po_tbl_varchar30,
442: p_ship_to_org_id_tbl IN po_tbl_number,
443: p_item_id_tbl IN po_tbl_number,
444: p_txn_flow_header_id_tbl IN po_tbl_number,
445: p_accrue_on_receipt_flag_tbl IN po_tbl_varchar1,
446: p_value_basis_tbl IN po_tbl_varchar30,
447: p_purchase_basis_tbl IN po_tbl_varchar30, --bug 7644072
448: p_expense_accrual_code IN po_system_parameters.expense_accrual_code%TYPE,
449: p_loc_outsourced_assembly_tbl IN po_tbl_number,
460: l_num_list_tbl DBMS_SQL.NUMBER_TABLE;
461:
462: -- tables to store the derived result
463: l_index_tbl PO_TBL_NUMBER;
464: l_result_tbl PO_TBL_VARCHAR1;
465: l_item_status_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
466:
467: BEGIN
468:
461:
462: -- tables to store the derived result
463: l_index_tbl PO_TBL_NUMBER;
464: l_result_tbl PO_TBL_VARCHAR1;
465: l_item_status_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
466:
467: BEGIN
468:
469: d_position := 0;
953: -- For other destination type, the value has to be 'N'.
954: -----------------------------------------------------------
955: PROCEDURE prevent_encumbrance_flag(
956: p_id_tbl IN po_tbl_number,
957: p_prevent_encum_flag_tbl IN po_tbl_varchar1,
958: p_dest_type_code_tbl IN po_tbl_varchar30,
959: p_distribution_type_tbl IN po_tbl_varchar30, -- PDOI for Complex PO Project
960: p_wip_entity_id_tbl IN po_tbl_number,
961: x_results IN OUT NOCOPY po_validation_results_type,
1487: -- If tax_recovery_override_flag is 'Y' and
1488: -- p_allow_tax_rate_override is not 'Y', throw an error
1489: -----------------------------------------------------------
1490: PROCEDURE tax_recovery_override_flag(p_id_tbl IN po_tbl_number,
1491: p_recovery_override_flag_tbl IN po_tbl_varchar1,
1492: p_allow_tax_rate_override IN VARCHAR2,
1493: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
1494: x_result_type OUT NOCOPY VARCHAR2)
1495: IS
1636: -- need to be thrown. But the tax amount is not yet calculated, this
1637: -- validation will be done in Post Processing.
1638: --------------------------------------------------------------------------
1639: PROCEDURE partial_funded_flag(p_id_tbl IN po_tbl_number,
1640: p_partial_funded_flag_tbl IN po_tbl_varchar1,
1641: p_funded_value_tbl IN po_tbl_number,
1642: p_style_id_tbl IN po_tbl_number,
1643: p_po_encumberance_flag IN VARCHAR2,
1644: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,