APPS.FLM_KANBAN_MASSLOAD SQL Statements

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

Line: 22

    SELECT *
    FROM flm_ekb_pull_seq_interface
    WHERE group_id = p_group_id
      AND process_status = flm_kanban_massload.running
    ORDER BY interface_id;

Line: 29

    SELECT ksi.*
    FROM flm_ekb_pull_seq_interface psi,
         flm_ekb_supplier_interface ksi
    WHERE psi.interface_id   = ksi.parent_interface_id
      AND psi.process_status = flm_kanban_massload.running
      AND psi.group_id       = p_group_id
      ORDER BY ksi.parent_interface_id;

Line: 40

  UPDATE flm_ekb_pull_seq_interface
  SET process_status         = flm_kanban_massload.running,
      request_id             = FND_GLOBAL.CONC_REQUEST_ID,
      program_application_id = FND_GLOBAL.PROG_APPL_ID,
      program_id             = FND_GLOBAL.CONC_PROGRAM_ID,
      program_update_date    = SYSDATE
  WHERE group_id = p_group_id
    AND process_status = flm_kanban_massload.pending;

Line: 79

    SELECT *
    FROM flm_ekb_cards_interface
    WHERE group_id = p_group_id
      AND process_status = flm_kanban_massload.running
   ORDER BY interface_id;

Line: 88

  UPDATE flm_ekb_cards_interface
  SET process_status         = flm_kanban_massload.running,
      request_id             = FND_GLOBAL.CONC_REQUEST_ID,
      program_application_id = FND_GLOBAL.PROG_APPL_ID,
      program_id             = FND_GLOBAL.CONC_PROGRAM_ID,
      program_update_date    = SYSDATE
  WHERE group_id = p_group_id
    AND process_status = flm_kanban_massload.pending;

Line: 164

    UPDATE flm_ekb_pull_seq_interface
    SET pull_sequence_id = g_pull_seq_tbl(i).pull_sequence_id,
        process_status   = g_pull_seq_tbl(i).process_status,
        error_text       = g_pull_seq_tbl(i).error_text
    WHERE interface_id   = g_pull_seq_tbl(i).interface_id;

Line: 172

    UPDATE flm_ekb_cards_interface
    SET kanban_card_id = g_kanban_card_tbl(i).kanban_card_id,
        process_status = g_kanban_card_tbl(i).process_status,
        error_text     = g_kanban_card_tbl(i).error_text
    WHERE interface_id = g_kanban_card_tbl(i).interface_id;