APPS.CZ_ATP_CALLBACK_UTIL SQL Statements

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

Line: 27

  PROCEDURE delete_atp_recs (p_config_session_key IN VARCHAR2) IS
    PRAGMA AUTONOMOUS_TRANSACTION;

Line: 30

    DELETE FROM cz_atp_requests WHERE configurator_session_key = p_config_session_key;

Line: 32

  END delete_atp_recs;

Line: 34

  PROCEDURE insert_atp_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,
                            p_ato_config_item_id IN NUMBER,
                            p_component_sequence_id IN NUMBER) IS
    PRAGMA AUTONOMOUS_TRANSACTION;

Line: 63

        SELECT bill_sequence_id INTO l_component_sequence_id
        FROM bom_bill_of_materials
        WHERE assembly_item_id = l_item_id
        AND organization_id = l_org_id AND alternate_bom_designator IS NULL;

Line: 75

    INSERT INTO CZ_ATP_REQUESTS (atp_request_id,
                                 configurator_session_key,
                                 seq_no,
                                 ps_node_id,
                                 item_key, item_key_type,
                                 quantity, uom_code,
                                 config_item_id, parent_config_item_id,
                                 ato_config_item_id,
                                 component_sequence_id)
        VALUES (cz_atp_requests_s.nextval, p_config_session_key, p_seq_nbr,
                p_ps_node_id, p_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),
                p_ato_config_item_id,
                l_component_sequence_id);

Line: 93

  END insert_atp_rec;

Line: 146

    SELECT
      substr(component_code_from_item_key(p_item_key),
             instr(decode(substr(p_item_key,1,3),'PRJ',null,'PRD',
                          substr(p_item_key,
                                 instr(p_item_key,ITEM_KEY_DELIMITER,-1,1)+1),
                          substr(p_item_key,1,instr(p_item_key,ITEM_KEY_DELIMITER)-1)),
                   COMP_CODE_DELIMITER,-1,1)+1) INTO l_item_id_str FROM dual;

Line: 169

    SELECT
      decode(substr(p_item_key,1,3),
                          'PRJ',null,
                          'PRD',
                          substr(p_item_key,
                                 instr(p_item_key,ITEM_KEY_DELIMITER,-1,1)+1),
                    substr(p_item_key,1,instr(p_item_key,ITEM_KEY_DELIMITER)-1))
    INTO l_comp_code_str FROM dual;

Line: 194

      select instr(l_input_str,p_delimiter)
        into l_delim_pos from dual;

Line: 245

      select item_key into l_item_key from cz_atp_requests where
        configurator_session_key = p_config_session_key and seq_no = 1;

Line: 272

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