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_VAL_LINES dependencies on PO_TBL_VARCHAR30

Line 335: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30

331: -----------------------------------------------------------------------------
332: PROCEDURE quantity_gt_zero(
333: p_line_id_tbl IN PO_TBL_NUMBER
334: , p_quantity_tbl IN PO_TBL_NUMBER
335: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
336: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
337: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30 -- CLM changes
338: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
339: , x_result_type OUT NOCOPY VARCHAR2

Line 337: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30 -- CLM changes

333: p_line_id_tbl IN PO_TBL_NUMBER
334: , p_quantity_tbl IN PO_TBL_NUMBER
335: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
336: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
337: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30 -- CLM changes
338: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
339: , x_result_type OUT NOCOPY VARCHAR2
340: , p_header_id_tbl IN PO_TBL_NUMBER --
341: )

Line 796: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30

792: -----------------------------------------------------------------------------
793: PROCEDURE amount_gt_zero(
794: p_line_id_tbl IN PO_TBL_NUMBER
795: , p_amount_tbl IN PO_TBL_NUMBER
796: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
797: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
798: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30 -- CLM changes
799: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
800: , x_result_type OUT NOCOPY VARCHAR2

Line 798: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30 -- CLM changes

794: p_line_id_tbl IN PO_TBL_NUMBER
795: , p_amount_tbl IN PO_TBL_NUMBER
796: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
797: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
798: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30 -- CLM changes
799: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
800: , x_result_type OUT NOCOPY VARCHAR2
801: , p_header_id_tbl IN PO_TBL_NUMBER --
802: )

Line 839: , p_currency_code_tbl IN PO_TBL_VARCHAR30

835: -----------------------------------------------------------------------------
836: PROCEDURE amount_ge_amount_exec(
837: p_line_id_tbl IN PO_TBL_NUMBER
838: , p_amount_tbl IN PO_TBL_NUMBER
839: , p_currency_code_tbl IN PO_TBL_VARCHAR30
840: , x_result_set_id IN OUT NOCOPY NUMBER
841: , x_result_type OUT NOCOPY VARCHAR2
842: )
843: IS

Line 1223: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30

