DBA Data[Home] [Help]

APPS.PO_VAL_LINES dependencies on PO_CORE_S

Line 181: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES

177: BEGIN
178:
179: PO_VALIDATION_HELPER.greater_or_equal_zero(
180: p_calling_module => D_amt_agreed_ge_zero
181: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES
182: , p_value_tbl => p_committed_amount_tbl
183: , p_entity_id_tbl => p_line_id_tbl
184: , p_entity_type => c_ENTITY_TYPE_LINE
185: , p_column_name => c_COMMITTED_AMOUNT

Line 208: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES

204: BEGIN
205:
206: PO_VALIDATION_HELPER.greater_or_equal_zero(
207: p_calling_module => D_min_rel_amt_ge_zero
208: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES
209: , p_value_tbl => p_min_release_amount_tbl
210: , p_entity_id_tbl => p_line_id_tbl
211: , p_entity_type => c_ENTITY_TYPE_LINE
212: , p_column_name => c_MIN_RELEASE_AMOUNT

Line 239: , p_check_quantity_types_flag => PO_CORE_S.g_parameter_YES

235: p_calling_module => D_quantity_gt_zero
236: , p_value_tbl => p_quantity_tbl
237: , p_entity_id_tbl => p_line_id_tbl
238: , p_order_type_lookup_code_tbl => p_order_type_lookup_code_tbl
239: , p_check_quantity_types_flag => PO_CORE_S.g_parameter_YES
240: , p_entity_type => c_ENTITY_TYPE_LINE
241: , p_column_name => c_QUANTITY
242: , x_results => x_results
243: , x_result_type => x_result_type

Line 554: , p_check_quantity_types_flag => PO_CORE_S.g_parameter_NO

550: p_calling_module => D_amount_gt_zero
551: , p_value_tbl => p_amount_tbl
552: , p_entity_id_tbl => p_line_id_tbl
553: , p_order_type_lookup_code_tbl => p_order_type_lookup_code_tbl
554: , p_check_quantity_types_flag => PO_CORE_S.g_parameter_NO
555: , p_entity_type => c_ENTITY_TYPE_LINE
556: , p_column_name => c_AMOUNT
557: , x_results => x_results
558: , x_result_type => x_result_type

Line 608: l_gt_key := PO_CORE_S.get_session_gt_nextval();

604:
605: d_progress := 20.0;
606:
607: -- get currency info and put in GT table
608: l_gt_key := PO_CORE_S.get_session_gt_nextval();
609:
610: d_progress := 30.0;
611:
612: FORALL i IN 1 .. p_line_id_tbl.COUNT

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

797: END IF;
798:
799: l_results_count := x_results.result_type.COUNT;
800:
801: l_data_key := PO_CORE_S.get_session_gt_nextval();
802:
803: FORALL i IN 1 .. p_line_id_tbl.COUNT
804: INSERT INTO PO_SESSION_GT
805: ( key

Line 936: , p_null_allowed_flag => PO_CORE_S.g_parameter_NO

932: BEGIN
933:
934: PO_VALIDATION_HELPER.greater_than_zero(
935: p_calling_module => D_line_num_gt_zero
936: , p_null_allowed_flag => PO_CORE_S.g_parameter_NO
937: , p_value_tbl => p_line_num_tbl
938: , p_entity_id_tbl => p_line_id_tbl
939: , p_entity_type => c_ENTITY_TYPE_LINE
940: , p_column_name => c_LINE_NUM

Line 1205: , p_null_allowed_flag => PO_CORE_S.g_parameter_NO

1201: l_unit_price_tbl.trim(l_input_size-l_count);
1202:
1203: PO_VALIDATION_HELPER.greater_or_equal_zero(
1204: p_calling_module => d_mod
1205: , p_null_allowed_flag => PO_CORE_S.g_parameter_NO
1206: , p_value_tbl => l_unit_price_tbl
1207: , p_entity_id_tbl => l_line_id_tbl
1208: , p_entity_type => c_ENTITY_TYPE_LINE
1209: , p_column_name => c_UNIT_PRICE

Line 1239: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES

1235: BEGIN
1236:
1237: PO_VALIDATION_HELPER.greater_or_equal_zero(
1238: p_calling_module => D_list_price_ge_zero
1239: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES
1240: , p_value_tbl => p_list_price_per_unit_tbl
1241: , p_entity_id_tbl => p_line_id_tbl
1242: , p_entity_type => c_ENTITY_TYPE_LINE
1243: , p_column_name => c_LIST_PRICE_PER_UNIT

Line 1266: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES

1262: BEGIN
1263:
1264: PO_VALIDATION_HELPER.greater_or_equal_zero(
1265: p_calling_module => D_market_price_ge_zero
1266: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES
1267: , p_value_tbl => p_market_price_tbl
1268: , p_entity_id_tbl => p_line_id_tbl
1269: , p_entity_type => c_ENTITY_TYPE_LINE
1270: , p_column_name => c_MARKET_PRICE

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

1305: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1306: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1307: END IF;
1308:
1309: l_data_key := PO_CORE_S.get_session_gt_nextval();
1310:
1311: FORALL i IN 1 .. p_line_id_tbl.COUNT
1312: INSERT INTO PO_SESSION_GT
1313: ( key

Line 1461: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES

1457: BEGIN
1458:
1459: PO_VALIDATION_HELPER.within_percentage_range(
1460: p_calling_module => D_recoupment_rate_range_check
1461: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES
1462: , p_value_tbl => p_recoupment_rate_tbl
1463: , p_entity_id_tbl => p_line_id_tbl
1464: , p_entity_type => c_ENTITY_TYPE_LINE
1465: , p_column_name => c_RECOUPMENT_RATE

Line 1484: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES

1480: BEGIN
1481:
1482: PO_VALIDATION_HELPER.within_percentage_range(
1483: p_calling_module => D_retainage_rate_range_check
1484: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES
1485: , p_value_tbl => p_retainage_rate_tbl
1486: , p_entity_id_tbl => p_line_id_tbl
1487: , p_entity_type => c_ENTITY_TYPE_LINE
1488: , p_column_name => c_RETAINAGE_RATE

Line 1507: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES

1503: BEGIN
1504:
1505: PO_VALIDATION_HELPER.within_percentage_range(
1506: p_calling_module => D_prog_pay_rate_range_check
1507: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES
1508: , p_value_tbl => p_prog_pay_rate_tbl
1509: , p_entity_id_tbl => p_line_id_tbl
1510: , p_entity_type => c_ENTITY_TYPE_LINE
1511: , p_column_name => c_PROGRESS_PAYMENT_RATE

Line 2373: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES

2369: BEGIN
2370:
2371: PO_VALIDATION_HELPER.greater_or_equal_zero(
2372: p_calling_module => D_max_retain_amt_ge_zero
2373: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES
2374: , p_value_tbl => p_max_retain_amt_tbl
2375: , p_entity_id_tbl => p_line_id_tbl
2376: , p_entity_type => c_ENTITY_TYPE_LINE
2377: , p_column_name => c_MAX_RETAINAGE_AMOUNT