DBA Data[Home] [Help]

APPS.PO_VAL_SHIPMENTS dependencies on PO_CORE_S

Line 157: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES

153: BEGIN
154:
155: PO_VALIDATION_HELPER.greater_or_equal_zero(
156: p_calling_module => D_days_early_gte_zero
157: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES
158: , p_value_tbl => p_days_early_rcpt_allowed_tbl
159: , p_entity_id_tbl => p_line_loc_id_tbl
160: , p_entity_type => c_ENTITY_TYPE_LINE_LOCATION
161: , p_column_name => c_DAYS_EARLY_RECEIPT_ALLOWED

Line 184: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES

180: BEGIN
181:
182: PO_VALIDATION_HELPER.greater_or_equal_zero(
183: p_calling_module => D_days_late_gte_zero
184: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES
185: , p_value_tbl => p_days_late_rcpt_allowed_tbl
186: , p_entity_id_tbl => p_line_loc_id_tbl
187: , p_entity_type => c_ENTITY_TYPE_LINE_LOCATION
188: , p_column_name => c_DAYS_LATE_RECEIPT_ALLOWED

Line 212: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES

208: BEGIN
209:
210: PO_VALIDATION_HELPER.within_percentage_range(
211: p_calling_module => D_rcv_close_tol_within_range
212: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES
213: , p_value_tbl => p_receive_close_tolerance_tbl
214: , p_entity_id_tbl => p_line_loc_id_tbl
215: , p_entity_type => c_ENTITY_TYPE_LINE_LOCATION
216: , p_column_name => c_RECEIVE_CLOSE_TOLERANCE

Line 239: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES

235: BEGIN
236:
237: PO_VALIDATION_HELPER.within_percentage_range(
238: p_calling_module => D_over_rcpt_tol_within_range
239: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES
240: , p_value_tbl => p_qty_rcv_tolerance_tbl
241: , p_entity_id_tbl => p_line_loc_id_tbl
242: , p_entity_type => c_ENTITY_TYPE_LINE_LOCATION
243: , p_column_name => c_QTY_RCV_TOLERANCE

Line 440: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES

436: BEGIN
437:
438: PO_VALIDATION_HELPER.within_percentage_range(
439: p_calling_module => D_inv_close_tol_range_check
440: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES
441: , p_value_tbl => p_invoice_close_tolerance_tbl
442: , p_entity_id_tbl => p_line_loc_id_tbl
443: , p_entity_type => c_ENTITY_TYPE_LINE_LOCATION
444: , p_column_name => c_INVOICE_CLOSE_TOLERANCE

Line 696: , p_null_allowed_flag => PO_CORE_S.g_parameter_NO

692: --: only pass in the filtered
693: --list of line locations
694: PO_VALIDATION_HELPER.greater_than_zero(
695: p_calling_module => D_ship_num_gt_zero
696: , p_null_allowed_flag => PO_CORE_S.g_parameter_NO
697: , p_value_tbl => l_shipment_num_tbl --
698: , p_entity_id_tbl => l_line_loc_id_tbl --
699: , p_entity_type => c_ENTITY_TYPE_LINE_LOCATION
700: , p_column_name => c_SHIPMENT_NUM

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

782: END IF;
783:
784: l_results_count := x_results.result_type.COUNT;
785:
786: l_data_key := PO_CORE_S.get_session_gt_nextval();
787:
788: FORALL i IN 1 .. p_line_loc_id_tbl.COUNT
789: INSERT INTO PO_SESSION_GT SES
790: ( key

Line 833: PO_CORE_S.check_inv_org_in_sob(

829: ;
830:
831: FOR i IN 1 .. l_line_loc_id_tbl.COUNT LOOP
832:
833: PO_CORE_S.check_inv_org_in_sob(
834: x_return_status => l_return_status
835: , p_inv_org_id => l_ship_to_org_id_tbl(i)
836: , p_sob_id => l_set_of_books_id_tbl(i)
837: , x_in_sob => l_in_sob

Line 963: , p_null_allowed_flag => PO_CORE_S.g_parameter_NO

959: IF l_is_clm_po = 'Y'
960: THEN
961: PO_VALIDATION_HELPER.greater_or_equal_zero(
962: p_calling_module => d_mod
963: , p_null_allowed_flag => PO_CORE_S.g_parameter_NO
964: , p_value_tbl => l_quantity_tbl
965: , p_entity_id_tbl => l_line_loc_id_tbl
966: , p_entity_type => c_ENTITY_TYPE_LINE_LOCATION
967: , p_column_name => c_QUANTITY

Line 977: , p_null_allowed_flag => PO_CORE_S.g_parameter_NO

973: ELSE
974:
975: PO_VALIDATION_HELPER.greater_than_zero(
976: p_calling_module => d_mod
977: , p_null_allowed_flag => PO_CORE_S.g_parameter_NO
978: , p_value_tbl => l_quantity_tbl
979: , p_entity_id_tbl => l_line_loc_id_tbl
980: , p_entity_type => c_ENTITY_TYPE_LINE_LOCATION
981: , p_column_name => c_QUANTITY

Line 1191: , p_null_allowed_flag => PO_CORE_S.g_parameter_NO

1187: IF l_is_clm_po = 'Y'
1188: THEN
1189: PO_VALIDATION_HELPER.greater_or_equal_zero(
1190: p_calling_module => d_mod
1191: , p_null_allowed_flag => PO_CORE_S.g_parameter_NO
1192: , p_value_tbl => l_amount_tbl
1193: , p_entity_id_tbl => l_line_loc_id_tbl
1194: , p_entity_type => c_ENTITY_TYPE_LINE_LOCATION
1195: , p_column_name => c_AMOUNT

Line 1205: , p_null_allowed_flag => PO_CORE_S.g_parameter_NO

1201: ELSE
1202:
1203: PO_VALIDATION_HELPER.greater_than_zero(
1204: p_calling_module => d_mod
1205: , p_null_allowed_flag => PO_CORE_S.g_parameter_NO
1206: , p_value_tbl => l_amount_tbl
1207: , p_entity_id_tbl => l_line_loc_id_tbl
1208: , p_entity_type => c_ENTITY_TYPE_LINE_LOCATION
1209: , p_column_name => c_AMOUNT

Line 1721: , p_null_allowed_flag => PO_CORE_S.g_parameter_NO

1717: l_price_override_tbl.trim(l_input_size-l_count);
1718:
1719: PO_VALIDATION_HELPER.greater_than_zero(
1720: p_calling_module => D_complex_price_or_gt_zero
1721: , p_null_allowed_flag => PO_CORE_S.g_parameter_NO
1722: , p_value_tbl => l_price_override_tbl
1723: , p_entity_id_tbl => l_line_loc_id_tbl
1724: , p_entity_type => c_ENTITY_TYPE_LINE_LOCATION
1725: , p_column_name => c_PRICE_OVERRIDE