1219: -- Where clauses derived from L_ITEM_CSR in PO_AUTOSOURCE_SV.get_asl_info
1220: ------------------------------------------------------------------------
1221: PROCEDURE vmi_asl_exists(
1222: p_line_id_tbl IN PO_TBL_NUMBER
1223: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
1224: , p_item_id_tbl IN PO_TBL_NUMBER
1225: , p_org_id_tbl IN PO_TBL_NUMBER
1226: , p_vendor_id_tbl IN PO_TBL_NUMBER
1227: , p_vendor_site_id_tbl IN PO_TBL_NUMBER

Line 2026: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30

2022: -----------------------------------------------------------------------------
2023: PROCEDURE unit_price_ge_zero(
2024: p_line_id_tbl IN PO_TBL_NUMBER
2025: , p_unit_price_tbl IN PO_TBL_NUMBER
2026: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
2027: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
2028: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2029: , x_result_type OUT NOCOPY VARCHAR2
2030: )

Line 2155: , p_price_break_lookup_code_tbl IN PO_TBL_VARCHAR30

2151: -----------------------------------------------------------------------------
2152: PROCEDURE validate_unit_price_change(
2153: p_line_id_tbl IN PO_TBL_NUMBER
2154: , p_unit_price_tbl IN PO_TBL_NUMBER
2155: , p_price_break_lookup_code_tbl IN PO_TBL_VARCHAR30
2156: , p_amt_changed_flag_tbl IN PO_TBL_VARCHAR1
2157: , x_result_set_id IN OUT NOCOPY NUMBER
2158: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2159: , x_result_type OUT NOCOPY VARCHAR2

Line 2166: l_price_break_lookup_code_tbl PO_TBL_VARCHAR30;

2162: d_mod CONSTANT VARCHAR2(100) := D_validate_unit_price_change;
2163:
2164: l_data_key NUMBER;
2165: l_line_id_tbl PO_TBL_NUMBER;
2166: l_price_break_lookup_code_tbl PO_TBL_VARCHAR30;
2167: l_amount_changed_flag_tbl PO_TBL_VARCHAR1; -- --
2168:
2169: BEGIN
2170:

Line 2587: , p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30

2583: -- Ensures that the Unit of Measure is not null for non-FIXED PRICE lines.
2584: -------------------------------------------------------------------------------
2585: PROCEDURE unit_meas_not_null(
2586: p_line_id_tbl IN PO_TBL_NUMBER
2587: , p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30
2588: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
2589: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
2590: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2591: , x_result_type OUT NOCOPY VARCHAR2

Line 2588: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30

2584: -------------------------------------------------------------------------------
2585: PROCEDURE unit_meas_not_null(
2586: p_line_id_tbl IN PO_TBL_NUMBER
2587: , p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30
2588: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
2589: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
2590: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2591: , x_result_type OUT NOCOPY VARCHAR2
2592: )

Line 2735: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30

2731: ---------------------------------------------------------------------------
2732: PROCEDURE item_id_not_null(
2733: p_id_tbl IN PO_TBL_NUMBER
2734: , p_item_id_tbl IN PO_TBL_NUMBER
2735: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
2736: , p_line_type_id_tbl IN PO_TBL_NUMBER
2737: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
2738: , p_message_name IN VARCHAR2
2739: , x_result_set_id IN OUT NOCOPY NUMBER

Line 2847: , p_purchase_basis_tbl IN PO_TBL_VARCHAR30

2843: -------------------------------------------------------------------------------
2844: PROCEDURE temp_labor_job_id_not_null(
2845: p_line_id_tbl IN PO_TBL_NUMBER
2846: , p_job_id_tbl IN PO_TBL_NUMBER
2847: , p_purchase_basis_tbl IN PO_TBL_VARCHAR30
2848: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2849: , x_result_type OUT NOCOPY VARCHAR2
2850: )
2851: IS

Line 3031: , p_purchase_basis_tbl IN PO_TBL_VARCHAR30

3027: -------------------------------------------------------------------------------
3028: PROCEDURE temp_lbr_start_date_not_null(
3029: p_line_id_tbl IN PO_TBL_NUMBER
3030: , p_start_date_tbl IN PO_TBL_DATE
3031: , p_purchase_basis_tbl IN PO_TBL_VARCHAR30
3032: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
3033: , x_result_type OUT NOCOPY VARCHAR2
3034: )
3035: IS

Line 3158: , p_primary_uom_tbl IN PO_TBL_VARCHAR30

3154: PROCEDURE line_qtys_within_deviation (
3155: p_line_id_tbl IN PO_TBL_NUMBER
3156: , p_item_id_tbl IN PO_TBL_NUMBER
3157: , p_quantity_tbl IN PO_TBL_NUMBER
3158: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
3159: , p_sec_quantity_tbl IN PO_TBL_NUMBER
3160: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30
3161: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
3162: , x_result_type OUT NOCOPY VARCHAR2

Line 3160: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30

3156: , p_item_id_tbl IN PO_TBL_NUMBER
3157: , p_quantity_tbl IN PO_TBL_NUMBER
3158: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
3159: , p_sec_quantity_tbl IN PO_TBL_NUMBER
3160: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30
3161: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
3162: , x_result_type OUT NOCOPY VARCHAR2
3163: )
3164: IS

Line 3866: ,p_control_action_tbl IN PO_TBL_VARCHAR30

3862: END line_num_disp_check;
3863:
3864: PROCEDURE mod_no_cancel_shp_complt(
3865: p_line_id_tbl IN PO_TBL_NUMBER
3866: ,p_control_action_tbl IN PO_TBL_VARCHAR30
3867: ,x_result_set_id IN OUT NOCOPY NUMBER
3868: ,x_result_type OUT NOCOPY VARCHAR2
3869: )
3870: IS

Line 4194: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30

4190:
4191:
4192: PROCEDURE validate_contract_type(
4193: p_intf_line_id_tbl IN PO_TBL_NUMBER
4194: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
4195: , p_contract_type_tbl IN PO_TBL_VARCHAR240
4196: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
4197: , x_result_type OUT NOCOPY VARCHAR2
4198: ) IS

Line 4283: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30

4279:
4280:
4281: PROCEDURE validate_cost_constraint(
4282: p_intf_line_id_tbl IN PO_TBL_NUMBER
4283: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30
4284: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
4285: , x_result_type OUT NOCOPY VARCHAR2
4286: ) IS
4287:

Line 5050: , p_draft_type_tbl IN PO_TBL_VARCHAR30

5046: ------------------------------------------------------------------------
5047: PROCEDURE validate_comments_not_null(
5048: p_line_id_tbl IN PO_TBL_NUMBER
5049: , p_draft_id_tbl IN PO_TBL_NUMBER
5050: , p_draft_type_tbl IN PO_TBL_VARCHAR30
5051: , p_comments_tbl IN PO_TBL_VARCHAR2000
5052: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
5053: , x_result_type OUT NOCOPY VARCHAR2
5054: )

Line 5191: p_order_type_lookup_code IN PO_TBL_VARCHAR30,

5187: END validate_exhibit_name;
5188: -- bug 16461105
5189: PROCEDURE validate_undef_amt_le_line_amt(
5190: p_po_line_id IN PO_TBL_NUMBER,
5191: p_order_type_lookup_code IN PO_TBL_VARCHAR30,
5192: p_unit_price IN PO_TBL_NUMBER,
5193: p_quantity IN PO_TBL_NUMBER,
5194: p_old_quantity IN PO_TBL_NUMBER,
5195: p_old_unit_price IN PO_TBL_NUMBER,