DBA Data[Home] [Help]

APPS.PO_VALIDATION_HELPER dependencies on PO_CORE_S

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

142: --p_calling_module
143: -- The module base of the calling procedure, used for logging.
144: --p_null_allowed_flag
145: -- Indicates whether or not NULL values should produce errors.
146: -- PO_CORE_S.g_parameter_YES - NULL is not an error.
147: -- PO_CORE_S.g_parameter_NO - NULL is an error.
148: --p_value_tbl
149: -- The values to be checked.
150: --p_entity_id_tbl

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

143: -- The module base of the calling procedure, used for logging.
144: --p_null_allowed_flag
145: -- Indicates whether or not NULL values should produce errors.
146: -- PO_CORE_S.g_parameter_YES - NULL is not an error.
147: -- PO_CORE_S.g_parameter_NO - NULL is an error.
148: --p_value_tbl
149: -- The values to be checked.
150: --p_entity_id_tbl
151: -- The entity id's corresponding to the values to be checked.

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

198: END IF;
199:
200: l_results_count := x_results.result_type.COUNT;
201:
202: IF (p_null_allowed_flag = PO_CORE_S.g_parameter_YES) THEN
203: l_null_not_allowed := FALSE;
204: ELSE
205: l_null_not_allowed := TRUE;
206: END IF;

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

261: --p_calling_module
262: -- The module base of the calling procedure, used for logging.
263: --p_null_allowed_flag
264: -- Indicates whether or not NULL values should produce errors.
265: -- PO_CORE_S.g_parameter_YES - NULL is not an error.
266: -- PO_CORE_S.g_parameter_NO - NULL is an error.
267: --p_value_tbl
268: -- The values to be checked.
269: --p_entity_id_tbl

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

262: -- The module base of the calling procedure, used for logging.
263: --p_null_allowed_flag
264: -- Indicates whether or not NULL values should produce errors.
265: -- PO_CORE_S.g_parameter_YES - NULL is not an error.
266: -- PO_CORE_S.g_parameter_NO - NULL is an error.
267: --p_value_tbl
268: -- The values to be checked.
269: --p_entity_id_tbl
270: -- The entity id's corresponding to the values to be checked.

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

335: END IF;
336:
337: l_results_count := x_results.result_type.COUNT;
338:
339: IF (p_null_allowed_flag = PO_CORE_S.g_parameter_YES) THEN
340: l_null_not_allowed := FALSE;
341: ELSE
342: l_null_not_allowed := TRUE;
343: END IF;

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

402: --p_calling_module
403: -- The module base of the calling procedure, used for logging.
404: --p_null_allowed_flag
405: -- Indicates whether or not NULL values should produce errors.
406: -- PO_CORE_S.g_parameter_YES - NULL is not an error.
407: -- PO_CORE_S.g_parameter_NO - NULL is an error.
408: --p_value_tbl
409: -- The values to be checked.
410: --p_entity_id_tbl

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

403: -- The module base of the calling procedure, used for logging.
404: --p_null_allowed_flag
405: -- Indicates whether or not NULL values should produce errors.
406: -- PO_CORE_S.g_parameter_YES - NULL is not an error.
407: -- PO_CORE_S.g_parameter_NO - NULL is an error.
408: --p_value_tbl
409: -- The values to be checked.
410: --p_entity_id_tbl
411: -- The entity id's corresponding to the values to be checked.

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

467: END IF;
468:
469: l_results_count := x_results.result_type.COUNT;
470:
471: IF (p_null_allowed_flag = PO_CORE_S.g_parameter_YES) THEN
472: l_null_not_allowed := FALSE;
473: ELSE
474: l_null_not_allowed := TRUE;
475: END IF;

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

1067: -- The order_type_lookup_code of the corresponding value.
1068: --p_check_quantity_types_flag
1069: -- Indicates whether values that depend on QUANTITY or AMOUNT
1070: -- should be checked.
1071: -- PO_CORE_S.g_parameter_YES - check QUANTITY types (QUANTITY, AMOUNT).
1072: -- PO_CORE_S.g_parameter_NO - check AMOUNT types (FIXED PRICE, RATE).
1073: --p_entity_type
1074: --p_column_name
1075: -- Values to use in the error results.

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

1068: --p_check_quantity_types_flag
1069: -- Indicates whether values that depend on QUANTITY or AMOUNT
1070: -- should be checked.
1071: -- PO_CORE_S.g_parameter_YES - check QUANTITY types (QUANTITY, AMOUNT).
1072: -- PO_CORE_S.g_parameter_NO - check AMOUNT types (FIXED PRICE, RATE).
1073: --p_entity_type
1074: --p_column_name
1075: -- Values to use in the error results.
1076: --IN OUT:

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

