DBA Data[Home] [Help]

APPS.PO_VALIDATION_HELPER dependencies on PO_CORE_S

Line 136: -- PO_CORE_S.g_parameter_YES - NULL is not an error.

132: --p_calling_module
133: -- The module base of the calling procedure, used for logging.
134: --p_null_allowed_flag
135: -- Indicates whether or not NULL values should produce errors.
136: -- PO_CORE_S.g_parameter_YES - NULL is not an error.
137: -- PO_CORE_S.g_parameter_NO - NULL is an error.
138: --p_value_tbl
139: -- The values to be checked.
140: --p_entity_id_tbl

Line 137: -- PO_CORE_S.g_parameter_NO - NULL is an error.

133: -- The module base of the calling procedure, used for logging.
134: --p_null_allowed_flag
135: -- Indicates whether or not NULL values should produce errors.
136: -- PO_CORE_S.g_parameter_YES - NULL is not an error.
137: -- PO_CORE_S.g_parameter_NO - NULL is an error.
138: --p_value_tbl
139: -- The values to be checked.
140: --p_entity_id_tbl
141: -- The entity id's corresponding to the values to be checked.

Line 192: IF (p_null_allowed_flag = PO_CORE_S.g_parameter_YES) THEN

188: END IF;
189:
190: l_results_count := x_results.result_type.COUNT;
191:
192: IF (p_null_allowed_flag = PO_CORE_S.g_parameter_YES) THEN
193: l_null_not_allowed := FALSE;
194: ELSE
195: l_null_not_allowed := TRUE;
196: END IF;

Line 255: -- PO_CORE_S.g_parameter_YES - NULL is not an error.

251: --p_calling_module
252: -- The module base of the calling procedure, used for logging.
253: --p_null_allowed_flag
254: -- Indicates whether or not NULL values should produce errors.
255: -- PO_CORE_S.g_parameter_YES - NULL is not an error.
256: -- PO_CORE_S.g_parameter_NO - NULL is an error.
257: --p_value_tbl
258: -- The values to be checked.
259: --p_entity_id_tbl

Line 256: -- PO_CORE_S.g_parameter_NO - NULL is an error.

252: -- The module base of the calling procedure, used for logging.
253: --p_null_allowed_flag
254: -- Indicates whether or not NULL values should produce errors.
255: -- PO_CORE_S.g_parameter_YES - NULL is not an error.
256: -- PO_CORE_S.g_parameter_NO - NULL is an error.
257: --p_value_tbl
258: -- The values to be checked.
259: --p_entity_id_tbl
260: -- The entity id's corresponding to the values to be checked.

Line 329: IF (p_null_allowed_flag = PO_CORE_S.g_parameter_YES) THEN

325: END IF;
326:
327: l_results_count := x_results.result_type.COUNT;
328:
329: IF (p_null_allowed_flag = PO_CORE_S.g_parameter_YES) THEN
330: l_null_not_allowed := FALSE;
331: ELSE
332: l_null_not_allowed := TRUE;
333: END IF;

Line 396: -- PO_CORE_S.g_parameter_YES - NULL is not an error.

392: --p_calling_module
393: -- The module base of the calling procedure, used for logging.
394: --p_null_allowed_flag
395: -- Indicates whether or not NULL values should produce errors.
396: -- PO_CORE_S.g_parameter_YES - NULL is not an error.
397: -- PO_CORE_S.g_parameter_NO - NULL is an error.
398: --p_value_tbl
399: -- The values to be checked.
400: --p_entity_id_tbl

Line 397: -- PO_CORE_S.g_parameter_NO - NULL is an error.

393: -- The module base of the calling procedure, used for logging.
394: --p_null_allowed_flag
395: -- Indicates whether or not NULL values should produce errors.
396: -- PO_CORE_S.g_parameter_YES - NULL is not an error.
397: -- PO_CORE_S.g_parameter_NO - NULL is an error.
398: --p_value_tbl
399: -- The values to be checked.
400: --p_entity_id_tbl
401: -- The entity id's corresponding to the values to be checked.

Line 461: IF (p_null_allowed_flag = PO_CORE_S.g_parameter_YES) THEN

457: END IF;
458:
459: l_results_count := x_results.result_type.COUNT;
460:
461: IF (p_null_allowed_flag = PO_CORE_S.g_parameter_YES) THEN
462: l_null_not_allowed := FALSE;
463: ELSE
464: l_null_not_allowed := TRUE;
465: END IF;

Line 1061: -- PO_CORE_S.g_parameter_YES - check QUANTITY types (QUANTITY, AMOUNT).

