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 120: RETURN PO_TBL_VARCHAR30;

116: -- Private Functions/Procedures
117: -------------------------------------------------------------------------------
118: FUNCTION get_item_secondary_uom(p_item_id_tbl IN po_tbl_number,
119: p_organization_id_tbl IN po_tbl_number)
120: RETURN PO_TBL_VARCHAR30;
121:
122: -------------------------------------------------------------------------------
123: --Start of Comments
124: --Pre-reqs: None.

Line 1081: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30

1077: PROCEDURE gt_zero_order_type_filter(
1078: p_calling_module IN VARCHAR2
1079: , p_value_tbl IN PO_TBL_NUMBER
1080: , p_entity_id_tbl IN PO_TBL_NUMBER
1081: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
1082: , p_check_quantity_types_flag IN VARCHAR2
1083: , p_entity_type IN VARCHAR2
1084: , p_column_name IN VARCHAR2
1085: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 1530: , p_entity_type_tbl IN PO_TBL_VARCHAR30 DEFAULT NULL --

1526: , p_parent_id_tbl IN PO_TBL_NUMBER
1527: , p_entity_num_tbl IN PO_TBL_NUMBER
1528: , x_result_set_id IN OUT NOCOPY NUMBER
1529: , x_result_type OUT NOCOPY VARCHAR2
1530: , p_entity_type_tbl IN PO_TBL_VARCHAR30 DEFAULT NULL --
1531: )
1532: IS
1533: d_mod CONSTANT VARCHAR2(100) := D_child_num_unique;
1534:

Line 1796: , p_entity_type_tbl IN PO_TBL_VARCHAR30

1792: PROCEDURE price_diff_value_unique(
1793: p_calling_module IN VARCHAR2
1794: , p_price_diff_id_tbl IN PO_TBL_NUMBER
1795: , p_entity_id_tbl IN PO_TBL_NUMBER
1796: , p_entity_type_tbl IN PO_TBL_VARCHAR30
1797: , p_unique_value_tbl IN PO_TBL_VARCHAR4000
1798: , p_column_name IN VARCHAR2
1799: , p_message_name IN VARCHAR2
1800: , x_result_set_id IN OUT NOCOPY NUMBER

Line 2537: , p_primary_uom_tbl IN PO_TBL_VARCHAR30

2533: , p_entity_id_tbl IN PO_TBL_NUMBER
2534: , p_item_id_tbl IN PO_TBL_NUMBER
2535: , p_inv_org_id_tbl IN PO_TBL_NUMBER
2536: , p_quantity_tbl IN PO_TBL_NUMBER
2537: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
2538: , p_sec_quantity_tbl IN PO_TBL_NUMBER
2539: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30
2540: , p_column_name IN VARCHAR2
2541: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 2539: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30

2535: , p_inv_org_id_tbl IN PO_TBL_NUMBER
2536: , p_quantity_tbl IN PO_TBL_NUMBER
2537: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
2538: , p_sec_quantity_tbl IN PO_TBL_NUMBER
2539: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30
2540: , p_column_name IN VARCHAR2
2541: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2542: , x_result_type OUT NOCOPY VARCHAR2
2543: )

Line 2658: p_secondary_unit_of_meas_tbl IN po_tbl_varchar30,

2654: --------------------------------------------------------------------------------------------
2655: PROCEDURE secondary_unit_of_measure(
2656: p_id_tbl IN po_tbl_number,
2657: p_entity_type IN VARCHAR2,
2658: p_secondary_unit_of_meas_tbl IN po_tbl_varchar30,
2659: p_item_id_tbl IN po_tbl_number,
2660: p_item_tbl IN po_tbl_varchar2000,
2661: p_organization_id_tbl IN po_tbl_number,
2662: p_doc_type IN VARCHAR2,

Line 2669: l_secondary_unit_of_meas_tbl PO_TBL_VARCHAR30 := PO_TBL_VARCHAR30();

2665: x_result_type OUT NOCOPY VARCHAR2)
2666: IS
2667:
2668: d_mod CONSTANT VARCHAR2(100) := d_secondary_unit_of_measure;
2669: l_secondary_unit_of_meas_tbl PO_TBL_VARCHAR30 := PO_TBL_VARCHAR30();
2670: l_validation_id NUMBER;
2671:
2672: BEGIN
2673:

Line 2794: p_order_type_lookup_code_tbl IN po_tbl_varchar30,

2790: PROCEDURE secondary_quantity(
2791: p_id_tbl IN po_tbl_number,
2792: p_entity_type IN VARCHAR2,
2793: p_secondary_quantity_tbl IN po_tbl_number,
2794: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2795: p_item_id_tbl IN po_tbl_number,
2796: p_item_tbl IN po_tbl_varchar2000,
2797: p_organization_id_tbl IN po_tbl_number,
2798: p_doc_type IN VARCHAR2,

Line 2805: l_secondary_unit_of_meas_tbl PO_TBL_VARCHAR30 := PO_TBL_VARCHAR30();

2801: x_result_type OUT NOCOPY VARCHAR2)
2802: IS
2803:
2804: d_mod CONSTANT VARCHAR2(100) := d_secondary_quantity;
2805: l_secondary_unit_of_meas_tbl PO_TBL_VARCHAR30 := PO_TBL_VARCHAR30();
2806: l_validation_id NUMBER;
2807: d_position NUMBER := 0;
2808:
2809: BEGIN

Line 2985: p_secondary_unit_of_meas_tbl IN po_tbl_varchar30,

2981: --------------------------------------------------------------------------------------------
2982: PROCEDURE secondary_uom_update(
2983: p_id_tbl IN po_tbl_number,
2984: p_entity_type IN VARCHAR2,
2985: p_secondary_unit_of_meas_tbl IN po_tbl_varchar30,
2986: p_item_id_tbl IN po_tbl_number,
2987: p_organization_id_tbl IN po_tbl_number,
2988: p_create_or_update_item_flag IN VARCHAR2,
2989: x_result_set_id IN OUT NOCOPY NUMBER,

Line 3295: RETURN PO_TBL_VARCHAR30

3291: --------------------------------------------------------------------------------------------
3292: FUNCTION get_item_secondary_uom(
3293: p_item_id_tbl IN po_tbl_number,
3294: p_organization_id_tbl IN po_tbl_number)
3295: RETURN PO_TBL_VARCHAR30
3296: IS
3297:
3298: d_mod CONSTANT VARCHAR2(100) := d_get_item_secondary_uom;
3299: l_secondary_unit_of_meas_tbl PO_TBL_VARCHAR30 := PO_TBL_VARCHAR30();

Line 3299: l_secondary_unit_of_meas_tbl PO_TBL_VARCHAR30 := PO_TBL_VARCHAR30();

3295: RETURN PO_TBL_VARCHAR30
3296: IS
3297:
3298: d_mod CONSTANT VARCHAR2(100) := d_get_item_secondary_uom;
3299: l_secondary_unit_of_meas_tbl PO_TBL_VARCHAR30 := PO_TBL_VARCHAR30();
3300:
3301: -- key value used to identify rows in po_session_gt table
3302: l_key po_session_gt.key%TYPE;
3303: l_index_tbl DBMS_SQL.NUMBER_TABLE;

Line 3305: l_result1_tbl PO_TBL_VARCHAR30;

3301: -- key value used to identify rows in po_session_gt table
3302: l_key po_session_gt.key%TYPE;
3303: l_index_tbl DBMS_SQL.NUMBER_TABLE;
3304: l_index1_tbl PO_TBL_NUMBER;
3305: l_result1_tbl PO_TBL_VARCHAR30;
3306:
3307: BEGIN
3308:
3309: IF PO_LOG.d_proc THEN

Line 3393: p_attribute_category_tbl IN PO_TBL_VARCHAR30,

3389: PROCEDURE validate_desc_flex (
3390: p_calling_module IN VARCHAR2,
3391: p_id_tbl IN po_tbl_number,
3392: p_desc_flex_name IN fnd_descr_flex_column_usages.descriptive_flexfield_name%TYPE,
3393: p_attribute_category_tbl IN PO_TBL_VARCHAR30,
3394: p_attribute1_tbl IN PO_TBL_VARCHAR2000,
3395: p_attribute2_tbl IN PO_TBL_VARCHAR2000,
3396: p_attribute3_tbl IN PO_TBL_VARCHAR2000,
3397: p_attribute4_tbl IN PO_TBL_VARCHAR2000,