DBA Data[Home] [Help]

APPS.PO_VAL_HEADERS dependencies on PO_CORE_S

Line 187: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES

183: BEGIN
184:
185: PO_VALIDATION_HELPER.greater_or_equal_zero(
186: p_calling_module => D_price_update_tol_ge_zero
187: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES
188: , p_value_tbl => p_price_update_tol_tbl
189: , p_entity_id_tbl => p_header_id_tbl
190: , p_entity_type => c_entity_type_HEADER
191: , p_column_name => c_PRICE_UPDATE_TOLERANCE

Line 215: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES

211: BEGIN
212:
213: PO_VALIDATION_HELPER.greater_or_equal_zero(
214: p_calling_module => D_amount_limit_ge_zero
215: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES
216: , p_value_tbl => p_amount_limit_tbl
217: , p_entity_id_tbl => p_header_id_tbl
218: , p_entity_type => c_entity_type_HEADER
219: , p_column_name => c_AMOUNT_LIMIT

Line 291: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES

287: BEGIN
288:
289: PO_VALIDATION_HELPER.greater_or_equal_zero(
290: p_calling_module => D_amount_agreed_ge_zero
291: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES
292: , p_value_tbl => p_blanket_total_amount_tbl
293: , p_entity_id_tbl => p_header_id_tbl
294: , p_entity_type => c_entity_type_HEADER
295: , p_column_name => c_BLANKET_TOTAL_AMOUNT

Line 454: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES

450: BEGIN
451:
452: PO_VALIDATION_HELPER.greater_than_zero(
453: p_calling_module => D_rate_gt_zero
454: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES
455: , p_value_tbl => p_rate_tbl
456: , p_entity_id_tbl => p_header_id_tbl
457: , p_entity_type => c_entity_type_HEADER
458: , p_column_name => c_RATE

Line 1092: ,p_null_allowed_flag => PO_CORE_S.g_parameter_YES

1088: END IF;
1089:
1090: PO_VALIDATION_HELPER.within_percentage_range(
1091: p_calling_module => D_min_guar_perc_range_check
1092: ,p_null_allowed_flag => PO_CORE_S.g_parameter_YES
1093: ,p_value_tbl => p_min_guar_perc_tbl
1094: ,p_entity_id_tbl => p_header_id_tbl
1095: ,p_entity_type => c_ENTITY_TYPE_HEADER
1096: ,p_column_name => c_MIN_GUAR_PERC

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

1552: END IF;
1553:
1554: l_results_count := x_results.result_type.COUNT;
1555:
1556: l_data_key := PO_CORE_S.get_session_gt_nextval();
1557:
1558: FORALL i IN 1 .. p_header_id_tbl.COUNT
1559: INSERT INTO PO_SESSION_GT
1560: ( key

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

1709: -- index_char2 - used to identify failure rows
1710: --
1711: ----------------------------------------------------------
1712:
1713: l_data_key := PO_CORE_S.get_session_gt_nextval();
1714:
1715: -- Only check unsaved headers with manually entered document numbers.
1716:
1717: FORALL i IN 1 .. p_header_id_tbl.COUNT

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

3200: FROM po_doc_style_headers
3201: WHERE status = 'ACTIVE'
3202: AND Nvl(clm_flag,'N') = 'Y';
3203:
3204: l_data_key := PO_CORE_S.get_session_gt_nextval();
3205:
3206: FORALL i IN 1..p_intf_header_id.Count
3207: INSERT INTO po_session_gt(KEY,num1,num2)
3208: SELECT l_data_key,

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

3279: IF (x_results IS NULL) THEN
3280: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
3281: END IF;
3282:
3283: l_data_key := PO_CORE_S.get_session_gt_nextval();
3284:
3285: FORALL i IN 1..p_intf_header_id.Count
3286: INSERT INTO po_session_gt(KEY,num1, num2)
3287: SELECT l_data_key,

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

3349: IF (x_results IS NULL) THEN
3350: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
3351: END IF;
3352:
3353: l_data_key := PO_CORE_S.get_session_gt_nextval();
3354:
3355: FORALL i IN 1..p_intf_header_id.Count
3356: INSERT INTO po_session_gt(KEY,num1, num2)
3357: SELECT l_data_key,

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

3421: IF (x_results IS NULL) THEN
3422: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
3423: END IF;
3424:
3425: l_data_key := PO_CORE_S.get_session_gt_nextval();
3426:
3427: FORALL i IN 1..p_intf_header_id.Count
3428: INSERT INTO po_session_gt(KEY,num1, num2)
3429: SELECT l_data_key,