APPS.GMI_QUANTITY_PUB SQL Statements

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

Line: 183

  SELECT gem5_journal_id_s.nextval INTO l_journal_id FROM dual;

Line: 201

  l_ic_jrnl_mst_rec.last_update_date   := SYSDATE;

Line: 203

  l_ic_jrnl_mst_rec.last_updated_by    := l_user_id;

Line: 204

  l_ic_jrnl_mst_rec.last_update_login  := TO_NUMBER(FND_PROFILE.Value(
                                        'LOGIN_ID'));

Line: 206

  l_ic_jrnl_mst_rec.delete_mark        := 0;

Line: 211

  l_ic_jrnl_mst_rec.program_update_date  := SYSDATE;

Line: 213

  l_ic_jrnl_mst_rec.last_update_login  := l_user_id;

Line: 215

  IF NOT GMI_QUANTITY_PVT.insert_ic_jrnl_mst(l_ic_jrnl_mst_rec)
  THEN
    RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line: 222

  SELECT gem5_doc_id_s.nextval INTO l_doc_id FROM dual;

Line: 251

      SELECT gem5_line_id_s.nextval INTO l_line_id FROM dual;

Line: 329

    l_ic_adjs_jnl_rec.last_update_date := SYSDATE;

Line: 331

    l_ic_adjs_jnl_rec.last_updated_by  := l_user_id;

Line: 334

    l_ic_adjs_jnl_rec.program_update_date := SYSDATE;

Line: 336

    l_ic_adjs_jnl_rec.last_update_login :=l_user_id;

Line: 339

    IF NOT GMI_QUANTITY_PVT.insert_ic_adjs_jnl(l_ic_adjs_jnl_rec)
    THEN
      RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line: 375

    IF NOT GMI_CMP_TRAN_PVT.Update_quantity_transaction(l_cmp_tran_rec)
    THEN
      RAISE FND_API.G_EXC_UNEXPECTED_ERROR;