[Home] [Help]
629: -- PBWC Message Change Impact: Adding a token
630: , p_token1_name
631: , to_char(p_token1_value(i))
632: FROM
633: DUAL
634: WHERE NOT EXISTS
635: ( SELECT null
636: FROM
637: GL_PERIOD_STATUSES PO_PERIOD
1678: -- Merge in the new data.
1679:
1680: FORALL i IN 1 .. p_entity_id_tbl.COUNT
1681: MERGE INTO PO_SESSION_GT SES
1682: USING DUAL
1683: ON
1684: ( SES.key = l_data_key
1685: AND SES.index_num2 = p_entity_id_tbl(i)
1686: )
1871: -- Merge in the new data.
1872:
1873: FORALL i IN 1 .. p_price_diff_id_tbl.COUNT
1874: MERGE INTO PO_SESSION_GT SES
1875: USING DUAL
1876: ON
1877: ( SES.key = l_data_key
1878: AND SES.index_num2 = p_price_diff_id_tbl(i)
1879: )
2317: p_terms_id_tbl(i),
2318: 'VALUE',
2319: p_terms_id_tbl(i),
2320: p_validation_id
2321: FROM DUAL
2322: WHERE p_terms_id_tbl(i) IS NOT NULL
2323: AND NOT EXISTS
2324: (SELECT 1
2325: FROM AP_TERMS APT
2359: --Locks: None.
2360: --Function:
2361: -- Checks that each value is greater than zero and not null,
2362: -- and adds an error to x_results if it is not.
2363: -- The check is only performed for opm dual uom items
2364: --Parameters:
2365: --IN:
2366: --p_calling_module
2367: -- The module base of the calling procedure, used for logging.
2514: -- primary uom
2515: --p_secondary_uom_tbl
2516: -- Secondary uom
2517: --p_sec_default_ind_tbl
2518: -- Determines if the item is opm dual uom contrilled item
2519: --p_column_name
2520: --IN OUT:
2521: --x_results
2522: -- Validation errors will be added to this object.
2594:
2595: IF l_sec_default_ind IS NOT NULL AND p_quantity_tbl(i) IS NOT NULL AND
2596: p_sec_quantity_tbl(i) IS NOT NULL
2597: THEN
2598: -- Call the INV API to validate dual quantities
2599: PO_INV_INTEGRATION_GRP.within_deviation(
2600: p_api_version => 1.0,
2601: p_organization_id => p_inv_org_id_tbl(i),
2602: p_item_id => p_item_id_tbl(i),
2715: END IF;
2716:
2717: IF l_secondary_unit_of_meas_tbl(i) IS NULL THEN
2718: IF (p_secondary_unit_of_meas_tbl(i) IS NOT NULL) THEN
2719: -- Item is not dual control
2720: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
2721: l_validation_id := PO_VAL_CONSTANTS.c_line_secondary_uom_null;
2722: ELSE
2723: l_validation_id := PO_VAL_CONSTANTS.c_loc_secondary_uom_null;
2731: x_result_type := po_validations.c_result_type_failure;
2732: END IF;
2733: ELSE -- l_secondary_unit_of_measure is not null
2734: IF p_secondary_unit_of_meas_tbl(i) IS NULL THEN
2735: -- Secondary UOM missing for dual control item
2736: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
2737: l_validation_id := PO_VAL_CONSTANTS.c_line_secondary_uom_not_null;
2738: ELSE
2739: l_validation_id := PO_VAL_CONSTANTS.c_loc_secondary_uom_not_null;
2918:
2919: d_position := 60;
2920:
2921: IF p_secondary_quantity_tbl(i) IS NOT NULL AND p_doc_type IN ('STANDARD', 'BLANKET') THEN
2922: -- Item is not dual control
2923: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
2924: l_validation_id := PO_VAL_CONSTANTS.c_line_sec_quantity_no_req_uom;
2925: ELSE
2926: l_validation_id := PO_VAL_CONSTANTS.c_loc_sec_quantity_not_req_uom;
2937:
2938: d_position := 70;
2939:
2940: IF p_secondary_quantity_tbl(i) IS NULL AND p_doc_type='STANDARD' THEN
2941: -- Secondary Quantity missing for dual control item
2942: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
2943: l_validation_id := PO_VAL_CONSTANTS.c_line_sec_quantity_req_uom;
2944: ELSE
2945: l_validation_id := PO_VAL_CONSTANTS.c_loc_sec_quantity_req_uom;
3033: 'ITEM',
3034: 'SECONDARY_UNIT_OF_MEASURE',
3035: p_secondary_unit_of_meas_tbl(i),
3036: p_item_id_tbl(i)
3037: FROM DUAL
3038: WHERE p_item_id_tbl(i) IS NOT NULL
3039: AND p_organization_id_tbl(i) IS NOT NULL
3040: AND p_secondary_unit_of_meas_tbl(i) IS NOT NULL
3041: AND EXISTS(
3149: p_preferred_grade_tbl(i),
3150: DECODE(p_validation_id, PO_VAL_CONSTANTS.c_line_preferred_grade,
3151: PO_VAL_CONSTANTS.c_line_preferred_grade_item,
3152: PO_VAL_CONSTANTS.c_loc_preferred_grade_item)
3153: FROM DUAL
3154: WHERE p_preferred_grade_tbl(i) IS NOT NULL
3155: AND p_item_id_tbl(i) IS NOT NULL
3156: AND EXISTS(
3157: SELECT 1
3183: p_preferred_grade_tbl(i),
3184: DECODE(p_validation_id, PO_VAL_CONSTANTS.c_line_preferred_grade,
3185: PO_VAL_CONSTANTS.c_line_preferred_grade_valid,
3186: PO_VAL_CONSTANTS.c_loc_preferred_grade_valid)
3187: FROM DUAL
3188: WHERE p_preferred_grade_tbl(i) IS NOT NULL
3189: AND NOT EXISTS(
3190: SELECT 1
3191: FROM mtl_grades_b mgb
3253: p_id_tbl(i),
3254: 'PO_OPS_ITEM_PROCESS_ORG',
3255: 'SHIP_TO_ORGANIZATION_ID',
3256: p_ship_to_organization_id_tbl(i)
3257: FROM DUAL
3258: WHERE p_ship_to_organization_id_tbl(i) IS NOT NULL
3259: AND p_item_id_tbl(i) IS NOT NULL
3260: AND EXISTS(
3261: SELECT 1