1057: -- The order_type_lookup_code of the corresponding value.
1058: --p_check_quantity_types_flag
1059: -- Indicates whether values that depend on QUANTITY or AMOUNT
1060: -- should be checked.
1061: -- PO_CORE_S.g_parameter_YES - check QUANTITY types (QUANTITY, AMOUNT).
1062: -- PO_CORE_S.g_parameter_NO - check AMOUNT types (FIXED PRICE, RATE).
1063: --p_entity_type
1064: --p_column_name
1065: -- Values to use in the error results.

Line 1062: -- PO_CORE_S.g_parameter_NO - check AMOUNT types (FIXED PRICE, RATE).

1058: --p_check_quantity_types_flag
1059: -- Indicates whether values that depend on QUANTITY or AMOUNT
1060: -- should be checked.
1061: -- PO_CORE_S.g_parameter_YES - check QUANTITY types (QUANTITY, AMOUNT).
1062: -- PO_CORE_S.g_parameter_NO - check AMOUNT types (FIXED PRICE, RATE).
1063: --p_entity_type
1064: --p_column_name
1065: -- Values to use in the error results.
1066: --IN OUT:

Line 1112: IF (p_check_quantity_types_flag = PO_CORE_S.g_parameter_YES) THEN

1108: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
1109: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1110: END IF;
1111:
1112: IF (p_check_quantity_types_flag = PO_CORE_S.g_parameter_YES) THEN
1113: l_keep_quantity := TRUE;
1114: ELSE
1115: l_keep_quantity := FALSE;
1116: END IF;

Line 1144: , p_null_allowed_flag => PO_CORE_S.g_parameter_NO

1140: l_value_tbl.trim(l_input_size-l_count);
1141:
1142: PO_VALIDATION_HELPER.greater_than_zero(
1143: p_calling_module => p_calling_module
1144: , p_null_allowed_flag => PO_CORE_S.g_parameter_NO
1145: , p_value_tbl => l_value_tbl
1146: , p_entity_id_tbl => l_entity_id_tbl
1147: , p_entity_type => p_entity_type
1148: , p_column_name => p_column_name

Line 1273: l_data_key := PO_CORE_S.get_session_gt_nextval();

1269: l_expiration_date_tbl := p_expiration_date_tbl;
1270: END IF;
1271:
1272:
1273: l_data_key := PO_CORE_S.get_session_gt_nextval();
1274:
1275: FORALL i IN 1 .. p_line_id_tbl.COUNT
1276: INSERT INTO PO_SESSION_GT SES
1277: ( key

Line 1593: l_data_key := PO_CORE_S.get_session_gt_nextval();

1589: l_parent_id_tbl := PO_TBL_NUMBER() MULTISET UNION DISTINCT p_parent_id_tbl;
1590:
1591: -- Put the stored data for these ids into the temp table.
1592:
1593: l_data_key := PO_CORE_S.get_session_gt_nextval();
1594:
1595: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_DISTRIBUTION) THEN
1596:
1597: l_column_name := c_DISTRIBUTION_NUM;

Line 1846: l_data_key := PO_CORE_S.get_session_gt_nextval();

1842: l_parent_id_tbl := PO_TBL_NUMBER() MULTISET UNION DISTINCT p_entity_id_tbl;
1843:
1844: -- Put the stored data for these ids into the temp table.
1845:
1846: l_data_key := PO_CORE_S.get_session_gt_nextval();
1847:
1848: FORALL i IN 1 .. l_parent_id_tbl.COUNT
1849: INSERT INTO PO_SESSION_GT
1850: ( key

Line 2465: , p_null_allowed_flag => PO_CORE_S.g_parameter_NO

2461: l_value_tbl.trim(l_input_size-l_count);
2462:
2463: PO_VALIDATION_HELPER.greater_than_zero(
2464: p_calling_module => p_calling_module
2465: , p_null_allowed_flag => PO_CORE_S.g_parameter_NO
2466: , p_value_tbl => l_value_tbl
2467: , p_entity_id_tbl => l_entity_id_tbl
2468: , p_entity_type => p_entity_type
2469: , p_column_name => p_column_name

Line 3316: l_key := PO_CORE_S.get_session_gt_nextval;

3312: END IF;
3313:
3314: l_secondary_unit_of_meas_tbl.extend(p_item_id_tbl.COUNT);
3315:
3316: l_key := PO_CORE_S.get_session_gt_nextval;
3317:
3318: FOR i IN 1..p_item_id_tbl.COUNT LOOP
3319: l_index_tbl(i) := i;
3320: END LOOP;