APPS.CZ_PRC_CALLBACK_UTIL SQL Statements

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

Line: 9

  PROCEDURE insert_pricing_table (p_pricing_tbl IN system.cz_price_tbl_type)
  IS
    PRAGMA AUTONOMOUS_TRANSACTION;

Line: 16

      INSERT INTO CZ_PRICING_STRUCTURES (configurator_session_key,
                                         seq_nbr,
                                         ps_node_id,
                                         item_key,
                                         item_key_type,
             	                         quantity,
                                         uom_code,
                                         config_item_id,
                                         parent_config_item_id)
      VALUES (p_pricing_tbl(i).config_session_key,
              p_pricing_tbl(i).seq_nbr,
              p_pricing_tbl(i).ps_node_id,
	      nvl(p_pricing_tbl(i).item_key, to_char(p_pricing_tbl(i).ps_node_id)),
              decode(p_pricing_tbl(i).item_key, NULL, G_ITEM_KEY_PS_NODE,
                     G_ITEM_KEY_BOM_NODE),
	      p_pricing_tbl(i).quantity,
              p_pricing_tbl(i).uom_code,
              p_pricing_tbl(i).config_item_id,
              decode(p_pricing_tbl(i).parent_config_item_id, NO_PARENT_VALUE, NULL,
                     p_pricing_tbl(i).parent_config_item_id));

Line: 38

  END insert_pricing_table;

Line: 40

  PROCEDURE insert_pricing_rec (p_config_session_key IN VARCHAR2,
                                p_seq_nbr IN NUMBER,
                                p_ps_node_id IN NUMBER,
                                p_item_key IN VARCHAR2,
                                p_quantity IN NUMBER,
                                p_uom_code IN VARCHAR2,
                                p_config_item_id IN NUMBER,
                                p_parent_config_item_id IN NUMBER) IS
    PRAGMA AUTONOMOUS_TRANSACTION;

Line: 62

    INSERT INTO cz_pricing_structures (configurator_session_key,
                                       seq_nbr,
    				       ps_node_id, item_key,
    				       item_key_type, quantity,
    				       uom_code, config_item_id,
                                       parent_config_item_id)
      VALUES (p_config_session_key,
              p_seq_nbr,
              p_ps_node_id, l_item_key,
              l_item_key_type, p_quantity, p_uom_code, p_config_item_id,
              decode(p_parent_config_item_id, NO_PARENT_VALUE, NULL,
                     p_parent_config_item_id));

Line: 75

  END insert_pricing_rec;

Line: 77

  PROCEDURE delete_pricing_recs (p_config_session_key IN VARCHAR2) IS
    PRAGMA AUTONOMOUS_TRANSACTION;

Line: 80

    DELETE FROM CZ_PRICING_STRUCTURES
    WHERE configurator_session_key = p_config_session_key;

Line: 83

  END delete_pricing_recs;

Line: 153

  SELECT item_key, config_item_id BULK COLLECT INTO tabItemKey, tabConfigItemId
    FROM cz_pricing_structures
   WHERE configurator_session_key = p_config_session_key
     AND item_key_type = G_ITEM_KEY_BOM_NODE;