APPS.PO_VAL_PRICE_ADJS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 7

c_UPDATED_FLAG CONSTANT VARCHAR2(30) := 'UPDATED_FLAG';

Line: 28

, p_updated_flag_tbl       IN  PO_TBL_VARCHAR1
, p_change_reason_code_tbl IN  PO_TBL_VARCHAR30
, x_results                IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
, x_result_type            OUT NOCOPY    VARCHAR2
)
IS
  d_mod CONSTANT VARCHAR2(100) := D_ovr_chng_reas_code_not_null;

Line: 44

    PO_LOG.proc_begin(d_mod,'p_updated_flag_tbl',p_updated_flag_tbl);

Line: 52

    IF (NVL(p_updated_flag_tbl(i),'N') = 'Y' AND p_change_reason_code_tbl(i) IS NULL)
    THEN
      x_results.add_result(
        p_entity_type => c_ENTITY_TYPE_PRICE_ADJ
      , p_entity_id => p_price_adj_id_tbl(i)
      , p_column_name => c_CHANGE_REASON_CODE
      , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
      );

Line: 87

, p_updated_flag_tbl       IN  PO_TBL_VARCHAR1
, p_change_reason_text_tbl IN  PO_TBL_VARCHAR2000
, x_results                IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
, x_result_type            OUT NOCOPY    VARCHAR2
)
IS
  d_mod CONSTANT VARCHAR2(100) := D_ovr_chng_reas_text_not_null;

Line: 103

    PO_LOG.proc_begin(d_mod,'p_updated_flag_tbl',p_updated_flag_tbl);

Line: 111

    IF (NVL(p_updated_flag_tbl(i),'N') = 'Y' AND p_change_reason_text_tbl(i) IS NULL)
    THEN
      x_results.add_result(
        p_entity_type => c_ENTITY_TYPE_PRICE_ADJ
      , p_entity_id => p_price_adj_id_tbl(i)
      , p_column_name => c_CHANGE_REASON_TEXT
      , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
      );