APPS.FLM_EKANBAN_PUB SQL Statements

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

Line: 30

    SELECT kanban_card_id
    FROM mtl_kanban_cards
    WHERE kanban_card_number = c_kanban_card_number
      AND organization_id = (SELECT organization_id
                             FROM mtl_parameters
                             WHERE organization_code = c_organization_code);

Line: 382

PROCEDURE update_card_status
(   p_api_version           IN         NUMBER,
    p_commit                IN         VARCHAR2,
    p_init_msg_list         IN         VARCHAR2,
    x_return_status         OUT NOCOPY VARCHAR2,
    x_msg_count             OUT NOCOPY NUMBER,
    x_msg_data              OUT NOCOPY VARCHAR2,
    p_kanban_card_number    IN         VARCHAR2,
    p_organization_code     IN         VARCHAR2,
    p_supply_status_from    IN         NUMBER,
    p_supply_status_to      IN         NUMBER,
    p_card_status_to        IN         NUMBER
)
IS
  l_api_name       CONSTANT VARCHAR2(30) := 'update_card_status';

Line: 403

  SAVEPOINT Update_Card_Status_PUB;

Line: 421

  FLM_KANBANCARD_PUB.update_card_status(p_kanban_card_num    => p_kanban_card_number,
                                        p_org_code           => p_organization_code,
                                        p_supply_status_from => p_supply_status_from,
                                        p_supply_status_to   => p_supply_status_to,
                                        p_card_status_to     => p_card_status_to,
                                        p_commit_flag        => 'N',
                                        x_retcode            => x_return_status,
                                        x_ret_msg_code       => l_ret_msg_code,
                                        x_err_msg            => x_msg_data);

Line: 438

    ROLLBACK TO Update_Card_Status_PUB;

Line: 446

    ROLLBACK TO Update_Card_Status_PUB;

Line: 454

    ROLLBACK TO Update_Card_Status_PUB;

Line: 466

END update_card_status;