[Home] [Help]
285: BEGIN
286:
287: PO_VALIDATION_HELPER.greater_or_equal_zero(
288: p_calling_module => D_amt_agreed_ge_zero
289: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES
290: , p_value_tbl => p_committed_amount_tbl
291: , p_entity_id_tbl => p_line_id_tbl
292: , p_entity_type => c_ENTITY_TYPE_LINE
293: , p_column_name => c_COMMITTED_AMOUNT
312: BEGIN
313:
314: PO_VALIDATION_HELPER.greater_or_equal_zero(
315: p_calling_module => D_min_rel_amt_ge_zero
316: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES
317: , p_value_tbl => p_min_release_amount_tbl
318: , p_entity_id_tbl => p_line_id_tbl
319: , p_entity_type => c_ENTITY_TYPE_LINE
320: , p_column_name => c_MIN_RELEASE_AMOUNT
348: , p_entity_id_tbl => p_line_id_tbl
349: , p_order_type_lookup_code_tbl => p_order_type_lookup_code_tbl
350: , p_clm_info_flag_tbl => p_clm_info_flag_tbl
351: , p_cost_constraint_tbl => p_cost_constraint_tbl
352: , p_check_quantity_types_flag => PO_CORE_S.g_parameter_YES
353: , p_entity_type => c_ENTITY_TYPE_LINE
354: , p_column_name => c_QUANTITY
355: , x_results => x_results
356: , x_result_type => x_result_type
809: , p_entity_id_tbl => p_line_id_tbl
810: , p_order_type_lookup_code_tbl => p_order_type_lookup_code_tbl
811: , p_clm_info_flag_tbl => p_clm_info_flag_tbl -- CLM changes
812: , p_cost_constraint_tbl => p_cost_constraint_tbl -- CLM changes
813: , p_check_quantity_types_flag => PO_CORE_S.g_parameter_NO
814: , p_entity_type => c_ENTITY_TYPE_LINE
815: , p_column_name => c_AMOUNT
816: , x_results => x_results
817: , x_result_type => x_result_type
864:
865: d_progress := 20.0;
866:
867: -- get currency info and put in GT table
868: l_gt_key := PO_CORE_S.get_session_gt_nextval();
869:
870: d_progress := 30.0;
871:
872: FORALL i IN 1 .. p_line_id_tbl.COUNT
1057: END IF;
1058:
1059: l_results_count := x_results.result_type.COUNT;
1060:
1061: l_data_key := PO_CORE_S.get_session_gt_nextval();
1062:
1063: FORALL i IN 1 .. p_line_id_tbl.COUNT
1064: INSERT INTO PO_SESSION_GT
1065: ( key
1196: BEGIN
1197:
1198: PO_VALIDATION_HELPER.greater_than_zero(
1199: p_calling_module => D_line_num_gt_zero
1200: , p_null_allowed_flag => PO_CORE_S.g_parameter_NO
1201: , p_value_tbl => p_line_num_tbl
1202: , p_entity_id_tbl => p_line_id_tbl
1203: , p_entity_type => c_ENTITY_TYPE_LINE
1204: , p_column_name => c_LINE_NUM
2068: l_unit_price_tbl.trim(l_input_size-l_count);
2069:
2070: PO_VALIDATION_HELPER.greater_or_equal_zero(
2071: p_calling_module => d_mod
2072: , p_null_allowed_flag => PO_CORE_S.g_parameter_NO
2073: , p_value_tbl => l_unit_price_tbl
2074: , p_entity_id_tbl => l_line_id_tbl
2075: , p_entity_type => c_ENTITY_TYPE_LINE
2076: , p_column_name => c_UNIT_PRICE
2102: BEGIN
2103:
2104: PO_VALIDATION_HELPER.greater_or_equal_zero(
2105: p_calling_module => D_list_price_ge_zero
2106: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES
2107: , p_value_tbl => p_list_price_per_unit_tbl
2108: , p_entity_id_tbl => p_line_id_tbl
2109: , p_entity_type => c_ENTITY_TYPE_LINE
2110: , p_column_name => c_LIST_PRICE_PER_UNIT
2129: BEGIN
2130:
2131: PO_VALIDATION_HELPER.greater_or_equal_zero(
2132: p_calling_module => D_market_price_ge_zero
2133: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES
2134: , p_value_tbl => p_market_price_tbl
2135: , p_entity_id_tbl => p_line_id_tbl
2136: , p_entity_type => c_ENTITY_TYPE_LINE
2137: , p_column_name => c_MARKET_PRICE
2175: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
2176: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2177: END IF;
2178:
2179: l_data_key := PO_CORE_S.get_session_gt_nextval();
2180:
2181: FORALL i IN 1 .. p_line_id_tbl.COUNT
2182: INSERT INTO PO_SESSION_GT
2183: ( key
2332: BEGIN
2333:
2334: PO_VALIDATION_HELPER.within_percentage_range(
2335: p_calling_module => D_recoupment_rate_range_check
2336: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES
2337: , p_value_tbl => p_recoupment_rate_tbl
2338: , p_entity_id_tbl => p_line_id_tbl
2339: , p_entity_type => c_ENTITY_TYPE_LINE
2340: , p_column_name => c_RECOUPMENT_RATE
2355: BEGIN
2356:
2357: PO_VALIDATION_HELPER.within_percentage_range(
2358: p_calling_module => D_retainage_rate_range_check
2359: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES
2360: , p_value_tbl => p_retainage_rate_tbl
2361: , p_entity_id_tbl => p_line_id_tbl
2362: , p_entity_type => c_ENTITY_TYPE_LINE
2363: , p_column_name => c_RETAINAGE_RATE
2378: BEGIN
2379:
2380: PO_VALIDATION_HELPER.within_percentage_range(
2381: p_calling_module => D_prog_pay_rate_range_check
2382: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES
2383: , p_value_tbl => p_prog_pay_rate_tbl
2384: , p_entity_id_tbl => p_line_id_tbl
2385: , p_entity_type => c_ENTITY_TYPE_LINE
2386: , p_column_name => c_PROGRESS_PAYMENT_RATE
3316: BEGIN
3317:
3318: PO_VALIDATION_HELPER.greater_or_equal_zero(
3319: p_calling_module => D_max_retain_amt_ge_zero
3320: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES
3321: , p_value_tbl => p_max_retain_amt_tbl
3322: , p_entity_id_tbl => p_line_id_tbl
3323: , p_entity_type => c_ENTITY_TYPE_LINE
3324: , p_column_name => c_MAX_RETAINAGE_AMOUNT
3964: END IF;
3965:
3966: -- Get a distinct list of parent ids.
3967: l_parent_id_tbl := PO_TBL_NUMBER() MULTISET UNION DISTINCT p_header_id_tbl;
3968: l_data_key := PO_CORE_S.get_session_gt_nextval();
3969:
3970: FOR i IN 1 .. l_parent_id_tbl.COUNT LOOP
3971: -- Extract Par Line ids of this line
3972: PO_VALIDATION_HELPER.extract_par_draft_id_tbl(p_par_draft_id_tbl(i),
4899: IF (x_results IS NULL) THEN
4900: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
4901: END IF;
4902:
4903: l_data_key := PO_CORE_S.get_session_gt_nextval();
4904:
4905: FORALL i IN 1..p_intf_line_id_tbl.Count
4906: INSERT INTO PO_SESSION_GT(
4907: KEY,
4972: IF (x_results IS NULL) THEN
4973: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
4974: END IF;
4975:
4976: l_data_key := PO_CORE_S.get_session_gt_nextval();
4977:
4978: FORALL i IN 1..p_intf_line_id_tbl.Count
4979: INSERT INTO PO_SESSION_GT(
4980: KEY,