1125: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
1126: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1127: END IF;
1128:
1129: IF (p_check_quantity_types_flag = PO_CORE_S.g_parameter_YES) THEN
1130: l_keep_quantity := TRUE;
1131: ELSE
1132: l_keep_quantity := FALSE;
1133: END IF;

Line 1189: , p_null_allowed_flag => PO_CORE_S.g_parameter_NO

1185: THEN
1186:
1187: PO_VALIDATION_HELPER.greater_or_equal_zero(
1188: p_calling_module => p_calling_module
1189: , p_null_allowed_flag => PO_CORE_S.g_parameter_NO
1190: , p_value_tbl => l_value_tbl
1191: , p_entity_id_tbl => l_entity_id_tbl
1192: , p_entity_type => p_entity_type
1193: , p_column_name => p_column_name

Line 1203: , p_null_allowed_flag => PO_CORE_S.g_parameter_NO

1199: ELSE
1200:
1201: PO_VALIDATION_HELPER.greater_than_zero(
1202: p_calling_module => p_calling_module
1203: , p_null_allowed_flag => PO_CORE_S.g_parameter_NO
1204: , p_value_tbl => l_value_tbl
1205: , p_entity_id_tbl => l_entity_id_tbl
1206: , p_entity_type => p_entity_type
1207: , p_column_name => p_column_name

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

1262: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
1263: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1264: END IF;
1265:
1266: IF (p_check_quantity_types_flag = PO_CORE_S.g_parameter_YES) THEN
1267: l_keep_quantity := TRUE;
1268: ELSE
1269: l_keep_quantity := FALSE;
1270: END IF;

Line 1298: , p_null_allowed_flag => PO_CORE_S.g_parameter_NO

1294: l_value_tbl.trim(l_input_size-l_count);
1295:
1296: PO_VALIDATION_HELPER.greater_than_zero(
1297: p_calling_module => p_calling_module
1298: , p_null_allowed_flag => PO_CORE_S.g_parameter_NO
1299: , p_value_tbl => l_value_tbl
1300: , p_entity_id_tbl => l_entity_id_tbl
1301: , p_entity_type => p_entity_type
1302: , p_column_name => p_column_name

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

1423: l_expiration_date_tbl := p_expiration_date_tbl;
1424: END IF;
1425:
1426:
1427: l_data_key := PO_CORE_S.get_session_gt_nextval();
1428:
1429: FORALL i IN 1 .. p_line_id_tbl.COUNT
1430: INSERT INTO PO_SESSION_GT SES
1431: ( key

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

1746: l_parent_id_tbl := PO_TBL_NUMBER() MULTISET UNION DISTINCT p_parent_id_tbl;
1747:
1748: -- Put the stored data for these ids into the temp table.
1749:
1750: l_data_key := PO_CORE_S.get_session_gt_nextval();
1751:
1752: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_DISTRIBUTION) THEN
1753:
1754: l_column_name := c_DISTRIBUTION_NUM;

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

2027: l_parent_id_tbl := PO_TBL_NUMBER() MULTISET UNION DISTINCT p_entity_id_tbl;
2028:
2029: -- Put the stored data for these ids into the temp table.
2030:
2031: l_data_key := PO_CORE_S.get_session_gt_nextval();
2032:
2033: FORALL i IN 1 .. l_parent_id_tbl.COUNT
2034: INSERT INTO PO_SESSION_GT
2035: ( key

Line 2650: , p_null_allowed_flag => PO_CORE_S.g_parameter_NO

2646: l_value_tbl.trim(l_input_size-l_count);
2647:
2648: PO_VALIDATION_HELPER.greater_than_zero(
2649: p_calling_module => p_calling_module
2650: , p_null_allowed_flag => PO_CORE_S.g_parameter_NO
2651: , p_value_tbl => l_value_tbl
2652: , p_entity_id_tbl => l_entity_id_tbl
2653: , p_entity_type => p_entity_type
2654: , p_column_name => p_column_name

Line 3503: l_key := PO_CORE_S.get_session_gt_nextval;

3499: END IF;
3500:
3501: l_secondary_unit_of_meas_tbl.extend(p_item_id_tbl.COUNT);
3502:
3503: l_key := PO_CORE_S.get_session_gt_nextval;
3504:
3505: FOR i IN 1..p_item_id_tbl.COUNT LOOP
3506: l_index_tbl(i) := i;
3507: END LOOP;