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

Line 130: RETURN PO_TBL_VARCHAR30;

126: -- Private Functions/Procedures
127: -------------------------------------------------------------------------------
128: FUNCTION get_item_secondary_uom(p_item_id_tbl IN po_tbl_number,
129: p_organization_id_tbl IN po_tbl_number)
130: RETURN PO_TBL_VARCHAR30;
131:
132: -------------------------------------------------------------------------------
133: --Start of Comments
134: --Pre-reqs: None.

Line 1091: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30

1087: PROCEDURE gt_zero_order_type_filter(
1088: p_calling_module IN VARCHAR2
1089: , p_value_tbl IN PO_TBL_NUMBER
1090: , p_entity_id_tbl IN PO_TBL_NUMBER
1091: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
1092: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1
1093: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30
1094: , p_check_quantity_types_flag IN VARCHAR2
1095: , p_entity_type IN VARCHAR2

Line 1093: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30

1089: , p_value_tbl IN PO_TBL_NUMBER
1090: , p_entity_id_tbl IN PO_TBL_NUMBER
1091: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
1092: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1
1093: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30
1094: , p_check_quantity_types_flag IN VARCHAR2
1095: , p_entity_type IN VARCHAR2
1096: , p_column_name IN VARCHAR2
1097: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 1235: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30

1231: PROCEDURE gt_zero_order_type_filter(
1232: p_calling_module IN VARCHAR2
1233: , p_value_tbl IN PO_TBL_NUMBER
1234: , p_entity_id_tbl IN PO_TBL_NUMBER
1235: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
1236: , p_check_quantity_types_flag IN VARCHAR2
1237: , p_entity_type IN VARCHAR2
1238: , p_column_name IN VARCHAR2
1239: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 1686: , p_entity_type_tbl IN PO_TBL_VARCHAR30 DEFAULT NULL --

1682: , p_par_draft_id_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL --
1683: , p_draft_id_tbl IN PO_TBL_NUMBER
1684: , x_result_set_id IN OUT NOCOPY NUMBER
1685: , x_result_type OUT NOCOPY VARCHAR2
1686: , p_entity_type_tbl IN PO_TBL_VARCHAR30 DEFAULT NULL --
1687: )
1688: IS
1689: d_mod CONSTANT VARCHAR2(100) := D_child_num_unique;
1690:

Line 1981: , p_entity_type_tbl IN PO_TBL_VARCHAR30

1977: PROCEDURE price_diff_value_unique(
1978: p_calling_module IN VARCHAR2
1979: , p_price_diff_id_tbl IN PO_TBL_NUMBER
1980: , p_entity_id_tbl IN PO_TBL_NUMBER
1981: , p_entity_type_tbl IN PO_TBL_VARCHAR30
1982: , p_unique_value_tbl IN PO_TBL_VARCHAR4000
1983: , p_column_name IN VARCHAR2
1984: , p_message_name IN VARCHAR2
1985: , x_result_set_id IN OUT NOCOPY NUMBER

Line 2722: , p_primary_uom_tbl IN PO_TBL_VARCHAR30

2718: , p_entity_id_tbl IN PO_TBL_NUMBER
2719: , p_item_id_tbl IN PO_TBL_NUMBER
2720: , p_inv_org_id_tbl IN PO_TBL_NUMBER
2721: , p_quantity_tbl IN PO_TBL_NUMBER
2722: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
2723: , p_sec_quantity_tbl IN PO_TBL_NUMBER
2724: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30
2725: , p_column_name IN VARCHAR2
2726: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 2724: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30

2720: , p_inv_org_id_tbl IN PO_TBL_NUMBER
2721: , p_quantity_tbl IN PO_TBL_NUMBER
2722: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
2723: , p_sec_quantity_tbl IN PO_TBL_NUMBER
2724: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30
2725: , p_column_name IN VARCHAR2
2726: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2727: , x_result_type OUT NOCOPY VARCHAR2
2728: )

Line 2845: p_secondary_unit_of_meas_tbl IN po_tbl_varchar30,

2841: --------------------------------------------------------------------------------------------
2842: PROCEDURE secondary_unit_of_measure(
2843: p_id_tbl IN po_tbl_number,
2844: p_entity_type IN VARCHAR2,
2845: p_secondary_unit_of_meas_tbl IN po_tbl_varchar30,
2846: p_item_id_tbl IN po_tbl_number,
2847: p_item_tbl IN po_tbl_varchar2000,
2848: p_organization_id_tbl IN po_tbl_number,
2849: p_doc_type IN VARCHAR2,

Line 2856: l_secondary_unit_of_meas_tbl PO_TBL_VARCHAR30 := PO_TBL_VARCHAR30();

2852: x_result_type OUT NOCOPY VARCHAR2)
2853: IS
2854:
2855: d_mod CONSTANT VARCHAR2(100) := d_secondary_unit_of_measure;
2856: l_secondary_unit_of_meas_tbl PO_TBL_VARCHAR30 := PO_TBL_VARCHAR30();
2857: l_validation_id NUMBER;
2858:
2859: BEGIN
2860:

Line 2981: p_order_type_lookup_code_tbl IN po_tbl_varchar30,

2977: PROCEDURE secondary_quantity(
2978: p_id_tbl IN po_tbl_number,
2979: p_entity_type IN VARCHAR2,
2980: p_secondary_quantity_tbl IN po_tbl_number,
2981: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2982: p_item_id_tbl IN po_tbl_number,
2983: p_item_tbl IN po_tbl_varchar2000,
2984: p_organization_id_tbl IN po_tbl_number,
2985: p_doc_type IN VARCHAR2,

Line 2992: l_secondary_unit_of_meas_tbl PO_TBL_VARCHAR30 := PO_TBL_VARCHAR30();

2988: x_result_type OUT NOCOPY VARCHAR2)
2989: IS
2990:
2991: d_mod CONSTANT VARCHAR2(100) := d_secondary_quantity;
2992: l_secondary_unit_of_meas_tbl PO_TBL_VARCHAR30 := PO_TBL_VARCHAR30();
2993: l_validation_id NUMBER;
2994: d_position NUMBER := 0;
2995:
2996: BEGIN

Line 3172: p_secondary_unit_of_meas_tbl IN po_tbl_varchar30,

3168: --------------------------------------------------------------------------------------------
3169: PROCEDURE secondary_uom_update(
3170: p_id_tbl IN po_tbl_number,
3171: p_entity_type IN VARCHAR2,
3172: p_secondary_unit_of_meas_tbl IN po_tbl_varchar30,
3173: p_item_id_tbl IN po_tbl_number,
3174: p_organization_id_tbl IN po_tbl_number,
3175: p_create_or_update_item_flag IN VARCHAR2,
3176: x_result_set_id IN OUT NOCOPY NUMBER,

Line 3482: RETURN PO_TBL_VARCHAR30

3478: --------------------------------------------------------------------------------------------
3479: FUNCTION get_item_secondary_uom(
3480: p_item_id_tbl IN po_tbl_number,
3481: p_organization_id_tbl IN po_tbl_number)
3482: RETURN PO_TBL_VARCHAR30
3483: IS
3484:
3485: d_mod CONSTANT VARCHAR2(100) := d_get_item_secondary_uom;
3486: l_secondary_unit_of_meas_tbl PO_TBL_VARCHAR30 := PO_TBL_VARCHAR30();

Line 3486: l_secondary_unit_of_meas_tbl PO_TBL_VARCHAR30 := PO_TBL_VARCHAR30();

3482: RETURN PO_TBL_VARCHAR30
3483: IS
3484:
3485: d_mod CONSTANT VARCHAR2(100) := d_get_item_secondary_uom;
3486: l_secondary_unit_of_meas_tbl PO_TBL_VARCHAR30 := PO_TBL_VARCHAR30();
3487:
3488: -- key value used to identify rows in po_session_gt table
3489: l_key po_session_gt.key%TYPE;
3490: l_index_tbl DBMS_SQL.NUMBER_TABLE;

Line 3492: l_result1_tbl PO_TBL_VARCHAR30;

3488: -- key value used to identify rows in po_session_gt table
3489: l_key po_session_gt.key%TYPE;
3490: l_index_tbl DBMS_SQL.NUMBER_TABLE;
3491: l_index1_tbl PO_TBL_NUMBER;
3492: l_result1_tbl PO_TBL_VARCHAR30;
3493:
3494: BEGIN
3495:
3496: IF PO_LOG.d_proc THEN